Search Results cz_system_components_v

Overview

CZ_SYSTEM_COMPONENTS_V is a reporting view in the Oracle E-Business Suite Bills of Material (BOM) module, associated with Oracle's configuration and system (ATO/CTO) functionality. It exposes the set of "system components" — that is, the configuration line details that make up configured systems on sales orders — by consolidating data from sales order lines, configuration system headers, service details, and transaction type definitions. The view is primarily used in contexts where configured or assemble-to-order (ATO) products must be reported at the component level, including both the original configuration lines and their revisions.

The view is documented as "System components" with the product designation BOM - Bills of Material. In the ETRM metadata for 12.2.2 it is noted as Not implemented in this database, meaning the object exists as reference documentation but is not physically deployed in the release against which the metadata was captured. This is an important distinction: consultants should verify the object's presence in a given environment before relying on it. The term the user searched, cs_transaction_types, corresponds directly to the CS_TRANSACTION_TYPES table, which is one of the four base tables underlying this view.

Underlying Base Objects

The documented view text establishes that CZ_SYSTEM_COMPONENTS_V is defined over four base tables:

• SO_LINES_ALL — aliased as SOL, providing sales order line attributes such as header, line, item, warehouse, and quantities.
• CS_SYSTEMS_ALL — aliased as CS, supplying the configuration system type and system identifier.
• SO_LINE_SERVICE_DETAILS — aliased as SOD, linking order lines to system identifiers, transaction types, and customer product quantities.
• CS_TRANSACTION_TYPES — aliased as CST, defining the transaction type and its revision flag that classifies lines as original or revised.

These four tables are joined on SYSTEM_ID, LINE_ID, and TRANSACTION_TYPE_ID. The metadata notes that referenced base objects are "none documented," and no owner is recorded; in practice the tables reside in the respective SO and CS schemas. The view is a UNION of two nearly identical SELECT statements, differentiated by the CST.REVISION_FLAG filter.

Key Columns

• SYSTEM_ID — Identifier of the configuration system to which the component belongs.
• CONFIG_SYSTEM_TYPE — The type classification of the configuration system.
• HEADER_ID / LINE_ID — Sales order header and line identifiers for the component line.
• ITEM_TYPE_CODE — Indicates the type of the line item (for example, standard, model, or option class).
• PARENT_LINE_ID / ATO_LINE_ID — Pointers to the parent line and the associated ATO model line, establishing hierarchy.
• INVENTORY_ITEM_ID / WAREHOUSE_ID — The inventory item and warehouse for the component.
• ORDERED_QUANTITY / CANCELLED_QUANTITY / CUSTOMER_PRODUCT_QUANTITY — Quantity metrics, including ordered, cancelled, and customer-product quantities.
• PARENT_QUANTITY — A literal constant of 1 in both branches of the UNION.
• UNIT_CODE — The unit of measure for the line.

Common Use Cases and Queries

Typical uses include reporting configured system contents, reconciling revisions of configured lines, and reconciling ATO component quantities against order lines. The revision handling is keyed on CS_TRANSACTION_TYPES.REVISION_FLAG: the first branch includes flags 'N' and 'Y' while excluding lines already revised, and the second branch captures the revision lines (flag 'R').

A representative query retrieves components for a given order:

• SELECT SYSTEM_ID, HEADER_ID, LINE_ID, ITEM_TYPE_CODE, INVENTORY_ITEM_ID, ORDERED_QUANTITY FROM CZ_SYSTEM_COMPONENTS_V WHERE HEADER_ID = :p_header_id;
• SELECT SYSTEM_ID, CONFIG_SYSTEM_TYPE, COUNT(*) FROM CZ_SYSTEM_COMPONENTS_V GROUP BY SYSTEM_ID, CONFIG_SYSTEM_TYPE;

Because the metadata notes the view is not implemented in the documented database, always confirm its existence and validity status in the target EBS 12.1.1 or 12.2.2 instance before incorporating it into custom reports or integrations.