DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 7535: l_from_cc := l_from_cc || ', mtl_cycle_count_entries mcce ';

7531: -- Build the generic from section of the query
7532: l_from_cc := ' FROM ';
7533: l_from_cc := l_from_cc || ' mtl_system_items_kfv msiv ';
7534: l_from_cc := l_from_cc || ', mtl_item_locations_kfv milv ';
7535: l_from_cc := l_from_cc || ', mtl_cycle_count_entries mcce ';
7536:
7537: /*Bug 3856227 -Added the table mtl_cycle_count_headers in the from clause
7538: if the task is of status pending, queued, dispatched, active
7539: or if the cycle count name is not null.*/

Line 10702: FROM mtl_cycle_count_entries mcce,

10698: l_non_cycle_count_number := l_non_cycle_count_number + 1;
10699: ELSE
10700: SELECT mcce.cycle_count_entry_id
10701: INTO l_transaction_temp_id_table (i)
10702: FROM mtl_cycle_count_entries mcce,
10703: wms_dispatched_tasks wdt
10704: WHERE mcce.cycle_count_entry_id =
10705: rec_wwtt.transaction_temp_id
10706: AND mcce.cycle_count_entry_id = wdt.transaction_temp_id(+)

Line 10816: UPDATE mtl_cycle_count_entries

10812: END IF;
10813:
10814: IF l_cycle_count_number > 0 THEN
10815: FORALL i IN l_transaction_temp_id_table.FIRST .. l_transaction_temp_id_table.LAST
10816: UPDATE mtl_cycle_count_entries
10817: SET task_priority = l_task_priority_table (i),
10818: last_update_date = SYSDATE,
10819: last_updated_by = p_user_id,
10820: last_update_login = p_login_id,