eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CZ.CZ_TYPE_RELATIONSHIPS

Object Details

Object Name:	CZ_TYPE_RELATIONSHIPS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_TYPE_RELATIONSHIPS
Subobject Name:
Status:	VALID

CZ_TYPE_RELATIONSHIPS records important aspects of configurator data types (in CZ_SIGNATURES) with regard to other types and properties, of which the most important relationships are subtype equivalency/conversion, parent/child inclusion, and system-property attachment.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_TYPE_RELATIONSHIPS_PK

SUBJECT_TYPE
REL_TYPE_CODE
OBJECT_TYPE

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_TYPE_RELATIONSHIPS_PK	NORMAL	UNIQUE	APPS_TS_SEED	SUBJECT_TYPE REL_TYPE_CODE OBJECT_TYPE
CZ_TYPE_RELATIONSHIPS_U1	NORMAL	UNIQUE	APPS_TS_SEED	DELETED_FLAG REL_TYPE_CODE OBJECT_TYPE SUBJECT_TYPE
CZ_TYPE_RELATIONSHIPS_U2	NORMAL	UNIQUE	APPS_TS_SEED	REL_TYPE_CODE DELETED_FLAG SUBJECT_TYPE OBJECT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_TYPE	NUMBER		Yes
REL_TYPE_CODE	VARCHAR2	(3)	Yes	'CNV' – implicit data type conversion; 'SYS' – intrinsic association of system property to (node) type; 'CHL' object type is allowable child or member of subject type
SUBJECT_TYPE	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER			Records the login ID under which this record was last updated
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
CREATION_DATE	DATE		Yes	Date this record was created
CREATED_BY	NUMBER		Yes	Standard field recording the ID of the user that created this record
LAST_UPDATED_BY	NUMBER		Yes	Standard field recording the ID of the user that last updated this record
SEEDED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this is a seeded expr node
DELETED_FLAG	VARCHAR2	(1)	Yes

Query Text

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


SELECT OBJECT_TYPE
,      REL_TYPE_CODE
,      SUBJECT_TYPE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SEEDED_FLAG
,      DELETED_FLAG
FROM CZ.CZ_TYPE_RELATIONSHIPS;

Dependencies

[top of page]

CZ.CZ_TYPE_RELATIONSHIPS does not reference any database object

CZ.CZ_TYPE_RELATIONSHIPS is referenced by following:

APPS: CZ_TYPE_RELATIONSHIPS; CZ_TYPE_RELATIONSHIPS_T1