VIEW: APPS.AMW_LOOKUPS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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