Search Results ship_state_province




Overview
Explore in AI Chat

Overview

APPS.PO_HEADERS_CHANGE_PRINT is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that consolidates purchasing document header information required for change-order printing and purchase order audit reporting. It draws primarily from PO_HEADERS and the corresponding archive tables (PO_HEADERS_ARCHIVE, PO_HEADERS_ARCHIVE_ALL, PO_RELEASES_ARCHIVE, PO_RELEASES_ARCHIVE_ALL), allowing report developers to reproduce the content of a purchase order or release header as it existed at the time of printing or revision. The view is owned by APPS and is generally treated as a read-only reporting object.

The view exposes supplier, site, buyer, currency, shipping, billing, and print-control attributes in a single flattened structure. For Oracle Purchasing's standard change-order and PO print programs, this view is the common source of the header-level data that feeds a report layout. Because it references archived rows, it supports historical reconstruction of PO data for audit and reprint purposes.

Underlying Base Objects

The documented base objects include:

The view therefore sits atop the purchasing header model, the HR employee model for buyer names, the supplier model for vendor details, and the FND layer for currency and territory data.

Key Columns

The column most relevant to the search term "ship_state_province" is SHIP_STATE_PROVINCE, which is populated via PO_COMMUNICATION_PVT.GETSTATEORPROVINCE, alongside the analogous BILL_STATE_PROVINCE.

Common Use Cases and Queries

Typical uses include change-order printing, PO reprint reports, audit extracts of PO header revisions, and supplier/address verification. A simple query to retrieve the ship state/province for a given PO is:

SELECT segment1, revision_num, ship_state_province, ship_city, ship_postal_code
FROM apps.po_headers_change_print
WHERE segment1 = :p_po_number;

For change-order reporting, filtering on print and revision timestamps isolates documents requiring reissue:

SELECT segment1, revision_num, print_count, printed_date, revised_date
FROM apps.po_headers_change_print
WHERE revised_date > :p_from_date
ORDER BY segment1, revision_num;

Because the view references HR_SECURITY and FND_GLOBAL, queries executed from within EBS respect the current organization and security context. When running outside the EBS application, developers should still restrict results by operating unit and agent to avoid exposing data across organizations.