VIEW: APPS.PSA_LOOKUP_TYPES

Source

View Text - Preformatted

SELECT LV.LOOKUP_TYPE, LV.DESCRIPTION, DECODE(LV.CUSTOMIZATION_LEVEL,'E','Y','N') user_updateable_flag, LV.CREATED_BY, LV.CREATION_DATE, LV.LAST_UPDATED_BY, LV.LAST_UPDATE_DATE from FND_LOOKUP_TYPES_VL LV WHERE LV.VIEW_APPLICATION_ID = 8450 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)))))

View Text - HTML Formatted

SELECT LV.LOOKUP_TYPE
, LV.DESCRIPTION
, DECODE(LV.CUSTOMIZATION_LEVEL
, 'E'
, 'Y'
, 'N') USER_UPDATEABLE_FLAG
, LV.CREATED_BY
, LV.CREATION_DATE
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_DATE
FROM FND_LOOKUP_TYPES_VL LV
WHERE LV.VIEW_APPLICATION_ID = 8450
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)))))