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

Line 5239: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;

5235: AND transaction_temp_id = p_transaction_number;
5236: --added for completed tasks under bug 6854145
5237: --start changes 6854145
5238: l_mmt_rec mtl_material_transactions%ROWTYPE;
5239: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;
5240: CURSOR c_cd_task1 (p_transaction_number IN NUMBER) IS
5241: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl
5242: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5243: AND mtrl.line_id = wdth.move_order_line_id

Line 5241: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl

5237: --start changes 6854145
5238: l_mmt_rec mtl_material_transactions%ROWTYPE;
5239: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;
5240: CURSOR c_cd_task1 (p_transaction_number IN NUMBER) IS
5241: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl
5242: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5243: AND mtrl.line_id = wdth.move_order_line_id
5244: AND transaction_id = p_transaction_number;
5245: --end changes 6854145

Line 5709: FROM wms_dispatched_tasks_history

5705: BEGIN
5706: inv_trx_util_pub.trace('checking in wdth for completed inbound or crossdock tasks');
5707: SELECT *
5708: INTO l_wdth_rec
5709: FROM wms_dispatched_tasks_history
5710: WHERE transaction_id = p_transaction_number;
5711:
5712: IF(l_debug = 1) THEN
5713: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;