Search Results cz_opportunity_hdrs




Overview
Explore in AI Chat

Overview

The CZ_OPPORTUNITY_HDRS table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as the master header table for sales opportunities created and managed through the SellingPoint application. An opportunity represents a potential sales transaction, and this table stores the foundational, non-configuration-specific metadata for each opportunity record. Its primary role is to serve as a central reference point, linking an opportunity to related customer data, configuration sessions, quotes, and proposals within the Configurator's data model.

Key Information Stored

The table's structure is centered on the unique identifier for each opportunity. The primary key column, OPPORTUNITY_HDR_ID, is the critical field used to join this header record to all related transactional data. Other significant foreign key columns establish core business relationships. The CUSTOMER_ID column links the opportunity to a specific customer record in the CZ_CUSTOMERS table, identifying the purchasing party. The END_USER_ID column, referencing the CZ_END_USERS table, can distinguish the final consumer of the product or service from the purchasing customer. Collectively, these columns define the "who" and "what" of the sales opportunity at the header level.

Common Use Cases and Queries

This table is essential for reporting and integration processes that track the sales pipeline within the Configurator environment. A common use case involves generating a list of all open opportunities with associated customer information for a sales manager. Another typical scenario is tracing the lineage of a finalized configuration or quote back to its originating opportunity for audit or analysis purposes. A sample query to retrieve basic opportunity header data with customer details would be:

  • SELECT oh.OPPORTUNITY_HDR_ID, oh.CREATION_DATE, c.CUSTOMER_NAME
  • FROM CZ.CZ_OPPORTUNITY_HDRS oh, CZ.CZ_CUSTOMERS c
  • WHERE oh.CUSTOMER_ID = c.CUSTOMER_ID;

Data from this table is also frequently accessed by the Configurator's internal APIs and user interfaces when loading or referencing an existing opportunity record.

Related Objects

The CZ_OPPORTUNITY_HDRS table has defined foreign key relationships with several other key Configurator tables, as documented in the ETRM. It is a parent table to multiple transactional entities. The OPPORTUNITY_HDR_ID column is referenced by the following child tables, creating a one-to-many relationship from the header to its details:

  • CZ_CONFIG_HDRS: Links an opportunity to one or more configuration sessions (CZ_CONFIG_HDRS.OPPORTUNITY_HDR_ID).
  • CZ_OPP_HDR_CONTACTS: Stores contact information associated with the opportunity header (CZ_OPP_HDR_CONTACTS.OPPORTUNITY_HDR_ID).
  • CZ_PROPOSAL_HDRS: Links the opportunity to formal sales proposals (CZ_PROPOSAL_HDRS.OPPORTUNITY_HDR_ID).
  • CZ_QUOTE_HDRS: Links the opportunity to formal sales quotes (CZ_QUOTE_HDRS.OPPORTUNITY_HDR_ID).

Conversely, it is a child table to master data tables via its own foreign keys:

  • CZ_CUSTOMERS: References the customer (CZ_OPPORTUNITY_HDRS.CUSTOMER_ID).
  • CZ_END_USERS: References the end user (CZ_OPPORTUNITY_HDRS.END_USER_ID).