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_ITEMS_V

Object Details

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

View Type

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

This 'client' view of cz_config_items presents all active (non-deleted) configuration items along with the model-instantiation type recorded in the header. This can contain non-orderable items, e.g., selections the user made on "guided selling" items.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIG_HDR_ID	NUMBER		Yes	Identifies the configuration header for this item
CONFIG_REV_NBR	NUMBER	(9)	Yes	Specifies the configuration revision for this item
CONFIG_ITEM_ID	NUMBER		Yes	Detail item identity
PS_NODE_ID	NUMBER	(15)		Identifies the product-structure node that defines this item, if applicable
VALUE_TYPE_CODE	NUMBER		Yes	Describes the type of value associated with this item: 0 - empty; 2 - text; 3 - numeric; 4 - component
SEQUENCE_NBR	NUMBER			Orders this item among all those sharing the same PARENT_CONFIG_ITEM_ID
ITEM_VAL	VARCHAR2	(4000)		Value of this item
INSTANCE_NBR	NUMBER			For items which created from instantiable model nodes, specifies the instance number for this item
PARENT_CONFIG_ITEM_ID	NUMBER			Identifies the configuration item that contains this item
NODE_IDENTIFIER	VARCHAR2	(1200)		Used to identify an alternative definition of this item; may refer to inventory, Configurator structure, or external specification
INVENTORY_ITEM_ID	NUMBER	(9)		Records inventory identity for those configuration-items that are defined in Inventory
ORGANIZATION_ID	NUMBER	(9)		Records the organization for those configuration-items that are defined in Inventory
COMPONENT_SEQUENCE_ID	NUMBER	(15)		Records the component-sequence for this item when defined in a Bill of Material
UOM_CODE	VARCHAR2	(3)		Units of Measure for the ITEM_VAL
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_ITEM_TYPE	NUMBER	(9)		Records the BOM Item Type for items derived from Bills of Material
QUOTEABLE_FLAG	VARCHAR2	(1)		Indicates whether this item is separately quoteable/orderable
BOM_SORT_ORDER	VARCHAR2	(4000)		Captures the BOM_SORT_ORDER field for items derived from Bills of Material
TARGET_CONFIG_ITEM_ID	NUMBER	(15)		Records the target item for Connector items
INSTANCE_CONFIG_ITEM_ID	NUMBER	(15)		For upgrades to installed networks, records the top configuration item for the instance in which this item resides
NAME	VARCHAR2	(255)		Persistent name for this item; can be set in model UIs, Functional Companions, and custom UIs
ATO_CONFIG_ITEM_ID	NUMBER	(15)		In Solution-type configurations, identifies the top or 'outermost' ATO-model item under which this item is included
INSTANCE_HDR_ID	NUMBER		Yes	For configuration networks, records the header ID for the configuation instance of which this item is a part - a subtree of the overall tree, which is identified by CONFIG_HDR_ID
INSTANCE_REV_NBR	NUMBER		Yes	For configuration networks, records the revision of the configuation instance of which this item is a part (cf INSTANCE HDR_ID)
TARGET_HDR_ID	NUMBER			Records the instance-level configuration header for a connector's target item
TARGET_REV_NBR	NUMBER			Records the instance revision of a connector's target item
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
LOCATION_TYPE_CODE	VARCHAR2	(255)		Specifies the format and source of the LOCATION_ID field
COMPONENT_INSTANCE_TYPE	VARCHAR2	(1)	Yes	Distinguishes different types of configurable items, 'R', 'I', and 'T'
IB_TRACKABLE	VARCHAR2	(1)		Identifies this as an item that is trackable in Installed Base; value is copied from Inventory and Product-Structure data
EXT_ACTIVATED_FLAG	VARCHAR2	(1)		For upgrades to installed networks, this flag indicates whether this item was saved from an externally-activated instance
LINE_TYPE	NUMBER			Indicates the 'line type' for the fulfillment action needed to order this item, specifically in upgrades to installed networks
MODEL_INSTANTIATION_TYPE	VARCHAR2	(1)	Yes	Describes the instantiation rules for the (top) model in this configuration: 'A' - ATO; 'C' -Configurator Native; 'N' - Network; 'P' - PTO; 'S' - Solution
DISCONTINUED_FLAG	VARCHAR2	(1)	Yes
ITEM_NUM_VAL	NUMBER			Stores numeric item values.
ORIG_SYS_REF	VARCHAR2	(1200)
ITEM_SRC_APPL_ID	NUMBER
PS_NODE_NAME	VARCHAR2	(1200)
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
,      PS_NODE_ID
,      VALUE_TYPE_CODE
,      SEQUENCE_NBR
,      ITEM_VAL
,      INSTANCE_NBR
,      PARENT_CONFIG_ITEM_ID
,      NODE_IDENTIFIER
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      UOM_CODE
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      BOM_ITEM_TYPE
,      QUOTEABLE_FLAG
,      BOM_SORT_ORDER
,      TARGET_CONFIG_ITEM_ID
,      INSTANCE_CONFIG_ITEM_ID
,      NAME
,      ATO_CONFIG_ITEM_ID
,      INSTANCE_HDR_ID
,      INSTANCE_REV_NBR
,      TARGET_HDR_ID
,      TARGET_REV_NBR
,      CONFIG_DELTA
,      LOCATION_ID
,      LOCATION_TYPE_CODE
,      COMPONENT_INSTANCE_TYPE
,      IB_TRACKABLE
,      EXT_ACTIVATED_FLAG
,      LINE_TYPE
,      MODEL_INSTANTIATION_TYPE
,      DISCONTINUED_FLAG
,      ITEM_NUM_VAL
,      ORIG_SYS_REF
,      ITEM_SRC_APPL_ID
,      PS_NODE_NAME
,      TANGIBLE_ITEM_FLAG
,      RETURNED_FLAG
FROM APPS.CZ_CONFIG_ITEMS_V;

Dependencies

[top of page]

APPS.CZ_CONFIG_ITEMS_V references the following:

APPS: CZ_CONFIG_HDRS; CZ_CONFIG_ITEMS

APPS.CZ_CONFIG_ITEMS_V is referenced by following:

APPS: CSI_CZ_INT - show dependent code; CSI_INTERFACE_PKG - show dependent code; CSI_ITEM_INSTANCE_PUB - show dependent code; CSI_T_TXN_LINE_DTLS_PVT - show dependent code; CSI_T_TXN_RLTNSHPS_PVT - show dependent code; CSI_T_VLDN_ROUTINES_PVT - show dependent code; CZ_IB_TRANSACTIONS - show dependent code; OKC_XPRT_UTIL_PVT - show dependent code