View: CZFV_CONFIG_SYSTEM_TYPES

View Text

SELECT AP.APPLICATION_NAME
, CO.LOOKUP_TYPE
, COTY.LOOKUP_TYPE_MEANING
, CO.LOOKUP_CODE
, CO.MEANING
, '_LA:CO.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, CO.DESCRIPTION
, CO.START_DATE_ACTIVE
, CO.END_DATE_ACTIVE
, CO.VIEW_APPLICATION_ID
, '_DF:FND:FND_COMMON_LOOKUPS:CO'
, CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
FROM FND_COMMON_LOOKUP_TYPES COTY
, FND_APPLICATION_VL AP
, FND_LOOKUP_VALUES CO
WHERE CO.LOOKUP_TYPE = 'CZ_SYSTEM_TYPES'
AND CO.VIEW_APPLICATION_ID =3
AND CO.LANGUAGE = USERENV('LANG')
AND SECURITY_GROUP_ID = (SELECT MAX(SECURITY_GROUP_ID)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = CO.VIEW_APPLICATION_ID
AND LT.LOOKUP_TYPE = CO.LOOKUP_TYPE
AND LT.SECURITY_GROUP_ID IN (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))))
AND CO.VIEW_APPLICATION_ID = AP.APPLICATION_ID
AND COTY.APPLICATION_ID = 702
AND CO.LOOKUP_TYPE = COTY.LOOKUP_TYPE WITH READ ONLY

Columns