Search Results cogs_ccid

Overview

The APPS.DPP_XLA_INV_LINES_V view is a distribution accounting extraction object within the Oracle EBS Distribution and Profitability (DPP) module, closely tied to the ETRM (Enterprise Transaction and Reconciliation Management) and SLA (Subledger Accounting) architectures available in release 12.1.1 and 12.2.2. The view exposes inventory transaction line data alongside its associated accounting entries, producing a flattened, XLA-compatible record set that maps physical material movements in MTL_MATERIAL_TRANSACTIONS to their corresponding subledger accounting events and lines. Its principal role is to serve as a reporting and integration bridge between the inventory valuation layer and the General Ledger, enabling reconciliation of inventory cost adjustments to journal entries. Because the view synthesizes ledger context (GL_LEDGERS), operating unit metadata (HR_OPERATING_UNITS), and item-level accounting configuration (MTL_SYSTEM_ITEMS_B), it is frequently used in reconciliation scripts, diagnostics, and custom reporting where a combined inventory-and-accounting perspective is required.

Underlying Base Objects

The view is defined over a multi-table join. Documented referenced objects include:

• DPP_XLA_INV_HEADERS_V (VIEW) — supplies the event header context, including event_id and org_id.
• DPP_XLA_LINES — links the accounting event to its base transaction line identifier.
• DPP_TRANSACTION_HEADERS_ALL and DPP_TRANSACTION_LINES_ALL — provide distribution transaction metadata and descriptive attributes.
• MTL_MATERIAL_TRANSACTIONS — supplies the actual cost, quantity, and transaction attributes.
• MTL_SYSTEM_ITEMS_B — sources item-level accounting and identification attributes such as COST_OF_SALES_ACCOUNT.
• GL_LEDGERS — provides the ledger_id and currency code.
• HR_OPERATING_UNITS — resolves the operating unit to its set of books/ledger.
• DPP_XLA_EVENT_PUB (PACKAGE) — supports event processing logic used by the view family.

Joins are driven primarily by TRANSACTION_ID, TRANSACTION_HEADER_ID, BASE_TRANSACTION_LINE_ID, ORGANIZATION_ID, and INVENTORY_ITEM_ID.

Key Columns

• EVENT_ID / LINE_NUMBER — SLA event identifier and a row number partitioned by event, forming a synthetic distribution line reference.
• ENTERED_AMOUNT / ACCOUNTED_AMOUNT — computed as (prior_cost − new_cost) × quantity_adjusted, representing the cost adjustment value.
• COGS_CCID — sourced from MTL_SYSTEM_ITEMS_B.COST_OF_SALES_ACCOUNT; the cost of sales account code combination central to COGS reconciliation.
• CURRENCY_CODE, LEDGER_ID — ledger and currency context obtained via GL_LEDGERS.
• TRANSACTION_ID, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_DATE — identify and timestamp the underlying material transaction.
• ORGANIZATION_ID, INVENTORY_ITEM_ID, SUBINVENTORY_CODE, LOCATOR_ID, COST_GROUP_ID — inventory-level positioning attributes.
• ATTRIBUTE1–ATTRIBUTE30, SUPPLIER_PART_NUM, PRIOR_PRICE, CHANGE_TYPE, CHANGE_VALUE — flexible descriptive fields sourced from DPP_TRANSACTION_LINES_ALL.

Common Use Cases and Queries

The view is most commonly queried to reconcile cost adjustments against configured cost of sales accounts. A typical query filtering on the COGS account follows:

• SELECT event_id, transaction_id, cogs_ccid, entered_amount, accounted_amount FROM apps.dpp_xla_inv_lines_v WHERE cogs_ccid = :p_ccid;
• Identifying all inventory events affecting a specific cost of sales code combination.
• Joining to GL_JE_LINES to tie accounted_amount to journal lines.
• Diagnosing discrepancies between inventory cost adjustments and posted subledger entries.
• Extracting line-level XLA event data for downstream reporting or archival.

Because the view performs heavy joins and window functions, query performance benefits from filtering on EVENT_ID, TRANSACTION_ID, or COGS_CCID and from restricting date ranges via TRANSACTION_DATE.