FND Design Data [Home] [Help]

View: PA_LOOKUPS

Product: PA - Projects
Description: PA_LOOKUPS is a view of system defined lookup codes and their corresponding meaning for Oracle Projects. This view will display the meani ng in the language of the session.
Implementation/DBA Data: ViewAPPS.PA_LOOKUPS
View Text

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

Columns

Name
LOOKUP_TYPE
LOOKUP_CODE
MEANING
DESCRIPTION
ENABLED_FLAG
PREDEFINED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15