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

Line 614: FROM WMS_DISPATCHED_TASKS wdt1

610: assigned is logged on to the system. If the user is logged on, updating the same is not allowed. */
611: BEGIN
612: SELECT COUNT(*)
613: INTO l_count
614: FROM WMS_DISPATCHED_TASKS wdt1
615: WHERE wdt1.status = 9
616: AND wdt1.TRANSACTION_TEMP_ID =p_task_rec.TRANSACTION_NUMBER
617: AND EXISTS
618: (SELECT 1

Line 620: WMS_DISPATCHED_TASKS wdt

616: AND wdt1.TRANSACTION_TEMP_ID =p_task_rec.TRANSACTION_NUMBER
617: AND EXISTS
618: (SELECT 1
619: FROM MTL_MOBILE_LOGIN_HIST MMLH,
620: WMS_DISPATCHED_TASKS wdt
621: WHERE wdt1.TRANSACTION_TEMP_ID = wdt.TRANSACTION_TEMP_ID
622: AND MMLH.USER_ID = wdt1.LAST_UPDATED_BY
623: AND MMLH.LOGOFF_DATE IS NULL
624: AND MMLH.EVENT_MESSAGE IS NULL

Line 657: WMS_DISPATCHED_TASKS wdt

653: BEGIN
654: SELECT COUNT(*)
655: INTO l_count
656: FROM mtl_material_transactions_temp mmtt,
657: WMS_DISPATCHED_TASKS wdt
658: WHERE mmtt.transaction_temp_id = wdt.transaction_temp_id
659: AND wdt.transaction_temp_id =p_task_rec.TRANSACTION_NUMBER
660: AND wdt.status = 3
661: AND EXISTS

Line 663: FROM WMS_DISPATCHED_TASKS wdt2

659: AND wdt.transaction_temp_id =p_task_rec.TRANSACTION_NUMBER
660: AND wdt.status = 3
661: AND EXISTS
662: (SELECT 1
663: FROM WMS_DISPATCHED_TASKS wdt2
664: WHERE wdt2.person_id = p_task_rec.PERSON_ID
665: AND wdt2.status = 9
666: AND wdt2.task_method IS NOT NULL
667: AND wdt2.transaction_temp_id IN

Line 1107: FROM Wms_Dispatched_Tasks wdt

1103: --Need to check status in WDT .
1104: BEGIN
1105: SELECT wdt.status
1106: INTO l_wdt_status
1107: FROM Wms_Dispatched_Tasks wdt
1108: WHERE wdt.transaction_temp_id = p_transaction_number ;
1109: EXCEPTION
1110: WHEN NO_DATA_FOUND THEN
1111: --No WDT, so task must bein status pending/unreleased.

Line 1119: FROM Wms_Dispatched_Tasks wdt

1115: END;
1116: IF (l_wdt_status = 0 AND l_task_type= 2 ) THEN --Only for putaway tasks.
1117: SELECT MAX(wdt.status )
1118: INTO l_wdt_status
1119: FROM Wms_Dispatched_Tasks wdt
1120: WHERE wdt.transaction_temp_id in
1121: (SELECT transaction_temp_id --To check the child tasks
1122: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
1123: WHERE mmtt.parent_line_id = p_transaction_number

Line 2393: This procedure is called to accordingly split the task record contained in wms_dispatched_tasks table

2389: END split_lot_serial;
2390:
2391: -------------------------------------------------------------------------------------------------------------------
2392: /*PROCEDURE split_wdt()
2393: This procedure is called to accordingly split the task record contained in wms_dispatched_tasks table
2394: */
2395: -------------------------------------------------------------------------------------------------------------------
2396: PROCEDURE split_wdt( p_new_task_id IN NUMBER ,
2397: p_new_transaction_temp_id IN NUMBER ,

Line 2412: INTO wms_dispatched_tasks

2408: IF g_debug = 1 THEN
2409: print_msg(l_proceudre_name, ' Entered ');
2410: END IF;
2411: INSERT
2412: INTO wms_dispatched_tasks
2413: (
2414: op_plan_instance_id ,
2415: task_method ,
2416: task_id ,

Line 2517: FROM wms_dispatched_tasks

2513: suggested_dest_locator_id ,
2514: operation_plan_id ,
2515: p_new_mol_id ,
2516: transfer_lpn_id
2517: FROM wms_dispatched_tasks
2518: WHERE transaction_temp_id = p_orig_transaction_temp_id;
2519: x_return_status := 'S';
2520: EXCEPTION
2521: WHEN OTHERS THEN

Line 3261: Unmarks the serials, checks if a task record exists in wms_dispatched_tasks and deletes it.

3257:
3258: -------------------------------------------------------------------------------------------------------------------
3259: /*PROCEDURE delete_transaction()
3260: This procedure checks for lot/serial control-deletes MTLT, MSNT,
3261: Unmarks the serials, checks if a task record exists in wms_dispatched_tasks and deletes it.
3262: */
3263: -------------------------------------------------------------------------------------------------------------------
3264: PROCEDURE delete_transaction( x_return_status OUT NOCOPY VARCHAR2 ,
3265: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 3439: FROM wms_dispatched_tasks

3435: END IF;
3436: END IF;
3437: SELECT count (*)
3438: INTO l_wdt_count
3439: FROM wms_dispatched_tasks
3440: WHERE transaction_temp_id = p_transaction_temp_id;
3441: IF l_wdt_count >0 THEN
3442: -- Deleting the Task
3443: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_transaction_temp_id;

Line 3443: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_transaction_temp_id;

3439: FROM wms_dispatched_tasks
3440: WHERE transaction_temp_id = p_transaction_temp_id;
3441: IF l_wdt_count >0 THEN
3442: -- Deleting the Task
3443: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_transaction_temp_id;
3444: IF l_debug = 1 THEN
3445: debug_print( 'Records deleted in WDT = ' || SQL%ROWCOUNT);
3446: END IF;
3447: IF SQL%ROWCOUNT = 0 THEN

Line 3866: FROM wms_dispatched_tasks wdt,

3862: SELECT 'N'
3863: FROM DUAL
3864: WHERE EXISTS
3865: (SELECT 1
3866: FROM wms_dispatched_tasks wdt,
3867: mtl_material_transactions_temp mmtt
3868: WHERE mmtt.move_order_line_id = l_mo_line_rec.line_id
3869: AND wdt.transaction_temp_id = nvl(mmtt.parent_line_id, mmtt.transaction_temp_id)
3870: AND wdt.status IN (4,9)

Line 4351: FROM wms_dispatched_tasks

4347: END IF;
4348: l_progress := '155';
4349: SELECT count(*)
4350: INTO l_wdt_count
4351: FROM wms_dispatched_tasks
4352: WHERE transaction_temp_id = l_transaction_number;
4353: IF l_wdt_count > 0 THEN
4354: DELETE
4355: FROM wms_dispatched_tasks

Line 4355: FROM wms_dispatched_tasks

4351: FROM wms_dispatched_tasks
4352: WHERE transaction_temp_id = l_transaction_number;
4353: IF l_wdt_count > 0 THEN
4354: DELETE
4355: FROM wms_dispatched_tasks
4356: WHERE transaction_temp_id = l_transaction_number;
4357: IF SQL%ROWCOUNT = 0 THEN
4358: IF l_debug = 1 THEN
4359: debug_print ( 'delete_so: l_progress: ' || l_progress );

Line 5015: FROM wms_dispatched_tasks

5011: RAISE exc_not_deleted ;
5012: END IF;
5013: SELECT count(task_id)
5014: INTO l_cyc_task
5015: FROM wms_dispatched_tasks
5016: WHERE transaction_temp_id = l_cc_entry_id
5017: AND task_type = 3;
5018: IF l_cyc_task <> 0 THEN
5019: DELETE

Line 5020: FROM wms_dispatched_tasks

5016: WHERE transaction_temp_id = l_cc_entry_id
5017: AND task_type = 3;
5018: IF l_cyc_task <> 0 THEN
5019: DELETE
5020: FROM wms_dispatched_tasks
5021: WHERE transaction_temp_id = l_cc_entry_id
5022: AND task_type = 3;
5023: IF SQL%ROWCOUNT =0 THEN
5024: IF l_debug =1 THEN

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;

Line 6859: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

6855: FROM dual;
6856: SELECT mtl_material_transactions_s.NEXTVAL
6857: INTO l_new_transaction_temp_id
6858: FROM dual;
6859: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6860: IF g_debug = 1 THEN
6861: print_msg(l_procedure_name, ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number);
6862: END IF;
6863: split_mmtt( p_orig_transaction_temp_id => p_source_transaction_number ,

Line 6886: FROM wms_dispatched_tasks

6882: END IF;
6883: BEGIN
6884: SELECT status
6885: INTO l_mmtt_task_status
6886: FROM wms_dispatched_tasks
6887: WHERE transaction_temp_id = p_source_transaction_number;
6888: EXCEPTION
6889: WHEN NO_DATA_FOUND THEN
6890: l_mmtt_task_status := -9999;

Line 7678: INTO wms_dispatched_tasks

7674: --Do BULK INSERT,UPDATE
7675: IF (l_transaction_num_table.COUNT > 0) THEN
7676: FORALL i in 1..l_transaction_num_table.COUNT
7677: INSERT
7678: INTO wms_dispatched_tasks
7679: (
7680: task_id ,
7681: transaction_temp_id ,
7682: organization_id ,

Line 7703: wms_dispatched_tasks_s.NEXTVAL ,

7699: transfer_lpn_id
7700: )
7701: VALUES
7702: (
7703: wms_dispatched_tasks_s.NEXTVAL ,
7704: l_transaction_num_table(i) ,
7705: l_organization_id_table(i) ,
7706: l_usertask_type_id_table(i) ,
7707: p_person_id ,

Line 7746: UPDATE wms_dispatched_tasks

7742: END IF;
7743:
7744: IF (l_wdt_transaction_num_table.COUNT > 0) THEN
7745: FORALL i in 1..l_wdt_transaction_num_table.COUNT
7746: UPDATE wms_dispatched_tasks
7747: SET status = l_wdt_status_id_table(i) ,
7748: operation_plan_id = l_wdt_operation_plan_id_table(i),
7749: priority = l_wdt_priority_table(i) ,
7750: user_task_type = l_wdt_usertask_type_id_table(i)

Line 7756: DELETE from wms_dispatched_tasks

7752: END IF;
7753:
7754: IF (l_wdt_del_trns_num_table.COUNT > 0) THEN
7755: FORALL i in 1..l_wdt_del_trns_num_table.COUNT
7756: DELETE from wms_dispatched_tasks
7757: WHERE transaction_temp_id = l_wdt_del_trns_num_table(i);
7758: END IF;
7759:
7760: IF (p_commit = FND_API.G_TRUE) THEN