Search Results oke_dts_shipping_v




Overview
Explore in AI Chat

Overview

OKE_DTS_SHIPPING_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the OKE – Project Contracts product family. Its stated purpose is to expose shipping data related to contract deliverables. Functionally, it consolidates delivery header, delivery detail, delivery assignment, packing slip, delivery leg, and document instance information from the Oracle Shipping (WSH) tables into a single, denormalized projection that is keyed to the OKE deliverable structure.

In practice, the view serves as the shipping-side companion to the OKE deliverable and billing tables. It allows contract-facing reporting, inquiry screens, and integration extracts to retrieve the physical fulfillment status of a contract deliverable — what was requested, what was shipped, what was delivered, and what was cancelled — along with carrier, waybill, tracking, and packing slip references, without joining the WSH tables directly. Because delivery status is resolved through the FND_LOOKUP_VALUES_VL lookup on the DELIVERY_STATUS lookup type, the view presents human-readable status values rather than raw codes.

Underlying Base Objects

The view is defined with an explicit filter on WSH_DELIVERY_DETAILS (DLVDTL) restricting rows to SOURCE_CODE = 'OKE', which is the predicate that ties shipping records back to Project Contracts deliverables. It is built from the following documented base objects:

Most joins are outer joins, so deliverables without a shipment or without packing slip and document instance records still return rows.

Key Columns

The most frequently referenced columns include:

Common Use Cases and Queries

A typical use is to track delivered versus requested quantities per deliverable, which supports progress billing, milestone verification, and open quantity analysis. A representative query follows:

  • SELECT deliverable_id, delivered_quantity, requested_quantity, status FROM oke_dts_shipping_v WHERE source_header_id = :header_id;
  • SELECT deliverable_id, delivered_quantity - requested_quantity shortfall FROM oke_dts_shipping_v WHERE cancelled_quantity > 0;
  • SELECT deliverable_id, status, waybill, packing_slip_number FROM oke_dts_shipping_v WHERE status = 'Delivered' AND date_scheduled BETWEEN :from AND :to;

Because the view resolves status codes through the lookup view and locations through OKE_UTILS, queries are self-contained and suitable for concurrent programs, OBIEE extracts, and integration interfaces. Reports should filter on SOURCE_HEADER_ID or DELIVERABLE_ID to avoid full-table scans, since the WSH base objects are among the largest in the EBS data model.