APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 290: WSH_DELIVERY_DETAILS

286: SELECT
287: NVL(PICKED_QUANTITY,REQUESTED_QUANTITY)
288: INTO LOT_QTY
289: FROM
290: WSH_DELIVERY_DETAILS
291: WHERE DELIVERY_DETAIL_ID = DELIVERY_DETAIL_ID3;
292: END IF;
293: RETURN LOT_QTY;
294: END F_LOT_QUANTITYFORMULA;

Line 357: WSH_DELIVERY_DETAILS

353: SELECT
354: SUM(REQUESTED_QUANTITY)
355: INTO REQ_QTY
356: FROM
357: WSH_DELIVERY_DETAILS
358: WHERE SOURCE_HEADER_ID = SOURCE_HEADER_ID1
359: AND SOURCE_LINE_ID = SOURCE_LINE_ID1
360: AND MOVE_ORDER_LINE_ID = MOVE_ORDER_LINE_ID1
361: AND NVL(LINE_DIRECTION

Line 585: WSH_DELIVERY_DETAILS WDD,

581: FROM
582: WSH_TRIP_STOPS WTS,
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

Line 623: WSH_DELIVERY_DETAILS WDD,

619: FROM
620: WSH_TRIP_STOPS WTS,
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

Line 661: WSH_DELIVERY_DETAILS WDD,

657: FROM
658: WSH_TRIP_STOPS WTS,
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

Line 831: WSH_DELIVERY_DETAILS WDD,

827: WHERE LOC.WSH_LOCATION_ID = (
828: SELECT
829: WDD.SHIP_TO_LOCATION_ID
830: FROM
831: WSH_DELIVERY_DETAILS WDD,
832: WSH_PICK_SLIP_V WPSV
833: WHERE WPSV.PICK_SLIP_NUMBER = X_PS_NUM
834: AND WPSV.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID
835: AND ROWNUM = 1 );