Search Results dpp_transaction_lines_all_n1

Overview

DPP.DPP_TRANSACTION_LINES_ALL is the line-level detail table for Oracle E-Business Suite's Price Protection (DPP) module. It stores the individual line records that belong to a Price Protection transaction header, capturing supplier price changes at the item and organization level. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are housed in APPS_TS_TX_IDX. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the calculation, approval, and downstream propagation of supplier price protection claims.

From a Data Vault modeling perspective, the heuristic classification is standalone, meaning the table does not exhibit a dominant parent-child FK structure within the mined schema. This classification should be treated as a modeling suggestion rather than a hard dependency. The documented primary key is DPP_TRANSACTION_LINES_ALL_PK, defined on TRANSACTION_LINE_ID. Because ORG_ID is present, the table is multi-org enabled and stores line detail per operating unit.

Key Information Stored

The table contains 72 documented columns. The most significant are:

• TRANSACTION_LINE_ID — Surrogate primary key; uniquely identifies each line. It is also the single column in unique index DPP_TRANSACTION_LINES_ALL_U1, making it the documented business-key candidate.
• TRANSACTION_HEADER_ID — FK-style reference to the parent transaction header. Indexed by DPP_TRANSACTION_LINES_ALL_N1 together with INVENTORY_ITEM_ID.
• LINE_NUMBER — Sequential line number within the transaction.
• INVENTORY_ITEM_ID and SUPPLIER_PART_NUM — The affected item.
• PRIOR_PRICE, SUPPLIER_NEW_PRICE, PRICE_CHANGE, CHANGE_TYPE (increase/decrease, amount/percentage), and CHANGE_VALUE — The price change metrics driving the claim.
• ONHAND_INVENTORY, COVERED_INVENTORY, APPROVED_INVENTORY, and UOM — Inventory quantities used to compute the claim amount.
• CLAIM_AMOUNT, SUPPLIER_APPROVED_BY, SUPPLIER_APPROVAL_DATE, SUPP_DIST_CLAIM_ID, and SUPP_DIST_CLAIM_STATUS — Claim approval and settlement fields.
• LAST_CALCULATED_DATE and LAST_CALCULATED_BY — Audit of the price protection recalculation.
• Flag columns such as UPDATE_PURCHASING_DOCS, UPDATE_INVENTORY_COSTING, UPDATE_ITEM_LIST_PRICE, and the NOTIFY_* flags — each has its own nonunique index (N2 through N9) for efficient processing by concurrent programs.

Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY), concurrent request columns (REQUEST_ID, PROGRAM_ID), OBJECT_VERSION_NUMBER, and ATTRIBUTE1 through ATTRIBUTE30 (with ATTRIBUTE_CATEGORY) are also present for auditing, extensibility, and locking.

Common Use Cases and Queries

Typical usage includes generating price protection claim reports, identifying lines pending supplier approval, and auditing downstream updates. A representative query joins header and line detail:

SELECT l.transaction_line_id, l.line_number, l.inventory_item_id, l.prior_price, l.supplier_new_price, l.claim_amount, l.supp_dist_claim_status FROM dpp.dpp_transaction_lines_all l WHERE l.transaction_header_id = :header_id AND l.org_id = :org_id ORDER BY l.line_number;

The N2–N9 indexes support driving batch processes that apply updates to purchasing documents, inventory costing, and price lists, or send notifications. Querying on UPDATE_PURCHASING_DOCS = 'Y' or SUPP_DIST_CLAIM_STATUS helps isolate work queues. Analytical reports frequently aggregate CLAIM_AMOUNT by INVENTORY_ITEM_ID or by supplier using SUPPLIER_PART_NUM.

Related Objects

• DPP_TRANSACTION_HEADERS_ALL — Parent header table, joined via TRANSACTION_HEADER_ID.
• MTL_SYSTEM_ITEMS_B — Item master, joined on INVENTORY_ITEM_ID, referenced by index N1.
• MTL_ONHAND_QUANTITIES — On-hand source for ONHAND_INVENTORY / COVERED_INVENTORY.
• PO_HEADERS_ALL / PO_LINES_ALL — Purchasing documents updated when UPDATE_PURCHASING_DOCS is set.
• CST_ITEM_COSTS — Inventory costing targets referenced by UPDATE_INVENTORY_COSTING.
• QP_LIST_HEADERS_B / QP_LIST_LINES — Price lists affected by UPDATE_ITEM_LIST_PRICE and the NOTIFY_* flags.
• DPP_SUPP_DIST_CLAIMS — Supplier/distributor claim entity referenced by SUPP_DIST_CLAIM_ID.
• FND_CONCURRENT_REQUESTS — Correlates batch processing via REQUEST_ID.

The nine documented indexes and the parent-child relationship with the header table make DPP_TRANSACTION_LINES_ALL the central operational table of the Price Protection workflow.