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 2307: This procedure is called to accordingly split the task record contained in wms_dispatched_tasks table

2303: END split_lot_serial;
2304:
2305: -------------------------------------------------------------------------------------------------------------------
2306: /*PROCEDURE split_wdt()
2307: This procedure is called to accordingly split the task record contained in wms_dispatched_tasks table
2308: */
2309: -------------------------------------------------------------------------------------------------------------------
2310: PROCEDURE split_wdt( p_new_task_id IN NUMBER ,
2311: p_new_transaction_temp_id IN NUMBER ,

Line 2326: INTO wms_dispatched_tasks

2322: IF g_debug = 1 THEN
2323: print_msg(l_proceudre_name, ' Entered ');
2324: END IF;
2325: INSERT
2326: INTO wms_dispatched_tasks
2327: (
2328: op_plan_instance_id ,
2329: task_method ,
2330: task_id ,

Line 2431: FROM wms_dispatched_tasks

2427: suggested_dest_locator_id ,
2428: operation_plan_id ,
2429: p_new_mol_id ,
2430: transfer_lpn_id
2431: FROM wms_dispatched_tasks
2432: WHERE transaction_temp_id = p_orig_transaction_temp_id;
2433: x_return_status := 'S';
2434: EXCEPTION
2435: WHEN OTHERS THEN

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

3168:
3169: -------------------------------------------------------------------------------------------------------------------
3170: /*PROCEDURE delete_transaction()
3171: This procedure checks for lot/serial control-deletes MTLT, MSNT,
3172: Unmarks the serials, checks if a task record exists in wms_dispatched_tasks and deletes it.
3173: */
3174: -------------------------------------------------------------------------------------------------------------------
3175: PROCEDURE delete_transaction( x_return_status OUT NOCOPY VARCHAR2 ,
3176: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 3350: FROM wms_dispatched_tasks

3346: END IF;
3347: END IF;
3348: SELECT count (*)
3349: INTO l_wdt_count
3350: FROM wms_dispatched_tasks
3351: WHERE transaction_temp_id = p_transaction_temp_id;
3352: IF l_wdt_count >0 THEN
3353: -- Deleting the Task
3354: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_transaction_temp_id;

Line 3354: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_transaction_temp_id;

3350: FROM wms_dispatched_tasks
3351: WHERE transaction_temp_id = p_transaction_temp_id;
3352: IF l_wdt_count >0 THEN
3353: -- Deleting the Task
3354: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_transaction_temp_id;
3355: IF l_debug = 1 THEN
3356: debug_print( 'Records deleted in WDT = ' || SQL%ROWCOUNT);
3357: END IF;
3358: IF SQL%ROWCOUNT = 0 THEN

Line 3777: FROM wms_dispatched_tasks wdt,

3773: SELECT 'N'
3774: FROM DUAL
3775: WHERE EXISTS
3776: (SELECT 1
3777: FROM wms_dispatched_tasks wdt,
3778: mtl_material_transactions_temp mmtt
3779: WHERE mmtt.move_order_line_id = l_mo_line_rec.line_id
3780: AND wdt.transaction_temp_id = nvl(mmtt.parent_line_id, mmtt.transaction_temp_id)
3781: AND wdt.status IN (4,9)

Line 4262: FROM wms_dispatched_tasks

4258: END IF;
4259: l_progress := '155';
4260: SELECT count(*)
4261: INTO l_wdt_count
4262: FROM wms_dispatched_tasks
4263: WHERE transaction_temp_id = l_transaction_number;
4264: IF l_wdt_count > 0 THEN
4265: DELETE
4266: FROM wms_dispatched_tasks

Line 4266: FROM wms_dispatched_tasks

4262: FROM wms_dispatched_tasks
4263: WHERE transaction_temp_id = l_transaction_number;
4264: IF l_wdt_count > 0 THEN
4265: DELETE
4266: FROM wms_dispatched_tasks
4267: WHERE transaction_temp_id = l_transaction_number;
4268: IF SQL%ROWCOUNT = 0 THEN
4269: IF l_debug = 1 THEN
4270: debug_print ( 'delete_so: l_progress: ' || l_progress );

Line 4926: FROM wms_dispatched_tasks

4922: RAISE exc_not_deleted ;
4923: END IF;
4924: SELECT count(task_id)
4925: INTO l_cyc_task
4926: FROM wms_dispatched_tasks
4927: WHERE transaction_temp_id = l_cc_entry_id
4928: AND task_type = 3;
4929: IF l_cyc_task <> 0 THEN
4930: DELETE

Line 4931: FROM wms_dispatched_tasks

4927: WHERE transaction_temp_id = l_cc_entry_id
4928: AND task_type = 3;
4929: IF l_cyc_task <> 0 THEN
4930: DELETE
4931: FROM wms_dispatched_tasks
4932: WHERE transaction_temp_id = l_cc_entry_id
4933: AND task_type = 3;
4934: IF SQL%ROWCOUNT =0 THEN
4935: IF l_debug =1 THEN

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;

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

6760: FROM dual;
6761: SELECT mtl_material_transactions_s.NEXTVAL
6762: INTO l_new_transaction_temp_id
6763: FROM dual;
6764: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6765: IF g_debug = 1 THEN
6766: print_msg(l_procedure_name, ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number);
6767: END IF;
6768: split_mmtt( p_orig_transaction_temp_id => p_source_transaction_number ,

Line 6790: FROM wms_dispatched_tasks

6786: END IF;
6787: BEGIN
6788: SELECT status
6789: INTO l_mmtt_task_status
6790: FROM wms_dispatched_tasks
6791: WHERE transaction_temp_id = p_source_transaction_number;
6792: EXCEPTION
6793: WHEN NO_DATA_FOUND THEN
6794: l_mmtt_task_status := -9999;

Line 7579: INTO wms_dispatched_tasks

7575: --Do BULK INSERT,UPDATE
7576: IF (l_transaction_num_table.COUNT > 0) THEN
7577: FORALL i in 1..l_transaction_num_table.COUNT
7578: INSERT
7579: INTO wms_dispatched_tasks
7580: (
7581: task_id ,
7582: transaction_temp_id ,
7583: organization_id ,

Line 7604: wms_dispatched_tasks_s.NEXTVAL ,

7600: transfer_lpn_id
7601: )
7602: VALUES
7603: (
7604: wms_dispatched_tasks_s.NEXTVAL ,
7605: l_transaction_num_table(i) ,
7606: l_organization_id_table(i) ,
7607: l_usertask_type_id_table(i) ,
7608: p_person_id ,

Line 7647: UPDATE wms_dispatched_tasks

7643: END IF;
7644:
7645: IF (l_wdt_transaction_num_table.COUNT > 0) THEN
7646: FORALL i in 1..l_wdt_transaction_num_table.COUNT
7647: UPDATE wms_dispatched_tasks
7648: SET status = l_wdt_status_id_table(i) ,
7649: operation_plan_id = l_wdt_operation_plan_id_table(i),
7650: priority = l_wdt_priority_table(i) ,
7651: user_task_type = l_wdt_usertask_type_id_table(i)

Line 7657: DELETE from wms_dispatched_tasks

7653: END IF;
7654:
7655: IF (l_wdt_del_trns_num_table.COUNT > 0) THEN
7656: FORALL i in 1..l_wdt_del_trns_num_table.COUNT
7657: DELETE from wms_dispatched_tasks
7658: WHERE transaction_temp_id = l_wdt_del_trns_num_table(i);
7659: END IF;
7660:
7661: IF (p_commit = FND_API.G_TRUE) THEN