APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 15: WSH_DELIVERY_ASSIGNMENTS_V DA

11: CURSOR C_GET_DELIVERY_DETAILS(P_DELIVERY_DETAIL_ID IN NUMBER) IS
12: SELECT
13: DELIVERY_DETAIL_ID
14: FROM
15: WSH_DELIVERY_ASSIGNMENTS_V DA
16: START WITH DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID
17: CONNECT BY prior DELIVERY_DETAIL_ID = PARENT_DELIVERY_DETAIL_ID;
18: L_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
19: L_FIRST_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;

Line 246: WSH_DELIVERY_ASSIGNMENTS_V WDA,

242: INTO L_SHIP_METHOD_CODE
243: FROM
244: WSH_TRIPS WT,
245: WSH_TRIP_STOPS WTS,
246: WSH_DELIVERY_ASSIGNMENTS_V WDA,
247: WSH_DELIVERY_LEGS WDL
248: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
249: --AND WDA.DELIVERY_ID = DELIVERY_ID
250: AND WDA.DELIVERY_ID = DELIVERY_ID1

Line 333: WSH_DELIVERY_ASSIGNMENTS_V WDA

329: WHERE DELIVERY_DETAIL_ID in (
330: SELECT
331: WDA.DELIVERY_DETAIL_ID
332: FROM
333: WSH_DELIVERY_ASSIGNMENTS_V WDA
334: START WITH WDA.PARENT_DELIVERY_DETAIL_ID = P_DEL_DET_ID_2
335: CONNECT BY prior WDA.DELIVERY_DETAIL_ID = PARENT_DELIVERY_DETAIL_ID )
336: AND SHIP_TO_CONTACT_ID is not null
337: AND CONTAINER_FLAG IN ( 'N' , 'Y' )