Search Results customer




Overview
Explore in AI Chat

Overview

The PA_PWP_CUSTOMER_SUMM_ALL table is a core data repository within the Oracle E-Business Suite Projects module (PA). Its primary function is to store summarized customer invoice information specifically for consumption by the Subcontractor Workbench. This workbench is a critical component for managing subcontractor-related activities, including performance evaluation and payment processing. By centralizing this invoice data, the table enables project managers and administrators to efficiently correlate subcontractor work progress and deliverables with corresponding customer billings, thereby supporting accurate financial tracking and compliance within project-centric operations.

Key Information Stored

Based on the documented primary key structure, the table is organized to uniquely identify invoice records by a combination of key business identifiers. The essential columns include ORG_ID, which defines the operating unit for multi-organization security; PROJECT_ID, linking the data to a specific project within Oracle Projects; and DRAFT_INVOICE_NUM, identifying the specific customer invoice document. While the full column list is not detailed in the provided excerpt, the table's purpose implies it likely holds summarized financial amounts (such as invoice amounts, revenue, or tax), invoice dates, statuses, and customer identifiers. The '_ALL' suffix indicates it is a multi-org table, storing data for all operating units, with security typically enforced via a Virtual Private Database (VPD) policy.

Common Use Cases and Queries

The primary use case is within the Subcontractor Workbench, where this data provides the financial context for subcontractor performance. A common reporting requirement is to verify that customer invoices exist for work performed by a subcontractor before authorizing their payment. A typical query would join this table to project and task tables. For example, to find customer invoice summaries for a specific project, one might use:

  • SELECT draft_invoice_num, invoice_amount, invoice_date FROM pa_pwp_customer_summ_all WHERE project_id = :p_project_id AND org_id = :p_org_id;

Another critical use case is reconciliation, where data from this table is compared against detailed invoice lines in PA_CUST_REV_DIST_LINES_ALL or against subcontractor invoice data in tables like PA_PWP_SUPPLIER_SUMM_ALL to ensure alignment between customer billings and supplier costs.

Related Objects

This table is integral to the subcontractor workbench data model. It is directly referenced by the Subcontractor Workbench's underlying views and application logic. Key related objects include the PA_PWP_SUPPLIER_SUMM_ALL table, which stores parallel summarized information for supplier/subcontractor invoices, enabling side-by-side analysis. It also has a fundamental relationship with core Projects tables such as PA_PROJECTS_ALL (via PROJECT_ID) and financial distribution tables like PA_CUST_REV_DIST_LINES_ALL for detailed invoice line data. The primary key constraint PA_PWP_CUSTOMER_SUMM_PK enforces data integrity on its key columns.