View: AR_LOOKUP_TYPES

Product:	AR - Receivables
Description:	AR_LOOKUP_TYPES stores standard lookup types for Quickcodes
Implementation/DBA Data:	APPS.AR_LOOKUP_TYPES

View Text

SELECT LV.LOOKUP_TYPE
, LV.LAST_UPDATE_DATE
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_LOGIN
, LV.CREATION_DATE
, LV.CREATED_BY
, DECODE(LV.CUSTOMIZATION_LEVEL
, 'U'
, 'Y'
, 'N')
, LV.MEANING
FROM FND_LOOKUP_TYPES_VL LV
WHERE LV.VIEW_APPLICATION_ID = 222
AND LV.SECURITY_GROUP_ID = (SELECT MAX(LT.SECURITY_GROUP_ID)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = LV.VIEW_APPLICATION_ID
AND LT.LOOKUP_TYPE = LV.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)))))

Columns