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


VIEW: APPS.IEC_LOOKUPS

Object Details
Object Name: IEC_LOOKUPS
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


IEC-specific view for pulling data from FND_LOOKUP tables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes The lookup type from FND_LOOKUP_TYPES.
LOOKUP_CODE VARCHAR2 (30) Yes The lookup code from FND_LOOKUP_VALUES.
MEANING VARCHAR2 (80) Yes The meaning of the lookup code.
DESCRIPTION VARCHAR2 (240)
The description of the lookup code.
ENABLED_FLAG VARCHAR2 (1) Yes Whether or not the lookup code is enabled.
START_DATE_ACTIVE DATE

Start date for the lookup code.
END_DATE_ACTIVE DATE

End date for the lookup code.
TAG VARCHAR2 (150)
Arbitrary additional lookup data.
Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      MEANING
,      DESCRIPTION
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TAG
FROM APPS.IEC_LOOKUPS;

Dependencies

[top of page]

APPS.IEC_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_TYPES
SynonymFND_LOOKUP_VALUES
APPS.IEC_LOOKUPS is referenced by following:

SchemaAPPS
Package BodyIEC_DEFAULT_SUBSET_PVT - show dependent code
ViewIEC_LIST_SRC_FIELDS_V
ViewIEC_LIST_STATUSES_V
ViewIEC_O_VALIDATION_REPORT_SUMM_V
Package BodyIEC_WHERECLAUSE_PVT - show dependent code