Search Results cst_xla_rcv_headers_v




Overview
Explore in AI Chat

Overview

CST_XLA_RCV_HEADERS_V is an Oracle E-Business Suite dictionary view owned by the APPS schema (status VALID), catalogued under the BOM – Bills of Material product family. It exists to expose receiving sub-ledger accounting events in the uniform column layout expected by the Subledger Accounting (XLA) and Create Accounting engines. Its most distinctive characteristic is the literal DISTRIBUTION_TYPE column, which is hard-coded to the value 'RCV_RECEIVING_SUB_LEDGER' in the view text. This constant identifies every row returned as belonging to the Receiving sub-ledger accounting source, allowing downstream accounting programs and reporting queries to filter, group, and join across multiple sub-ledger "header" views without ambiguity.

The view is not a transactional entity in its own right; it is a thin projection that joins the receiving accounting event data to the XLA event global temporary table and enriches it with currency, conversion, and General Ledger transfer attributes. It therefore serves as the reconciliation bridge between Purchasing/Receiving transactions and their eventual journal entries.

Underlying Base Objects

The view is defined over four documented base objects, all referenced through APPS synonyms:

The /*+ CARDINALITY(XEG, 1) */ hint reflects the expected one-row-per-event resolution of the XLA events table in this context.

Key Columns

  • EVENT_ID — the XLA event identifier from XLA_EVENTS_GT.
  • DISTRIBUTION_TYPE — literal 'RCV_RECEIVING_SUB_LEDGER', the discriminator that labels the row set as receiving sub-ledger data.
  • RCV_ACCOUNTING_EVENT_ID — the underlying receiving accounting event reference from RCV_ACCOUNTING_EVENTS.
  • CURRENCY_CODE — resolved via NVL from the event currency, falling back to the ledger functional currency.
  • CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE — conversion attributes that are nulled out when the transaction currency equals the ledger currency, using DECODE logic.
  • TRANSFER_TO_GL_INDICATOR — derived from MTL_PARAMETERS.GENERAL_LEDGER_UPDATE_CODE; returns 'N' when the code equals 3, otherwise 'Y', indicating whether the event transfers to the General Ledger.

Common Use Cases and Queries

The view is typically queried to audit receiving accounting events, confirm GL transfer status, or feed custom sub-ledger extracts. A representative query filtering by the searched attribute is:

  • SELECT event_id, rcv_accounting_event_id, currency_code, transfer_to_gl_indicator FROM cst_xla_rcv_headers_v WHERE distribution_type = 'RCV_RECEIVING_SUB_LEDGER';
  • Joining back to RCV_ACCOUNTING_EVENTS or RCV_TRANSACTIONS on RCV_ACCOUNTING_EVENT_ID for transaction detail.
  • Filtering on TRANSFER_TO_GL_INDICATOR = 'N' to identify events excluded from GL posting under the organization's update code.

Because DISTRIBUTION_TYPE is a constant, its primary use is as a set identifier when this view is unioned with peer sub-ledger header views.