Results for “cz_config_contents_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_CONFIG_CONTENTS_V is an APPS-owned unified configuration-item view within the Oracle E-Business Suite Configurator (CZ) module. It presents a consolidated, reporting-friendly representation of configured items together with their associated configuration inputs. Rather than forcing developers and report authors to join the parent configuration item structures to their input details manually, the view exposes a single flattened result set combining columns from both CZ_CONFIG_ITEMS and CZ_CONFIG_INPUTS.

The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is referenced by the ETRM metadata as the "Unified Configuration-item View." Its principal role is to support reporting, extract, and integration scenarios where a complete picture of a configuration model instance — the configuration header, revision, item hierarchy, instance details, and the input values that drive the configuration — is required. Because it is a view rather than a table, it delivers no independent storage; it inherits the read consistency and security characteristics of the underlying Configurator tables.

Underlying Base Objects

The documented base objects behind CZ_CONFIG_CONTENTS_V are two synonyms: CZ_CONFIG_ITEMS and CZ_CONFIG_INPUTS. The view text confirms this by referencing columns from both sources in a single SELECT list. CZ_CONFIG_ITEMS anchors the configuration item (the configurable structure node), while CZ_CONFIG_INPUTS supplies the associated input records that parameterize configuration behavior. The two are related in the view output through shared key columns such as the configuration header identifier, configuration revision number, and configuration item identifier, with CZ_CONFIG_INPUTS also contributing its own CONFIG_INPUT_ID, INPUT_SEQ, and parent/target input references. Because the base objects are synonyms resolving to APPS tables, all standard EBS table conventions — WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — are carried through the view.

Key Columns

• CONFIG_HDR_ID / CONFIG_REV_NBR — configuration header identity and revision, defining the configuration model instance.
• CONFIG_ITEM_ID / PARENT_CONFIG_ITEM_ID / SEQUENCE_NBR — hierarchical positioning of each configuration item within the structure.
• INPUT_SEQ — the sequence number of the configuration input; the column most likely sought in the user's search, used to order inputs within their parent item or input group.
• CONFIG_INPUT_ID / PARENT_INPUT_ID / TARGET_CONFIG_INPUT_ID — input record identity and its parent/target relationships.
• INPUT_TYPE_CODE / INSTANCE_ACTION_TYPE / INPUT_VAL / INPUT_NUM_VAL — the input's type, action, and character or numeric value.
• NAME / NODE_IDENTIFIER / PS_NODE_ID — item naming and structure-node references.
• ORGANIZATION_ID / INVENTORY_ITEM_ID — inventory context for the configured item.
• COMPONENT_SEQUENCE_ID / BOM_SORT_ORDER / UOM_CODE — bill-of-materials linkage and ordering.
• USER_NUM01–04 / USER_STR01–04 — configurable user-defined attribute columns.
• QUOTEABLE_FLAG / EXT_ACTIVATED_FLAG / DISCONTINUED_FLAG — item status indicators.

Common Use Cases and Queries

Typical uses include extracting all inputs for a given configuration, ordering them by sequence, and reporting configured items with their input parameters for integration to order management or manufacturing.

Retrieve all inputs for a configuration, ordered by sequence:

• SELECT config_item_id, input_seq, input_type_code, input_val
• FROM cz_config_contents_v
• WHERE config_hdr_id = :p_hdr_id
• ORDER BY config_item_id, input_seq;

List configuration items with their inventory context:

• SELECT config_item_id, name, organization_id, inventory_item_id, user_num01
• FROM cz_config_contents_v
• WHERE quoteable_flag = 'Y'
• AND discontinued_flag = 'N';

Because the view joins items to inputs, results repeat item attributes for each input row; consumers should aggregate or filter accordingly.