Common Lookups
SELECT
fltv.lookup_type,
fltv.meaning Lookup_Type_Meaning,
fltv.description Lookup_Type_Description,
fatv.user_module_name Module,
CUST_LVL.meaning Lookup_Configuration_Level,
RES_ACC_SEC.meaning REST_Access_Secured,
fcl.lookup_code,
fcl.display_sequence,
HR_GENERAL.DECODE_LOOKUP('YES_NO',fcl.enabled_flag) Enabled,
to_char(fcl.start_date_Active,'MM/DD/YYYY') Start_Date,
to_char(fcl.end_Date_active,'MM/DD/YYYY') End_Date,
fcl.meaning,
fcl.description,
fcl.tag
FROM
FND_LOOKUP_TYPES_VL FLTV,
FND_LOOKUPS RES_ACC_SEC,
FND_LOOKUPS CUST_LVL,
fnd_appl_taxonomy_vl fatv,
fnd_common_lookups fcl
WHERE RES_ACC_SEC.lookup_type = 'ORA_FND_REST_ACCESS_SECURED'
AND RES_ACC_SEC.lookup_code = fltv.rest_Access_secured
AND fatv.module_id = fltv.module_id
AND CUST_LVL.lookup_type = 'LOOKUP_CUSTOMIZATION_LEVEL'
AND CUST_LVL.lookup_code = fltv.customization_level
AND fcl.lookup_type = fltv.lookup_type
AND (
(:P_CREATION_TYPE= 'Custom' AND FLTV.created_by <> 'SEED_DATA_FROM_APPLICATION' )
OR (:P_CREATION_TYPE = 'Seeded' AND FLTV.created_by = 'SEED_DATA_FROM_APPLICATION' )
OR (:P_CREATION_TYPE = 'Seeded Modified' AND FLTV.created_by = 'SEED_DATA_FROM_APPLICATION' AND FLTV.last_updated_by <> 'SEED_DATA_FROM_APPLICATION')
OR (:P_CREATION_TYPE = 'ALL')
)
ORDER BY fltv.lookup_type