APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_DELIVERY_LEGS

Line 428: WSH_DELIVERY_LEGS WDL

424: WT.NAME
425: FROM
426: WSH_TRIPS WT,
427: WSH_TRIP_STOPS WTS,
428: WSH_DELIVERY_LEGS WDL
429: WHERE WDL.DELIVERY_ID = DELIVERY_ID1
430: AND WTS.STOP_LOCATION_ID = INITIAL_PICKUP_LOCATION_ID
431: AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID
432: AND WTS.TRIP_ID = WT.TRIP_ID;

Line 556: WSH_DELIVERY_LEGS WDL,

552: ,''
553: ,', ') || LOC.COUNTRY
554: FROM
555: WSH_TRIP_STOPS WTS,
556: WSH_DELIVERY_LEGS WDL,
557: WSH_LOCATIONS LOC
558: WHERE WDL.DELIVERY_ID = P_DELIVERY_ID
559: AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
560: AND WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID;

Line 582: WSH_DELIVERY_LEGS WDL,

578: ,''
579: ,', ') || LOC.COUNTRY
580: FROM
581: WSH_TRIP_STOPS WTS,
582: WSH_DELIVERY_LEGS WDL,
583: WSH_DELIVERY_ASSIGNMENTS_V WDA,
584: WSH_DELIVERY_DETAILS WDD,
585: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
586: WSH_LOCATIONS LOC

Line 620: WSH_DELIVERY_LEGS WDL,

616: ,''
617: ,', ') || LOC.COUNTRY
618: FROM
619: WSH_TRIP_STOPS WTS,
620: WSH_DELIVERY_LEGS WDL,
621: WSH_DELIVERY_ASSIGNMENTS_V WDA,
622: WSH_DELIVERY_DETAILS WDD,
623: MTL_MATERIAL_TRANSACTIONS MMT,
624: WSH_LOCATIONS LOC

Line 658: WSH_DELIVERY_LEGS WDL,

654: ,''
655: ,', ') || LOC.COUNTRY
656: FROM
657: WSH_TRIP_STOPS WTS,
658: WSH_DELIVERY_LEGS WDL,
659: WSH_DELIVERY_ASSIGNMENTS_V WDA,
660: WSH_DELIVERY_DETAILS WDD,
661: MTL_TXN_REQUEST_LINES MTRL,
662: WSH_LOCATIONS LOC