VIEW: APPS.WSH_BACKORDER_LINES_V

Source

View Text - Preformatted

SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID , WDD.SOURCE_HEADER_NUMBER ORDER_NUMBER , WDD.SOURCE_LINE_NUMBER LINE_NUMBER , WDD.SOURCE_HEADER_ID HEADER_ID , WDD.SOURCE_HEADER_TYPE_ID ORDER_TYPE_ID , WDD.SOURCE_HEADER_TYPE_NAME ORDER_TYPE_NAME , WDD.SOURCE_LINE_ID LINE_ID , WDD.CUSTOMER_ID CUSTOMER_ID , WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION , WDD.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID , WDD.ORGANIZATION_ID ORGANIZATION_ID , WDD.REQUESTED_QUANTITY REQUESTED_QUANTITY , WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM , WND.DELIVERY_ID DELIVERY_ID , WND.NAME DELIVERY_NAME , WTS.TRIP_ID TRIP_ID , WTS.STOP_ID STOP_ID , WDL.DELIVERY_LEG_ID DELIVERY_LEG_ID FROM wsh_delivery_details WDD, wsh_delivery_assignments_v WDA, wsh_new_deliveries WND, wsh_delivery_legs WDL, wsh_trip_stops WTS WHERE WDD.delivery_detail_id = WDA.delivery_detail_id AND WDA.delivery_id = WND.delivery_id AND WND.initial_pickup_location_id = WTS.stop_location_id AND WND.delivery_id = WDL.delivery_id AND WDL.pick_up_stop_id = WTS.stop_id AND WDA.delivery_id is NOT NULL AND WDD.released_status = 'B' AND nvl(WDD.line_direction, 'O') IN ('O', 'IO') AND WND.delivery_type = 'STANDARD' UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID , WDD.SOURCE_HEADER_NUMBER ORDER_NUMBER , WDD.SOURCE_LINE_NUMBER LINE_NUMBER , WDD.SOURCE_HEADER_ID HEADER_ID , WDD.SOURCE_HEADER_TYPE_ID ORDER_TYPE_ID , WDD.SOURCE_HEADER_TYPE_NAME ORDER_TYPE_NAME , WDD.SOURCE_LINE_ID LINE_ID , WDD.CUSTOMER_ID CUSTOMER_ID , WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION , WDD.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID , WDD.ORGANIZATION_ID ORGANIZATION_ID , WDD.REQUESTED_QUANTITY REQUESTED_QUANTITY , WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM , WND.DELIVERY_ID DELIVERY_ID , WND.NAME DELIVERY_NAME , TO_NUMBER(NULL) TRIP_ID , TO_NUMBER(NULL) STOP_ID , TO_NUMBER(NULL) DELIVERY_LEG_ID FROM wsh_delivery_details WDD, wsh_delivery_assignments_v WDA, wsh_new_deliveries WND, wsh_delivery_legs WDL WHERE WDD.delivery_detail_id = WDA.delivery_detail_id AND WDA.delivery_id = WND.delivery_id AND WND.delivery_id = WDL.delivery_id (+) AND WDD.released_status = 'B' AND WDA.delivery_id is NOT NULL AND WDL.delivery_id is NULL AND nvl(WDD.line_direction, 'O') IN ('O', 'IO') AND WND.delivery_type = 'STANDARD' UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID , WDD.SOURCE_HEADER_NUMBER ORDER_NUMBER , WDD.SOURCE_LINE_NUMBER LINE_NUMBER , WDD.SOURCE_HEADER_ID HEADER_ID , WDD.SOURCE_HEADER_TYPE_ID ORDER_TYPE_ID , WDD.SOURCE_HEADER_TYPE_NAME ORDER_TYPE_NAME , WDD.SOURCE_LINE_ID LINE_ID , WDD.CUSTOMER_ID CUSTOMER_ID , WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION , WDD.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID , WDD.ORGANIZATION_ID ORGANIZATION_ID , WDD.REQUESTED_QUANTITY REQUESTED_QUANTITY , WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM , TO_NUMBER(NULL) DELIVERY_ID , NULL DELIVERY_NAME , TO_NUMBER(NULL) TRIP_ID , TO_NUMBER(NULL) STOP_ID , TO_NUMBER(NULL) DELIVERY_LEG_ID FROM wsh_delivery_details WDD, wsh_delivery_assignments_v WDA WHERE WDD.delivery_detail_id = WDA.delivery_detail_id AND WDD.released_status = 'B' AND WDA.delivery_id is NULL AND nvl(WDD.line_direction, 'O') IN ('O', 'IO')

View Text - HTML Formatted

SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WDD.SOURCE_HEADER_NUMBER ORDER_NUMBER
, WDD.SOURCE_LINE_NUMBER LINE_NUMBER
, WDD.SOURCE_HEADER_ID HEADER_ID
, WDD.SOURCE_HEADER_TYPE_ID ORDER_TYPE_ID
, WDD.SOURCE_HEADER_TYPE_NAME ORDER_TYPE_NAME
, WDD.SOURCE_LINE_ID LINE_ID
, WDD.CUSTOMER_ID CUSTOMER_ID
, WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION
, WDD.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, WDD.ORGANIZATION_ID ORGANIZATION_ID
, WDD.REQUESTED_QUANTITY REQUESTED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, WND.DELIVERY_ID DELIVERY_ID
, WND.NAME DELIVERY_NAME
, WTS.TRIP_ID TRIP_ID
, WTS.STOP_ID STOP_ID
, WDL.DELIVERY_LEG_ID DELIVERY_LEG_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
, WSH_TRIP_STOPS WTS
WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WND.DELIVERY_ID
AND WND.INITIAL_PICKUP_LOCATION_ID = WTS.STOP_LOCATION_ID
AND WND.DELIVERY_ID = WDL.DELIVERY_ID
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
AND WDA.DELIVERY_ID IS NOT NULL
AND WDD.RELEASED_STATUS = 'B'
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO')
AND WND.DELIVERY_TYPE = 'STANDARD' UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WDD.SOURCE_HEADER_NUMBER ORDER_NUMBER
, WDD.SOURCE_LINE_NUMBER LINE_NUMBER
, WDD.SOURCE_HEADER_ID HEADER_ID
, WDD.SOURCE_HEADER_TYPE_ID ORDER_TYPE_ID
, WDD.SOURCE_HEADER_TYPE_NAME ORDER_TYPE_NAME
, WDD.SOURCE_LINE_ID LINE_ID
, WDD.CUSTOMER_ID CUSTOMER_ID
, WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION
, WDD.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, WDD.ORGANIZATION_ID ORGANIZATION_ID
, WDD.REQUESTED_QUANTITY REQUESTED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, WND.DELIVERY_ID DELIVERY_ID
, WND.NAME DELIVERY_NAME
, TO_NUMBER(NULL) TRIP_ID
, TO_NUMBER(NULL) STOP_ID
, TO_NUMBER(NULL) DELIVERY_LEG_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WND.DELIVERY_ID
AND WND.DELIVERY_ID = WDL.DELIVERY_ID (+)
AND WDD.RELEASED_STATUS = 'B'
AND WDA.DELIVERY_ID IS NOT NULL
AND WDL.DELIVERY_ID IS NULL
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO')
AND WND.DELIVERY_TYPE = 'STANDARD' UNION SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WDD.SOURCE_HEADER_NUMBER ORDER_NUMBER
, WDD.SOURCE_LINE_NUMBER LINE_NUMBER
, WDD.SOURCE_HEADER_ID HEADER_ID
, WDD.SOURCE_HEADER_TYPE_ID ORDER_TYPE_ID
, WDD.SOURCE_HEADER_TYPE_NAME ORDER_TYPE_NAME
, WDD.SOURCE_LINE_ID LINE_ID
, WDD.CUSTOMER_ID CUSTOMER_ID
, WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION
, WDD.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, WDD.ORGANIZATION_ID ORGANIZATION_ID
, WDD.REQUESTED_QUANTITY REQUESTED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, TO_NUMBER(NULL) DELIVERY_ID
, NULL DELIVERY_NAME
, TO_NUMBER(NULL) TRIP_ID
, TO_NUMBER(NULL) STOP_ID
, TO_NUMBER(NULL) DELIVERY_LEG_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.RELEASED_STATUS = 'B'
AND WDA.DELIVERY_ID IS NULL
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO')