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_CONTENTS_V

Object Details

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

View Type

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

CZ_CONFIG_CONTENTS_V is a view unifying the CZ_CONFIG_INPUTS and CZ_CONFIG_ITEMS tables exploiting their matching cardinality. It is insertable. All saved-configuration information can be obtained through this view.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIG_HDR_ID	NUMBER		Yes	Identifies configuration header for this record
CONFIG_REV_NBR	NUMBER	(9)	Yes	Specifies configuration revision for this record
CONFIG_ITEM_ID	NUMBER		Yes	Assigns item ID for this record
PARENT_CONFIG_ITEM_ID	NUMBER			Item enclosing this item in the configuration
SEQUENCE_NBR	NUMBER			Orders the children of each PARENT_CONFIG_ITEM_ID
INSTANCE_CONFIG_ITEM_ID	NUMBER	(15)		Specifies the Item ID of the network instance, within this configuration, of which this item is a member
TARGET_CONFIG_ITEM_ID	NUMBER	(15)		For connector/reference items, specifies the connected item
NAME	VARCHAR2	(255)		Persistent name for this item
PS_NODE_ID	NUMBER	(15)		Persistent PS_NODE_ID defining this item
INSTANCE_NBR	NUMBER			Enumerates this record as the instance of a multiply-instantiable model node, if applicable.
ITEM_TYPE_CODE	NUMBER		Yes	Value type code: EMPTY = 0; TEXT = 2; NUMERIC = 3; COMPONENT = 4
ITEM_VAL	VARCHAR2	(4000)		Value of the item
ORGANIZATION_ID	NUMBER	(9)		Organization ID of the defining item, if any
INVENTORY_ITEM_ID	NUMBER	(9)		Inventory Item ID of the defining item, if any
BOM_ITEM_TYPE	NUMBER	(9)		For configuration items that refer to BOM items, specifies the BOM type of the defining item
NODE_IDENTIFIER	VARCHAR2	(1200)		Alternative configuration item identifier
COMPONENT_SEQUENCE_ID	NUMBER	(15)		Sequence identifier of the component instance
BOM_SORT_ORDER	VARCHAR2	(4000)		Provides a sorting key matching the sorting used in Bills of Material.
UOM_CODE	VARCHAR2	(3)		Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'.
QUOTEABLE_FLAG	VARCHAR2	(1)		Indicates whether this item is separately quoteable/orderable
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)
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)
CREATED_BY	NUMBER	(15)	Yes	Standard audit column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard audit column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard audit column
CREATION_DATE	DATE		Yes	Standard audit column
LAST_UPDATE_DATE	DATE		Yes	Standard audit column
ATO_CONFIG_ITEM_ID	NUMBER	(15)		In Solution-type configurations, identifies the top or outermost ATO-model item in which this item is included
CONFIG_INPUT_ID	NUMBER			ID of the Input that is part of this record
INPUT_SEQ	NUMBER	(9)		Records the sequence of the input attached to this record
INPUT_TYPE_CODE	NUMBER			Describes the type of the referenced Input
INSTANCE_ACTION_TYPE	NUMBER	(9)		Records the instance-action, if any, that describes this input
INPUT_VAL	VARCHAR2	(4000)		Records any value entered for this input
TARGET_CONFIG_INPUT_ID	NUMBER			For connector, identifies the input that created the instance to which this record is connected
PARENT_INPUT_ID	NUMBER			In the constructive hierarchy of config inputs, specifies the input for the enclosing item.
INSTANCE_HDR_ID	NUMBER		Yes	In configuration networks, identifies the header for the network instance that contains this item
INSTANCE_REV_NBR	NUMBER		Yes	In configuration networks, identifies the revision of the network instance that contains this item
TARGET_HDR_ID	NUMBER			Records the instance header to which this connector/ref is connected
TARGET_REV_NBR	NUMBER			Records revision of the instance to which this connector/ref record 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
COMPONENT_INSTANCE_TYPE	VARCHAR2	(1)	Yes	Distinguishes different types of configurable items. Allowed values are 'R', 'I', and 'T'.
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.
DISCONTINUED_FLAG	VARCHAR2	(1)	Yes
INPUT_NUM_VAL	NUMBER			Stores numeric input values.
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
,      PARENT_CONFIG_ITEM_ID
,      SEQUENCE_NBR
,      INSTANCE_CONFIG_ITEM_ID
,      TARGET_CONFIG_ITEM_ID
,      NAME
,      PS_NODE_ID
,      INSTANCE_NBR
,      ITEM_TYPE_CODE
,      ITEM_VAL
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      BOM_ITEM_TYPE
,      NODE_IDENTIFIER
,      COMPONENT_SEQUENCE_ID
,      BOM_SORT_ORDER
,      UOM_CODE
,      QUOTEABLE_FLAG
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ATO_CONFIG_ITEM_ID
,      CONFIG_INPUT_ID
,      INPUT_SEQ
,      INPUT_TYPE_CODE
,      INSTANCE_ACTION_TYPE
,      INPUT_VAL
,      TARGET_CONFIG_INPUT_ID
,      PARENT_INPUT_ID
,      INSTANCE_HDR_ID
,      INSTANCE_REV_NBR
,      TARGET_HDR_ID
,      TARGET_REV_NBR
,      CONFIG_DELTA
,      LINE_TYPE
,      LOCATION_ID
,      LOCATION_TYPE_CODE
,      COMPONENT_INSTANCE_TYPE
,      IB_TRACKABLE
,      EXT_ACTIVATED_FLAG
,      DISCONTINUED_FLAG
,      INPUT_NUM_VAL
,      ITEM_NUM_VAL
,      ORIG_SYS_REF
,      ITEM_SRC_APPL_ID
,      PS_NODE_NAME
,      TANGIBLE_ITEM_FLAG
,      RETURNED_FLAG
FROM APPS.CZ_CONFIG_CONTENTS_V;

Dependencies

[top of page]

APPS.CZ_CONFIG_CONTENTS_V references the following:

APPS: CZ_CONFIG_INPUTS; CZ_CONFIG_ITEMS

APPS.CZ_CONFIG_CONTENTS_V is referenced by following:

APPS: CZ_CONFIG_CONTENTS_V_T1; CZ_NETWORK_API_PUB - show dependent code