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_DETAILS_V

Object Details

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

View Type

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

CZ_CONFIG_DETAILS_V provides an interface that gathers into one place all of the information required to use a saved configuration.
In addition to the identity of each line of the configuration, the view contains the pricing and ATP data computed for each line, and the specific information required to add that line to a Sales Order.
The CZ_CONFIG_DETAILS_V view contains a record for each CZ_CONFIG_ITEMS record in a saved configuration.
This view is read only.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIG_HDR_ID	NUMBER		Yes	Configuration header identifier
CONFIG_REV_NBR	NUMBER	(9)	Yes	Configuration revision number
CONFIG_ITEM_ID	NUMBER		Yes	Identifier of the confiuration item. This ID has no relation to the inventory_item_id
PARENT_CONFIG_ITEM_ID	NUMBER			Parent confiuration item identifier
SEQUENCE_NBR	NUMBER			Sequence number of the item inside the configuration
INVENTORY_ITEM_ID	NUMBER	(9)		Identifier of the inventory item associated with the configuration item (if any)
ORGANIZATION_ID	NUMBER	(9)		Identifier of the inventory organization associated with the configuration item (if any)
COMPONENT_CODE	VARCHAR2	(1200)		Component_code from bom_explosions
COMPONENT_SEQUENCE_ID	NUMBER	(15)		Component_sequence_id from bom_explosions
QUANTITY	NUMBER			Configured quantity of the item
UOM_CODE	VARCHAR2	(3)		Unit of measure code for the item
QUOTEABLE_FLAG	VARCHAR2	(1)		Indicates this item can be separately quoted.
BOM_ITEM_TYPE	NUMBER	(9)		BOM item type if applicable: 1 - model; 2 - option class; 4 - standard item.
PS_NODE_ID	NUMBER	(15)		Associates this record with a Model structure node ('psnode')
USER_STR01	VARCHAR2	(255)		Standard extension field (string)
USER_STR02	VARCHAR2	(255)		Standard extension field (string)
USER_STR03	VARCHAR2	(255)		Standard extension field (string)
USER_STR04	VARCHAR2	(255)		Standard extension field (string)
USER_NUM01	NUMBER			Standard extension field (numeric)
USER_NUM02	NUMBER			Standard extension field (numeric)
USER_NUM03	NUMBER			Standard extension field (numeric)
USER_NUM04	NUMBER			Standard extension field (numeric)
BOM_SORT_ORDER	VARCHAR2	(4000)		Holds the 'sort order' value for nodes imported from Oracle Bills of Material (denormalization)
MODEL_CONFIG_ITEM_ID	NUMBER	(15)		For upgrades to installed networks, records the top configuration item for the instance in which this item resides.
ATO_CONFIG_ITEM_ID	NUMBER	(15)		In Solution-type configurations, identifies the top or outermost ATO-model item in which this item is included
NAME	VARCHAR2	(255)		Persistent name for this item, user interfaces and functional companions can allow users to set.
INSTANCE_HDR_ID	NUMBER		Yes	For configuration networks, records the Header ID for the configuration instance of which this item is a part. A subtree of the overall configuration (which is identified by CONFIG_HDR_ID)
INSTANCE_REV_NBR	NUMBER		Yes	For connectors/references, records the rev number for the instance to which this item is connected
LINE_TYPE	NUMBER			Indicates the type of fulfillment action needed to order this item, specifically for upgrades to installed networks.
COMPONENT_INSTANCE_TYPE	VARCHAR2	(1)	Yes	Distinguishes different types of configurable items. Allowed values are 'R', 'I', and 'T'.
TARGET_HDR_ID	NUMBER			For connectors/references, records the instance-level configuration header
TARGET_REV_NBR	NUMBER			For connectors/references, records the rev number for the instance to which this item is connected
CONFIG_DELTA	NUMBER		Yes	For upgraded configurations, encodes the types of changes made to this item since it was previously saved.
LOCATION_ID	NUMBER			Location to which this item is to be installed/upgraded. Cf. CZI_T_TXN_LINE_DETAILS LOCATION_ID
LOCATION_TYPE_CODE	VARCHAR2	(255)		Type of location key for LOCATION_ID. Cf. CZI_T_TXN_LINE_DETAILS LOCATION_TYPE_CODE
IB_TRACKABLE	VARCHAR2	(1)		Identifies this as an item trackable in Installed Base; copied from corresponding data in MTL_SYSTEM_ITEMS (and CZ_PS_NODES)
EXT_ACTIVATED_FLAG	VARCHAR2	(1)		For upgrades to installed networks, this flag indicates whether this item was saved from an externally-activated instance.
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'
DISCONTINUED_FLAG	VARCHAR2	(1)	Yes
ITEM_SRC_APPL_ID	NUMBER
TANGIBLE_ITEM_FLAG	VARCHAR2	(1)
RETURNED_FLAG	VARCHAR2	(1)

Query Text

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


SELECT CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      CONFIG_ITEM_ID
,      PARENT_CONFIG_ITEM_ID
,      SEQUENCE_NBR
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPONENT_CODE
,      COMPONENT_SEQUENCE_ID
,      QUANTITY
,      UOM_CODE
,      QUOTEABLE_FLAG
,      BOM_ITEM_TYPE
,      PS_NODE_ID
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      BOM_SORT_ORDER
,      MODEL_CONFIG_ITEM_ID
,      ATO_CONFIG_ITEM_ID
,      NAME
,      INSTANCE_HDR_ID
,      INSTANCE_REV_NBR
,      LINE_TYPE
,      COMPONENT_INSTANCE_TYPE
,      TARGET_HDR_ID
,      TARGET_REV_NBR
,      CONFIG_DELTA
,      LOCATION_ID
,      LOCATION_TYPE_CODE
,      IB_TRACKABLE
,      EXT_ACTIVATED_FLAG
,      MODEL_INSTANTIATION_TYPE
,      DISCONTINUED_FLAG
,      ITEM_SRC_APPL_ID
,      TANGIBLE_ITEM_FLAG
,      RETURNED_FLAG
FROM APPS.CZ_CONFIG_DETAILS_V;

Dependencies

[top of page]

APPS.CZ_CONFIG_DETAILS_V references the following:

APPS: CZ_CONFIG_HDRS; CZ_CONFIG_ITEMS; CZ_UTILS - show dependent code

APPS.CZ_CONFIG_DETAILS_V is referenced by following:

APPS: ASO_ATP_INT - show dependent code; ASO_CFG_INT - show dependent code; ASO_CONFIG_OPERATIONS_PVT - show dependent code; ASO_QUOTE_HEADERS_PVT - show dependent code; ASO_QUOTE_LINES_PVT - show dependent code; ASO_VALIDATE_PVT - show dependent code; CSI_ITEM_INSTANCE_PUB - show dependent code; CZ_BOM_CONFIG_EXPLOSIONS_PKG - show dependent code; CZ_CF_API - show dependent code; CZ_IB_LOCKING - show dependent code; CZ_RUNTIME - show dependent code; CZ_UPGRADE - show dependent code; IBE_ORDER_DETAIL_V; IBE_QUOTE_SAVESHARE_PVT - show dependent code; OE_BULK_CONFIG_UTIL - show dependent code; OE_CONFIG_PVT - show dependent code; OE_CONFIG_TSO_PVT - show dependent code; OE_CONFIG_UTIL - show dependent code; OE_DEFAULT_LINE - show dependent code; OE_OE_FORM_LINE - show dependent code; OE_ORDER_PVT - show dependent code