DBA Data[Home] [Help]

APPS.WMS_TASK_SKIPPED dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 93: FROM mtl_cycle_count_entries mcce

89: WHERE mmtt.transaction_temp_id = l_task_id
90: AND mmtt.wms_task_type IS NOT NULL AND mmtt.transaction_status = 2
91: UNION ALL
92: SELECT mcce.cycle_count_entry_id task_id, 3 wms_task_type_id,mcce.inventory_item_id
93: FROM mtl_cycle_count_entries mcce
94: WHERE mcce.cycle_count_entry_id=l_task_id
95: AND entry_status_code IN (1,3) AND NVL(export_flag, 2) = 2 ) t
96: WHERE t.task_id = l_task_id
97: AND t.wms_task_type_id = p_wms_task_type