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]

VIEW: APPS.CZ_CONFIG_HDRS_V

Object Details

Object Name:	CZ_CONFIG_HDRS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_CONFIG_HDRS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

CZ_CONFIG_HDRS_V provides a view of Saved Configurations to applications and custom software outside Configurator.

[View Source]

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
DELETED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if configuration was deleted by the user. If deleted_flag=1 the record will be purged.
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
PERSISTENT_COMPONENT_ID	NUMBER			Persistent ID (preserved in copies) of the component which this logic/net file implements
CONFIG_MODEL_LOOKUP_DATE	DATE			This is the date originally used to qualify the configuration for a particular model applicability.
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
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
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'
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
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)

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
,      DELETED_FLAG
,      EFFECTIVE_USAGE_ID
,      EFFECTIVE_DATE
,      PERSISTENT_COMPONENT_ID
,      CONFIG_MODEL_LOOKUP_DATE
,      BASELINE_REV_NBR
,      CONFIG_DELTA_SPEC
,      MODEL_INSTANTIATION_TYPE
,      COMPONENT_INSTANCE_TYPE
,      HAS_FAILURES
,      MODEL_POST_MIGR_CHG_FLAG
FROM APPS.CZ_CONFIG_HDRS_V;

Dependencies

[top of page]

APPS.CZ_CONFIG_HDRS_V references the following:

APPS: CZ_CONFIG_HDRS

APPS.CZ_CONFIG_HDRS_V is referenced by following:

APPS: CSI_ITEM_INSTANCE_PUB - show dependent code; OKC_XPRT_UTIL_PVT - show dependent code