APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 272: MTL_MATERIAL_TRANSACTIONS_TEMP

268: SELECT
269: SUM(ABS(TRANSACTION_QUANTITY))
270: INTO LOT_QTY
271: FROM
272: MTL_MATERIAL_TRANSACTIONS_TEMP
273: WHERE TRANSACTION_TEMP_ID = LOT_TXN_ID
274: AND ( REVISION IS NOT NULL
275: OR LOCATOR_ID IS NOT NULL )
276: GROUP BY

Line 401: MTL_MATERIAL_TRANSACTIONS_TEMP

397: SELECT
398: REVISION
399: INTO REVISION
400: FROM
401: MTL_MATERIAL_TRANSACTIONS_TEMP
402: WHERE TRANSACTION_TEMP_ID = TRANSACTION_ID1;
403: EXCEPTION
404: WHEN NO_DATA_FOUND THEN
405: BEGIN

Line 410: MTL_MATERIAL_TRANSACTIONS

406: SELECT
407: REVISION
408: INTO REVISION
409: FROM
410: MTL_MATERIAL_TRANSACTIONS
411: WHERE TRANSACTION_ID = TRANSACTION_ID1;
412: EXCEPTION
413: WHEN NO_DATA_FOUND THEN
414: REVISION := ' ';

Line 586: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

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
590: AND MMTT.PICK_SLIP_NUMBER IS NOT NULL

Line 624: MTL_MATERIAL_TRANSACTIONS MMT,

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
628: AND MMT.PICK_SLIP_NUMBER IS NOT NULL