SELECT WDD.SOURCE_HEADER_ID,
OOH.ORDER_NUMBER,
WND.DELIVERY_ID,
WND.NAME,
WDD.DELIVERY_DETAIL_ID,
WDL.PICK_UP_STOP_ID,
WDD.INV_INTERFACED_FLAG,
WDD.OE_INTERFACED_FLAG,
WND.STATUS_CODE,
WDD.RELEASED_STATUS
FROM APPS.WSH_DELIVERY_DETAILS WDD,
APPS.WSH_DELIVERY_ASSIGNMENTS WDA,
APPS.WSH_NEW_DELIVERIES WND,
APPS.WSH_DELIVERY_LEGS WDL,
APPS.WSH_TRIP_STOPS WTS,
APPS.OE_ORDER_HEADERS_ALL OOH,
APPS.OE_ORDER_LINES_ALL OOL
WHERE WDD.SOURCE_CODE = ‘OE’
AND WDD.RELEASED_STATUS = ‘C’
AND WDD.INV_INTERFACED_FLAG IN (‘N’, ‘P’)
AND WDD.ORGANIZATION_ID = &ORGANIZATION_ID
AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WND.DELIVERY_ID = WDA.DELIVERY_ID
AND WND.STATUS_CODE IN (‘CL’, ‘IT’)
AND WDL.DELIVERY_ID = WND.DELIVERY_ID
AND TRUNC (WTS.ACTUAL_DEPARTURE_DATE) BETWEEN ‘&period_start_date’
AND ‘&period_end_date’
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
AND WDD.SOURCE_HEADER_ID = OOH.HEADER_ID
AND WDD.SOURCE_LINE_ID = OOL.LINE_ID;