VIEW: APPS.WSH_DELIVERY_DETAILS_OE_V

Source

View Text - Preformatted

SELECT wda.DELIVERY_ID, wnd.NAME DELIVERY_NAME, wdd.source_header_id source_header_id, wdd.source_line_id source_line_id, wdd.delivery_detail_id, wdd.source_code, wdd.organization_id, wdd.requested_quantity, wdd.oe_interfaced_flag, wdd.inv_interfaced_flag, wdd.move_order_line_id, wdd.ship_method_code line_ship_method, wnd.ship_method_code delivery_ship_method, wdd.tracking_number, wnd.waybill, wdd.released_status, lk.meaning original_line_status, wdd.requested_quantity2, wnd.delivered_date, wdd.replenishment_status FROM oe_order_lines_all oe, wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_lookups lk WHERE oe.header_id = wdd.source_header_id AND oe.line_id = wdd.source_line_id AND wdd.delivery_detail_id = wda.delivery_detail_id AND wdd.source_code = 'OE' AND wnd.delivery_id = wda.delivery_id AND lk.lookup_type = 'PICK_STATUS' AND lk.lookup_code = wdd.released_status AND wnd.delivery_type = 'STANDARD'

View Text - HTML Formatted

SELECT WDA.DELIVERY_ID
, WND.NAME DELIVERY_NAME
, WDD.SOURCE_HEADER_ID SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID SOURCE_LINE_ID
, WDD.DELIVERY_DETAIL_ID
, WDD.SOURCE_CODE
, WDD.ORGANIZATION_ID
, WDD.REQUESTED_QUANTITY
, WDD.OE_INTERFACED_FLAG
, WDD.INV_INTERFACED_FLAG
, WDD.MOVE_ORDER_LINE_ID
, WDD.SHIP_METHOD_CODE LINE_SHIP_METHOD
, WND.SHIP_METHOD_CODE DELIVERY_SHIP_METHOD
, WDD.TRACKING_NUMBER
, WND.WAYBILL
, WDD.RELEASED_STATUS
, LK.MEANING ORIGINAL_LINE_STATUS
, WDD.REQUESTED_QUANTITY2
, WND.DELIVERED_DATE
, WDD.REPLENISHMENT_STATUS
FROM OE_ORDER_LINES_ALL OE
, WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
, WSH_LOOKUPS LK
WHERE OE.HEADER_ID = WDD.SOURCE_HEADER_ID
AND OE.LINE_ID = WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.SOURCE_CODE = 'OE'
AND WND.DELIVERY_ID = WDA.DELIVERY_ID
AND LK.LOOKUP_TYPE = 'PICK_STATUS'
AND LK.LOOKUP_CODE = WDD.RELEASED_STATUS
AND WND.DELIVERY_TYPE = 'STANDARD'