Oracle Cloud ERP -Fusion (SaaS) – Lookup Creation and Query to extract

Steps to Create

As an administrator, here’s how you can create/view the Lookup:

  1. In the Setup and Maintenance work area, go to:
    • Task: Manage Common Lookups
  2. Click on + , in search Results to create Lookup Type and in the below region, create Lookup Codes
--Sample Query
select * from fnd_lookup_types where lookup_type='FND_ATTACHMENT_STATUSES';
select * from  FND_LOOKUP_VALUES  where lookup_type='FND_ATTACHMENT_STATUSES' and language='US';

Leave a Reply

Your email address will not be published.