Search Results po_headers_ap_v




Overview
Explore in AI Chat

Overview

The PO_HEADERS_AP_V view is an APPS schema database object owned by the Oracle Purchasing (PO) module. Per Oracle's ETRM documentation it is flagged with the description "10SC ONLY", indicating it exists to support a specific, restricted implementation context rather than general-purpose reporting. Functionally, it presents a simplified, flattened projection of purchasing document headers intended for Accounts Payable-style consumption and downstream integration. It surfaces purchase order number, derived document type, vendor, currency, approval status, closure status, operating unit, and consigned consumption attributes in a single row per qualifying document.

Because the view pre-joins the document type lookup to a friendly display value, it removes the need for consumers to resolve lookup codes themselves, making it convenient for reporting layers, interface programs, and extracts that require a human-readable PO type alongside core header attributes. The 12.2.2 metadata confirms the view is VALID and owned by APPS.

Underlying Base Objects

The documented definition joins two objects directly and references others through the APPS synonym layer:

  • PO_HEADERS (synonym to the base header table) — aliased POH; supplies PO number, header ID, vendor, currency, approved flag, closed code, org ID, and consigned consumption flag.
  • PO_LOOKUP_CODES (view) — aliased PLC; supplies the DISPLAYED_FIELD value resolved from the PO TYPE lookup category.

The documented 12.2.2 metadata additionally lists FND_GLOBAL (package), PER_ALL_PEOPLE_F, and PO_DISTRIBUTIONS_ALL as referenced base objects, reflecting security/context resolution and related purchasing structures. Filtering logic restricts output to documents whose TYPE_LOOKUP_CODE is STANDARD, BLANKET, or PLANNED, joined to a matching PO TYPE lookup, and excludes PCARD-originated documents (POH.PCARD_ID IS NULL).

Key Columns

  • PO_NUMBER — the SEGMENT1 document number from PO_HEADERS.
  • PO_TYPE — the displayed lookup meaning for the document type, driven by the "po_type" search interest; maps to PLC.DISPLAYED_FIELD.
  • PO_HEADER_ID — unique surrogate key of the purchasing document header.
  • VENDOR_ID — supplier identifier associated with the header.
  • CURRENCY_CODE — document currency.
  • APPROVED_FLAG — approval state of the document.
  • CLOSED_CODE — closure state (open, closed, finally closed).
  • ORG_ID — operating unit owning the document, supporting multi-org filtering.
  • CONSIGNED_CONSUMPTION_FLAG — indicates consignment consumption treatment.

Common Use Cases and Queries

Typical uses include PO type reporting, approved/closed document extracts, and vendor-currency feeds.

Filtering by type (the "po_type" scenario):

SELECT po_number, po_type, vendor_id, currency_code FROM apps.po_headers_ap_v WHERE po_type = 'Standard Purchase Order';

Listing open approved documents per operating unit:

SELECT po_number, po_type, org_id, closed_code FROM apps.po_headers_ap_v WHERE approved_flag = 'Y' AND closed_code = 'OPEN';

Because the view already constrains to STANDARD, BLANKET, and PLANNED types and excludes PCARD documents, consumers should expect only those document categories. Validate column-level behavior against the target instance, since the "10SC ONLY" designation implies restricted applicability.