Product: | PSA - Public Sector Financials |
---|---|
Description: | Contains seeded lookup codes for Public Sector Applications |
Implementation/DBA Data: | APPS.PSA_LOOKUP_CODES |
SELECT LV.LOOKUP_TYPE
, LV.LOOKUP_CODE
, LV.MEANING DESCRIPTION
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_DATE
, LV.LAST_UPDATE_LOGIN
, LV.CREATED_BY
, LV.CREATION_DATE
, LV.ATTRIBUTE_CATEGORY
, LV.ATTRIBUTE1
, LV.ATTRIBUTE2
, LV.ATTRIBUTE3
, LV.ATTRIBUTE4
, LV.ATTRIBUTE5
, LV.ATTRIBUTE6
, LV.ATTRIBUTE7
, LV.ATTRIBUTE8
, LV.ATTRIBUTE9
, LV.ATTRIBUTE10
, LV.ATTRIBUTE11
, LV.ATTRIBUTE12
, LV.ATTRIBUTE13
, LV.ATTRIBUTE14
, LV.ATTRIBUTE15
FROM FND_LOOKUP_VALUES LV
WHERE LV.LANGUAGE = USERENV('LANG')
AND LV.VIEW_APPLICATION_ID = 8450
AND LV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)