Search Results oe_interfaced_flag




Overview
Explore in AI Chat

Overview

APPS.WSH_DELIVERY_DETAILS_OE_V is a Shipping Execution (WSH) reporting and integration view that presents delivery detail records originating from Oracle Order Management (OE) sales order lines. The view joins delivery detail rows in WSH_DELIVERY_DETAILS to their parent delivery header in WSH_NEW_DELIVERIES, to the delivery assignment in WSH_DELIVERY_ASSIGNMENTS_V, to the originating order line in OE_ORDER_LINES_ALL, and to WSH_LOOKUPS for the decoded pick status. It is restricted to delivery details where SOURCE_CODE = 'OE' and to standard deliveries (DELIVERY_TYPE = 'STANDARD'), so only order-management-sourced, standard outbound shipments are surfaced.

The view is principally used for reporting, order-to-shipment reconciliation, and downstream integration extracts, since it flattens delivery header attributes (name, ship method, waybill, delivered date) alongside line-level shipping detail (requested quantity, tracking number, released status, replenishment status) in a single queryable object. Because it exposes the OE_INTERFACED_FLAG and INV_INTERFACED_FLAG columns, it is a frequent target for queries investigating whether shipping transactions have been pushed to Order Management and to Inventory, which is directly relevant to searches for "inv_interfaced_flag".

Underlying Base Objects

  • OE_ORDER_LINES_ALL (SYNONYM) — joined on OE.HEADER_ID = WDD.SOURCE_HEADER_ID and OE.LINE_ID = WDD.SOURCE_LINE_ID, providing the order line context for the delivery detail.
  • WSH_DELIVERY_DETAILS (SYNONYM) — the primary table (alias WDD) supplying line-level shipping detail, including quantities, interfaced flags, tracking number, and release status.
  • WSH_DELIVERY_ASSIGNMENTS_V (VIEW) — joined on WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID, linking the detail to its delivery assignment.
  • WSH_NEW_DELIVERIES (SYNONYM) — the delivery header (alias WND), supplying DELIVERY_NAME, WAYBILL, DELIVERED_DATE, header ship method, and constrained to DELIVERY_TYPE = 'STANDARD'.
  • WSH_LOOKUPS (VIEW) — joined on LOOKUP_TYPE = 'PICK_STATUS' and LOOKUP_CODE = WDD.RELEASED_STATUS, decoding the pick/release status into ORIGINAL_LINE_STATUS.

Key Columns

  • DELIVERY_ID / DELIVERY_NAME — the delivery header identifier and user-visible delivery name.
  • SOURCE_HEADER_ID / SOURCE_LINE_ID — the originating sales order header and line identifiers.
  • DELIVERY_DETAIL_ID — unique delivery detail identifier; the join key to assignments and the OE line.
  • SOURCE_CODE — source system of the detail; fixed to 'OE' by the view predicate.
  • ORGANIZATION_ID — inventory organization that owns the shipped material.
  • REQUESTED_QUANTITY / REQUESTED_QUANTITY2 — requested shipping quantities (e.g., primary and secondary UOM).
  • OE_INTERFACED_FLAG — indicates whether the delivery detail has been interfaced back to Order Management.
  • INV_INTERFACED_FLAG — indicates whether the detail has been interfaced to Inventory for shipment transaction processing. This is the column most often queried in troubleshooting interface status.
  • MOVE_ORDER_LINE_ID — associated move order line, where applicable.
  • LINE_SHIP_METHOD / DELIVERY_SHIP_METHOD — shipping method at the line and delivery header levels respectively.
  • TRACKING_NUMBER / WAYBILL — line tracking number and header waybill for carrier tracking.
  • RELEASED_STATUS / ORIGINAL_LINE_STATUS — release/pick status code and its decoded lookup meaning.
  • DELIVERED_DATE — actual delivery date recorded on the header.
  • REPLENISHMENT_STATUS — replenishment state for the detail.

Common Use Cases and Queries

The view is commonly used to reconcile order lines with their deliveries and to identify shipping details that have not yet been interfaced to Inventory or Order Management. A typical query lists detail with its interface flags:

  • SELECT delivery_id, delivery_name, source_header_id, source_line_id, delivery_detail_id, organization_id, requested_quantity, oe_interfaced_flag, inv_interfaced_flag, released_status, original_line_status, delivered_date FROM wsh_delivery_details_oe_v WHERE inv_interfaced_flag = 'N';
  • Correlate a specific sales order to shipments by filtering on SOURCE_HEADER_ID or SOURCE_LINE_ID.
  • Report delivery lines by carrier tracking (TRACKING_NUMBER, WAYBILL) or ship method for logistics analysis.
  • Audit pick/release progress using RELEASED_STATUS and ORIGINAL_LINE_STATUS.

Because the view is defined only for standard OE-sourced deliveries, queries against it will not return internal, RMA, or non-standard delivery types; those must be sourced directly from WSH_DELIVERY_DETAILS with appropriate SOURCE_CODE filters.