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 5328: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;

5324: AND transaction_temp_id = p_transaction_number;
5325: --added for completed tasks under bug 6854145
5326: --start changes 6854145
5327: l_mmt_rec mtl_material_transactions%ROWTYPE;
5328: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;
5329: CURSOR c_cd_task1 (p_transaction_number IN NUMBER) IS
5330: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl
5331: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5332: AND mtrl.line_id = wdth.move_order_line_id

Line 5330: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl

5326: --start changes 6854145
5327: l_mmt_rec mtl_material_transactions%ROWTYPE;
5328: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;
5329: CURSOR c_cd_task1 (p_transaction_number IN NUMBER) IS
5330: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl
5331: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5332: AND mtrl.line_id = wdth.move_order_line_id
5333: AND transaction_id = p_transaction_number;
5334: --end changes 6854145

Line 5801: FROM wms_dispatched_tasks_history

5797: BEGIN
5798: inv_trx_util_pub.trace('checking in wdth for completed inbound or crossdock tasks');
5799: SELECT *
5800: INTO l_wdth_rec
5801: FROM wms_dispatched_tasks_history
5802: WHERE transaction_id = p_transaction_number;
5803:
5804: IF(l_debug = 1) THEN
5805: l_err_msg := 'Calling API wms_waveplan_tasks_pvt.query_tasks for task: '||p_transaction_number;