DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_LOOKUP_TYPES

Object Details
Object Name: PA_LOOKUP_TYPES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_LOOKUP_TYPES
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


PA_LOOKUP_TYPES is a view of system-defined application-specific categories of lookup codes for Oracle Projects. All lookup types are system defined. Oracle Projects provides all lookup types upon installation.
This view is multi-lingual view. The meaning and description for each lookup type 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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes Name that uniquely identifies the lookup type
MEANING VARCHAR2 (80) Yes User friendly name of the lookup type
DESCRIPTION VARCHAR2 (240)
Description of the lookup type
USER_DEFINABLE_FLAG VARCHAR2 (1)
Flag that indicates user can define lookup code for the lookup type
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_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOOKUP_TYPE
,      MEANING
,      DESCRIPTION
,      USER_DEFINABLE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.PA_LOOKUP_TYPES;

Dependencies

[top of page]

APPS.PA_LOOKUP_TYPES references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_TYPES
SynonymFND_LOOKUP_TYPES_TL
APPS.PA_LOOKUP_TYPES is referenced by following:

SchemaAPPS
ViewPA_ADW_SRVC_TYPES_B_V