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


VIEW: APPS.XNP_LOOKUPS

Object Details
Object Name: XNP_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXNP.XNP_LOOKUPS
Subobject Name:
Status: VALID

View Type

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


XNP Lookups


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes Check the Base table for the column description.
LOOKUP_CODE VARCHAR2 (30) Yes Check the Base table for the column description.
LAST_UPDATE_DATE DATE
Yes Check the Base table for the column description.
LAST_UPDATED_BY NUMBER (15) Yes Check the Base table for the column description.
LAST_UPDATE_LOGIN NUMBER (15)
Check the Base table for the column description.
CREATION_DATE DATE
Yes Check the Base table for the column description.
CREATED_BY NUMBER (15) Yes Check the Base table for the column description.
MEANING VARCHAR2 (80) Yes Check the Base table for the column description.
ENABLED_FLAG VARCHAR2 (1) Yes Check the Base table for the column description.
START_DATE_ACTIVE DATE

Check the Base table for the column description.
END_DATE_ACTIVE DATE

Check the Base table for the column description.
DESCRIPTION VARCHAR2 (240)
Check the Base table for the column description.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Check the Base table for the column description.
ATTRIBUTE1 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE2 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE3 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE4 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE5 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE6 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE7 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE8 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE9 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE10 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE11 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE12 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE13 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE14 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE15 VARCHAR2 (150)
Check the Base table for the column description.
TAG VARCHAR2 (150)
Check the Base table for the column description.
Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      MEANING
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TAG
FROM APPS.XNP_LOOKUPS;

Dependencies

[top of page]

APPS.XNP_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES

APPS.XNP_LOOKUPS is not referenced by any database object