Search Results related_deal_lines_id

Overview

The OZF_RELATED_DEAL_LINES table is a core data object within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves a specific architectural function in the management of complex Trade Deal Offers. In the pricing engine, a single deal line can be configured with two distinct pricing modifiers. This table exists to formally define and store the hierarchical or associative relationship between those two related modifier lines. By capturing this link, it ensures the pricing engine can correctly apply compound business rules and discounts, maintaining data integrity and auditability for sophisticated trade promotions.

Key Information Stored

The table's primary purpose is to link two pricing modifiers. Its key columns, as defined by its foreign key constraints, are central to this function. The RELATED_DEAL_LINES_ID column serves as the unique primary key for each relationship record. The MODIFIER_ID and RELATED_MODIFIER_ID columns are foreign keys that reference the LIST_LINE_ID in the QP_LIST_LINES table, thereby identifying the two specific pricing modifiers that are related within a deal. The QP_LIST_HEADER_ID is a foreign key to the OZF_OFFERS table, anchoring the relationship to a specific parent Trade Deal Offer header. This structure ensures that relationships are scoped correctly within the context of a single deal.

Common Use Cases and Queries

This table is primarily accessed for troubleshooting, reporting, and data validation on complex deal configurations. A common operational use case involves diagnosing pricing calculation errors by verifying the intended relationships between modifiers. For reporting, analysts may query it to understand the prevalence of multi-modifier deal structures across the promotion portfolio. A typical SQL query to retrieve all related modifier pairs for a specific deal would join this table to the QP_LIST_LINES table twice to resolve the modifier identifiers into their detailed definitions.

• Identifying all related lines within a specific offer: SELECT * FROM ozf_related_deal_lines WHERE qp_list_header_id = <header_id>;
• Resolving modifier details for a relationship: SELECT rdl.*, qpl1.list_line_code AS modifier_code, qpl2.list_line_code AS related_modifier_code FROM ozf_related_deal_lines rdl, qp_list_lines qpl1, qp_list_lines qpl2 WHERE rdl.modifier_id = qpl1.list_line_id AND rdl.related_modifier_id = qpl2.list_line_id;

Related Objects

The OZF_RELATED_DEAL_LINES table has defined dependencies on several critical EBS objects, as confirmed by its foreign key constraints. It is fundamentally tied to the pricing engine via the QP_LIST_LINES table, with two separate foreign key relationships for the MODIFIER_ID and RELATED_MODIFIER_ID columns. This table is the source for the actual modifier definitions. Furthermore, it is linked to the Trade Management module's central offer header through a foreign key to the OZF_OFFERS table via the QP_LIST_HEADER_ID column. While not explicitly listed in the provided metadata, this table is also likely referenced by various OZF package bodies (e.g., OZF_OFFER_PVT) that contain the business logic for creating, updating, and validating deal line relationships.