VIEW: APPS.LNS_LOOKUPS

Source

View Text - Preformatted

SELECT FNDLKPV.LOOKUP_TYPE , FNDLKPV.LOOKUP_CODE , FNDLKPV.LAST_UPDATE_DATE , FNDLKPV.LAST_UPDATED_BY , FNDLKPV.LAST_UPDATE_LOGIN , FNDLKPV.CREATION_DATE , FNDLKPV.CREATED_BY , FNDLKPV.MEANING , FNDLKPV.ENABLED_FLAG , FNDLKPV.START_DATE_ACTIVE , FNDLKPV.END_DATE_ACTIVE , FNDLKPV.DESCRIPTION , FNDLKPV.TAG , FNDLKPV.ATTRIBUTE_CATEGORY , FNDLKPV.ATTRIBUTE1 , FNDLKPV.ATTRIBUTE2 , FNDLKPV.ATTRIBUTE3 , FNDLKPV.ATTRIBUTE4 , FNDLKPV.ATTRIBUTE5 , FNDLKPV.ATTRIBUTE6 , FNDLKPV.ATTRIBUTE7 , FNDLKPV.ATTRIBUTE8 , FNDLKPV.ATTRIBUTE9 , FNDLKPV.ATTRIBUTE10 , FNDLKPV.ATTRIBUTE11 , FNDLKPV.ATTRIBUTE12 , FNDLKPV.ATTRIBUTE13 , FNDLKPV.ATTRIBUTE14 , FNDLKPV.ATTRIBUTE15 FROM FND_LOOKUP_VALUES FNDLKPV WHERE FNDLKPV.LANGUAGE = userenv('LANG') AND FNDLKPV.VIEW_APPLICATION_ID = 206 AND FNDLKPV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(FNDLKPV.LOOKUP_TYPE, FNDLKPV.VIEW_APPLICATION_ID)

View Text - HTML Formatted

SELECT FNDLKPV.LOOKUP_TYPE
, FNDLKPV.LOOKUP_CODE
, FNDLKPV.LAST_UPDATE_DATE
, FNDLKPV.LAST_UPDATED_BY
, FNDLKPV.LAST_UPDATE_LOGIN
, FNDLKPV.CREATION_DATE
, FNDLKPV.CREATED_BY
, FNDLKPV.MEANING
, FNDLKPV.ENABLED_FLAG
, FNDLKPV.START_DATE_ACTIVE
, FNDLKPV.END_DATE_ACTIVE
, FNDLKPV.DESCRIPTION
, FNDLKPV.TAG
, FNDLKPV.ATTRIBUTE_CATEGORY
, FNDLKPV.ATTRIBUTE1
, FNDLKPV.ATTRIBUTE2
, FNDLKPV.ATTRIBUTE3
, FNDLKPV.ATTRIBUTE4
, FNDLKPV.ATTRIBUTE5
, FNDLKPV.ATTRIBUTE6
, FNDLKPV.ATTRIBUTE7
, FNDLKPV.ATTRIBUTE8
, FNDLKPV.ATTRIBUTE9
, FNDLKPV.ATTRIBUTE10
, FNDLKPV.ATTRIBUTE11
, FNDLKPV.ATTRIBUTE12
, FNDLKPV.ATTRIBUTE13
, FNDLKPV.ATTRIBUTE14
, FNDLKPV.ATTRIBUTE15
FROM FND_LOOKUP_VALUES FNDLKPV
WHERE FNDLKPV.LANGUAGE = USERENV('LANG')
AND FNDLKPV.VIEW_APPLICATION_ID = 206
AND FNDLKPV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FNDLKPV.LOOKUP_TYPE
, FNDLKPV.VIEW_APPLICATION_ID)