[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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) |
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;
CZ.CZ_CONFIG_ITEMS does not reference any database object
CZ.CZ_CONFIG_ITEMS is referenced by following:
|
|
|