[Home] [Help] [Dependency Information]

TABLE: EC.ECE_RULE_NULL_DEP_DETAILS

Object Details

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

ECE_RULE_DEP_DETAILS contains information about the null
dependency column rule. This table is a child table to
ECE_RULE_NULL_DEP.

Each row is a dependency condition. The COMPARISON_CODE
indicates that the dependency must be null, not nulls or equal to
VALUE.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_RULE_NULL_DEP_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_SEED	NULL_DEPENDENCY_DETAIL_ID

Columns

Query Text

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

SELECT NULL_DEPENDENCY_DETAIL_ID
,      NULL_DEPENDENCY_RULE_ID
,      INTERFACE_COLUMN
,      COMPARISON_CODE
,      VALUE
,      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_NULL_DEP_DETAILS;

Dependencies

[top of page]

EC.ECE_RULE_NULL_DEP_DETAILS does not reference any database object

EC.ECE_RULE_NULL_DEP_DETAILS is referenced by following:

EC

ECE_RULE_NULL_DEP_DETAILS#