[Home] [Help] [Dependency Information]
Object Name: | PA_LOOKUPS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_LOOKUPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_LOOKUPS is a view of codes or values associated with system-defined lookup types for Oracle Projects. Lookup codes can be user-defined or system-defined.
Oracle Projects prevents users from deleting system-defined lookup codes.
Many user-defined lookup codes are defined during implementation.
This view is a multi-lingual view. The meaning and description for each lookup code are defined in each installed language of Oracle Applications. Based on the language of the session, the meaning and description in that langauge are displayed to the user.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | Quick code type |
LOOKUP_CODE | VARCHAR2 | (30) | Yes | Quick code code |
MEANING | VARCHAR2 | (80) | Yes | Quick code meaning |
DESCRIPTION | VARCHAR2 | (240) | Quick code description | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enabled flag |
PREDEFINED_FLAG | VARCHAR2 | (150) | Pre-defined flag | |
START_DATE_ACTIVE | DATE | The date when the QuickCode becomes active | ||
END_DATE_ACTIVE | DATE | The date when the QuickCode becomes inactive | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context field | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.PA_LOOKUPS;
|
|
|