EXM_LOOKUP_VALUES

Details

Name
LOOKUP_TYPE LOOKUP_CODE DISPLAYED_FIELD DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE DISPLAY_SEQUENCE CREATED_BY

Name

LOOKUP_TYPE

LOOKUP_CODE

DISPLAYED_FIELD

DESCRIPTION

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

DISPLAY_SEQUENCE

CREATED_BY

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) )

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)

)