Search Results projfunc_invoice_amount




Overview
Explore in AI Chat

Overview

APPS.PA_PWP_SUPPLIER_INVOICE_V is a reporting view in Oracle E-Business Suite that consolidates supplier invoice information alongside project-related payables and payment metrics. The view is part of the Project Payables Workbench (PWP) family of objects, which supports project-driven procurement and supplier invoice analysis. Its primary purpose is to expose a denormalized, aggregation-ready record set that joins invoice header data with detail-level project accounting amounts, converting and grouping them into meaningful project functional and project currency totals. This makes it particularly suitable for reporting on project invoice amounts in multiple currencies.

The view is significant to users who search for projfunc_invoice_amount, as that column is one of several aggregated monetary measures surfaced by the view. It enables analysts and developers to retrieve the project functional currency equivalent of invoice amounts without manually joining and summing the underlying AP and PA tables. The view is documented in ETRM metadata for release 12.2.2 and applies equally in principle to 12.1.1, where the same base objects and PWP structures are present.

Underlying Base Objects

The view is defined over the following documented objects:

  • PA_PWP_AP_INV_HDR — supplier invoice header data (invoice number, vendor, invoice date, payment status, PO number, hold flags).
  • PA_PWP_AP_INV_DTL — invoice detail lines carrying project, currency, and project accounting amount columns such as PROJFUNC_INVOICE_AMOUNT.
  • PA_PROJECTS_ALL — project master, used in the correlated subquery for period validation.
  • PA_IMPLEMENTATIONS_ALL — implementation/ledger linkage used to associate projects with set of books.
  • GL_PERIOD_STATUSES — general ledger period status, used to confirm that the invoice date falls within an open period.
  • PA_LOOKUPS — lookup values used to derive descriptive code meanings.

Header and detail rows are joined on INVOICE_ID, and the detail amounts are aggregated by project and currency. A correlated subquery over PA_PWP_AP_INV_DTL, GL_PERIOD_STATUSES, PA_PROJECTS_ALL, and PA_IMPLEMENTATIONS_ALL returns an NVL-wrapped summary of PROJFUNC_INVOICE_AMOUNT for invoices falling in an open accounting period, defaulting to 0 when no qualifying period exists.

Key Columns

Common Use Cases and Queries

Typical uses include project cost reporting, supplier invoice reconciliation, and cash flow analysis by project and currency. A representative query retrieving project functional invoice totals by project is:

SELECT PROJECT_ID, PROJFUNC_CURRENCY_CODE, SUM(PROJFUNC_INVOICE_AMOUNT) TOTAL
FROM APPS.PA_PWP_SUPPLIER_INVOICE_V
WHERE PROJECT_ID = :project_id
GROUP BY PROJECT_ID, PROJFUNC_CURRENCY_CODE;

Because amounts are already aggregated, additional grouping is straightforward, and the view can be joined back to PA_PROJECTS_ALL or used to filter invoices with active holds using PWP_HOLD_FLAG.