Results for “ps_node_type”

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

Overview

CZ_EXP_TMP_LINES is a table in the CZ (Configurator) schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Per Oracle's ETRM repository, the object is marked OBSOLETE and is described as having been "used for order export." It is therefore a legacy staging or temporary structure that once held exploded configuration line detail during the export of configured order or quote information out of the Configurator module. In current releases it carries no active application logic, and Oracle no longer documents it as a supported integration point.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table's attributes describe the state of configuration lines at a point in time, keyed to a parent document header, rather than serving purely as a many-to-many junction or as a standalone business hub.

Key Information Stored

The table contains 17 documented columns. The most significant are:

• QUOTE_HDR_ID and QUOTE_REV_NBR — the foreign key to CZ_QUOTE_HDRS, identifying the parent quote header and its revision. These are the primary business-key candidates linking staged lines to their source document.
• CONFIG_ID — the configuration identifier for the exploded model instance.
• SELF_LINE, PARENT_LINE, ROOT_LINE — line-positioning attributes that reconstruct the hierarchy of a configured item within the export set.
• CHILD_ID, PARENT_ID, ROOT_ID — identifier counterparts to the line columns, expressing parent/child/root relationships among configuration components.
• SO_ITEM_TYPE_CODE and PS_NODE_TYPE — classification codes describing the sales-order item type and the node type of the configuration structure.
• BOM_REQUIRED_FLAG — indicates whether bill-of-material processing is required for the line.
• QUANTITY — the configured quantity carried through export.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard EBS audit columns.

No surrogate primary key is documented for this table; the combination of QUOTE_HDR_ID and QUOTE_REV_NBR with the line identity columns functions as the effective business key.

Common Use Cases and Queries

Because the object is obsolete, production use is limited to historical troubleshooting, upgrade validation, and archival reporting. A representative query retrieves staged lines for a given quote:

• SELECT l.config_id, l.self_line, l.parent_line, l.quantity FROM cz.cz_exp_tmp_lines l WHERE l.quote_hdr_id = :quote_hdr_id AND l.quote_rev_nbr = :rev;
• Joining to the header to reconcile staged volume: SELECT h.*, l.* FROM cz.cz_exp_tmp_lines l JOIN cz.cz_quote_hdrs h ON h.quote_hdr_id = l.quote_hdr_id AND h.quote_rev_nbr = l.quote_rev_nbr;
• Hierarchy reconstruction using ROOT_ID, PARENT_ID and CHILD_ID to rebuild the exploded model tree for audit purposes.

Reporting use cases center on historical order-export reconciliation, migration verification (confirming rows were consumed before upgrade), and data-archival purging, since behavior differs materially between 12.1.1 and 12.2.2.

Related Objects

The documented relationship data identifies one foreign-key dependency, with the broader Configurator and order-capture context supplying additional related objects:

• CZ_QUOTE_HDRS — referenced via CZ_EXP_TMP_LINES.QUOTE_HDR_ID (and QUOTE_REV_NBR); the primary parent document.
• CZ_QUOTE_LINES — the standard quote line table, a logical counterpart to this staging structure.
• CZ_CONFIG_HDRS / CZ_CONFIG_DETAILS — configuration definitions that the staged lines reference through CONFIG_ID and node identifiers.
• OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — the order-export destination objects that this table historically fed.
• CZ_CONFIG_ITEMS and related Configurator APIs (e.g., CZ_CFG_API) — the runtime interfaces whose order-export logic formerly populated this table.

Because the object is obsolete, DBAs should treat all references as historical and avoid building new dependencies against CZ_EXP_TMP_LINES.