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 1557: INSERT INTO wms_dispatched_tasks

1553: mydebug ('p_merge_temp_id = ' || p_merge_temp_id);
1554: mydebug ('p_task_status = ' || p_task_status);
1555:
1556: IF p_insert = 'Y' THEN
1557: INSERT INTO wms_dispatched_tasks
1558: (task_id
1559: ,transaction_temp_id
1560: ,organization_id
1561: ,user_task_type

Line 1605: (SELECT wms_dispatched_tasks_s.NEXTVAL

1601: ,suggested_dest_locator_id
1602: ,operation_plan_id
1603: ,move_order_line_id
1604: ,transfer_lpn_id )
1605: (SELECT wms_dispatched_tasks_s.NEXTVAL
1606: ,p_new_temp_id -- parameter
1607: ,organization_id
1608: ,user_task_type
1609: ,person_id

Line 1652: FROM wms_dispatched_tasks

1648: ,suggested_dest_locator_id
1649: ,operation_plan_id
1650: ,move_order_line_id
1651: ,transfer_lpn_id
1652: FROM wms_dispatched_tasks
1653: WHERE transaction_temp_id = p_temp_id);
1654: IF SQL%NOTFOUND THEN
1655: myDebug('Error inserting a new task using WDT record for : '|| p_temp_id);
1656: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG

Line 1673: UPDATE wms_dispatched_tasks

1669: END IF;
1670: l_progress := '250';
1671: mydebug('l_progress: ' || l_progress );
1672: mydebug('l_transaction_temp_id : ' || l_transaction_temp_id);
1673: UPDATE wms_dispatched_tasks
1674: SET status = p_task_status
1675: ,loaded_time = SYSDATE
1676: ,last_update_date = SYSDATE
1677: ,last_updated_by = p_user_id

Line 1694: DELETE wms_dispatched_tasks

1690: fnd_msg_pub.ADD;
1691: l_progress := '300';
1692: mydebug('l_progress: ' || l_progress );
1693: -- delete the original one with p_transaction_temp_id
1694: DELETE wms_dispatched_tasks
1695: WHERE transaction_temp_id = p_temp_id;
1696: IF SQL%NOTFOUND THEN
1697: myDebug('Error deleting task for : '|| l_transaction_temp_id);
1698: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG

Line 5082: UPDATE wms_dispatched_tasks

5078: --only when it is not start over case, the retain task will be used 431009
5079: wms_picking_pkg.g_start_over_tempid.DELETE;
5080: IF p_retain_task = 'Y' THEN --{ bug 4310093
5081: mydebug('change the task status to Dispatched if retain_task is Y');
5082: UPDATE wms_dispatched_tasks
5083: SET status = l_g_task_dispatched
5084: ,last_update_date = SYSDATE
5085: ,last_updated_by = p_user_id
5086: WHERE transaction_temp_id IN

Line 5090: UPDATE wms_dispatched_tasks

5086: WHERE transaction_temp_id IN
5087: (SELECT transaction_temp_id
5088: FROM mtl_allocations_gtmp);
5089: mydebug('nullify certain columns for all the dispatched tasks for this user');
5090: UPDATE wms_dispatched_tasks
5091: SET device_invoked = null
5092: -- Following two statement are commnet for bug 4560814
5093: --task_method = NULL -- for cluster picking
5094: -- ,task_group_id = NULL

Line 5114: DELETE wms_dispatched_tasks

5110:
5111: -- this global temp table has a list of transaction_temp_ids of MMTTs that
5112: -- are confirmed to stay back in MMTT and WDT. Using this we will delete WDT and MMTT
5113:
5114: DELETE wms_dispatched_tasks
5115: WHERE transaction_temp_id IN
5116: (SELECT transaction_temp_id
5117: FROM mtl_material_transactions_temp
5118: WHERE transaction_header_id = p_transaction_header_id

Line 5138: DELETE wms_dispatched_tasks

5134: */
5135:
5136: IF p_start_over ='N' and p_retain_task='N' THEN --bug 4310093
5137:
5138: DELETE wms_dispatched_tasks
5139: WHERE transaction_temp_id IN
5140: (SELECT transaction_temp_id
5141: FROM mtl_allocations_gtmp)
5142: AND status <> l_g_task_queued;

Line 5221: FROM wms_dispatched_tasks

5217: -- select all tasks that belong to this employee
5218: CURSOR cur_wdt_for_emp IS
5219: SELECT transaction_temp_id
5220: , device_request_id
5221: FROM wms_dispatched_tasks
5222: WHERE person_id = p_employee_id
5223: AND ( status <= l_g_task_dispatched OR
5224: status = l_g_task_active) -- (<=3, OR 9 ) ;
5225: AND device_request_id IS NOT NULL;

Line 5231: FROM wms_dispatched_tasks

5227: -- select task that belong to this employee and p_transaction_temp_id
5228: CURSOR cur_wdt_for_temp_id IS
5229: SELECT transaction_temp_id
5230: , device_request_id
5231: FROM wms_dispatched_tasks
5232: WHERE person_id = p_employee_id
5233: AND transaction_temp_id = p_transaction_temp_id
5234: AND device_request_id IS NOT NULL;
5235:

Line 5362: FROM wms_dispatched_tasks wdt

5358: AND NOT EXISTS(SELECT 1
5359: FROM mtl_material_transactions_temp t1
5360: WHERE t1.parent_line_id = mmtt.transaction_temp_id)
5361: AND NOT EXISTS(SELECT 1
5362: FROM wms_dispatched_tasks wdt
5363: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id);
5364:
5365: BEGIN
5366: mydebug ('IN : ' || l_proc_name);

Line 5642: FROM wms_dispatched_tasks

5638:
5639: CURSOR cur_reset_task_status IS
5640: SELECT transaction_temp_id
5641: ,task_id
5642: FROM wms_dispatched_tasks
5643: WHERE person_id = p_employee_id
5644: AND ( status = l_g_task_dispatched OR
5645: status = l_g_task_active); -- IN (3,9 ) ;
5646: BEGIN

Line 5658: DELETE wms_dispatched_tasks

5654: mydebug('l_progress = ' || l_progress);
5655:
5656: IF p_action = 'CMS' THEN
5657:
5658: DELETE wms_dispatched_tasks
5659: WHERE transaction_temp_id IN
5660: (SELECT transaction_temp_id
5661: FROM mtl_material_transactions_temp
5662: WHERE transaction_header_id = p_transaction_header_id);

Line 5693: UPDATE wms_dispatched_tasks

5689: mydebug('l_prev_task_status = ' || l_prev_task_status || ' for p_transaction_temp_id: '
5690: || p_transaction_temp_id);
5691: /* this update is seperate because for a pick nmore case, there can be multiple temp_ids (MMTTs)
5692: for the given header id ...current task) */
5693: UPDATE wms_dispatched_tasks
5694: SET status = l_prev_task_status
5695: ,last_update_date = SYSDATE
5696: ,last_updated_by = p_user_id
5697: WHERE person_id = p_employee_id

Line 5723: UPDATE wms_dispatched_tasks

5719: l_prev_task_status := l_g_task_pending;
5720: END ;
5721: mydebug('l_prev_task_status = ' || l_prev_task_status || ' for transaction_temp_id: '
5722: || rec_reset_task_status.transaction_temp_id);
5723: UPDATE wms_dispatched_tasks
5724: SET status = l_prev_task_status
5725: ,last_update_date = SYSDATE
5726: ,last_updated_by = p_user_id
5727: WHERE task_id = rec_reset_task_status.task_id;

Line 5738: DELETE wms_dispatched_tasks

5734:
5735: l_progress := 200;
5736: mydebug('l_progress = ' || l_progress);
5737:
5738: DELETE wms_dispatched_tasks
5739: WHERE person_id = p_employee_id
5740: AND (status = l_g_task_pending OR
5741: status = l_g_task_dispatched OR
5742: status = l_g_task_active) ; -- IN (3,9 ) ;

Line 5753: UPDATE wms_dispatched_tasks

5749: END IF;
5750:
5751: l_progress := 300;
5752: mydebug('l_progress = ' || l_progress);
5753: UPDATE wms_dispatched_tasks
5754: SET task_method = NULL -- for cluster picking
5755: WHERE person_id = p_employee_id
5756: AND status = l_g_task_queued;
5757:

Line 5896: UPDATE wms_dispatched_tasks

5892:
5893: -- Updating wdd status and printing final values sent in pl/sql table
5894:
5895: forall L in wms_picking_pkg.g_start_over_tempid.FIRST .. wms_picking_pkg.g_start_over_tempid.LAST
5896: UPDATE wms_dispatched_tasks
5897: SET status = l_g_task_dispatched
5898: ,last_update_date = SYSDATE
5899: ,last_updated_by = p_user_id
5900: WHERE transaction_temp_id = wms_picking_pkg.g_start_over_tempid(L);