VIEW: APPS.PO_LOOKUP_TYPES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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