APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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 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