Search Results projfunc_invoice_amount




Overview
Explore in AI Chat

Overview

PA_PWP_SUPPLIER_INV_SUMMARY_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. Its documented purpose is to display supplier-wise invoice amounts for a project, consolidating accounts payable invoice data that has been interfaced or staged for project-related processing. The view is part of the PA PWP (Project Workbench/Project Invoice Summary) reporting layer and is typically consumed by project billing, cost, and invoice analysis reports and concurrent programs.

The view aggregates invoice amounts at the vendor and project level across multiple currency perspectives — project functional currency, project currency, and the transaction (invoice) currency. Critically, it also isolates amounts flagged as on hold through correlated subqueries keyed on HOLD_FLAG = 'Y', allowing users to distinguish invoices that are subject to payment holds from those that are not. The view is defined in the 12.2.2 ETRM metadata as VALID and is available in both 12.1.1 and 12.2.2 environments where the PA product is installed and the PWP schema objects have been deployed.

Underlying Base Objects

The documented base objects referenced by the view are:

The header and detail staging tables are joined on PA_PWP_AP_HDR_ID. The header is aliased HDR in the view text and drives the outer aggregation, while detail sums are rolled up by PROJECT_ID and currency combination.

Key Columns

Common Use Cases and Queries

Typical uses include supplier spend analysis by project, aged invoice and hold reporting, and reconciliation of project-related AP invoice balances to the project functional ledger. A representative query retrieves supplier-level invoice totals for a project:

  • SELECT supplier_name, projfunc_currency_code, projfunc_invoice_amount, projfunc_inv_paid_amount, projfunc_inv_unpaid_amount, projfunc_invamt_onhold FROM pa_pwp_supplier_inv_summary_v WHERE project_id = :project_id ORDER BY supplier_name;

To isolate suppliers with on-hold exposure:

  • SELECT supplier_name, project_id, proj_invamt_onhold FROM pa_pwp_supplier_inv_summary_v WHERE proj_invamt_onhold > 0;

Because the view performs its own GROUP BY aggregation, filters on PROJECT_ID and vendor attributes are the most efficient predicates. When joins back to PA_PROJECTS_ALL are required for project names or numbers, join on PROJECT_ID. Note that the correlated subqueries reference PA_PWP_AP_HDR_ID as the join key between header and detail, which is the same key the user searched for; any direct reporting on the staging tables must preserve this linkage to reproduce the view's supplier-wise totals correctly.