View: PO_LOOKUP_TYPES

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_LOOKUP_TYPES

View Text

SELECT B.LOOKUP_TYPE
, T.LAST_UPDATE_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_LOGIN
, T.CREATION_DATE
, T.CREATED_BY
, B.CUSTOMIZATION_LEVEL
, T.MEANING
, TO_NUMBER(NULL) REQUEST_ID
, TO_NUMBER(NULL) PROGRAM_APPLICATION_ID
, TO_NUMBER(NULL) PROGRAM_ID
, TO_DATE(NULL) PROGRAM_UPDATE_DATE
FROM FND_LOOKUP_TYPES_TL T
, FND_LOOKUP_TYPES B
WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE
AND B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
AND B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.VIEW_APPLICATION_ID = 201
AND B.SECURITY_GROUP_ID = (SELECT MAX(SECURITY_GROUP_ID)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
AND LT.LOOKUP_TYPE = B.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