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_ENGINE dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 3512: FROM wms_dispatched_tasks_history wdth

3508:
3509: SELECT transaction_id, task_type, loaded_time
3510: INTO l_last_dropoff_task_id, l_last_dropoff_task_type, l_last_dropoff_time
3511: FROM (SELECT transaction_id, task_type, loaded_time
3512: FROM wms_dispatched_tasks_history wdth
3513: WHERE wdth.person_id = p_sign_on_emp_id
3514: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3515: FROM wms_dispatched_tasks_history
3516: WHERE person_id = p_sign_on_emp_id))

Line 3515: FROM wms_dispatched_tasks_history

3511: FROM (SELECT transaction_id, task_type, loaded_time
3512: FROM wms_dispatched_tasks_history wdth
3513: WHERE wdth.person_id = p_sign_on_emp_id
3514: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3515: FROM wms_dispatched_tasks_history
3516: WHERE person_id = p_sign_on_emp_id))
3517: WHERE ROWNUM = 1; -- make sure only one task selected
3518:
3519: l_progress := '33';

Line 6735: FROM wms_dispatched_tasks_history wdth

6731: , l_last_dropoff_time
6732: FROM (SELECT transaction_id
6733: , task_type
6734: , loaded_time
6735: FROM wms_dispatched_tasks_history wdth
6736: WHERE wdth.person_id = p_sign_on_emp_id
6737: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6738: FROM wms_dispatched_tasks_history
6739: WHERE person_id = p_sign_on_emp_id))

Line 6738: FROM wms_dispatched_tasks_history

6734: , loaded_time
6735: FROM wms_dispatched_tasks_history wdth
6736: WHERE wdth.person_id = p_sign_on_emp_id
6737: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6738: FROM wms_dispatched_tasks_history
6739: WHERE person_id = p_sign_on_emp_id))
6740: WHERE ROWNUM = 1 -- make sure only one task selected
6741: ;
6742:

Line 10293: FROM wms_dispatched_tasks_history wdth

10289: , l_last_dropoff_time
10290: FROM (SELECT transaction_id
10291: , task_type
10292: , loaded_time
10293: FROM wms_dispatched_tasks_history wdth
10294: WHERE wdth.person_id = p_sign_on_emp_id
10295: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
10296: FROM wms_dispatched_tasks_history
10297: WHERE person_id = p_sign_on_emp_id))

Line 10296: FROM wms_dispatched_tasks_history

10292: , loaded_time
10293: FROM wms_dispatched_tasks_history wdth
10294: WHERE wdth.person_id = p_sign_on_emp_id
10295: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
10296: FROM wms_dispatched_tasks_history
10297: WHERE person_id = p_sign_on_emp_id))
10298: WHERE ROWNUM = 1; -- make sure only one task selected
10299:
10300: l_progress := '33';