Results for “offer_discount_line_id”

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

Overview

OZF_DISCOUNT_PRODUCT_RELN is a Trade Management (OZF) table in Oracle E-Business Suite that stores Discount line relationships. Within the Oracle Trade Management discount and offer framework, this table functions as the association object that links an offer discount line to the specific product records that participate in that discount. In heuristic Data Vault modeling terms, this object classifies as a link table: it resolves a many-to-many relationship between discount lines and discount products rather than carrying descriptive master data of its own. Each row represents one such association, identified by the surrogate primary key DISCOUNT_PRODUCT_RELN_ID.

The table is owned by the OZF schema and is marked VALID in the ETRM 12.1.1 and 12.2.2 environments. Its physical schema comprises nine documented columns, of which the remaining eight beyond the primary key are primarily foreign keys and standard Who-column audit attributes.

Key Information Stored

The most important columns documented in the ETRM metadata are as follows:

• DISCOUNT_PRODUCT_RELN_ID — Surrogate primary key of the relationship row. This column is also the sole column of the unique index OZF_DISCOUNT_PRODUCT_RELN_U1, making it the business-key candidate in the documented schema.
• OFFER_DISCOUNT_LINE_ID — Foreign key to OZF_OFFER_DISCOUNT_LINES. Identifies the discount line to which the product association belongs.
• OFF_DISCOUNT_PRODUCT_ID — Foreign key to OZF_OFFER_DISCOUNT_PRODUCTS. Identifies the specific product record that is related to the discount line.
• CREATION_DATE, CREATED_BY — Standard audit columns recording when the relationship row was created and by which user.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification of the row and the login context associated with it.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OZF framework to detect concurrent updates.

Together these columns carry no descriptive business attributes; the table's informational value is entirely relational, expressing which products are attached to which discount lines.

Common Use Cases and Queries

Typical usage of this table is to enumerate the products associated with a given offer discount line, or conversely to find all discount lines that reference a particular discount product. A representative join pattern is:

• Join OZF_DISCOUNT_PRODUCT_RELN to OZF_OFFER_DISCOUNT_LINES on OFFER_DISCOUNT_LINE_ID to retrieve discount line attributes for each product association.
• Join OZF_DISCOUNT_PRODUCT_RELN to OZF_OFFER_DISCOUNT_PRODUCTS on OFF_DISCOUNT_PRODUCT_ID to retrieve the product detail behind each association.
• Filter by OFFER_DISCOUNT_LINE_ID when reporting on the product coverage of a single discount line.
• Use CREATION_DATE and LAST_UPDATE_DATE for audit, reconciliation, and change-tracking reports.

Because the table is a relationship link, reporting queries usually aggregate counts of products per discount line or resolve product descriptions through the foreign-key parents.

Related Objects

• OZF_OFFER_DISCOUNT_LINES — Parent table referenced via OFFER_DISCOUNT_LINE_ID.
• OZF_OFFER_DISCOUNT_PRODUCTS — Parent table referenced via OFF_DISCOUNT_PRODUCT_ID.
• OZF_DISCOUNT_PRODUCT_RELN_PK — Primary key constraint on DISCOUNT_PRODUCT_RELN_ID.
• OZF_DISCOUNT_PRODUCT_RELN_U1 — Unique index on DISCOUNT_PRODUCT_RELN_ID.
• OZF_OFFER_DISCOUNT_LINES and OZF_OFFER_DISCOUNT_PRODUCTS together form the core join path for extracting discount-line-to-product relationships.

Any OZF Trade Management discount setup, offer validation, or reporting process that resolves product eligibility for discount lines will traverse this table through its two documented foreign keys.