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_DES_CHART_COLUMNS

Object Details

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

Created to allow column widths to be custom-sized per chart. Note other aspects of columns, in particular the background color, or font could also be added to this table.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_DES_CHART_COLUMNS_PK

RULE_ID
OPTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_DES_CHART_COLUMNS_PK	NORMAL	UNIQUE	APPS_TS_SEED	RULE_ID OPTION_ID

Columns

Name	Datatype	Mandatory	Comments
RULE_ID	NUMBER	Yes	Rule ID for the design chart
OPTION_ID	NUMBER	Yes	Option ID for this column. Note that this option is defined specifically with reference to the primary feature of the design chart (cz_des_chart_features with same rule_id and feature_type 5)
COLUMN_WIDTH	NUMBER		NULL indicates default width. Note an outer-join query can eliminate the need for such rows.
FEATURE_ID	NUMBER	Yes	DENORMALIZATION - should match the corresponding feature ID both from cz_des_chart_features, and from cz_ps_nodes.
MODEL_REF_EXPL_ID	NUMBER	Yes	DENORMALIZATION - must match the explosion ID of the primary feature in the design chart
CREATED_BY	NUMBER	Yes	Standard audit field
CREATION_DATE	DATE	Yes	Standard audit field
LAST_UPDATED_BY	NUMBER	Yes	Standard audit field
LAST_UPDATE_DATE	DATE	Yes	Standard audit field

Query Text

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


SELECT RULE_ID
,      OPTION_ID
,      COLUMN_WIDTH
,      FEATURE_ID
,      MODEL_REF_EXPL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM CZ.CZ_DES_CHART_COLUMNS;

Dependencies

[top of page]

CZ.CZ_DES_CHART_COLUMNS does not reference any database object

CZ.CZ_DES_CHART_COLUMNS is referenced by following:

APPS: CZ_DES_CHART_COLUMNS; CZ_DES_CHART_COLUMNS_T1