Search Results closed_code




Overview
Explore in AI Chat

Overview

POS_VIEW_PO_SUMMARY_V is a reporting view owned by the APPS schema within the iSupplier Portal (POS) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to present a consolidated summary of purchase orders sourced from the archived purchasing tables, allowing historical procurement documents to be surfaced alongside their active counterparts. Because the view draws on the archive headers rather than the live operational tables alone, it is particularly useful for supplier-facing inquiries, audit history, and reconciliation where documents may have been archived out of the primary transactional tables. The view joins vendor, vendor site, organization, and document-type information so that a single row presents a denormalized, human-readable purchase order summary rather than a set of foreign keys.

The most frequently searched attribute against this object is po_num, which the view exposes as an alias for the SEGMENT1 column of the purchase order header. This mirrors the visible purchase order number that end users recognize, and it also supplies a parallel SEGMENT1 column for compatibility with other query patterns.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the view is defined over several documented base objects:

Additional objects listed in the metadata include PO_DOCUMENT_TYPES_ALL, PO_DOC_STYLE_HEADERS, and PO_RELEASES_ARCHIVE_ALL, which support document type and release information.

Key Columns

Common Use Cases and Queries

A typical use is retrieving a purchase order summary by its visible number. The following query returns the order, vendor, and status:

  • SELECT po_num, vendor_name, type_name, closed_code, currency_code FROM pos_view_po_summary_v WHERE po_num = '12345';
  • SELECT po_num, vendor_name, approved_date FROM pos_view_po_summary_v WHERE vendor_name LIKE 'Acme%' ORDER BY approved_date DESC;
  • SELECT po_num, org_name, type_name FROM pos_view_po_summary_v WHERE org_id = :p_org_id;

These patterns support supplier portal displays, archived order lookups, and ad hoc reporting against historical procurement data.