Search Results rcv_sl_details_id




Overview
Explore in AI Chat

Overview

APPS.RCV_SUB_LEDGER_DET_MRC_V is a multi-reporting-currency (MRC) view in Oracle E-Business Suite that exposes receiving subledger accounting distributions across multiple reporting currencies. In the MRC architecture used prior to full Subledger Accounting (SLA) adoption, each reporting currency required its own set of accounting rows. This view presents the rows held in the MRC subledger detail table for a given set of books, giving reporting and reconciliation users a single read-only interface into receiving-related accounting entries for currencies other than the primary ledger currency.

The view contains no procedural or filtering logic of its own; it is a straight projection of the columns from its single underlying object. Its principal value is abstraction and naming stability: applications and reports can reference RCV_SUB_LEDGER_DET_MRC_V regardless of the physical table name, and the columns are aligned to the standard subledger detail convention (accounted and entered amounts, journal source and category, period name, code combination, and so on). For developers searching on rcv_sl_details_id, this view is the MRC counterpart to the primary receiving subledger detail view and is the correct target when the reported amounts belong to a non-primary reporting currency.

Underlying Base Objects

The view is defined over a single base object, RCV_MC_SUB_LEDGER_DETAILS, which is exposed to APPS through a synonym. Every column in the view corresponds one-to-one with a column in that table; no joins, unions, or aggregations are performed. The relationship is therefore direct: the view is a column-level alias of the table, and all row filtering, currency scoping, and set-of-books restriction must be supplied by the calling query through predicates such as SET_OF_BOOKS_ID, CURRENCY_CODE, or PERIOD_NAME.

Because the object is a simple view rather than a materialized view, no refresh or staleness considerations apply; queries always see the current committed contents of RCV_MC_SUB_LEDGER_DETAILS.

Key Columns

Common Use Cases and Queries

Typical uses include reconciliation of receiving accruals per reporting currency, tracing a receiving transaction's accounting lines to GL, and reporting entered-versus-accounted variances arising from currency conversion.

SELECT rcv_sl_details_id,
       rcv_transaction_id,
       set_of_books_id,
       currency_code,
       accounted_dr,
       accounted_cre
FROM   apps.rcv_sub_ledger_det_mrc_v
WHERE  rcv_sl_details_id = :p_rcv_sl_details_id;

SELECT period_name,
       SUM(accounted_dr) accounted_dr,
       SUM(accounted_cr) accounted_cr
FROM   apps.rcv_sub_ledger_det_mrc_v
WHERE  set_of_books_id = :p_set_of_books_id
AND    period_name = :p_period_name
GROUP  BY period_name;