Results for “icx_distribution”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.ICX_PO_LINE_DIST_DIFF_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle iProcurement / Internet Procurement (ICX) module and serves a narrow, purpose-built role: it exposes distribution-level change records captured during the purchasing document revision process, joined to the archived shipment data for the affected line location.

The view is not a general-purpose reporting object. It is consumed internally by the purchasing revision comparison logic, which detects what changed on a purchase order or release between a prior version and the current version. When a distribution-level attribute is altered, a row is written into the temporary revision table, and this view resolves that row against the archive of line location shipments so that the change can be presented with its shipment number context. Because it reads from an ICX temporary/staging table, its contents are transient and are meaningful only within the window of an active revision comparison operation.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed through synonyms in ETRM metadata:

• ICX_PO_REVISIONS_TEMP (SYNONYM) — the driving table, aliased POR in the view text. It holds the staged revision rows recording which level, field, and values changed.
• PO_LINE_LOCATIONS_ARCHIVE (SYNONYM) — aliased POLLA, the archive of purchase order line location shipments used for historical comparison.

The two objects are joined on POLLA.SHIPMENT_NUM = POR.LOCATION_ID, and the result set is filtered with POR.LEVEL_ALTERED = 'ICX_DISTRIBUTION'. This restricts output to rows where the altered level is the distribution, and joins them to the archived shipment whose shipment number matches the recorded location identifier. The relationship is therefore a one-to-one style lookup of revision rows against archived shipments, not a hierarchical expansion.

Key Columns

The view projects a compact set of columns that together describe a single distribution-level change:

• LINE_SEQ — ordering sequence for the line within the document, sourced from the revision row.
• HEADER_ID, RELEASE_ID, LINE_ID, LOCATION_ID — identifying keys for the purchasing document header, release, line, and location respectively.
• SHIPMENT_NUM — the archived shipment number from PO_LINE_LOCATIONS_ARCHIVE, aligned to LOCATION_ID by the join predicate.
• DISTRIBUTION_ID, DISTRIBUTION_NUM — identifiers for the specific distribution affected by the change.
• LEVEL_ALTERED, FIELD_ALTERED — the level at which the change occurred (constrained to 'ICX_DISTRIBUTION') and the specific field that was altered.
• CHANGES_FROM, CHANGES_TO — the prior and new values of the altered field, enabling before/after presentation.

Common Use Cases and Queries

Because the view depends on the ICX revision staging table, it is used during purchasing document revision workflows — typically when iProcurement or Purchasing compares an archived version of a document against its current state and needs to surface distribution changes with shipment context.

A representative query retrieves all staged distribution changes for a given header:

• SELECT LINE_SEQ, LINE_ID, LOCATION_ID, SHIPMENT_NUM, DISTRIBUTION_NUM, FIELD_ALTERED, CHANGES_FROM, CHANGES_TO FROM APPS.ICX_PO_LINE_DIST_DIFF_V WHERE HEADER_ID = :p_header_id ORDER BY LINE_SEQ, DISTRIBUTION_NUM;

A second form inspects which fields changed at distribution level for a specific line and location:

• SELECT DISTRIBUTION_NUM, FIELD_ALTERED, CHANGES_FROM, CHANGES_TO FROM APPS.ICX_PO_LINE_DIST_DIFF_V WHERE LINE_ID = :p_line_id AND LOCATION_ID = :p_location_id;

In practice, this view should be treated as an internal construct. The user search term "po_line_locations_archive" reflects the archive table underlying it; direct reporting against PO_LINE_LOCATIONS_ARCHIVE is generally preferred for historical shipment analysis, while this view is reserved for revision-difference rendering within the ICX workflow.