Search Results dpp_xla_inv_lines_v




Overview
Explore in AI Chat

Overview

The DPP_XLA_INV_LINES_V view is an Oracle E-Business Suite dictionary object owned by the APPS schema and classified under the DPP – Oracle Price Protection product. Its documented description, "Dpp SLA Cost Update Lines View," identifies it as a reporting and integration interface that presents inventory cost update transaction lines to the Subledger Accounting (SLA) engine. The view is marked VALID in ETRM metadata for the 12.1.1 and 12.2.2 releases.

The view translates raw inventory valuation activity into line-level accounting candidates. Each row represents a single cost adjustment line, combining the transaction context from MTL_MATERIAL_TRANSACTIONS, the corresponding Price Protection transaction line, ledger and currency information from GL_LEDGERS, and the descriptive attributes carried on DPP_TRANSACTION_LINES_ALL. Because it exposes the accounting amount, the ledger, the distribution identifier, and the full attribute column set, it functions as the source for creating journal entries and for reconciliation reporting. The presence of DPP_XLA_EVENT_PUB among the referenced objects confirms that the view participates in the Price Protection SLA event publication flow.

Underlying Base Objects

The view is defined over the following documented base objects and synonyms:

The joins tie each material transaction to its DPP line, its ledger and operating unit, and its item definition, producing one accounting line per cost update event.

Key Columns

Common Use Cases and Queries

Typical uses include verifying the amounts fed to SLA, reconciling Price Protection cost changes to inventory valuation, and extracting DFF attributes for analysis. A representative query:

  • SELECT event_id, line_number, transaction_id, item_number, entered_amount, accounted_amount, currency_code, ledger_id, attribute_category FROM dpp_xla_inv_lines_v WHERE event_id = :p_event_id ORDER BY line_number;
  • Filtering by attribute_category to isolate lines carrying a specific descriptive flexfield context for reporting.
  • Joining event_id back to SLA tables to confirm that posted journal lines match the amounts presented here.