DBA Data[Home] [Help]

APPS.WMS_TASK_SKIPPED dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 80: FROM mtl_material_transactions_temp mmtt

76: INTO l_inventory_item_id, l_created_by
77: FROM wms_dispatched_tasks w ,
78: (SELECT mmtt.transaction_temp_id task_id, mmtt.wms_task_type wms_task_type_id,
79: mmtt.inventory_item_id
80: FROM mtl_material_transactions_temp mmtt
81: WHERE mmtt.transaction_temp_id = l_task_id
82: AND mmtt.wms_task_type IS NOT NULL AND mmtt.transaction_status = 2
83: UNION ALL
84: SELECT mcce.cycle_count_entry_id task_id, 3 wms_task_type_id,mcce.inventory_item_id