eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_LOAD dependencies on WMS_DISPATCHED_TASKS

Line 1697: INSERT INTO wms_dispatched_tasks

1693: mydebug ('p_merge_temp_id = ' || p_merge_temp_id);
1694: mydebug ('p_task_status = ' || p_task_status);
1695:
1696: IF p_insert = 'Y' THEN
1697: INSERT INTO wms_dispatched_tasks
1698: (task_id
1699: ,transaction_temp_id
1700: ,organization_id
1701: ,user_task_type

Line 1745: (SELECT wms_dispatched_tasks_s.NEXTVAL

1741: ,suggested_dest_locator_id
1742: ,operation_plan_id
1743: ,move_order_line_id
1744: ,transfer_lpn_id )
1745: (SELECT wms_dispatched_tasks_s.NEXTVAL
1746: ,p_new_temp_id -- parameter
1747: ,organization_id
1748: ,user_task_type
1749: ,person_id

Line 1792: FROM wms_dispatched_tasks

1788: ,suggested_dest_locator_id
1789: ,operation_plan_id
1790: ,move_order_line_id
1791: ,transfer_lpn_id
1792: FROM wms_dispatched_tasks
1793: WHERE transaction_temp_id = p_temp_id);
1794: IF SQL%NOTFOUND THEN
1795: myDebug('Error inserting a new task using WDT record for : '|| p_temp_id);
1796: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG

Line 1813: UPDATE wms_dispatched_tasks

1809: END IF;
1810: l_progress := '250';
1811: mydebug('l_progress: ' || l_progress );
1812: mydebug('l_transaction_temp_id : ' || l_transaction_temp_id);
1813: UPDATE wms_dispatched_tasks
1814: SET status = p_task_status
1815: ,loaded_time = SYSDATE
1816: ,last_update_date = SYSDATE
1817: ,last_updated_by = p_user_id

Line 1834: DELETE wms_dispatched_tasks

1830: fnd_msg_pub.ADD;
1831: l_progress := '300';
1832: mydebug('l_progress: ' || l_progress );
1833: -- delete the original one with p_transaction_temp_id
1834: DELETE wms_dispatched_tasks
1835: WHERE transaction_temp_id = p_temp_id;
1836: IF SQL%NOTFOUND THEN
1837: myDebug('Error deleting task for : '|| l_transaction_temp_id);
1838: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG

Line 6301: UPDATE wms_dispatched_tasks

6297: --only when it is not start over case, the retain task will be used 431009
6298: wms_picking_pkg.g_start_over_tempid.DELETE;
6299: IF p_retain_task = 'Y' THEN --{ bug 4310093
6300: mydebug('change the task status to Dispatched if retain_task is Y');
6301: UPDATE wms_dispatched_tasks
6302: SET status = l_g_task_dispatched
6303: ,last_update_date = SYSDATE
6304: ,last_updated_by = p_user_id
6305: WHERE transaction_temp_id IN

Line 6309: UPDATE wms_dispatched_tasks

6305: WHERE transaction_temp_id IN
6306: (SELECT transaction_temp_id
6307: FROM mtl_allocations_gtmp);
6308: mydebug('nullify certain columns for all the dispatched tasks for this user');
6309: UPDATE wms_dispatched_tasks
6310: SET device_invoked = null
6311: -- Following two statement are commnet for bug 4560814
6312: --task_method = NULL -- for cluster picking
6313: -- ,task_group_id = NULL

Line 6333: DELETE wms_dispatched_tasks

6329:
6330: -- this global temp table has a list of transaction_temp_ids of MMTTs that
6331: -- are confirmed to stay back in MMTT and WDT. Using this we will delete WDT and MMTT
6332:
6333: DELETE wms_dispatched_tasks
6334: WHERE transaction_temp_id IN
6335: (SELECT transaction_temp_id
6336: FROM mtl_material_transactions_temp
6337: WHERE transaction_header_id = p_transaction_header_id

Line 6357: DELETE wms_dispatched_tasks

6353: */
6354:
6355: IF p_start_over ='N' and p_retain_task='N' THEN --bug 4310093
6356:
6357: DELETE wms_dispatched_tasks
6358: WHERE transaction_temp_id IN
6359: (SELECT transaction_temp_id
6360: FROM mtl_allocations_gtmp)
6361: AND status <> l_g_task_queued;

Line 6458: FROM wms_dispatched_tasks

6454: -- select all tasks that belong to this employee
6455: CURSOR cur_wdt_for_emp IS
6456: SELECT transaction_temp_id
6457: , device_request_id
6458: FROM wms_dispatched_tasks
6459: WHERE person_id = p_employee_id
6460: AND ( status <= l_g_task_dispatched OR
6461: status = l_g_task_active) -- (<=3, OR 9 ) ;
6462: AND device_request_id IS NOT NULL;

Line 6468: FROM wms_dispatched_tasks

6464: -- select task that belong to this employee and p_transaction_temp_id
6465: CURSOR cur_wdt_for_temp_id IS
6466: SELECT transaction_temp_id
6467: , device_request_id
6468: FROM wms_dispatched_tasks
6469: WHERE person_id = p_employee_id
6470: AND transaction_temp_id = p_transaction_temp_id
6471: AND device_request_id IS NOT NULL;
6472:

Line 6599: FROM wms_dispatched_tasks wdt

6595: AND NOT EXISTS(SELECT 1
6596: FROM mtl_material_transactions_temp t1
6597: WHERE t1.parent_line_id = mmtt.transaction_temp_id)
6598: AND NOT EXISTS(SELECT 1
6599: FROM wms_dispatched_tasks wdt
6600: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id);
6601:
6602: BEGIN
6603: mydebug ('IN : ' || l_proc_name);

Line 6884: FROM wms_dispatched_tasks

6880:
6881: CURSOR cur_reset_task_status IS
6882: SELECT transaction_temp_id
6883: ,task_id
6884: FROM wms_dispatched_tasks
6885: WHERE person_id = p_employee_id
6886: AND ( status = l_g_task_dispatched OR
6887: status = l_g_task_active); -- IN (3,9 ) ;
6888: BEGIN

Line 6900: DELETE wms_dispatched_tasks

6896: mydebug('l_progress = ' || l_progress);
6897:
6898: IF p_action = 'CMS' THEN
6899:
6900: DELETE wms_dispatched_tasks
6901: WHERE transaction_temp_id IN
6902: (SELECT transaction_temp_id
6903: FROM mtl_material_transactions_temp
6904: WHERE transaction_header_id = p_transaction_header_id);

Line 6935: UPDATE wms_dispatched_tasks

6931: mydebug('l_prev_task_status = ' || l_prev_task_status || ' for p_transaction_temp_id: '
6932: || p_transaction_temp_id);
6933: /* this update is seperate because for a pick nmore case, there can be multiple temp_ids (MMTTs)
6934: for the given header id ...current task) */
6935: UPDATE wms_dispatched_tasks
6936: SET status = l_prev_task_status
6937: ,last_update_date = SYSDATE
6938: ,last_updated_by = p_user_id
6939: WHERE person_id = p_employee_id

Line 6965: UPDATE wms_dispatched_tasks

6961: l_prev_task_status := l_g_task_pending;
6962: END ;
6963: mydebug('l_prev_task_status = ' || l_prev_task_status || ' for transaction_temp_id: '
6964: || rec_reset_task_status.transaction_temp_id);
6965: UPDATE wms_dispatched_tasks
6966: SET status = l_prev_task_status
6967: ,last_update_date = SYSDATE
6968: ,last_updated_by = p_user_id
6969: WHERE task_id = rec_reset_task_status.task_id;

Line 6980: DELETE wms_dispatched_tasks

6976:
6977: l_progress := 200;
6978: mydebug('l_progress = ' || l_progress);
6979:
6980: DELETE wms_dispatched_tasks
6981: WHERE person_id = p_employee_id
6982: AND (status = l_g_task_pending OR
6983: status = l_g_task_dispatched OR
6984: status = l_g_task_active) ; -- IN (3,9 ) ;

Line 6995: UPDATE wms_dispatched_tasks

6991: END IF;
6992:
6993: l_progress := 300;
6994: mydebug('l_progress = ' || l_progress);
6995: UPDATE wms_dispatched_tasks
6996: SET task_method = NULL -- for cluster picking
6997: WHERE person_id = p_employee_id
6998: AND status = l_g_task_queued;
6999:

Line 7138: UPDATE wms_dispatched_tasks

7134:
7135: -- Updating wdd status and printing final values sent in pl/sql table
7136:
7137: forall L in wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
7138: UPDATE wms_dispatched_tasks
7139: SET status = l_g_task_dispatched
7140: ,last_update_date = SYSDATE
7141: ,last_updated_by = p_user_id
7142: WHERE transaction_temp_id = wms_picking_pkg.g_start_over_tempid(L);