Search Results oke_contract_version_id




Overview
Explore in AI Chat

Overview

PO_LINES_ARCHIVE_ALL is a Purchasing (PO) module table owned by the PO schema that stores archived purchase order lines. It holds the historical, point-in-time copy of line-level purchasing data that Oracle EBS retains for audit, revision tracking, and archival reporting when active lines in PO_LINES_ALL are revised or purged from operational tables. The table is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its physical schema contains 186 columns, reflecting the full breadth of purchasing line attributes captured at the time of archival.

The primary key is PO_LINES_ARCHIVE_PK, composed of PO_LINE_ID and REVISION_NUM. The composite nature of this key confirms that the table retains multiple historical versions of the same logical line, keyed by revision. A unique index, PO_LINES_ARCHIVE_U1 (also PO_LINES_ARCHIVE_UK1), enforces uniqueness on PO_HEADER_ID, LINE_NUM, and REVISION_NUM. Based on the foreign key structure — which references PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_TYPES_B, MTL_CATEGORIES_B, PO_UN_NUMBERS_B, and PO_HAZARD_CLASSES_B — the table exhibits a satellite-leaning character within a Data Vault style model, since it hangs off the PO_LINE_ID business key while adding descriptive, revision-scoped attributes.

Key Information Stored

The most significant columns store the identity, financial, status, and descriptive attributes of archived lines:

Common Use Cases and Queries

Typical uses include reconstructing the historical state of a purchase order line at a specific revision, performing audit and compliance reporting, and comparing operational lines against their archived predecessors.

  • Retrieve all historical revisions of a line:
    SELECT * FROM PO.PO_LINES_ARCHIVE_ALL WHERE PO_LINE_ID = :line_id ORDER BY REVISION_NUM;
  • Report archived lines for a header:
    SELECT PO_LINE_ID, LINE_NUM, REVISION_NUM, QUANTITY, UNIT_PRICE FROM PO.PO_LINES_ARCHIVE_ALL WHERE PO_HEADER_ID = :header_id ORDER BY LINE_NUM, REVISION_NUM;
  • Compare current vs archived values by joining PO_LINES_ALL on PO_LINE_ID and REVISION_NUM to detect price or quantity drift.
  • Track change lineage using FROM_LINE_ID and FROM_HEADER_ID to build revised-line family histories.

Related Objects

  • PO_HEADERS_ALL — linked via PO_HEADER_ID and FROM_HEADER_ID; supplies the parent document context.
  • PO_LINES_ALL — linked via PO_LINE_ID and FROM_LINE_ID; the operational counterpart.
  • PO_LINE_TYPES_B — via LINE_TYPE_ID, defines line type.
  • MTL_CATEGORIES_B — via CATEGORY_ID, resolves item category.
  • PO_UN_NUMBERS_B and PO_HAZARD_CLASSES_B — via UN_NUMBER_ID and HAZARD_CLASS_ID for hazardous material attributes.
  • ICX_PO_REVISIONS_TEMP — references PO_LINES_ARCHIVE_ALL via LINE_ID and REVISION_NUM for revision workflow processing.
  • PON_AUCTION_HEADERS_ALL — linked via AUCTION_HEADER_ID for sourcing/auction traceability.