Results for “delivery_status”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
SO_DELIVERIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Order Entry (OE) product family. It presents a consolidated, order-centric picture of outbound shipping activity by joining order header, order line, delivery, and departure information into a single denormalized structure. Its stated purpose, reflected in the inline comment "ASSIGNED, UNRELEASED LINE DETAILS," is to expose order lines that have been assigned to a delivery or departure but not yet fully released or closed, thereby supporting shipment tracking, delivery scheduling, and carrier coordination reporting.
The view is registered as VALID at the APPS level and is available in both Oracle EBS 12.1.1 and 12.2.2. Because it is a view rather than a table, it carries no independent storage and derives all content at query time from its underlying base objects. This makes it a convenient integration and reporting surface for shipping-related data without requiring consumers to reconstruct the complex join logic between order management and warehouse shipping tables themselves.
The user search term "departure_date" maps directly to a computed column in this view. The DEPARTURE_DATE column is derived conditionally from the parent WSH_DEPARTURES record, selecting the actual departure date when the departure status is CLOSED, and the planned departure date for PLANNED or OPEN statuses, with a default fallback to the planned date in all other cases. This makes the column a reliable single source for the effective departure timestamp regardless of lifecycle stage.
Underlying Base Objects
SO_DELIVERIES_V is built from synonyms referencing the following documented base objects: MTL_PARAMETERS, SO_HEADERS_ALL, SO_LINES_ALL, SO_LINE_DETAILS, SO_LOOKUPS, SO_PICKING_HEADERS_ALL, SO_PICKING_LINES_ALL, SO_PICKING_LINE_DETAILS, WSH_DELIVERIES, and WSH_DEPARTURES, along with the FND_GLOBAL package. The published view text joins SO_HEADERS_ALL to SO_LINES_ALL on HEADER_ID, then to SO_LINE_DETAILS on LINE_ID. SO_LINE_DETAILS is the pivotal table linking order lines to deliveries (DELIVERY_ID) and departures (DEPARTURE_ID). MTL_PARAMETERS supplies the warehouse organization code, WSH_DELIVERIES supplies delivery attributes, and WSH_DEPARTURES supplies departure attributes. SO_LOOKUPS is outer-joined twice against the SHIPPING_STATUS lookup type to translate departure and delivery status codes into descriptive meanings.
Key Columns
- ORDER_NUMBER, CUSTOMER_ID — order header identifiers for the shipment.
- WAREHOUSE_ID, ORGANIZATION_CODE — the shipping warehouse and its code.
- DEPARTURE_ID, DEPARTURE_NAME, DEPARTURE_STATUS_CODE, DEPARTURE_STATUS, DEPARTURE_DATE — the departure record; DEPARTURE_DATE resolves to the actual date when CLOSED and the planned date when OPEN or PLANNED.
- DELIVERY_ID, DELIVERY_NAME, DELIVERY_STATUS_CODE, DELIVERY_STATUS — the delivery grouping the line belongs to.
- WAYBILL, EXPECTED_ARRIVAL_DATE, BILL_OF_LADING — carrier and transport documentation fields.
- DPW_ASSIGNED_FLAG — indicates whether a delivery/picking wave assignment has been made.
- FREIGHT_CARRIER_CODE — resolved via NVL from the line-level ship method, falling back to the header ship method.
- SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID — ship-to destination and contact, similarly resolved from line or header.
Common Use Cases and Queries
Typical uses include reporting open shipments by departure, tracking expected arrival against planned departure, and reconciling carrier waybills to order lines. The DISTINCT clause and the shippable/ATO filters in the view text mean it returns only shippable, non-service lines, which suits shipment-status dashboards rather than order-entry validation.
A representative query retrieving departure timing for a specific order:
- SELECT order_number, delivery_name, departure_name, departure_date, expected_arrival_date, freight_carrier_code FROM apps.so_deliveries_v WHERE order_number = :p_order_number ORDER BY departure_date;
All access should respect the view's APPS ownership and standard EBS security conventions.
-
Lookup Type: DELIVERY_STATUS 12.1.1
Delivery Status
-
Lookup Type: DELIVERY_STATUS 12.2.2
Delivery Status
-
View: SO_DELIVERIES_V 12.1.1
APPS.SO_DELIVERIES_V·↳ FND_GLOBAL·↳ MTL_PARAMETERS·↳ SO_HEADERS_ALL·Explore OE module →
-
View: ECX_OUT_PROCESS_VL 12.2.2
Status for Outbound Messages
APPS.ECX_OUT_PROCESS_VL·↳ ECX_DEBUG·↳ ECX_DOCLOGS·↳ ECX_ERROR_MSGS·Explore ECX module →
-
APPS.WSH_DELIVERY_LINE_STATUS_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOCATIONS·Explore WSH module →
-
View: POS_RCV_TRANSACTIONS_V 12.2.2
APPS.POS_RCV_TRANSACTIONS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: ICX_RCV_TRANSACTIONS_V 12.2.2
Receipt Lines View
APPS.ICX_RCV_TRANSACTIONS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
View: SO_DELIVERIES_V 12.2.2
APPS.SO_DELIVERIES_V·↳ FND_GLOBAL·↳ MTL_PARAMETERS·↳ SO_HEADERS_ALL·Explore OE module →
-
View: ECX_OUT_PROCESS_VL 12.1.1
Status for Outbound Messages
APPS.ECX_OUT_PROCESS_VL·↳ ECX_DEBUG·↳ ECX_DOCLOGS·↳ ECX_ERROR_MSGS·Explore ECX module →
-
View: POS_RCV_TRANSACTIONS_V 12.2.2
Displays Receiving Transactions
APPS.POS_RCV_TRANSACTIONS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore POS module →
-
APPS.POS_RCV_EARLY_LATE_RECEIPTS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
APPS.WSH_DELIVERY_LINE_STATUS_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOCATIONS·Explore WSH module →
-
Supplier Performance View based on On-Time Delivery Performance
APPS.ICX_RCV_EARLY_LATE_RECEIPTS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
View: POS_RCV_TRANSACTIONS_V 12.1.1
APPS.POS_RCV_TRANSACTIONS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS_KFV·Explore PO module →
-
View: ICX_RCV_TRANSACTIONS_V 12.1.1
Receipt Lines View
APPS.ICX_RCV_TRANSACTIONS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
APPS.POS_RCV_EARLY_LATE_RECEIPTS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
Holds data on all dunning transactions sent by the system.
-
Supplier Performance View based on On-Time Delivery Performance
APPS.ICX_RCV_EARLY_LATE_RECEIPTS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore ICX module →
-
Displays All receipts
APPS.POS_RCV_EARLY_LATE_RECEIPTS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore POS module →
-
VIEW: APPS.SO_DELIVERIES_V 12.1.1
-
VIEW: IEX.IEX_DUNNINGS# 12.2.2
-
VIEW: APPS.SO_DELIVERIES_V 12.2.2
-
VIEW: APPS.SO_DELIVERIES_V 12.2.2
-
View: ECX_OUT_PROCESS_V 12.1.1
Status for Outbound Messages
Not implemented in this database·Explore ECX module →
-
VIEW: IEX.IEX_DUNNINGS# 12.2.2
-
VIEW: APPS.SO_DELIVERIES_V 12.1.1
-
VIEW: APPS.IBE_SHIP_DLVY_V 12.2.2
-
VIEW: APPS.IBE_SHIP_DLVY_V 12.1.1
-
Delivery Leg Activities
-
View: ECX_OUT_PROCESS_V 12.2.2
Status for Outbound Messages
Not implemented in this database·Explore ECX module →
-
View: IBE_SHIPMENT_LINES_V 12.2.2
This view is used to get the Shipment line information in Post sales interaction with customer in iStore. This view is based on wsh_delivery_line_status_v.
Not implemented in this database·Explore IBE module →
-
Delivery Leg Activities