View: AMW_LOOKUPS

Product:	AMW - Internal Controls Manager
Description:	selection of lookups from fnd_lookup_values for ICM product
Implementation/DBA Data:	APPS.AMW_LOOKUPS

View Text

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, TAG
FROM FND_LOOKUP_VALUES
WHERE LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = '242'
AND SECURITY_GROUP_ID = TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))

Columns