Search Results hou_v




Overview
Explore in AI Chat

Overview

APPS.PO_CXML_LINE_LOC_ARCH_V is an Oracle E-Business Suite archive view that presents archived purchasing line-location shipment data in a flattened, integration-friendly form. It is owned by the APPS schema and is built primarily over PO_LINE_LOCATIONS_ARCHIVE_ALL, the archival shadow of the transactional PO_LINE_LOCATIONS_ALL table. The view joins archive shipment rows to their parent purchase lines, operating units, receiving organizations, items, units of measure, and hazard classes to produce a single row per archived shipment that is suitable for CXML (Commerce XML) message generation and for replenishment-style reporting.

Because the name carries the ARCH infix, the view is intended to be queried as a historical counterpart to the live purchasing line-location view. The user search term "hou_v" refers to the HR_ORGANIZATION_UNITS_V alias that appears in the view text; this view is joined on ORGANIZATION_ID = PLLA.ORG_ID to resolve the ship-to organization name. All references to the organization are therefore filtered through HR security, meaning the set of shipments visible depends on the HR security profile of the invoking user or responsibility.

Underlying Base Objects

The ETRM documentation lists the referenced base objects as: FINANCIALS_SYSTEM_PARAMS_ALL (synonym), HR_API (package), HR_GENERAL (package), HR_ORGANIZATION_UNITS_V (view), HR_SECURITY (package), MTL_SYSTEM_ITEMS_B_KFV (view), MTL_UNITS_OF_MEASURE_TL (synonym), PO_HAZARD_CLASSES (synonym), PO_LINES_ALL (synonym), PO_LINE_LOCATIONS_ARCHIVE_ALL (synonym), and PO_LINE_TYPES_B (synonym).

The driving table is PO_LINE_LOCATIONS_ARCHIVE_ALL, joined to PO_LINES_ALL on the composite key PO_LINE_ID and PO_HEADER_ID. Financials context is supplied by FINANCIALS_SYSTEM_PARAMS_ALL, which is joined twice — once as FSP (to derive the inventory organization) and once as FSPA (to derive buying-organization currency). Organization data comes from HR_ORGANIZATION_UNITS_V, with HR_API, HR_GENERAL, and HR_SECURITY packages providing the security predicates applied through that view. Items are resolved through MTL_SYSTEM_ITEMS_B_KFV, units of measure through MTL_UNITS_OF_MEASURE_TL, hazard classes through PO_HAZARD_CLASSES, and line types through PO_LINE_TYPES_B. Only shipments with a positive outstanding quantity, (QUANTITY - QUANTITY_CANCELLED) > 0, are returned.

Key Columns

Common Use Cases and Queries

Typical usage includes CXML/OCI punch-out order replication, archived shipment reconciliation, and reporting on open archived quantities by ship-to organization. Because the view enforces HR security, queries are commonly restricted by operating unit.

SELECT PO_HEADER_ID, LINE_NUM, SHIPMENT_NUM, ORDERED_QUANTITY,
       UOM, SHIPTO_ORG_NAME, NEED_BY_DATE
  FROM APPS.PO_CXML_LINE_LOC_ARCH_V
 WHERE PARTNER_ID = :org_id
   AND NEED_BY_DATE >= :start_date;

A second pattern aggregates archived demand by item and organization, joining the view to MTL_SYSTEM_ITEMS_B_KFV on the ITEM segment value to obtain item descriptions where the view token is insufficient.