Search Results pa_project_customers_v




Overview
Explore in AI Chat

Overview

PA_PROJECT_CUSTOMERS_V is an Oracle EBS Projects (PA) schema view owned by APPS and defined over the customer-relationship and address infrastructure of Oracle Projects. It presents project-to-customer associations together with their invoicing attributes and formatted bill-to and ship-to addresses. In 12.1.1 and 12.2.2, the view is the primary reporting and integration surface for project customer information used by billing, invoicing, and receivables-related processes.

The view is especially relevant to the search term inv_exchange_rate. The column INV_EXCHANGE_RATE is exposed directly from the underlying PA_PROJECT_CUSTOMERS table and carries the exchange rate used when converting project invoices into the invoice currency defined on the project customer record. Reporting that combines project customers with currency conversion information therefore frequently references this view.

Underlying Base Objects

The documented base objects referenced by the view are:

  • PA_PROJECT_CUSTOMERS (SYNONYM) — the core project-to-customer relationship table, aliased PC1.
  • PA_CUSTOMERS_V (VIEW) — customer name, number, status, party information, aliased CV1.
  • PA_CUSTOMER_RELATIONSHIPS_V (VIEW) — relationship code and meaning, aliased CRV1.
  • PA_PROJECTS_ALL (SYNONYM) — project number via SEGMENT1, aliased PPA.
  • PA_TASKS (SYNONYM) — receiver task number, aliased PT.
  • HZ_CUST_ACCT_SITES, HZ_PARTY_SITES, HZ_LOCATIONS (SYNONYMS) — joined twice to build bill-to and ship-to addresses, aliased BA_* and SA_*.

All address joins are outer joins (denoted by the (+) operator), so projects with missing or incomplete address references are still returned. The joins to PA_CUSTOMERS_V, PA_PROJECTS_ALL, and PA_TASKS are inner joins, meaning the view returns one row per project/customer combination that resolves successfully.

The view uses ROWID as the first selected column and carries the standard WHO columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, and RECORD_VERSION_NUMBER.

Key Columns

Invoicing columns drawn from PA_PROJECT_CUSTOMERS:

  • INV_CURRENCY_CODE — invoice currency for the project-customer relationship.
  • INV_RATE_TYPE — exchange rate type applied at invoice time.
  • INV_RATE_DATE — date used to derive the exchange rate.
  • INV_EXCHANGE_RATE — the stored exchange rate value used for currency conversion.
  • ALLOW_INV_USER_RATE_TYPE_FLAG — whether the user may override the rate type during invoicing.
  • CUSTOMER_BILL_SPLIT — proportion used when splitting billings across customers.

Relationship and address columns:

Common Use Cases and Queries

Typical uses include reporting on project customers and their invoicing terms, validating exchange rate setup before invoice generation, and driving downstream receivables integrations. A representative query retrieving rate information:

  • SELECT project_id, customer_id, inv_currency_code, inv_rate_type, inv_rate_date, inv_exchange_rate FROM pa_project_customers_v WHERE project_id = :project_id;

To list customers with their bill-to address:

  • SELECT customer_name, customer_number, bill_to_address_id FROM pa_project_customers_v WHERE project_id = :project_id;

Because the view resolves customer status via PA_CUSTOMERS_V and relationship meaning via PA_CUSTOMER_RELATIONSHIPS_V, it is preferable to querying PA_PROJECT_CUSTOMERS directly whenever customer name, party details, or formatted addresses are required.