APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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