[Home] [Help] [Dependency Information]
Object Name: | CZ_CONFIG_HDRS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_CONFIG_HDRS |
Subobject Name: | |
Status: | VALID |
CZ_CONFIG_HDRS stores the configuration headers information. It has one row for each configuration. CONFIG_HDR_ID is the system-generated configuration identifier. COMPONENT_ID defines what product is configured.
OPPORTUNITY_HDR_ID, NUMBER_QUOTES_USED_IN, and USER_ID_FOR_WHOM_CREATED fields are used by Oracle SellingPoint only.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_CONFIG_HDRS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CONFIG_HDR_ID
CONFIG_REV_NBR |
CZ_CONFIG_HDRS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMPONENT_ID |
CZ_CONFIG_HDRS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UI_DEF_ID |
CZ_CONFIG_HDRS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
NAME
DELETED_FLAG CONFIG_HDR_ID CONFIG_REV_NBR |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONFIG_STATUS | VARCHAR2 | (20) | Configuration Status: New, Incomplete, Complete | |
CONFIG_HDR_ID | NUMBER | Yes | Configuration unique identifier | |
NAME | VARCHAR2 | (255) | Configuration name | |
CONFIG_REV_NBR | NUMBER | (9) | Yes | Configuration revision number |
COMPONENT_ID | NUMBER | (15) | Root project structure node identifier for the configuration. | |
DESC_TEXT | VARCHAR2 | (2000) | Configuration description | |
UI_DEF_ID | NUMBER | (9) | UI definition identifier. Used by Oracle SellingPoint Studio only. | |
OPPORTUNITY_HDR_ID | NUMBER | (9) | Opportunity header identifier. Used by Oracle SellingPoint only | |
MODEL_IDENTIFIER | VARCHAR2 | (1200) | Identifier of the modelfor which this configuration was created | |
CONFIG_NOTE | VARCHAR2 | (255) | Configuration note | |
CONFIG_DATE_CREATED | DATE | Date on which configuration was created | ||
USER_ID_CREATED | NUMBER | (9) | User identifier of the user who created configuration | |
USER_ID_FOR_WHOM_CREATED | NUMBER | (9) | User identifier of the user who requested creation of the configuration. Used by Oracle SellingPoint only. | |
NUMBER_QUOTES_USED_IN | NUMBER | (9) | Number of quotes the configuration is used in. Used by Oracle SellingPoint only. | |
USER_NUM01 | NUMBER | (16) | User-defined numeric field. Not currently used | |
USER_NUM02 | NUMBER | (16) | User-defined numeric field. Not currently used | |
USER_NUM03 | NUMBER | (16) | User-defined numeric field. Not currently used | |
USER_NUM04 | NUMBER | (16) | User-defined numeric field. Not currently used | |
USER_STR01 | VARCHAR2 | (255) | Use- defined char field. Not currently used | |
USER_STR02 | VARCHAR2 | (255) | Use- defined char field. Not currently used | |
USER_STR03 | VARCHAR2 | (255) | Use- defined char field. Not currently used | |
USER_STR04 | VARCHAR2 | (255) | Use- defined char field. Not currently used | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating if configuration was deleted by the user. If deleted_flag=1 the record will be purged. |
EFF_FROM | DATE | Not currently used | ||
EFF_TO | DATE | Not currently used | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
SECURITY_MASK | VARCHAR2 | (40) | Not currently used | |
EFF_MASK | VARCHAR2 | (40) | Not currently used | |
CHECKOUT_USER | VARCHAR2 | (40) | Not currently used | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
PERSISTENT_COMPONENT_ID | NUMBER | Persistent ID (preserved in copies) of the component which this logic/net file implements | ||
EFFECTIVE_USAGE_ID | NUMBER | (9) | Yes | Records the usage (or -1, 'Any usage') under which this configuration was created. |
EFFECTIVE_DATE | DATE | Date for which the configuration is intended to be effective | ||
CONFIG_MODEL_LOOKUP_DATE | DATE | [15g] This is the date originally used to qualify the configuration for a particular model applicability. | ||
CONFIG_DELTA_SPEC | NUMBER | Yes | Another requirement of the design is for calling applications to have the ability to view only changed items in a MACD flow. A new field in CZ_CONFIG_HDRS will be used to persist the configuration delta mode and to dynamically modify the result set of the CZ_CONFIG_DETAILS_V view. Allowable values are 0 (default), 1, and 2 | |
COMPONENT_INSTANCE_TYPE | VARCHAR2 | (1) | Yes | To distinguish between the different types of configurable items a set of new fields must be added to CZ_CONFIG_HDRS |
MODEL_INSTANTIATION_TYPE | VARCHAR2 | (1) | Yes | To distinguish between the different types of configurable items a set of new fields must be added to CZ_CONFIG_HDRS. The allowable values are 'C', 'A', 'P', 'N' and 'S' |
BASELINE_REV_NBR | NUMBER | (9) | In order to satisfy the requirement to annotate delta records in the saved configurations, a new field will be used for storing the baseline revision number. It will be the revision number of the instance from which the upgrade quote first started | |
HAS_FAILURES | VARCHAR2 | (1) | Yes | Default value of '0'. Allowable values are '0' and '1'. A value of '1' means that an instance has validation failures or user messages. |
MODEL_POST_MIGR_CHG_FLAG | VARCHAR2 | (1) | FK to cz_devl_projects.POST_MIGR_CHANGE_FLAG | |
TO_BE_DELETED_FLAG | VARCHAR2 | (1) | ||
AUTO_COMPLETION_FLAG | VARCHAR2 | (1) | ||
CONFIG_ENGINE_TYPE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT CONFIG_STATUS
, CONFIG_HDR_ID
, NAME
, CONFIG_REV_NBR
, COMPONENT_ID
, DESC_TEXT
, UI_DEF_ID
, OPPORTUNITY_HDR_ID
, MODEL_IDENTIFIER
, CONFIG_NOTE
, CONFIG_DATE_CREATED
, USER_ID_CREATED
, USER_ID_FOR_WHOM_CREATED
, NUMBER_QUOTES_USED_IN
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
, LAST_UPDATE_LOGIN
, PERSISTENT_COMPONENT_ID
, EFFECTIVE_USAGE_ID
, EFFECTIVE_DATE
, CONFIG_MODEL_LOOKUP_DATE
, CONFIG_DELTA_SPEC
, COMPONENT_INSTANCE_TYPE
, MODEL_INSTANTIATION_TYPE
, BASELINE_REV_NBR
, HAS_FAILURES
, MODEL_POST_MIGR_CHG_FLAG
, TO_BE_DELETED_FLAG
, AUTO_COMPLETION_FLAG
, CONFIG_ENGINE_TYPE
FROM CZ.CZ_CONFIG_HDRS;
CZ.CZ_CONFIG_HDRS does not reference any database object
CZ.CZ_CONFIG_HDRS is referenced by following:
|
|
|