Search Results cst_xla_inv_lines_v




Overview
Explore in AI Chat

Overview

CST_XLA_INV_LINES_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 view owned by the APPS schema. It belongs to the Bills of Material (BOM) product family and serves as a subledger accounting (XLA) line-level source for inventory and cost management transactions. The view transforms accounting lines stored against material transactions into the standardized XLA line format required by the Subledger Accounting engine and its downstream journal creation processes.

Each row represents a single accounting line associated with an inventory event. The view is designed to be consumed by the XLA accounting program (CSTPSCHK and related cost management accounting packages) and by technical consultants building reconciliation, audit, and reporting queries that require the granular accounting detail behind inventory events. Because it aligns with the XLA event model, it is particularly relevant when tracing how inventory transactions are converted into journal entries, and it surfaces inventory-specific attribute such as cost element, basis type, and material/overhead identifiers referenced against a transfer cost group context.

Underlying Base Objects

The view is defined over the following documented base objects:

  • CSTPSCHK (PACKAGE) — Cost management package supplying accounting logic and validation used in the view definition.
  • CST_XLA_INV_HEADERS_V (VIEW) — The header-level companion view providing event header attributes.
  • GL_LEDGERS (SYNONYM) — Supplies the ledger currency code used when transaction currency is null.
  • MTL_MATERIAL_TRANSACTIONS (SYNONYM) — Source of transaction date, primary quantity, and currency conversion information.
  • MTL_PARAMETERS (SYNONYM) — Organization-level inventory parameters.
  • MTL_TRANSACTION_ACCOUNTS (SYNONYM) — The core accounting distribution table supplying code combination, amounts, rates, cost element, and reference account.
  • XLA_EVENTS_GT (SYNONYM) — The XLA events global temporary table driving event and line numbering.

The join path leads from XLA_EVENTS_GT through the header view to MTL_TRANSACTION_ACCOUNTS, with MTL_MATERIAL_TRANSACTIONS and GL_LEDGERS supplying defaults. The hint block (LEADING, PUSH_PRED, INDEX on MTL_TRANSACTION_ACCOUNTS_N1) indicates the view is tuned for event-driven access where the event identifier is the primary predicate.

Key Columns

Common Use Cases and Queries

Typical scenarios include event-level accounting reconciliation, transfer cost group tracing, and audit of inventory journal lines.

  • Reconcile inventory events to their accounting lines by EVENT_ID.
  • Trace transfer cost group activity by filtering derived subinventory columns for transfer actions.
  • Audit currency conversion logic where transaction currency differs from ledger currency.

Sample query:

SELECT event_id, line_number, code_combination_id, entered_amount, accounted_amount, accounting_line_type_code, cost_element_id, currency_code FROM cst_xla_inv_lines_v WHERE event_id = :p_event_id ORDER BY line_number;

Because transfer_cost_group_id is not exposed by this view's documented column list, users searching on that term should join to the underlying cost group tables or inspect related cost management views; this view remains the authoritative XLA line source for the associated inventory event.