Search Results drop_ship_flag




Overview
Explore in AI Chat

Overview

APPS.PO_ECX_LINE_LOC_ARCH_V is a Purchasing (PO) module view that exposes archived purchase order shipment and line-location information for use by Oracle EBS integration and reporting components, particularly the ECX (e-Commerce XML) message generation framework. The view consolidates header-level, line-level, and shipment-level attributes into a single flattened structure that external systems and Oracle's Procurement messaging infrastructure can consume without navigating the normalized PO schema directly.

Because the view draws exclusively from PO_LINE_LOCATIONS_ARCHIVE_ALL rather than the live PO_LINE_LOCATIONS_ALL, it is positioned primarily for archival, historical reporting, and XML message reconstruction — not for transactional processing. In the context of a user search for price_override, the view exposes the PRICE_OVERRIDE column directly from the archived shipment record, making it the appropriate source when auditing how price override behavior on a shipment was captured at the time of archival.

The view carries a status of VALID in the APPS schema and is documented in the ETRM for both 12.1.1 and 12.2.2. Its dependency chain includes HR security packages, HR organization views, and Financials system parameters, so grants and synonym resolution must be intact for the view to return rows.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following referenced objects:

The view therefore inherits two behavioral characteristics worth noting: results are language-dependent (UOM translation follows session NLS), and results are security-filtered through HR organization access.

Key Columns

  • PO_HEADER_ID, REVISION_NUM, PO_RELEASE_ID, PO_LINE_ID, LINE_NUM, LINE_LOCATION_ID, SHIPMENT_NUM — the composite identifying keys linking header, line, and shipment.
  • ORDERED_QUANTITY — computed as QUANTITY minus QUANTITY_CANCELLED; the WHERE clause filters out rows where this value would be negative.
  • UOM — translated unit of measure from MTL_UNITS_OF_MEASURE_TL.
  • NEED_BY_DATE, PROMISED_DATE, LAST_ACCEPT_DATE — scheduling and acceptance milestones from the archived shipment.
  • PRICE_OVERRIDE — the price override indicator/value on the archived shipment, which is the column most commonly targeted when investigating override behavior on historical POs.
  • TAXABLE_FLAG, TAX_CODE_ID — taxability attributes carried from the archived location row.
  • SHIPTO_ORG_NAME, SHIPTO_ORG_OTF, SHIPTO_ORG_PARTNER_TYPE, PARTNER_ID — partner-related fields; SHIPTO_ORG_OTF is hard-coded to '0' and SHIPTO_ORG_PARTNER_TYPE to 'SHIPTO', which is significant for ECX payloads.
  • BUYING_ORG_CURRENCY — currency code of the buying organization's financials setup.
  • CONSIGNED_FLAG, DROP_SHIP_FLAG — consignment and drop-shipment indicators; CONSIGNED_FLAG defaults to 'N' via NVL.
  • PSCLNSTATUS — derived status, set to 'CANCELLED' when PLA.CANCEL_FLAG = 'Y', otherwise 'OPEN'.

Common Use Cases and Queries

Auditing price overrides on archived shipments:

  • SELECT PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, SHIPMENT_NUM, PRICE_OVERRIDE, ORDERED_QUANTITY, PSCLNSTATUS FROM APPS.PO_ECX_LINE_LOC_ARCH_V WHERE PRICE_OVERRIDE IS NOT NULL;

Reconstructing ECX payload attributes for a specific PO header:

  • SELECT PO_HEADER_ID, LINE_NUM, SHIPMENT_NUM, UOM, ORDERED_QUANTITY, PRICE_OVERRIDE, BUYING_ORG_CURRENCY, SHIPTO_ORG_NAME, SHIPTO_ORG_PARTNER_TYPE FROM APPS.PO_ECX_LINE_LOC_ARCH_V WHERE PO_HEADER_ID = :p_header_id;

Identifying open versus cancelled archived shipments:

  • SELECT PO_HEADER_ID, LINE_NUM, SHIPMENT_NUM, PSCLNSTATUS, NEED_BY_DATE FROM APPS.PO_ECX_LINE_LOC_ARCH_V WHERE PSCLNSTATUS = 'OPEN';

Because HR organization security is applied through HR_ORGANIZATION_UNITS_V, query results are restricted to organizations the session user is authorized to see; a report that returns zero rows for otherwise valid PO_HEADER_ID values typically indicates an access or responsibility configuration issue rather than absent data.