VIEW: APPS.FND_COMMON_LOOKUPS

Source

View Text - Preformatted

SELECT FLT.APPLICATION_ID, FLT.LOOKUP_TYPE, FLV.LOOKUP_CODE, FLV.MEANING, FLV.DESCRIPTION, FLV.ENABLED_FLAG, FLV.START_DATE_ACTIVE, FLV.END_DATE_ACTIVE, FLV.CREATED_BY, FLV.CREATION_DATE, FLV.LAST_UPDATE_DATE, FLV.LAST_UPDATED_BY, FLV.LAST_UPDATE_LOGIN, FLV.ATTRIBUTE_CATEGORY, FLV.ATTRIBUTE1, FLV.ATTRIBUTE2, FLV.ATTRIBUTE3, FLV.ATTRIBUTE4, FLV.ATTRIBUTE5, FLV.ATTRIBUTE6, FLV.ATTRIBUTE7, FLV.ATTRIBUTE8, FLV.ATTRIBUTE9, FLV.ATTRIBUTE10, FLV.ATTRIBUTE11, FLV.ATTRIBUTE12, FLV.ATTRIBUTE13, FLV.ATTRIBUTE14, FLV.ATTRIBUTE15 from FND_LOOKUP_TYPES FLT, FND_LOOKUP_VALUES FLV WHERE FLV.LOOKUP_TYPE = FLT.LOOKUP_TYPE and FLV.SECURITY_GROUP_ID = FLT.SECURITY_GROUP_ID and FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID and FLV.LANGUAGE = userenv('LANG') and FLV.VIEW_APPLICATION_ID = 3 and FLV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID)

View Text - HTML Formatted

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