Search Results owning_status

Overview

APPS.PO_GA_ORG_ASSIGNMENTS_V is a public Oracle E-Business Suite view owned by the APPS schema and registered in FND Design Data as PO.PO_GA_ORG_ASSIGNMENTS_V. Its documented purpose is to retrieve existing Global Agreement organization assignment information. In Oracle Purchasing, a Global Agreement is a sourcing document that can be shared across multiple operating units; the assignment records determine which operating units are permitted to purchase against that agreement and which one is treated as the owning organization. This view presents that assignment data in a denormalized, reporting-friendly form, joining the raw assignment rows to operating unit and supplier site descriptions so that consumers do not need to resolve those lookups themselves. Because it is a view rather than a base table, it is read-only and intended for custom reporting and integration extracts. The view is marked VALID and exposes a ROWID-based ROW_ID column derived from PO_GA_ORG_ASSIGNMENTS, which allows report builders to correlate a view row back to the underlying assignment record. The object remains available in both the 12.1.1 and 12.2.2 code lines, which is significant because multi-org and operating unit access behavior changed between those releases while the view's contract remained stable.

Underlying Base Objects

The documented dependency list identifies five referenced objects. PO_GA_ORG_ASSIGNMENTS is the primary base table and is referenced through a synonym; it holds one row per organization assigned to a Global Agreement, including the enabled flag and owning status. PO_HEADERS_ALL, also referenced via synonym, supplies the Global Agreement header identified by PO_HEADER_ID. HR_OPERATING_UNITS provides the operating unit names, yielding both ORGANIZATION_NAME and PURCHASING_ORG_NAME. PO_VENDOR_SITES_ALL supplies supplier site information, producing VENDOR_SITE_ID and VENDOR_SITE_CODE. FND_GLOBAL is referenced as a package rather than a data source; it is typically invoked to supply the current session's ORG_ID or user context so that the view returns rows consistent with the caller's operating unit security profile. This dependency pattern is standard for multi-org views in Purchasing and explains why the view can present both the requesting organization and the purchasing operating unit without additional joins in the consuming query.

Key Columns

• ROW_ID — ROWID from PO_GA_ORG_ASSIGNMENTS, used to trace back to the base row.
• PO_HEADER_ID — Unique identifier of the Global Agreement header.
• ORG_ID and ORGANIZATION_NAME — Organization identifier and display name of the requesting operating unit.
• PURCHASING_ORG_ID and PURCHASING_ORG_NAME — Identifier and name of the purchasing operating unit; when ENABLED_FLAG is set, that unit may purchase against the Global Agreement. This is the column most often targeted by searches for "purchasing_org_name."
• ENABLED_FLAG — Indicates whether the organization is currently enabled with respect to the agreement.
• VENDOR_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE — Supplier and supplier site identifiers for the purchasing operating unit.
• OWNING_STATUS — Ordering indicator used to list the owning organization first.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who columns for audit and incremental extraction.

Common Use Cases and Queries

Typical uses include reporting which operating units may buy from a given Global Agreement, identifying the owning organization, and building supplier site extracts for cross-operating-unit sourcing. The Who columns support incremental pulls by CREATION_DATE or LAST_UPDATE_DATE.

A representative query listing enabled purchasing organizations for an agreement:

• SELECT po_header_id, purchasing_org_id, purchasing_org_name, owning_status, vendor_site_code FROM apps.po_ga_org_assignments_v WHERE po_header_id = :p_header_id AND enabled_flag = 'Y' ORDER BY owning_status, purchasing_org_name;

For reporting across all agreements visible to the session, omit the header predicate and filter on OWNING_STATUS = 1 to isolate the owning organization per agreement.