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_EXPRESS_PICK_TASK dependencies on WMS_DISPATCHED_TASKS

Line 131: FROM WMS_DISPATCHED_TASKS

127: BEGIN
128:
129: SELECT 1
130: INTO L_DUMMY
131: FROM WMS_DISPATCHED_TASKS
132: WHERE PERSON_ID = P_USER_ID
133: AND ORGANIZATION_ID = P_ORG_ID
134: AND TASK_TYPE IN (1, 3, 4)
135: AND STATUS <= 3

Line 179: FROM WMS_DISPATCHED_TASKS WDT

175: BEGIN
176:
177: SELECT IS_EXPRESS_PICK_TASK_ELIGIBLE(WDT.TRANSACTION_TEMP_ID)
178: INTO X_RETURN_STATUS
179: FROM WMS_DISPATCHED_TASKS WDT
180: WHERE WDT.TASK_ID = P_TASK_ID;
181:
182: RETURN X_RETURN_STATUS;
183:

Line 692: UPDATE wms_dispatched_tasks

688: mydebug('Updated MTTT row count: ' || SQL%ROWCOUNT);
689: END IF;
690:
691: --Set the task status to Loaded
692: UPDATE wms_dispatched_tasks
693: SET status = 4,
694: loaded_time = SYSDATE,
695: last_update_date = SYSDATE,
696: last_updated_by = p_user_id