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 239: WSH_DELIVERY_ASSIGNMENTS_V WDA,

235: INTO L_SHIP_METHOD_CODE
236: FROM
237: WSH_TRIPS WT,
238: WSH_TRIP_STOPS WTS,
239: WSH_DELIVERY_ASSIGNMENTS_V WDA,
240: WSH_DELIVERY_LEGS WDL
241: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
242: --AND WDA.DELIVERY_ID = DELIVERY_ID
243: AND WDA.DELIVERY_ID = DELIVERY_ID1

Line 326: WSH_DELIVERY_ASSIGNMENTS_V WDA

322: WHERE DELIVERY_DETAIL_ID in (
323: SELECT
324: WDA.DELIVERY_DETAIL_ID
325: FROM
326: WSH_DELIVERY_ASSIGNMENTS_V WDA
327: START WITH WDA.PARENT_DELIVERY_DETAIL_ID = P_DEL_DET_ID_2
328: CONNECT BY prior WDA.DELIVERY_DETAIL_ID = PARENT_DELIVERY_DETAIL_ID )
329: AND SHIP_TO_CONTACT_ID is not null
330: AND CONTAINER_FLAG IN ( 'N' , 'Y' )