Search Results document_num




Overview
Explore in AI Chat

Overview

The PO_TAX_HEADERS_DETAIL_V view is a Purchasing (PO) module reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2 that consolidates header-level tax summary information across three distinct procurement document types: purchase orders, purchase order releases, and requisitions. Rather than maintaining tax figures on a single transactional table, the view derives recoverable tax, non-recoverable tax, and total document amount at runtime by invoking the PO_TAX_SUMMARY_PKG PL/SQL package. This design ensures that tax values always reflect the latest tax engine calculations, including any retroactive adjustments processed through Oracle's E-Business Tax (EBTax) architecture. The view plays a supporting role in tax reporting, reconciliation, and integration scenarios where a uniform, header-level view of taxable amounts across the entire procurement lifecycle is required. As documented in ETRM 12.2.2, the view is not implemented directly in the database as a stored object tracked by the implementation metadata; its text is exposed for reference, indicating it is defined and maintained as part of the standard PO schema.

Underlying Base Objects

According to the documented view text, the object is defined as a three-way UNION query over the following base objects:

Tax amounts are not read from these tables directly but are computed by the PO_TAX_SUMMARY_PKG functions GET_RECOVERABLE_TAX, GET_NONRECOVERABLE_TAX, and GET_HEADER_AMOUNT. The ETRM metadata notes that no additional base objects are documented beyond those named in the view text.

Key Columns

  • OBJECT_TYPE — literal discriminator ('PO', 'REL', or 'REQ') identifying the source document class.
  • HEADER_ID — the primary key of the source header (PO_HEADER_ID, PO_RELEASE_ID, or REQUISITION_HEADER_ID).
  • DOCUMENT_NUM — the human-readable document number (SEGMENT1) of the header. This column is the typical target of a document_num search.
  • RELEASE — the release number for release rows (RELEASE_NUM); null for PO and requisition rows.
  • CURRENCY_CODE — the document currency.
  • RECOVERABLE_TAX and NONRECOVERABLE_TAX — tax amounts returned by the summary package functions.
  • AMOUNT — the computed header amount for the document in its currency.

Common Use Cases and Queries

Typical uses include tax reconciliation reports, drill-downs from procurement dashboards, and outbound integrations requiring consolidated header-level tax figures. A frequent requirement is locating a document by number, which maps to DOCUMENT_NUM:

  • Retrieve all tax details for a specific purchase order, release, or requisition by its document number.
  • Compare recoverable versus non-recoverable tax across document types in a single result set.
  • Feed tax summaries into external reporting or data warehouse loads.

Sample query:

SELECT OBJECT_TYPE, HEADER_ID, DOCUMENT_NUM, RELEASE, CURRENCY_CODE, RECOVERABLE_TAX, NONRECOVERABLE_TAX, AMOUNT FROM PO_TAX_HEADERS_DETAIL_V WHERE DOCUMENT_NUM = :document_num;

Because tax values are computed through package calls, queries against this view execute the summary functions for every row returned; restricting by DOCUMENT_NUM or HEADER_ID is recommended to control performance.