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_CONFIG_HDRS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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)

Query Text

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;

Dependencies

[top of page]

CZ.CZ_CONFIG_HDRS does not reference any database object

CZ.CZ_CONFIG_HDRS is referenced by following:

CZ: CZ_CONFIG_HDRS#