View: ECX_LOOKUP_VALUES

Product:	ECX - XML Gateway
Description:	Stores XML Lookup Values
Implementation/DBA Data:	APPS.ECX_LOOKUP_VALUES

View Text

SELECT LOOKUP_TYPE LOOKUP_TYPE
, LOOKUP_CODE LOOKUP_CODE
, MEANING MEANING
, DESCRIPTION DESCRIPTION
, ENABLED_FLAG ENABLED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
FROM FND_LOOKUP_VALUES LV
WHERE LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 174
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)
AND ENABLED_FLAG = 'Y'

Columns