Search Results po_ecx_line_loc_v




Overview
Explore in AI Chat

Overview

PO_ECX_LINE_LOC_V is an APPS-owned database view in the Oracle E-Business Suite Purchasing (PO) module, classified as VALID in both release 12.1.1 and 12.2.2. It represents a denormalized, integration-oriented projection of purchase order shipment (line location) data, joining header, line, shipment, financial, and shipping location attributes into a single flattened result set. Its design pattern—with column aliases such as SHIPTO_ORG_NAME, SHIPTO_ORG_OTF, and SHIPTO_ORG_PARTNER_TYPE—indicates that it serves as a data source for outbound business events and external system integration, most notably the e-Commerce Gateway (ECX) purchasing extract. Rather than exposing raw transactional columns, the view resolves the ship-to location into human-readable organization, address, and telephone attributes suitable for transmission to suppliers or downstream systems. This makes PO_ECX_LINE_LOC_V a convenient reporting object for shipment-level detail without requiring callers to reconstruct the multi-table join chain manually.

Underlying Base Objects

The view is defined over five primary sources, each contributing distinct attributes:

The documented referenced objects also include the HR_API, HR_GENERAL, and HR_SECURITY packages, which are invoked by HR_ORGANIZATION_UNITS_V to enforce organization security and resolve flexible structures. Notably, the view filters to REVISION_NUM = 0 and to shipments where NET QUANTITY (QUANTITY minus QUANTITY_CANCELLED) exceeds zero, excluding fully cancelled shipments.

Key Columns

Common Use Cases and Queries

Typical uses include generating shipment extracts for supplier communication, validating ship-to organization names against purchase orders, and building ad hoc purchasing reports. A sample retrieval of shipment detail by ship-to organization is shown below.

SELECT l.po_header_id, l.po_line_id, l.line_num, l.shipment_number,
  l.ordered_quantity, l.uom, l.need_by_date, l.shipto_org_name,
  l.shipto_org_city, l.shipto_org_country
FROM apps.po_ecx_line_loc_v l
WHERE l.shipto_org_name = :p_org_name
AND l.need_by_date >= TRUNC(SYSDATE)
ORDER BY l.po_header_id, l.line_num, l.shipment_number;

Because the view already filters cancelled and superseded shipments, callers can rely on the result set reflecting only active, orderable commitments. Analysts should note the dependency on organization security via HR_ORGANIZATION_UNITS_V, which may restrict visible rows based on the session's organization access.