VIEW: APPS.WSH_INV_DELIVERY_DETAILS_V

Source

View Text - Preformatted

SELECT wdd.source_header_id oe_header_id, wts.stop_id trip_stop_id, wdd.source_line_id oe_line_id, wda.delivery_id shipping_delivery_id, wdd.customer_id customer_id, cust_acct.account_number /* customer number */, wlt.source_location_id ship_to_location, wlf.source_location_id ship_FROM_location, wdd.shipment_priority_code shipment_priority_code, ol.shipment_number shipment_number, wdd.ship_method_code freight_code, wdd.move_order_line_id move_order_line_id, wdd.released_status, wdd.delivery_detail_id FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda, hz_cust_accounts cust_acct, wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts, oe_order_lines_all ol, wsh_locations wlt, wsh_locations wlf WHERE wdd.customer_id = cust_acct.cust_account_id AND wnd.delivery_id(+) = wda.delivery_id AND wlg.delivery_id(+) = wnd.delivery_id AND wts.stop_id(+) = wlg.pick_up_stop_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 ol.line_id = wdd.source_line_id AND wdd.delivery_detail_id = wda.delivery_detail_id AND wdd.ship_FROM_location_id = wlf.wsh_location_id (+) AND wdd.ship_to_location_id = wlt.wsh_location_id (+) AND nvl(wdd.line_direction, 'O') in ('O', 'IO') AND NVL(wnd.delivery_type, 'STANDARD') = 'STANDARD'

View Text - HTML Formatted

SELECT WDD.SOURCE_HEADER_ID OE_HEADER_ID
, WTS.STOP_ID TRIP_STOP_ID
, WDD.SOURCE_LINE_ID OE_LINE_ID
, WDA.DELIVERY_ID SHIPPING_DELIVERY_ID
, WDD.CUSTOMER_ID CUSTOMER_ID
, CUST_ACCT.ACCOUNT_NUMBER /* CUSTOMER NUMBER */
, WLT.SOURCE_LOCATION_ID SHIP_TO_LOCATION
, WLF.SOURCE_LOCATION_ID SHIP_FROM_LOCATION
, WDD.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, OL.SHIPMENT_NUMBER SHIPMENT_NUMBER
, WDD.SHIP_METHOD_CODE FREIGHT_CODE
, WDD.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, WDD.RELEASED_STATUS
, WDD.DELIVERY_DETAIL_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, HZ_CUST_ACCOUNTS CUST_ACCT
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WLG
, WSH_TRIP_STOPS WTS
, OE_ORDER_LINES_ALL OL
, WSH_LOCATIONS WLT
, WSH_LOCATIONS WLF
WHERE WDD.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
AND WLG.DELIVERY_ID(+) = WND.DELIVERY_ID
AND WTS.STOP_ID(+) = WLG.PICK_UP_STOP_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 OL.LINE_ID = WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.SHIP_FROM_LOCATION_ID = WLF.WSH_LOCATION_ID (+)
AND WDD.SHIP_TO_LOCATION_ID = WLT.WSH_LOCATION_ID (+)
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO')
AND NVL(WND.DELIVERY_TYPE
, 'STANDARD') = 'STANDARD'