Search Results requisition_line_number




Overview
Explore in AI Chat

Overview

JAI_RCV_ACCT_DIST_V is an APPS-owned database view shipped with the Oracle E-Business Suite Asia/Pacific Localizations (JA) product family. It exposes receiving accounting distribution information by joining Receiving (RCV) and Purchasing (PO) base objects with General Ledger and Human Resources reference data. The view is designed primarily to support the accounting distribution requirements of Asia/Pacific localizations, most notably the receipt accounting and subledger extraction processes that feed regional statutory reporting such as excise, VAT, and customs documentation.

Because it presents receiving transaction data alongside GL code combination identifiers, currency conversion attributes, destination/transaction lookup meanings, and Work in Process (WIP) references, the view serves as a consolidated reporting and integration source. It is commonly consulted by localized reporting programs, reconciliation routines, and custom extracts rather than by the standard receiving transaction forms themselves.

Underlying Base Objects

The view is defined over a mix of synonyms, views, and packages. Documented referenced base objects include:

The primary driving table is RCV_TRANSACTIONS (aliased RCT), which supplies the receiving transaction quantities, currency conversion details, and WIP references. It joins to RCV_SHIPMENT_HEADERS (RSH) and RCV_SHIPMENT_LINES (RSL) for receipt number, shipment number, packing slip, vendor, item description, and revision. Purchasing context is obtained through PO_HEADERS, PO_LINES, and PO_REQUISITION_LINES. The localization synonym JAI_RCV_SUBLED_ENTRIES (RRSL) supplies accounting dates, entered debit/credit amounts, currency codes, and source document quantities. GL distribution is linked through GL_CODE_COMBINATIONS.

Key Columns

Common Use Cases and Queries

Typical scenarios include regional receiving accounting reconciliation, statutory receipt-based reporting, and tracing receipts to WIP or GL distributions. A representative query retrieving distributions for a specific receipt is:

SELECT po_number, receipt_number, transaction_id,
       accounting_date, quantity, currency_code,
       entered_dr, entered_credit_or_cr,
       wip_entity_id, wip_repetitive_schedule_id
FROM   apps.jai_rcv_acct_dist_v
WHERE  receipt_number = :receipt_number;

A query isolating receipts linked to repetitive schedules would filter on WIP_REPETITIVE_SCHEDULE_ID IS NOT NULL and join the resulting identifier to the WIP repetitive schedule tables. In practice, the view is consumed by localized subledger and tax reporting programs, and by custom extracts requiring a single denormalized source combining receiving, purchasing, currency, and accounting distribution attributes.