APPS.WSH_WSHRDBSR_XMLP_PKG dependencies on WSH_DELIVERY_LEGS

Line 331: WSH_DELIVERY_LEGS WDL,

327: MAX(WTS.ACTUAL_DEPARTURE_DATE) LAST_SHIPPED_DATE
328: FROM
329: WSH_DELIVERY_DETAILS WDD,
330: WSH_DELIVERY_ASSIGNMENTS_V WDA,
331: WSH_DELIVERY_LEGS WDL,
332: WSH_TRIP_STOPS WTS
333: WHERE WDD.RELEASED_STATUS in ( 'C' , 'I' )
334: AND WDD.SOURCE_CODE = 'OE'
335: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID