PJF_LOOKUPS

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE MEANING DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE TAG DISPLAY_SEQUENCE

Query

SQL_Statement
SELECT FLV.LOOKUP_TYPE , FLV.LOOKUP_CODE , FLV.MEANING , FLV.DESCRIPTION , FLV.ENABLED_FLAG , FLV.START_DATE_ACTIVE, FLV.END_DATE_ACTIVE , FLV.TAG, FLV.DISPLAY_SEQUENCE FROM FND_LOOKUP_VALUES_VL FLV, PJF_LOOKUP_TYPES FLT WHERE FLT.LOOKUP_TYPE = FLV.LOOKUP_TYPE AND FLV.VIEW_APPLICATION_ID = 0 AND FLV.SET_ID = 0