Search Results rcv_sub_ledger_id




Overview
Explore in AI Chat

Overview

APPS.CST_XLA_RCV_LINES_V is a Cost Management (CST) subledger accounting view that exposes the accounting distributions generated for receiving transactions in Oracle E-Business Suite. It bridges Oracle Subledger Accounting (XLA) event data with Receiving subledger accounting lines, producing a line-level, event-oriented representation of receiving accrual, charge, and encumbrance reversal entries. The view is consumed by the Create Accounting process and by downstream reporting and reconciliation tools that need to present receiving accounting entries in a normalized form, including a stable line ordering and a distribution identifier.

Underlying Base Objects

The view is defined over two documented objects: RCV_RECEIVING_SUB_LEDGER (accessed via a synonym) and XLA_EVENTS_GT (accessed via a synonym). RCV_RECEIVING_SUB_LEDGER stores the transactional accounting lines for receiving events, while XLA_EVENTS_GT is the global temporary table populated by the XLA event extraction logic; it carries the EVENT_ID and LEDGER_ID values that link receiving subledger lines to their owning accounting event. The join is performed on XEG.SOURCE_ID_INT_1 = RRS.RCV_TRANSACTION_ID and XEG.SOURCE_ID_INT_2 = RRS.ACCOUNTING_EVENT_ID, restricted to ENTITY_CODE = 'RCV_ACCOUNTING_EVENTS'. A UNION ALL branch handles Encumbrance Reversal lines, which relate to the event through REFERENCE9 rather than the accounting event identifier.

Key Columns

Common Use Cases and Queries

The view is typically queried to reconcile receiving accounting entries, to report on distributions by event, or to trace a specific distribution via its distribution identifier. A representative query retrieving all lines for an event follows:

  • SELECT event_id, line_number, distribution_identifier, rcv_accounting_line_type, accounted_amount, code_combination_id, ledger_id FROM apps.cst_xla_rcv_lines_v WHERE event_id = :event_id ORDER BY line_number;
  • SELECT distribution_identifier, rcv_accounting_line_type, entered_amount, accounted_amount FROM apps.cst_xla_rcv_lines_v WHERE distribution_identifier = :rcv_sub_ledger_id;

Because DISTRIBUTION_IDENTIFIER maps directly to RCV_SUB_LEDGER_ID, it serves as the primary lookup key when reconciling a receiving distribution back to its subledger line and onward to the generated journal entry. Reports frequently group by EVENT_ID and order by LINE_NUMBER to present a consistent, gapless listing of the accounting lines associated with each receiving event.