EXM_LOOKUP_VALUES
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: VIEW
Columns
Name |
---|
LOOKUP_TYPE LOOKUP_CODE DISPLAYED_FIELD DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE DISPLAY_SEQUENCE CREATED_BY |
Query
SQL_Statement |
---|
( select B.LOOKUP_TYPE, B.LOOKUP_CODE, T.MEANING DISPLAYED_FIELD, T.DESCRIPTION, B.ENABLED_FLAG, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.DISPLAY_SEQUENCE, TB.CREATED_BY from FND_LOOKUP_VALUES_TL T, FND_LOOKUP_VALUES_B B,FND_LOOKUP_TYPES TB where T.LOOKUP_TYPE = B.LOOKUP_TYPE AND T.LOOKUP_CODE = B.LOOKUP_CODE AND T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND T.LANGUAGE = userenv('LANG') AND TB.MODULE_ID = '47110F64AC0608E2E040449823C60DB6' AND TB.LOOKUP_TYPE = b.LOOKUP_TYPE and TB.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID and TB.view_application_id in (0, 10016) ) |