View: WSH_BACKORDER_LINES_V

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

View Text

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')

Columns