APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_LOCATIONS

Line 558: WSH_LOCATIONS LOC

554: ,', ') || LOC.COUNTRY
555: FROM
556: WSH_TRIP_STOPS WTS,
557: WSH_DELIVERY_LEGS WDL,
558: WSH_LOCATIONS LOC
559: WHERE WDL.DELIVERY_ID = P_DELIVERY_ID
560: AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
561: AND WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID;
562: CURSOR TRIP_STOP_FROM_PS(X_PS_NUMBER IN NUMBER) IS

Line 587: WSH_LOCATIONS LOC

583: WSH_DELIVERY_LEGS WDL,
584: WSH_DELIVERY_ASSIGNMENTS_V WDA,
585: WSH_DELIVERY_DETAILS WDD,
586: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
587: WSH_LOCATIONS LOC
588: WHERE MMTT.PICK_SLIP_NUMBER = X_PS_NUMBER
589: AND MMTT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
590: AND MMTT.PICK_SLIP_NUMBER IS NOT NULL
591: AND ABS(NVL(MMTT.TRANSACTION_QUANTITY

Line 625: WSH_LOCATIONS LOC

621: WSH_DELIVERY_LEGS WDL,
622: WSH_DELIVERY_ASSIGNMENTS_V WDA,
623: WSH_DELIVERY_DETAILS WDD,
624: MTL_MATERIAL_TRANSACTIONS MMT,
625: WSH_LOCATIONS LOC
626: WHERE MMT.PICK_SLIP_NUMBER = X_PS_NUMBER
627: AND MMT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
628: AND MMT.PICK_SLIP_NUMBER IS NOT NULL
629: AND NVL(MMT.TRANSACTION_QUANTITY

Line 663: WSH_LOCATIONS LOC

659: WSH_DELIVERY_LEGS WDL,
660: WSH_DELIVERY_ASSIGNMENTS_V WDA,
661: WSH_DELIVERY_DETAILS WDD,
662: MTL_TXN_REQUEST_LINES MTRL,
663: WSH_LOCATIONS LOC
664: WHERE MTRL.PICK_SLIP_NUMBER = X_PS_NUMBER
665: AND MTRL.LINE_ID = WDD.MOVE_ORDER_LINE_ID
666: AND MTRL.PICK_SLIP_NUMBER IS NOT NULL
667: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID

Line 826: WSH_LOCATIONS LOC

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