[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_DES_CHART_COLUMNS_PK | NORMAL | UNIQUE | APPS_TS_SEED |
RULE_ID
OPTION_ID |
Name | Datatype | Length | 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 |
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;
CZ.CZ_DES_CHART_COLUMNS does not reference any database object
CZ.CZ_DES_CHART_COLUMNS is referenced by following:
|
|
|