APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_LOCATIONS

Line 557: WSH_LOCATIONS LOC

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;
561: CURSOR TRIP_STOP_FROM_PS(X_PS_NUMBER IN NUMBER) IS

Line 586: WSH_LOCATIONS LOC

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
587: WHERE MMTT.PICK_SLIP_NUMBER = X_PS_NUMBER
588: AND MMTT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
589: AND MMTT.PICK_SLIP_NUMBER IS NOT NULL
590: AND ABS(NVL(MMTT.TRANSACTION_QUANTITY

Line 624: WSH_LOCATIONS LOC

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
625: WHERE MMT.PICK_SLIP_NUMBER = X_PS_NUMBER
626: AND MMT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
627: AND MMT.PICK_SLIP_NUMBER IS NOT NULL
628: AND NVL(MMT.TRANSACTION_QUANTITY

Line 662: WSH_LOCATIONS LOC

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
663: WHERE MTRL.PICK_SLIP_NUMBER = X_PS_NUMBER
664: AND MTRL.LINE_ID = WDD.MOVE_ORDER_LINE_ID
665: AND MTRL.PICK_SLIP_NUMBER IS NOT NULL
666: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID

Line 825: WSH_LOCATIONS LOC

821: ,NULL
822: ,''
823: ,', ') || LOC.COUNTRY
824: FROM
825: WSH_LOCATIONS LOC
826: WHERE LOC.WSH_LOCATION_ID = (
827: SELECT
828: WDD.SHIP_TO_LOCATION_ID
829: FROM