Search Results posted_amount

Overview

The PA_NL_TRANSFER_AP_INV_VIEW view, owned by the APPS schema in Oracle E-Business Suite, presents a consolidated, project-oriented projection of Payables invoice distribution data used by the Projects (PA) module. Its documented purpose is to expose project-related invoice distributions held in Oracle Payables, with the additional attribute of resolving accrual accounting behavior for purchase-order-matched distributions. The view is categorized as VALID and is a standard component of the PA - Projects product line in both 12.1.1 and 12.2.2.

The view's primary role is to serve as a reporting and integration layer for downstream Projects processing, allowing project costing, transfer, and reconciliation logic to read AP invoice distribution facts without directly querying the underlying Payables and Purchasing tables. Because it centralizes the logic that determines which code combination applies to a distribution, it reduces duplication of that logic in custom reports, interfaces, and extracts. The object is commonly referenced by users seeking currency-related fields such as EXCHANGE_RATE, EXCHANGE_RATE_TYPE, and EXCHANGE_DATE, which are the columns most closely associated with "receipt_conversion_rate" style lookups. Note that no column named RECEIPT_CONVERSION_RATE exists in the documented structure; the nearest documented equivalents are EXCHANGE_RATE and EXCHANGE_RATE_TYPE.

Underlying Base Objects

The ETRM metadata documents four referenced base objects, all accessed through synonyms in the APPS schema:

• AP_INVOICE_DISTRIBUTIONS_ALL — the primary source, aliased as DIST, supplying invoice distribution identifiers, amounts, accounting dates, tax and accrual attributes, and currency conversion fields.
• PO_DISTRIBUTIONS — aliased as PO, supplying purchase-order distribution identifiers, the ACCRUE_ON_RECEIPT_FLAG, and the purchase-order code combination.
• PO_LINES_ALL — joined to provide purchase-order line context for matched distributions.
• MTL_SYSTEM_ITEMS — provides item-level context for inventory and expense items referenced by invoice lines.

The defining characteristic of the view is the conditional expression DECODE(PO.ACCRUE_ON_RECEIPT_FLAG, 'Y', PO.CODE_COMBINATION_ID, DIST.DIST_CODE_COMBINATION_ID). Where accrual on receipt is enabled, the distribution's accounting code combination is sourced from the purchase order rather than the invoice distribution, reflecting the accounting treatment appropriate to receipt-accrued transactions. Similarly, NVL(PO.PO_DISTRIBUTION_ID, DIST.PO_DISTRIBUTION_ID) harmonizes the PO distribution reference across both pathways.

Key Columns

• INVOICE_ID — the parent Payables invoice identifier.
• DISTRIBUTION_LINE_NUMBER / DISTRIBUTION_LINE_NUMBER — positioning of the distribution within the invoice.
• AMOUNT, BASE_AMOUNT, STAT_AMOUNT — entered, converted (functional) and statistical amounts.
• EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE — currency conversion attributes; these are the documented fields closest to the "receipt_conversion_rate" concept.
• EXCHANGE_RATE_VARIANCE, INVOICE_PRICE_VARIANCE, BASE_INVOICE_PRICE_VARIANCE — variance amounts posted to their respective accounts.
• ACCOUNTING_DATE, PERIOD_NAME, SET_OF_BOOKS_ID — accounting period and ledger placement.
• POSTED_FLAG, PA_ADDITION_FLAG, ASSETS_ADDITION_FLAG, ACCRUAL_POSTED_FLAG, CASH_POSTED_FLAG — status indicators controlling downstream processing.
• PO_DISTRIBUTION_ID and the resolved CODE_COMBINATION_ID — the linkage and account derivation described above.

Common Use Cases and Queries

Typical uses include project cost extracts, Payables-to-Projects reconciliation, accrual-on-receipt reporting, and multi-currency analysis. The following query retrieves project-related distributions with their conversion attributes:

• SELECT invoice_id, distribution_line_number, amount, exchange_rate, exchange_rate_type, exchange_date FROM apps.pa_nl_transfer_ap_inv_view WHERE period_name = :p_period;
• SELECT invoice_id, SUM(amount) FROM apps.pa_nl_transfer_ap_inv_view WHERE pa_addition_flag = 'Y' GROUP BY invoice_id;
• SELECT invoice_id, amount, exchange_rate_variance FROM apps.pa_nl_transfer_ap_inv_view WHERE exchange_rate_type IS NOT NULL;

Because the view is a read-only projection, it is suitable for ad-hoc reporting and interface extracts rather than transactional updates. Confirm synonym visibility and the APPS schema on the target instance before use.