Results for “reply_date”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PO_HEADERS_ARCHIVE_XML is a Purchasing (PO) module view in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a denormalized, XML-oriented projection of archived purchasing document headers, drawing from PO_HEADERS_ARCHIVE_ALL and joining reference, vendor, currency, and buyer information. Its principal role is to serve as the data source for Oracle Purchasing's XML document generation and communication routines — particularly the archived/revised versions of purchase orders, blanket agreements, and contracts that must be rendered into XML for printing, e-mail, EDI, or fax transmission to suppliers.
The view is structured to present header-level information in a format readily consumable by the PO communication layer (PO_COMMUNICATION_PVT) and by XML Publisher / BI Publisher templates. Because it reflects the archive tables, it captures point-in-time snapshots of documents as they existed at each revision, which is essential for auditability and for regenerating documents historically.
Underlying Base Objects
The view is owned by APPS and is defined over the following documented base objects:
PO_HEADERS_ARCHIVE_ALL(synonym) — the primary archived header table, supplying document type, segment, revision, dates, amounts, flags, and note-to-vendor fields.PER_ALL_PEOPLE_F(synonym) — resolves the current document buyer's first name, last name, and title viaAGENT_ID.PO_AGENTS(synonym) — supports buyer identification across archive revisions.FND_CURRENCIES_TL,AP_TERMS,FND_LOOKUP_VALUES,FND_TERRITORIES_TL,HR_LOOKUPS,ORG_FREIGHT_TL,PO_DOC_STYLE_LINES_TL— reference data for currency, payment terms, lookups (FOB, freight terms), territories, and document styles.PO_VENDORS,PO_VENDOR_SITES_ALL,PO_VENDOR_CONTACTS(views) — supplier name, number, and address components.PO_COMMUNICATION_PVT,PO_CORE_S,FND_GLOBAL,HR_API(packages) — PL/SQL functions invoked directly within the view text, includingGETARCBUYERAGENTID,GETARCBUYERFNAME,GETARCBUYERLNAME,GETARCBUYERTITLE, andGETFORMATMASK.
The heavy use of packaged functions means the view is context-sensitive and can raise errors if session context (e.g., FND_GLOBAL initialization) is not set.
Key Columns
- Document identifiers:
TYPE_LOOKUP_CODE,SEGMENT1,REVISION_NUM,PRINT_COUNT. - Date columns (all formatted as
DD-MON-YYYY HH24:MI:SS):CREATION_DATE,PRINTED_DATE,REVISED_DATE,START_DATE,END_DATE,ACCEPTANCE_DUE_DATE. - Buyer information:
DOCUMENT_BUYER_FIRST_NAME,DOCUMENT_BUYER_LAST_NAME,DOCUMENT_BUYER_TITLE,DOCUMENT_BUYER_AGENT_ID, and the conditionalARCHIVE_BUYER_*columns derived fromPO_COMMUNICATION_PVT. - Financial:
AMOUNT_AGREED,CURRENCY_CODE,CURRENCY_NAME,RATE,PAYMENT_TERMS,FOB,FREIGHT_TERMS,SHIP_VIA. - Supplier:
VENDOR_NUM,VENDOR_NAME,CUSTOMER_NUM, plus address fieldsVENDOR_ADDRESS_LINE1/2/3,VENDOR_CITY,VENDOR_STATE,VENDOR_POSTAL_CODE. - Flags:
CANCEL_FLAG,CONFIRMING_ORDER_FLAG,ACCEPTANCE_REQUIRED_FLAG.
Common Use Cases and Queries
Typical uses include regenerating archived PO documents as XML, auditing field-level changes across revisions, and building custom BI Publisher reports against archived headers. Notably, the vendor_area_code field a user may search for is not exposed as a distinct column in this view's documented text; telephone area code is typically stored on vendor site/contact tables rather than the archived header.
- Retrieve recent archived headers for a supplier:
SELECT h.segment1, h.revision_num, h.creation_date,
h.vendor_name, h.currency_code, h.amount_agreed
FROM apps.po_headers_archive_xml h
WHERE h.vendor_num = '&vendor_num'
ORDER BY h.creation_date DESC;
- List archived buyers for revised documents only:
SELECT h.segment1, h.revision_num,
h.document_buyer_first_name, h.document_buyer_last_name,
h.archive_buyer_first_name, h.archive_buyer_last_name
FROM apps.po_headers_archive_xml h
WHERE NVL(h.revision_num,0) <> 0;
Because the view calls PO_COMMUNICATION_PVT and FND_GLOBAL, queries should be executed in an application-initialized session (or via concurrent programs) to avoid function errors.
-
View: PO_HEADERS_ARCHIVE_XML 12.2.2
APPS.PO_HEADERS_ARCHIVE_XML·↳ AP_TERMS·↳ FND_CURRENCIES_TL·↳ FND_GLOBAL·Explore PO module →
-
View: POS_PO_RFQ_HEADERS_V 12.1.1
APPS.POS_PO_RFQ_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
Table: PO_HEADERS_GT 12.1.1
For Internal Use Only: This table is global temporary table based on po_headers_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: PO_HEADERS_V 12.2.2
10SC ONLY
APPS.PO_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PO_HEADERS_TRX_V 12.2.2
View on po_headers table.
-
APPS.POS_PO_INVOICE_SUP_ORDERS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore PO module →
-
Archived purchase orders
-
- Retrofitted
APPS.PO_QUOTATIONS_TO_APPROVE·↳ AP_TERMS·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: PO_HEADERS_MERGE_V 12.1.1
APPS.PO_HEADERS_MERGE_V·↳ PO_DRAFTS·↳ PO_GLOBAL·↳ PO_HEADERS_ALL·Explore PO module →
-
View: PO_HEADERS_MERGE_V 12.2.2
APPS.PO_HEADERS_MERGE_V·↳ PO_DRAFTS·↳ PO_HEADERS_ALL·↳ PO_HEADERS_DRAFT_ALL·Explore PO module →
-
- Retrofitted
APPS.PO_QUOTATIONS_TO_APPROVE·↳ AP_TERMS·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: PO_HEADERS_XML 12.2.2
APPS.PO_HEADERS_XML·↳ AP_SUPPLIERS·↳ AP_SUPPLIER_SITES_ALL·↳ AP_TERMS·Explore PO module →
-
View: PO_HEADERS_ARCHIVE_XML 12.1.1
APPS.PO_HEADERS_ARCHIVE_XML·↳ AP_TERMS·↳ FND_CURRENCIES_TL·↳ FND_GLOBAL·Explore PO module →
-
View: PO_HEADERS_RFQQT_V 12.2.2
- Retrofitted
APPS.PO_HEADERS_RFQQT_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PO_HEADERS_XML 12.1.1
APPS.PO_HEADERS_XML·↳ AP_TERMS·↳ FND_CURRENCIES_TL·↳ FND_GLOBAL·Explore PO module →
-
View: POS_PO_RFQ_HEADERS_V 12.2.2
APPS.POS_PO_RFQ_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PO_HEADERS_RFQQT_V 12.1.1
- Retrofitted
APPS.PO_HEADERS_RFQQT_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
View: PO_HEADERS_INQ_REL_V 12.2.2
- Retrofitted
APPS.PO_HEADERS_INQ_REL_V·↳ AP_SUPPLIER_CONTACTS·↳ AP_TERMS·↳ FND_GLOBAL·Explore PO module →
-
View: PO_HEADERS_INQ_REL_V 12.1.1
- Retrofitted
APPS.PO_HEADERS_INQ_REL_V·↳ AP_TERMS·↳ HR_LOCATIONS_ALL_TL·↳ PO_DOCUMENT_TYPES_ALL_B·Explore PO module →
-
View: PO_HEADERS_V 12.1.1
10SC ONLY
APPS.PO_HEADERS_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
For Internal Use Only: This table is global temporary table based on po_headers_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: PO_HEADERS_INQ_PO_V 12.2.2
- Retrofitted
APPS.PO_HEADERS_INQ_PO_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: PO_HEADERS_INQ_PO_V 12.1.1
- Retrofitted
APPS.PO_HEADERS_INQ_PO_V·↳ AP_TERMS·↳ HR_LOCATIONS_ALL_TL·↳ PO_DOCUMENT_TYPES_ALL_B·Explore PO module →
-
View: PO_HEADERS_INQ_V 12.1.1
- Retrofitted
APPS.PO_HEADERS_INQ_V·↳ AP_TERMS·↳ HR_LOCATIONS_ALL_TL·↳ PO_DOCUMENT_TYPES_ALL_B·Explore PO module →
-
APPS.POS_PO_INVOICE_SUP_ORDERS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ FND_CURRENCY·↳ POS_GET·Explore PO module →
-
View: PO_HEADERS_INQ_V 12.2.2
- Retrofitted
APPS.PO_HEADERS_INQ_V·↳ AP_TERMS·↳ FND_GLOBAL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
Interface table for purchase order headers
-
Interface table for purchase order headers
-
Document headers (for purchase orders, purchase agreements, quotations, RFQs)
-
Document headers (for purchase orders, purchase agreements, quotations, RFQs)
-
Archived purchase orders
-
Draft Document headers (for purchase orders, purchase agreements, quotations, RFQs)
-
View: PO_HEADERS_MRC_V 12.1.1
- Retrofitted
Not implemented in this database·Explore PO module →
-
View: PO_HEADERS_ALL_MRC_V 12.2.2
- Retrofitted
Not implemented in this database·Explore PO module →
-
View: PO_HEADERS_ALL_MRC_V 12.1.1
- Retrofitted
Not implemented in this database·Explore PO module →
-
View: PO_HEADERS_MRC_V 12.2.2
- Retrofitted
Not implemented in this database·Explore PO module →