Search Results owning_org




Overview
Explore in AI Chat

Overview

APPS.PO_POS_ALL_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is catalogued in the E-Business Suite Technical Reference Manual (ETRM) with a status of VALID and is registered under FND Design Data as PO.PO_POS_ALL_V. The view is classified as a "supplementary view used to simplify forms coding," meaning it was created primarily to support the Purchasing (PO) module's Oracle Forms user interface rather than to serve as a stable, documented integration or reporting interface. Oracle explicitly warns that the view may change dramatically in subsequent minor or major releases and does not recommend querying or altering data through it directly.

Functionally, PO_POS_ALL_V presents a consolidated, form-friendly projection of purchasing document headers across operating units. It joins purchasing document types, supplier information, agent (employee) details, and operating unit (HR organization) data into a single flattened row set. The view therefore exposes one row per purchasing document header, enriched with descriptive attributes that would otherwise require multiple joins. Because the view draws on FINANCIALS_SYSTEM_PARAMETERS, FND_GLOBAL, and PO_GA_ORG_ASSIGNMENTS, its output is inherently Multi-Org aware: the rows returned are filtered by the operating unit context (ORG_ID) established for the session.

Underlying Base Objects

The ETRM dependency list shows that PO_POS_ALL_V is defined over the following objects: AP_SUPPLIERS, FINANCIALS_SYSTEM_PARAMETERS, FND_GLOBAL (package), FND_LOOKUP_VALUES, HR_ALL_ORGANIZATION_UNITS_TL, HZ_PARTIES, PO_DOCUMENT_TYPES_ALL_B, PO_DOCUMENT_TYPES_ALL_TL, PO_EMPLOYEES_SV (package), PO_GA_ORG_ASSIGNMENTS, and PO_HEADERS_ALL. The view is not referenced by any other database object, confirming its role as a terminal, UI-facing construct.

The principal driving table is PO_HEADERS_ALL, which supplies the purchasing document header rows, including the document number (SEGMENT1), PO_HEADER_ID, agent, authorization status, and style. PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL provide the document type name (TYPE_NAME) and lookup code (TYPE_LOOKUP_CODE). AP_SUPPLIERS and HZ_PARTIES contribute vendor identification and the vendor name (VENDOR_NAME). PO_EMPLOYEES_SV and HR_ALL_ORGANIZATION_UNITS_TL resolve the buyer/agent full name (FULL_NAME) and the operating unit name surfaced as OWNING_ORG. PO_GA_ORG_ASSIGNMENTS supports the global agreement flag logic and organizational assignment checks, while FND_LOOKUP_VALUES supplies decoded lookup meanings such as AUTHORIZATION_STATUS_DSP. FINANCIALS_SYSTEM_PARAMETERS and the FND_GLOBAL package provide session-level context, notably the active ORG_ID used to restrict results to the current operating unit.

Key Columns

  • SEGMENT1 (VARCHAR2, 20) — The purchasing document number, derived from the key flexfield segment on the header.
  • PO_HEADER_ID (NUMBER) — Primary key of the underlying PO_HEADERS_ALL row; the join key back to base purchasing data.
  • TYPE_NAME / TYPE_LOOKUP_CODE — The translated document type name and its lookup code (for example, Standard Purchase Order, Blanket, Contract).
  • VENDOR_ID / VENDOR_NAME — Supplier identifier and the formatted supplier name from AP_SUPPLIERS and HZ_PARTIES.
  • AGENT_ID / FULL_NAME — The buyer identifier and the buyer's full name resolved via PO_EMPLOYEES_SV.
  • OWNING_ORG (VARCHAR2, 240) — The name of the operating unit that owns the document, resolved from HR_ALL_ORGANIZATION_UNITS_TL. This is the column most commonly searched by users looking to report or filter purchasing documents by operating unit.
  • ORG_ID (NUMBER) — The organization identifier of the operating unit, used by Multi-Org security (MOAC) filtering.
  • AUTHORIZATION_STATUS / AUTHORIZATION_STATUS_DSP — The internal approval status code and its display value from FND_LOOKUP_VALUES.
  • GLOBAL_AGREEMENT_FLAG — Indicates whether the document is a global agreement spanning operating units.
  • SECURITY_LEVEL_CODE, COMMENTS, DISPLAYED_FIELD, STYLE_ID — Supporting attributes: the document security level, free-text comments, a concatenated display field used by the form, and the purchasing style identifier.
  • CREATION_DATE — Standard WHO column recording when the row was created.

Common Use Cases and Queries

The most frequent use of this view in custom reporting is to list purchasing documents together with their owning operating unit. A typical query filtering by the owning organization might read:

SELECT SEGMENT1, TYPE_NAME, VENDOR_NAME, FULL_NAME, AUTHORIZATION_STATUS_DSP, OWNING_ORG
FROM APPS.PO_POS_ALL_V
WHERE OWNING_ORG = :owning_org_name
AND AUTHORIZATION_STATUS = 'APPROVED';

Where the search term is "owning_org," the column OWNING_ORG exposes the human-readable operating unit name, allowing reports to group or filter documents by organization without joining HR_ALL_ORGANIZATION_UNITS_TL manually. Joining to ORG_ID is preferable for MOAC-correct queries, since ORG_ID is the numeric operating unit identifier:

SELECT ORG_ID, OWNING_ORG, COUNT(*)
FROM APPS.PO_POS_ALL_V
GROUP BY ORG_ID, OWNING_ORG;

Other common scenarios include extracting approved document headers for downstream integration, building buyer workload reports keyed on AGENT_ID and FULL_NAME, and populating dashboards that summarize spend by document type (TYPE_NAME) or by supplier (VENDOR_NAME). Because the view is Multi-Org secured through ORG_ID, results reflect only the operating units accessible to the session's responsibility.

Given Oracle's explicit warning that this supplementary view may change across releases, consumers should treat PO_POS_ALL_V as an interface of last resort. For durable reporting and integration, developers are advised to query the documented base tables — principally PO_HEADERS_ALL joined to PO_DOCUMENT_TYPES_ALL_TL, AP_SUPPLIERS, and HR_ALL_ORGANIZATION_UNITS_TL — rather than relying on this forms-support view, whose column set and WHERE predicates are not guaranteed between 12.1.1 and 12.2.2 or future minor releases.