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_ITEMS

Object Details

Object Name:	CZ_CONFIG_ITEMS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_CONFIG_ITEMS
Subobject Name:
Status:	VALID

CZ_CONFIG_ITEMS stores models, option classes, and options selected for the configuration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: CZ_CONFIG_ITEMS_PK

CONFIG_HDR_ID
CONFIG_REV_NBR
CONFIG_ITEM_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_CONFIG_ITEMS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONFIG_HDR_ID CONFIG_REV_NBR CONFIG_ITEM_ID
CZ_CONFIG_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INSTANCE_HDR_ID INSTANCE_REV_NBR CONFIG_ITEM_ID
CZ_CONFIG_ITEMS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARENT_CONFIG_ITEM_ID CONFIG_ITEM_ID INSTANCE_HDR_ID INSTANCE_REV_NBR DELETED_FLAG
CZ_CONFIG_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONFIG_HDR_ID CONFIG_REV_NBR PARENT_CONFIG_ITEM_ID

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	Unique identifier of configuration item
PS_NODE_ID	NUMBER	(15)		Project structure node identifier
VALUE_TYPE_CODE	NUMBER		Yes	Value type code: EMPTY = 0; TEXT = 2; NUMERIC = 3; COMPONENT = 4;
ROOT_BOM_CONFIG_ITEM_ID	NUMBER	(15)		Configuration item identifier of root bom item
SEQUENCE_NBR	NUMBER			Sequence number of item as a child of its parent
ITEM_VAL	VARCHAR2	(4000)		Item value
INSTANCE_NBR	NUMBER			Component instance number
PARENT_CONFIG_ITEM_ID	NUMBER			Configuration item identifier of the parent item
NODE_IDENTIFIER	VARCHAR2	(1200)		Alternative configuration item identifier
INVENTORY_ITEM_ID	NUMBER	(9)		Inventory item identifier of the configuration item
ORGANIZATION_ID	NUMBER	(9)		Organization identifier
COMPONENT_SEQUENCE_ID	NUMBER	(15)		Sequence identifier of the component instance
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
DELETED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if record 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
UOM_CODE	VARCHAR2	(3)		Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'.
BOM_ITEM_TYPE	NUMBER	(9)		Identifies BOM type for configuration items that refer to BOM items.
QUOTABLE_FLAG	VARCHAR2	(1)
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)		Provides a sorting key matching the sorting used in Bills of Material.
QUOTEABLE_FLAG	VARCHAR2	(1)		Indicates whether this item is separately quoteable/orderable
TARGET_CONFIG_ITEM_ID	NUMBER	(15)		For connector items, this field records the target item when connected.
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, user interfaces and functional companions can allow users to set.
ATO_CONFIG_ITEM_ID	NUMBER	(15)		In Solution-type configurations, identifies the top or outermost ATO-model item in which this item is included
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	Within a configuration network, stores the revision number for the instance containing this item
COMPONENT_INSTANCE_TYPE	VARCHAR2	(1)	Yes	Distinguishes different types of configurable items. Allowed values are 'R', 'I', and 'T'.
DISCONTINUED_FLAG	VARCHAR2	(1)	Yes	'1' a config item has been discontinued, '0' if not. Default value of '0'.
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.
LINE_TYPE	NUMBER			Indicates the type of fulfillment action needed to order this item, specifically for upgrades to installed networks.
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.
ITEM_NUM_VAL	NUMBER			Stores numeric item values.
ORIG_SYS_REF	VARCHAR2	(1200)		Holds the key information by which an imported record can be identified in it source database.
ITEM_SRC_APPL_ID	NUMBER			Source of value is cz_ps_nodes.src_application_id.
PS_NODE_NAME	VARCHAR2	(1200)
TANGIBLE_ITEM_FLAG	VARCHAR2	(1)
RETURNED_FLAG	VARCHAR2	(1)
VALUE_SOURCE	NUMBER	(9)
ORDERABLE_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
,      ROOT_BOM_CONFIG_ITEM_ID
,      SEQUENCE_NBR
,      ITEM_VAL
,      INSTANCE_NBR
,      PARENT_CONFIG_ITEM_ID
,      NODE_IDENTIFIER
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      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
,      UOM_CODE
,      BOM_ITEM_TYPE
,      QUOTABLE_FLAG
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      BOM_SORT_ORDER
,      QUOTEABLE_FLAG
,      TARGET_CONFIG_ITEM_ID
,      INSTANCE_CONFIG_ITEM_ID
,      NAME
,      ATO_CONFIG_ITEM_ID
,      INSTANCE_HDR_ID
,      INSTANCE_REV_NBR
,      COMPONENT_INSTANCE_TYPE
,      DISCONTINUED_FLAG
,      TARGET_HDR_ID
,      TARGET_REV_NBR
,      CONFIG_DELTA
,      LINE_TYPE
,      LOCATION_ID
,      LOCATION_TYPE_CODE
,      IB_TRACKABLE
,      EXT_ACTIVATED_FLAG
,      ITEM_NUM_VAL
,      ORIG_SYS_REF
,      ITEM_SRC_APPL_ID
,      PS_NODE_NAME
,      TANGIBLE_ITEM_FLAG
,      RETURNED_FLAG
,      VALUE_SOURCE
,      ORDERABLE_FLAG
FROM CZ.CZ_CONFIG_ITEMS;

Dependencies

[top of page]

CZ.CZ_CONFIG_ITEMS does not reference any database object

CZ.CZ_CONFIG_ITEMS is referenced by following:

APPS: CZ_CONFIG_ITEMS; CZ_CONFIG_ITEMS_T1