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

TABLE: CZ.CZ_XFR_FIELD_REQUIRES

Object Details
Object Name: CZ_XFR_FIELD_REQUIRES
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_XFR_FIELD_REQUIRES
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CZ_XFR_FIELD_REQS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFIELD_ORDER
ColumnORDER_SEQ
ColumnXFR_GROUP
ColumnREQ_ORDER
CZ_XFR_FIELD_REQUIRES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFIELD_ORDER
ColumnXFR_GROUP
ColumnORDER_SEQ
Columns
Name Datatype Length Mandatory Comments
FIELD_ORDER NUMBER
Yes Provides an order for each field in the dependency
XFR_GROUP VARCHAR2 (20) Yes Identifies the import/transfer group to which this field-dependency rule applies
REQ_ORDER NUMBER (9) Yes Indicates the order of this field dependency in the overal dependency list
ORDER_SEQ NUMBER (9) Yes Identifies the XFR_TABLES order to which this dependency record refers
REQ_TYPE NUMBER (9)
Indicates the type of dependency described in this record
REFSUBSCHEMA NUMBER

Identifies the subschema in which the table/field resides on which this field depends
REFTABLE VARCHAR2 (40)
Table on which this field depends
REFFIELD VARCHAR2 (40)
Name of the referenced field on which this field depends
Query Text

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


SELECT FIELD_ORDER
,      XFR_GROUP
,      REQ_ORDER
,      ORDER_SEQ
,      REQ_TYPE
,      REFSUBSCHEMA
,      REFTABLE
,      REFFIELD
FROM CZ.CZ_XFR_FIELD_REQUIRES;

Dependencies

[top of page]

CZ.CZ_XFR_FIELD_REQUIRES does not reference any database object

CZ.CZ_XFR_FIELD_REQUIRES is referenced by following:

SchemaCZ
ViewCZ_XFR_FIELD_REQUIRES#