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_DISPATCH_GEN dependencies on WMS_SKIP_TASK_EXCEPTIONS

Line 893: DELETE FROM wms_skip_task_exceptions

889: END IF;
890: END LOOP;
891:
892: --********************
893: DELETE FROM wms_skip_task_exceptions
894: WHERE task_id = task_rec.task_id
895: AND task_id IN(
896: SELECT wste.task_id
897: FROM wms_skip_task_exceptions wste, mtl_parameters mp

Line 897: FROM wms_skip_task_exceptions wste, mtl_parameters mp

893: DELETE FROM wms_skip_task_exceptions
894: WHERE task_id = task_rec.task_id
895: AND task_id IN(
896: SELECT wste.task_id
897: FROM wms_skip_task_exceptions wste, mtl_parameters mp
898: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
899: AND wste.task_id = task_rec.task_id
900: AND wste.organization_id = mp.organization_id);
901:

Line 1448: DELETE FROM wms_skip_task_exceptions

1444: END IF;
1445: END LOOP;
1446:
1447: --********************
1448: DELETE FROM wms_skip_task_exceptions
1449: WHERE task_id = task_rec.task_id
1450: AND task_id IN(
1451: SELECT wste.task_id
1452: FROM wms_skip_task_exceptions wste, mtl_parameters mp

Line 1452: FROM wms_skip_task_exceptions wste, mtl_parameters mp

1448: DELETE FROM wms_skip_task_exceptions
1449: WHERE task_id = task_rec.task_id
1450: AND task_id IN(
1451: SELECT wste.task_id
1452: FROM wms_skip_task_exceptions wste, mtl_parameters mp
1453: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
1454: AND wste.task_id = task_rec.task_id
1455: AND wste.organization_id = mp.organization_id);
1456: