Search Results sequence_nbr




Overview
Explore in AI Chat

Overview

CZ_CONFIG_DETAILS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CZ – Configurator product. Its stated purpose is to provide the information required to use a saved configuration, presenting the component-level detail of configured items in a flattened, join-ready form. The view is registered as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its definition has remained consistent across those releases.

Rather than exposing raw configuration tables directly, the view consolidates item-level records from a configuration header and its associated configuration items, applying filters that remove logically deleted and non-material rows. This makes it suitable for downstream reporting, order capture integration, and custom extensions that must resolve a saved configuration into its constituent components, quantities, and attributes without navigating the internal ETRM data model.

Underlying Base Objects

The view is defined over the following documented base objects:

  • CZ_CONFIG_HDRS (referenced via synonym) — the configuration header table, supplying model instantiation context and header-level deletion status.
  • CZ_CONFIG_ITEMS (referenced via synonym) — the configuration item table, supplying component, quantity, UOM, and attribute columns.
  • CZ_UTILS (package) — used at parse time for its CONV_NUM function to convert the numeric sequence number.

Both tables are joined on configuration identity. The join is effectively driven by CZ_CONFIG_ITEMS, which supplies the header and revision keys, with CZ_CONFIG_HDRS contributing the MODEL_INSTANTIATION_TYPE attribute. The WHERE clause enforces non-deletion on both sides and requires a valid inventory item, organization, and positive quantity, so only actionable configuration lines are surfaced.

Key Columns

Prominent columns exposed by the view include:

Common Use Cases and Queries

The view is typically queried to explode a saved configuration for reporting, order validation, or integration with external systems. A representative query retrieves all live components for a given configuration header:

  • SELECT config_hdr_id, config_item_id, parent_config_item_id, component_code, inventory_item_id, quantity, uom_code FROM cz_config_details_v WHERE config_hdr_id = :p_header_id ORDER BY bom_sort_order;
  • SELECT config_item_id, name, quoteable_flag, line_type FROM cz_config_details_v WHERE inventory_item_id = :p_item_id AND organization_id = :p_org_id;
  • SELECT config_hdr_id, COUNT(*) FROM cz_config_details_v GROUP BY config_hdr_id; — used to determine component counts per configuration.

Typical scenarios include validating that a saved configuration contains only quoteable or tangible items before order import, reconciling model-to-instance component mappings, and feeding configuration detail into custom BI Publisher or OBIEE reporting. Because the view filters on non-deletion and required keys, it should be used as the standard read interface for configuration detail wherever a complete, defect-free component listing is required.