DBA Data[Home] [Help]

APPS.WMS_EXPRESS_PICK_TASK dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 327: FROM MTL_TRANSACTION_LOTS_TEMP MTLT

323: BEGIN
324:
325: SELECT 1
326: INTO L_DUMMY
327: FROM MTL_TRANSACTION_LOTS_TEMP MTLT
328: WHERE MTLT.TRANSACTION_TEMP_ID = P_TRANSACTION_TEMP_ID;
329:
330: EXCEPTION
331: WHEN NO_DATA_FOUND THEN

Line 403: ,MTL_TRANSACTION_LOTS_TEMP MTLT

399:
400:
401: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
402: ,MTL_SYSTEM_ITEMS_B MSI
403: ,MTL_TRANSACTION_LOTS_TEMP MTLT
404: WHERE MMTT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
405: AND MMTT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
406: AND MMTT.TRANSACTION_TEMP_ID = P_TRANSACTION_TEMP_ID
407: AND MMTT.TRANSACTION_TEMP_ID = MTLT.transaction_temp_id(+);