Query to get Lookup Code and Values
SELECT
DESCRIPTION ,
LOOKUP_TYPE ,
LOOKUP_CODE ,
MEANING ,
ENABLED_FLAG ,
START_DATE_ACTIVE ,
END_DATE_ACTIVE
FROM fnd_lookups
![](http://oratrainings.com/wp-content/uploads/2023/06/image-3-1024x81.png)
SELECT
DESCRIPTION ,
LOOKUP_TYPE ,
LOOKUP_CODE ,
MEANING ,
ENABLED_FLAG ,
START_DATE_ACTIVE ,
END_DATE_ACTIVE
FROM fnd_lookups