-
-

Common Lookups

CORE

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