Search Results proj_bill_amount




Overview
Explore in AI Chat

Overview

PA_PWP_CUSTOMER_INVOICE_V is an Oracle E-Business Suite view owned by the APPS schema and classified under the Projects (PA) product family. It is documented as the "Subcontractor workbench customer invoice view." In Oracle Projects, the Subcontractor Management workbench supports the management of subcontractor work, purchase orders, and the flow of costs between the contractor and subcontractor ledgers. This view exposes customer invoice data as surfaced through that workbench, presenting draft and transferred receivable invoice information alongside the amounts linked to the subcontractor's purchase order and project accounting activity.

The user search term "invoice_status_m" corresponds directly to a column alias defined in the view text, where the base column PWP.INVOICE_STATUS is selected and renamed to INVOICE_STATUS_M. This naming convention is common in Oracle EBS views, where the "_M" suffix signals a column that is intended for a specific UI or reporting purpose, frequently linked to a value set or lookup. The presence of this alias confirms that the view is designed to supply invoice status information to the Subcontractor workbench screens and to any custom reports or integrations that follow the same column contract.

Underlying Base Objects

According to the documented view metadata for EBS 12.2.2, PA_PWP_CUSTOMER_INVOICE_V is defined over the following referenced base objects:

Because both referenced objects are non-table constructs (a synonym and a view), PA_PWP_CUSTOMER_INVOICE_V functions purely as a read-only presentation layer. It does not store data and cannot be updated directly; all transactional maintenance must be performed against the underlying base tables that supply PA_PWP_CUSTOMER_SUMM and PA_PWP_LINK_STATUS_V.

Key Columns

  • INVOICE_STATUS_M — the alias for PWP.INVOICE_STATUS, the column the user searched for. It carries the status of the draft or transferred customer invoice and drives workbench status displays and status-based filtering.
  • DRAFT_INVOICE_NUM / RA_INVOICE_NUMBER — the draft invoice identifier used within Oracle Projects and the corresponding Receivables invoice number once the invoice is transferred.
  • CUSTOMER_NAME / CUSTOMER_NUMBER — the customer associated with the invoice.
  • AGREEMENT_NUM / BILL_THROUGH_DATE / INVOICE_CLASS / INVOICE_DATE — descriptive invoice attributes, including the bill-through date and the invoice classification.
  • DRAFT_INVOICE_NUM_CREDITED (CREDIT_OF) — identifies the invoice being credited when the record is a credit memo.
  • PROJECT_ID — the project to which the invoice relates; the principal join key for project-level reporting.
  • INVOICE_COUNT, PFC_LINK_AP_AMOUNT, PC_LINK_AP_AMOUNT — aggregated link information originating from PA_PWP_LINK_STATUS_V.
  • Currency amount columns — INVOICE_INV_AMOUNT, AR_INV_RECIEPT_AMOUNT, AR_OUTSTANDING_AMOUNT, AR_INV_TAX_AMOUNT and related columns in invoice currency; PROJFUNC_BILL_AMOUNT and its counterparts in project functional currency; and PROJ_BILL_AMOUNT and its counterparts in project currency.
  • PFC_RATE — a derived rate computed as PROJFUNC_BILL_AMOUNT divided by INV_BILL_AMOUNT, returning zero where the invoice bill amount is zero.

Common Use Cases and Queries

The view is typically used to build Subcontractor workbench-style reports and to reconcile project-level customer invoicing across the three currency perspectives. A frequent pattern is to filter by status using INVOICE_STATUS_M and group by project:

  • Listing outstanding customer invoices for a project, filtered on invoice status.
  • Comparing invoice-currency, project functional, and project currency amounts for a single invoice line of reporting.
  • Identifying credit memos through the CREDIT_OF column.
  • Joining to PA_PROJECTS_ALL on PROJECT_ID to obtain project name and number.

A representative query is:

SELECT PROJECT_ID, DRAFT_INVOICE_NUM, RA_INVOICE_NUMBER, CUSTOMER_NAME, INVOICE_DATE, INVOICE_STATUS_M, INVOICE_INV_AMOUNT, PROJFUNC_BILL_AMOUNT, PROJ_BILL_AMOUNT, AR_OUTSTANDING_AMOUNT FROM APPS.PA_PWP_CUSTOMER_INVOICE_V WHERE INVOICE_STATUS_M = :p_status AND PROJECT_ID = :p_project_id ORDER BY INVOICE_DATE DESC;

Because the object is a view and read-only, it is well suited to ad hoc inquiry, Oracle BI Publisher data templates, and custom report integration, but it must not be treated as an interface for data loading.