Results for “item_price”

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

Overview

CZ_PRICES is a Configurator (CZ) module table within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. Its documented description identifies it as the repository for Oracle SellingPoint list prices utilized by the Quote module. In practical terms, the table stores item-level price records organized into price groups, allowing SellingPoint and Configurator-driven quote processes to resolve the applicable list price for a given item within a given pricing context. The table is owned by the CZ schema, carries VALID status, and contains 24 documented columns in the 12.2.2 physical schema.

From a data-modeling perspective, the heuristic Data Vault classification derived from the foreign-key structure is link. This suggests that CZ_PRICES functions as an associative entity resolving a many-to-many-style relationship between items and price groups, with the price value and its effective dating carried as attributes on that association. Modelers treating CZ_PRICES as a link would resolve it against hub-like entities representing items and pricing groups.

Key Information Stored

The primary key, CZ_PRICES_PK, is a composite key defined over PRICE_GROUP_ID and ITEM_ID. Both columns are also foreign keys, so the primary key simultaneously enforces the business rule that an item may appear at most once per price group. The most significant columns include:

• PRICE_GROUP_ID — Identifier of the price group to which the record belongs; references CZ_PRICE_GROUPS.
• ITEM_ID — Identifier of the priced item; references CZ_ITEM_MASTERS.
• ITEM_PRICE — The list price value associated with the item within the price group.
• EFF_FROM_DATE / EFF_TO_DATE — Date-range columns governing the validity window of the price record.
• EFF_FROM / EFF_TO — Additional effective-dating columns, typically used to support versioned or masked price logic.
• DELETED_FLAG — Logical delete indicator, allowing records to be retired without physical removal.
• SECURITY_MASK / EFF_MASK — Masking columns that support access control and effective-dating visibility rules.
• CREATION_DATE / LAST_UPDATE_DATE — Standard EBS audit timestamps.
• CREATED_BY / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard EBS audit accountability columns.
• CHECKOUT_USER — Indicates the user holding the record in a checked-out state, supporting concurrent maintenance.
• USER_NUM01–USER_NUM04 / USER_STR01–USER_STR04 — Descriptive flexfield-style user extension columns for customer-specific data.

The unique index CZ_PRICES_PK (PRICE_GROUP_ID, ITEM_ID) is the documented business-key candidate, distinguishing it from any surrogate identifier.

Common Use Cases and Queries

Typical reporting scenarios include verifying list prices for a set of items in a quote context, auditing price changes over time, and reconciling price groups against item masters. A representative query retrieves active prices for an item:

• Join CZ_PRICES to CZ_ITEM_MASTERS on ITEM_ID and CZ_PRICE_GROUPS on PRICE_GROUP_ID to produce a human-readable price listing.
• Filter with DELETED_FLAG = 'N' and SYSDATE BETWEEN EFF_FROM_DATE AND EFF_TO_DATE to isolate currently effective prices.
• Aggregate by PRICE_GROUP_ID to compare group-level pricing distributions for reporting.

Because PRICE_GROUP_ID and ITEM_ID form the primary key, lookups by either column alone benefit from the composite index; queries filtering solely on ITEM_ID should be reviewed for index efficiency.

Related Objects

The most significant related objects are those directly referenced by or referencing CZ_PRICES:

• CZ_ITEM_MASTERS — joined via CZ_PRICES.ITEM_ID; supplies item definitions for each price record.
• CZ_PRICE_GROUPS — joined via CZ_PRICES.PRICE_GROUP_ID; defines the pricing group context.
• CZ_PRICES_PK — the composite unique index enforcing uniqueness of PRICE_GROUP_ID and ITEM_ID.
• Quote-module objects that consume SellingPoint list prices, which resolve pricing through these same item and group identifiers.

Together these objects form the pricing backbone referenced by Configurator quoting flows across the CZ schema.