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 3319: FROM wms_dispatched_tasks_history wdth

3315:
3316: SELECT transaction_id, task_type, loaded_time
3317: INTO l_last_dropoff_task_id, l_last_dropoff_task_type, l_last_dropoff_time
3318: FROM (SELECT transaction_id, task_type, loaded_time
3319: FROM wms_dispatched_tasks_history wdth
3320: WHERE wdth.person_id = p_sign_on_emp_id
3321: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3322: FROM wms_dispatched_tasks_history
3323: WHERE person_id = p_sign_on_emp_id))

Line 3322: FROM wms_dispatched_tasks_history

3318: FROM (SELECT transaction_id, task_type, loaded_time
3319: FROM wms_dispatched_tasks_history wdth
3320: WHERE wdth.person_id = p_sign_on_emp_id
3321: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
3322: FROM wms_dispatched_tasks_history
3323: WHERE person_id = p_sign_on_emp_id))
3324: WHERE ROWNUM = 1; -- make sure only one task selected
3325:
3326: l_progress := '33';

Line 6396: FROM wms_dispatched_tasks_history wdth

6392: , l_last_dropoff_time
6393: FROM (SELECT transaction_id
6394: , task_type
6395: , loaded_time
6396: FROM wms_dispatched_tasks_history wdth
6397: WHERE wdth.person_id = p_sign_on_emp_id
6398: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6399: FROM wms_dispatched_tasks_history
6400: WHERE person_id = p_sign_on_emp_id))

Line 6399: FROM wms_dispatched_tasks_history

6395: , loaded_time
6396: FROM wms_dispatched_tasks_history wdth
6397: WHERE wdth.person_id = p_sign_on_emp_id
6398: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
6399: FROM wms_dispatched_tasks_history
6400: WHERE person_id = p_sign_on_emp_id))
6401: WHERE ROWNUM = 1 -- make sure only one task selected
6402: ;
6403:

Line 9954: FROM wms_dispatched_tasks_history wdth

9950: , l_last_dropoff_time
9951: FROM (SELECT transaction_id
9952: , task_type
9953: , loaded_time
9954: FROM wms_dispatched_tasks_history wdth
9955: WHERE wdth.person_id = p_sign_on_emp_id
9956: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
9957: FROM wms_dispatched_tasks_history
9958: WHERE person_id = p_sign_on_emp_id))

Line 9957: FROM wms_dispatched_tasks_history

9953: , loaded_time
9954: FROM wms_dispatched_tasks_history wdth
9955: WHERE wdth.person_id = p_sign_on_emp_id
9956: AND wdth.drop_off_time = (SELECT MAX(drop_off_time)
9957: FROM wms_dispatched_tasks_history
9958: WHERE person_id = p_sign_on_emp_id))
9959: WHERE ROWNUM = 1; -- make sure only one task selected
9960:
9961: l_progress := '33';