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
SELECT
DESCRIPTION ,
LOOKUP_TYPE ,
LOOKUP_CODE ,
MEANING ,
ENABLED_FLAG ,
START_DATE_ACTIVE ,
END_DATE_ACTIVE
FROM fnd_lookups