Search Results cz_exp_tmp_lines




Overview
Explore in AI Chat

Overview

The CZ_EXP_TMP_LINES table is a data object within the Oracle E-Business Suite (EBS) Configurator (CZ) module. As explicitly stated in its official documentation, its status is "OBSOLETE." Historically, it served as a temporary staging table to hold data during the process of exporting configured order or quote information from the Configurator to other transactional modules, such as Order Management. Its role was to facilitate the complex data transfer of configurable item line details, acting as an intermediary structure before final posting to permanent order tables.

Key Information Stored

While the provided metadata does not list the specific columns of CZ_EXP_TMP_LINES, its foreign key relationships and purpose indicate the general nature of the data it once contained. Based on its role in order export and its links to other Configurator tables, it would have stored temporary line-level details for a configured transaction. Critical data points likely included a unique session or transaction identifier, a link to the source configurator model, the configured item's inventory item ID, and detailed attribute selections that define the specific configuration. The documented foreign keys to CZ_QUOTE_HDRS on QUOTE_HDR_ID and QUOTE_REV_NBR confirm it was designed to associate these temporary line records with a specific quote header and revision.

Common Use Cases and Queries

Given its obsolete status, this table should not be used in new developments, custom reports, or integrations. In active implementations, any existing code referencing this table is part of a legacy process and should be reviewed for migration to supported APIs. Historical analysis of old export sessions, if data remains, would be the only potential use case. A sample query to investigate such legacy data, joining to the quote header, would be:

  • SELECT tmp.*, hdr.quote_number FROM cz_exp_tmp_lines tmp, cz_quote_hdrs hdr WHERE tmp.quote_hdr_id = hdr.quote_hdr_id AND tmp.quote_rev_nbr = hdr.quote_rev_nbr;

Oracle strongly recommends using the supported public interfaces and APIs of the Configurator and Order Management modules for all export and transaction processing.

Related Objects

The primary related object, as defined by its foreign key constraint, is the CZ_QUOTE_HDRS table. This relationship ties the temporary export lines to a permanent quote header record. The table is part of the CZ (Configurator) schema and is intrinsically linked to the core configurator engine's data model, including tables such as CZ_MODELS, CZ_CONFIG_HEADERS, and CZ_DEVL_PROJECTS. For current order export functionality, integration points with the Oracle Order Management module's tables (e.g., OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL) via published APIs are the relevant successors to this obsolete table's function.