DBA Data[Home] [Help]

APPS.WMS_TASK_SKIPPED dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 85: FROM mtl_cycle_count_entries mcce

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
85: FROM mtl_cycle_count_entries mcce
86: WHERE mcce.cycle_count_entry_id=l_task_id
87: AND entry_status_code IN (1,3) AND NVL(export_flag, 2) = 2 ) t
88: WHERE t.task_id = l_task_id
89: AND t.wms_task_type_id = p_wms_task_type