APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 289: WSH_DELIVERY_DETAILS

285: SELECT
286: REQUESTED_QUANTITY
287: INTO LOT_QTY
288: FROM
289: WSH_DELIVERY_DETAILS
290: WHERE DELIVERY_DETAIL_ID = DELIVERY_DETAIL_ID3;
291: END IF;
292: RETURN LOT_QTY;
293: END F_LOT_QUANTITYFORMULA;

Line 356: WSH_DELIVERY_DETAILS

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

Line 584: WSH_DELIVERY_DETAILS WDD,

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
587: WHERE MMTT.PICK_SLIP_NUMBER = X_PS_NUMBER
588: AND MMTT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID

Line 622: WSH_DELIVERY_DETAILS WDD,

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
625: WHERE MMT.PICK_SLIP_NUMBER = X_PS_NUMBER
626: AND MMT.MOVE_ORDER_LINE_ID = WDD.MOVE_ORDER_LINE_ID

Line 660: WSH_DELIVERY_DETAILS WDD,

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
663: WHERE MTRL.PICK_SLIP_NUMBER = X_PS_NUMBER
664: AND MTRL.LINE_ID = WDD.MOVE_ORDER_LINE_ID

Line 830: WSH_DELIVERY_DETAILS WDD,

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