View: WSH_SHIPPING_DETAILS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_SHIPPING_DETAILS_V

View Text

SELECT OL.HEADER_ID ORDER_HEADER_ID
, OL.LINE_ID ORDER_LINE_ID
, WDD.DELIVERY_DETAIL_ID PICKING_LINE_DETAIL_ID
, WDD.SHIPPED_QUANTITY SHIPPED_QUANTITY
, WDD.REQUESTED_QUANTITY REQUESTED_QUANTITY
, TO_NUMBER(NULL) PICK_SLIP_NUMBER
, HRLOC.INVENTORY_ORGANIZATION_ID WAREHOUSE_ID
, WDD.MVT_STAT_STATUS MVT_STAT_STATUS
, WDD.MOVEMENT_ID MOVEMENT_ID
, WDD.RELEASED_STATUS RELEASED_STATUS
, WDD.LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER
, WDD.CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, WDD.REQUESTED_QUANTITY_UOM SHIPPED_QUANTITY_UOM
, OL.SHIP_TO_ORG_ID SHIP_TO_SITE_USE_ID
, WDD.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, 0 CANCELLED_QUANTITY
, TO_NUMBER(NULL) PICKING_HEADER_ID
, TO_NUMBER(NULL) PICKING_LINE_ID
, TO_NUMBER(NULL) SEQUENCE_NUMBER
, OL.COMPONENT_CODE COMPONENT_CODE
, TO_NUMBER(NULL) COMPONENT_RATIO
, DECODE(OL.ITEM_TYPE_CODE
, 'INCLUDED'
, 'Y'
, 'N') INCLUDED_ITEM_FLAG
, WDD.DATE_REQUESTED DATE_REQUESTED
, WDD.REQUESTED_QUANTITY ORIGINAL_REQUESTED_QUANTITY
, WDD.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, WND.CONFIRM_DATE CONFIRM_DATE
, TO_CHAR(NULL) RA_INTERFACE_STATUS
, TO_NUMBER(NULL) INVOICED_QUANTITY
, DECODE(WTS.STATUS_CODE
, 'CLOSED'
, 'INTERFACED'
, NULL) INVENTORY_STATUS
, WDD.DATE_SCHEDULED SCHEDULE_DATE
, OL.DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, OL.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, DECODE(OL.ITEM_TYPE_CODE
, 'CONFIG'
, 'Y'
, 'N') CONFIGURATION_ITEM_FLAG
, OL.LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, WDD.ATTRIBUTE_CATEGORY CONTEXT
, WDD.ATTRIBUTE1 ATTRIBUTE1
, WDD.ATTRIBUTE2 ATTRIBUTE2
, WDD.ATTRIBUTE3 ATTRIBUTE3
, WDD.ATTRIBUTE4 ATTRIBUTE4
, WDD.ATTRIBUTE5 ATTRIBUTE5
, WDD.ATTRIBUTE6 ATTRIBUTE6
, WDD.ATTRIBUTE7 ATTRIBUTE7
, WDD.ATTRIBUTE8 ATTRIBUTE8
, WDD.ATTRIBUTE9 ATTRIBUTE9
, WDD.ATTRIBUTE10 ATTRIBUTE10
, WDD.ATTRIBUTE11 ATTRIBUTE11
, WDD.ATTRIBUTE12 ATTRIBUTE12
, WDD.ATTRIBUTE13 ATTRIBUTE13
, WDD.ATTRIBUTE14 ATTRIBUTE14
, WDD.ATTRIBUTE15 ATTRIBUTE15
, WDD.CREATION_DATE CREATION_DATE
, WDD.CREATED_BY CREATED_BY
, WDD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, WDD.LAST_UPDATED_BY LAST_UPDATED_BY
, WDD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WDD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, WDD.PROGRAM_ID PROGRAM_ID
, WDD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WDD.REQUEST_ID REQUEST_ID
, WTS.PLANNED_DEPARTURE_DATE PLANNED_DEPARTURE_DATE
, WTS.ACTUAL_DEPARTURE_DATE ACTUAL_DEPARTURE_DATE
, WTS.STATUS_CODE DEPARTURE_STATUS_CODE
, WND.CONFIRM_DATE DATE_CLOSED
, OL.SHIP_TO_ORG_ID ULTIMATE_SHIP_TO_ID
, WND.NAME DELIVERY_NAME
, WND.DELIVERY_ID DELIVERY_ID
, WND.STATUS_CODE DELIVERY_STATUS_CODE
, WDD.FOB_CODE FOB_CODE
, WDD.SHIP_METHOD_CODE FREIGHT_CARRIER_CODE
, WTS.STATUS_CODE PICKING_HDR_STATUS_CODE
, DECODE(WND.ULTIMATE_DROPOFF_DATE
, NULL
, 2
, 1) ARRIVED_FLAG
, WDD.SHIP_METHOD_CODE SHIP_METHOD_CODE
, WND.WAYBILL WAYBILL
, OL.ORG_ID ORG_ID
FROM WSH_LOOKUPS FL
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
, WSH_DELIVERY_DETAILS WDD
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WLG
, WSH_TRIP_STOPS WTS
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_LOCATIONS WSH_LOC
, HR_LOCATIONS_ALL HRLOC
WHERE WND.DELIVERY_ID = WDA.DELIVERY_ID
AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WDD.SOURCE_LINE_ID = OL.LINE_ID
AND OL.HEADER_ID = OH.HEADER_ID
AND WDD.SOURCE_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'SOURCE_SYSTEM'
AND FL.LOOKUP_CODE = 'OE'
AND WDD.SHIP_FROM_LOCATION_ID = WSH_LOC.WSH_LOCATION_ID
AND WSH_LOC.LOCATION_SOURCE_CODE = 'HR'
AND WSH_LOC.SOURCE_LOCATION_ID = HRLOC.LOCATION_ID
AND WTS.STOP_ID(+) = WLG.PICK_UP_STOP_ID
AND WLG.DELIVERY_ID(+) = WND.DELIVERY_ID
AND NVL(WLG.SEQUENCE_NUMBER
, -1) = (SELECT NVL(MIN(G.SEQUENCE_NUMBER)
, -1)
FROM WSH_DELIVERY_LEGS G
WHERE G.DELIVERY_ID(+) = WND.DELIVERY_ID )
AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'
AND WDA.DELIVERY_ID IS NOT NULL
AND WND.DELIVERY_TYPE = 'STANDARD'

Columns