Search Results purchasing_org_id

Overview

PO_GA_ORG_ASSIGNMENTS_V is an APPS-owned database view within the Oracle Purchasing (PO) module. Its documented purpose is to present Global Agreements Org Assignment data — the association between a global agreement (a purchasing document whose terms are shared across multiple operating units) and the organizations and vendor sites to which it applies. In Oracle EBS 12.1.1 and 12.2.2, global agreements are managed through the Global Agreements functionality, and the underlying assignment records are stored in PO_GA_ORG_ASSIGNMENTS. This view denormalizes those assignment rows by joining them to HR_OPERATING_UNITS and PO_VENDOR_SITES_ALL, so that report writers and integration developers can retrieve descriptive names and vendor-site context without performing the joins themselves. Because it is a view and not a table, it is read-only and inherits the security and freshness characteristics of its base objects.

Underlying Base Objects

The documented base objects are PO_GA_ORG_ASSIGNMENTS (synonym), PO_HEADERS_ALL (synonym), PO_VENDOR_SITES_ALL (view), and HR_OPERATING_UNITS (view), with FND_GLOBAL referenced as a package. The view text joins PO_GA_ORG_ASSIGNMENTS to PO_HEADERS_ALL on PO_HEADER_ID, to HR_OPERATING_UNITS on ORGANIZATION_ID (aliased OU), to PO_VENDOR_SITES_ALL on VENDOR_SITE_ID, and to HR_OPERATING_UNITS again on PURCHASING_ORG_ID (aliased OU2). These joins supply the organization name, the purchasing organization name, and vendor-site attributes that are not physically stored on the assignment row. PO_HEADERS_ALL is the parent document table, confirming that each assignment belongs to a global agreement header. The presence of FND_GLOBAL in the metadata indicates that the view or its underlying logic may make use of session context such as the current user or responsibility.

Key Columns

The primary identifier exposed is PO_HEADER_ID, which links the assignment to its global agreement header. ORGANIZATION_ID identifies the operating unit receiving the assignment, while ORG_ID and ORGANIZATION_NAME are derived from HR_OPERATING_UNITS. PURCHASING_ORG_ID and its corresponding PURCHASING_ORG_NAME identify the purchasing organization, which is the column most relevant to the user's search term: PURCHASING_ORG_ID is a distinct column on the view, separate from ORGANIZATION_ID, and is resolved through the second HR_OPERATING_UNITS join. ENABLED_FLAG indicates whether the assignment is currently active. VENDOR_ID, VENDOR_SITE_ID, and VENDOR_SITE_CODE describe the supplier and site associated with the assignment. OWNING_STATUS is computed by the DECODE expression comparing ORGANIZATION_ID to the header ORG_ID, returning 1 or 2 to distinguish the owning organization from other assigned organizations. Standard audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — are also exposed.

Common Use Cases and Queries

Typical use cases include reporting on which operating units and purchasing organizations a global agreement is assigned to, validating that a purchasing organization is enabled for a given agreement, and feeding downstream integrations that require vendor-site and organization names. A representative query filtering on the search term follows:

• List enabled assignments for a purchasing organization:
  SELECT po_header_id, organization_name, org_id, purchasing_org_name, purchasing_org_id, vendor_site_code, owning_status
FROM apps.po_ga_org_assignments_v
WHERE purchasing_org_id = :p_purchasing_org_id
AND enabled_flag = 'Y';
• Retrieve all organizations assigned to a specific global agreement:
  SELECT organization_name, org_id, owning_status
FROM apps.po_ga_org_assignments_v
WHERE po_header_id = :p_po_header_id;
• Identify the owning organization using the OWNING_STATUS flag:
  SELECT po_header_id, organization_name
FROM apps.po_ga_org_assignments_v
WHERE owning_status = 1;

Because PURCHASING_ORG_ID is a first-class column on this view, it is a reliable filter for responsibility-scoped reporting where the purchasing organization, rather than the assigned operating unit, is the relevant dimension.