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';