[Home] [Help] [Dependency Information]

TABLE: EC.ECE_RULE_SIMPLE_LOOKUP

Object Details

Object Name:	ECE_RULE_SIMPLE_LOOKUP
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_RULE_SIMPLE_LOOKUP
Subobject Name:
Status:	VALID

ECE_RULE_SIMPLE_LOOKUP contains information about the
column rule simple lookup. A record is created in this table
when the column rule simple lookup is assigned to a column
in a transcation.

LOOKUP_TABLE, LOOKUP_COLUMN, and
LOOKUP_WHERE_CLAUSE are used to construct the select
statement.

Enter the LOOKUP_WHERE_CLAUSE without the 'WHERE'.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_RULE_SIMPLE_LOOKUP_U1	NORMAL	UNIQUE	APPS_TS_SEED	LOOKUP_RULE_ID

Columns

Query Text

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

SELECT LOOKUP_RULE_ID
,      COLUMN_RULE_ID
,      LOOKUP_TABLE
,      LOOKUP_COLUMN
,      LOOKUP_WHERE_CLAUSE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EC.ECE_RULE_SIMPLE_LOOKUP;

Dependencies

[top of page]

EC.ECE_RULE_SIMPLE_LOOKUP does not reference any database object

EC.ECE_RULE_SIMPLE_LOOKUP is referenced by following:

EC

ECE_RULE_SIMPLE_LOOKUP#