APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 271: MTL_MATERIAL_TRANSACTIONS_TEMP

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

Line 400: MTL_MATERIAL_TRANSACTIONS_TEMP

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

Line 409: MTL_MATERIAL_TRANSACTIONS

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

Line 585: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

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

Line 623: MTL_MATERIAL_TRANSACTIONS MMT,

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