Search Results supplier_ref_number




Overview
Explore in AI Chat

Overview

PO_ECX_LINE_ARCH_V is a VALID Oracle EBS view owned by the APPS schema and defined within the PO - Purchasing product. It exposes archived purchase order line distribution detail in a flattened, denormalized form intended for reporting, data extraction, and integration through the e-Commerce Exchange (ECX) framework. The view combines header-level attributes from PO_HEADERS_ALL with line-level attributes from PO_LINES_ARCHIVE_ALL, resolving lookup values into human-readable codes such as unit of measure, item number, category concatenated segments, line type, and hazardous material classification. Because the object carries the _ARCH_ prefix, its row population derives from archived purchasing line records rather than the active PO_LINES_ALL transaction table.

The name of the view is significant for users who searched for latest_external_flag. That flag is not exposed by PO_ECX_LINE_ARCH_V; the view is archival in scope and does not include the latest external reference indicator found on other ECX extraction interfaces. Consumers requiring that flag must source it from the corresponding ECX staging or runtime view rather than this archived view.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects:

These objects are joined in the view text to produce a single denormalized result set.

Key Columns

  • PO_HEADER_ID, PO_LINE_ID, REVISION_NUM, LINE_NUM, RELEASE_ID — identifiers and versioning keys.
  • QUANTITY, QUANT_UOM, PRICE, UNIT — quantity and pricing attributes, with UNIT hard-coded as 'UNIT'.
  • ITEM, ITEMX, DESCRIPTION, ITEMRV — item flexfield segment, vendor product number, description, and item revision.
  • CATEGORYID — concatenated category flexfield segments.
  • HAZRDMTL, HAZRDUNNUM, HAZRDUNDESC — hazardous class and UN number detail.
  • CONTRACT_NUM, TASKID, PROJECTID — project and contract references.
  • VENDORQUOTENUM, LISTPRICE, MARKETPRICE, PRICENOTTOEXCEED, NEGPRICE, TAXABLE — supplier and pricing conditions.
  • TXNREASONCODE, TYPE1099, LINEORDERTYPE — transaction reason, 1099 type, and line type.
  • DFF_LINE_ATTR1 through DFF_LINE_ATTR16 and DFF_ITEM_ATTR1 onward — line and item descriptive flexfield attribute exposure.

Common Use Cases and Queries

Typical uses include archived PO line reporting, historical spend extraction, and ECX-based data feeds. A representative query:

  • SELECT PO_HEADER_ID, LINE_NUM, ITEM, DESCRIPTION, QUANTITY, QUANT_UOM, PRICE, CATEGORYID, LINEORDERTYPE FROM APPS.PO_ECX_LINE_ARCH_V WHERE PO_HEADER_ID = :p_header_id ORDER BY LINE_NUM;
  • SELECT ITEM, SUM(QUANTITY * PRICE) archived_value FROM APPS.PO_ECX_LINE_ARCH_V GROUP BY ITEM ORDER BY archived_value DESC;
  • SELECT PO_LINE_ID, DFF_LINE_ATTR1, DFF_ITEM_ATTR1 FROM APPS.PO_ECX_LINE_ARCH_V WHERE LINEORDERTYPE = 'GOODS';

Because the view operates over archived data and excludes latest_external_flag, it is unsuitable for real-time reconciliation against open purchasing documents.