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


VIEW: APPS.ECE_LOOKUP_VALUES

Object Details
Object Name: ECE_LOOKUP_VALUES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_LOOKUP_VALUES
Subobject Name:
Status: VALID

View Type

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


ECE_LOOKUP_VALUES view is a replacement for ECE_LOOKUP_VALUES
table, created after the migration of seed data to FND_LOOKUP tables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes Lookup Type
LOOKUP_CODE VARCHAR2 (30) Yes Lookup Code
MEANING VARCHAR2 (80) Yes Lookup Meaning
DESCRIPTION VARCHAR2 (240)
Lookup Description
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag
START_DATE_ACTIVE DATE

Effective start date of the Lookup
END_DATE_ACTIVE DATE

Effective end date of the Lookup
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
FROM APPS.ECE_LOOKUP_VALUES;

Dependencies

[top of page]

APPS.ECE_LOOKUP_VALUES references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
APPS.ECE_LOOKUP_VALUES is referenced by following:

SchemaAPPS
Package BodyECE_UTILITIES - show dependent code