Search Results pa_prvdr_cc_org_rel_v




Overview
Explore in AI Chat

Overview

PA_PRVDR_CC_ORG_REL_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents cross-charge organization relationships between a provider organization and a receiver organization, resolving those relationships into human-readable supplier (vendor) and legal entity attributes. The view is the reporting counterpart to the PA_CC_ORG_RELATIONSHIPS base table, exposing the raw relationship rows alongside descriptive names pulled from Human Resources and Payables.

The view specifically resolves the supplier site context for cross-charge processing. For each provider/receiver relationship, it derives the supplier name, supplier identifier, supplier site name, and supplier site identifier, along with the provider organization name, provider legal entity, and the invoice expenditure organization. This makes the view a convenient single source for reporting on how inter-organization cross-charges map to Payables suppliers and sites.

The status of the view is VALID and it is a standard, supported APPS object.

Underlying Base Objects

The view is defined over the following documented base objects: PA_CC_ORG_RELATIONSHIPS (synonym), PA_IMPLEMENTATIONS_ALL (synonym), HR_OPERATING_UNITS (view), HR_ORG_UNITS_NO_JOIN (view), HR_ALL_ORGANIZATION_UNITS_TL (synonym), XLE_ENTITY_PROFILES (synonym), PO_VENDORS (view), and PO_VENDOR_SITES_ALL (view). It also references the packages FND_GLOBAL, HR_GENERAL, and HR_SECURITY, which supply session and security context.

  • PA_CC_ORG_RELATIONSHIPS (aliased E) provides the driving relationship rows, including PRVDR_ORG_ID, RECVR_ORG_ID, VENDOR_SITE_ID, and the cross-charge attributes.
  • HR_OPERATING_UNITS (H) and XLE_ENTITY_PROFILES (XEP) resolve the provider organization and its legal entity name.
  • PA_IMPLEMENTATIONS_ALL (IMP) links the provider organization to the supplier (VENDOR_ID).
  • PO_VENDORS (V) supplies SUPPLIER_NAME; PO_VENDOR_SITES_ALL (VS) supplies SUPPLIER_SITE_CODE.
  • HR_ORG_UNITS_NO_JOIN and HR_ALL_ORGANIZATION_UNITS_TL (ORGTL) resolve the invoice expenditure organization name, using a language join against USERENV('LANG').

Most vendor and expenditure-organization joins are outer joins, so a relationship row is returned even when supplier or organization detail is absent.

Key Columns

Common Use Cases and Queries

Typical uses include reporting on cross-charge organization relationships by supplier site, validating that provider organizations are mapped to the correct supplier and site, and driving cross-charge invoice defaults. The following query returns relationships for a given supplier site:

SELECT prvdr_org_name, recvr_org_id, supplier_name, supplier_site_name, cross_charge_code
FROM apps.pa_prvdr_cc_org_rel_v
WHERE supplier_site_name = :p_site_name
AND prvdr_allow_cc_flag = 'Y';

To list all relationships for a provider organization with legal entity detail:

SELECT supplier_name, supplier_site_name, prvdr_legal_entity_name, ap_inv_exp_organization_name
FROM apps.pa_prvdr_cc_org_rel_v
WHERE prvdr_org_id = :p_provdr_org_id;

Because the view applies HR security and language context, queries should be run with a valid application session so that organization names resolve correctly.