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

Line 493: FROM wms_dispatched_tasks wdt

489: CURSOR c_get_task_type
490: ( p_temp_id IN NUMBER
491: ) IS
492: SELECT wdt.task_type
493: FROM wms_dispatched_tasks wdt
494: WHERE wdt.transaction_temp_id = p_temp_id;
495:
496: BEGIN
497: x_return_status := fnd_api.g_ret_sts_success;

Line 658: , wms_dispatched_tasks wdt

654: , wdt.created_by
655: , wdt.task_type
656: , wdt.loaded_time
657: FROM mtl_material_transactions_temp pmmtt
658: , wms_dispatched_tasks wdt
659: WHERE pmmtt.organization_id = p_org_id
660: AND pmmtt.transfer_lpn_id = p_lpn_id
661: AND pmmtt.transaction_temp_id = NVL(pmmtt.parent_line_id,0)
662: AND wdt.transaction_temp_id = pmmtt.parent_line_id;

Line 690: INSERT INTO wms_dispatched_tasks

686: , l_api_name
687: );
688: END IF;
689:
690: INSERT INTO wms_dispatched_tasks
691: ( task_id
692: , transaction_temp_id
693: , organization_id
694: , user_task_type

Line 713: ( SELECT wms_dispatched_tasks_s.NEXTVAL

709: , loaded_time
710: , operation_plan_id
711: , move_order_line_id
712: )
713: ( SELECT wms_dispatched_tasks_s.NEXTVAL
714: , mmtt.transaction_temp_id
715: , mmtt.organization_id
716: , c_parent_task_rec.user_task_type
717: , c_parent_task_rec.person_id

Line 739: FROM wms_dispatched_tasks wdt2

735: WHERE mmtt.parent_line_id = c_parent_task_rec.transaction_temp_id
736: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
737: AND NOT EXISTS
738: ( SELECT 'x'
739: FROM wms_dispatched_tasks wdt2
740: WHERE wdt2.transaction_temp_id = mmtt.transaction_temp_id
741: )
742: );
743:

Line 2897: INSERT INTO wms_dispatched_tasks

2893: print_debug( 'About to insert WDT record', l_api_name);
2894: END IF;
2895:
2896: -- Bug 4884284: insert WDT record for new child MMTT
2897: INSERT INTO wms_dispatched_tasks
2898: ( task_id
2899: , transaction_temp_id
2900: , organization_id
2901: , user_task_type

Line 2920: ( SELECT wms_dispatched_tasks_s.NEXTVAL

2916: , loaded_time
2917: , operation_plan_id
2918: , move_order_line_id
2919: )
2920: ( SELECT wms_dispatched_tasks_s.NEXTVAL
2921: , l_new_temp_id
2922: , mmtt.organization_id
2923: , wdt.user_task_type
2924: , wdt.person_id

Line 2941: FROM wms_dispatched_tasks wdt

2937: , wdt.task_type
2938: , wdt.loaded_time
2939: , mmtt.operation_plan_id
2940: , mmtt.move_order_line_id
2941: FROM wms_dispatched_tasks wdt
2942: , mtl_material_transactions_temp mmtt
2943: WHERE mmtt.transaction_temp_id = p_temp_id
2944: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
2945: );

Line 7187: , wms_dispatched_tasks wdt

7183: mmtt4.parent_line_id <> mmtt4.transaction_temp_id
7184: )
7185: )
7186: ) mmtt
7187: , wms_dispatched_tasks wdt
7188: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
7189: AND wdt.suggested_dest_subinventory IS NOT NULL
7190: AND wdt.suggested_dest_locator_id IS NOT NULL;
7191:

Line 7257: UPDATE wms_dispatched_tasks

7253: print_debug('Updated dest sub, dest loc on MMTTs', l_api_name);
7254: END IF;
7255:
7256: FORALL jj IN v_temp_id_tbl.FIRST..v_temp_id_tbl.LAST
7257: UPDATE wms_dispatched_tasks
7258: SET suggested_dest_subinventory = NULL
7259: , suggested_dest_locator_id = NULL
7260: WHERE transaction_temp_id = v_temp_id_tbl(jj);
7261:

Line 7267: DELETE wms_dispatched_tasks

7263: print_debug('Updated suggested dest sub/loc on WDTs to NULL', l_api_name);
7264: END IF;
7265:
7266: -- Bug 4884284: Delete child WDT records
7267: DELETE wms_dispatched_tasks
7268: WHERE transaction_temp_id IN
7269: ( SELECT transaction_temp_id
7270: FROM mtl_material_transactions_temp mmtt
7271: WHERE mmtt.parent_line_id IS NOT NULL

Line 9046: , wms_dispatched_tasks wdt

9042: ) IS
9043: SELECT mmtt.transaction_temp_id
9044: , wdt.task_id
9045: FROM mtl_material_transactions_temp mmtt
9046: , wms_dispatched_tasks wdt
9047: WHERE mmtt.organization_id = p_org_id
9048: AND mmtt.transfer_lpn_id = p_lpn_id
9049: AND mmtt.parent_line_id IS NOT NULL
9050: AND mmtt.parent_line_id = mmtt.transaction_temp_id

Line 9449: FROM wms_dispatched_tasks wdt

9445: BEGIN
9446: BEGIN
9447: SELECT wdt.task_id
9448: INTO l_task_id
9449: FROM wms_dispatched_tasks wdt
9450: WHERE wdt.transaction_temp_id = l_transaction_temp_id;
9451: EXCEPTION
9452: WHEN NO_DATA_FOUND THEN
9453: INSERT INTO wms_dispatched_tasks

Line 9453: INSERT INTO wms_dispatched_tasks

9449: FROM wms_dispatched_tasks wdt
9450: WHERE wdt.transaction_temp_id = l_transaction_temp_id;
9451: EXCEPTION
9452: WHEN NO_DATA_FOUND THEN
9453: INSERT INTO wms_dispatched_tasks
9454: ( task_id
9455: , transaction_temp_id
9456: , organization_id
9457: , user_task_type

Line 9476: ( SELECT wms_dispatched_tasks_s.NEXTVAL

9472: , loaded_time
9473: , operation_plan_id
9474: , move_order_line_id
9475: )
9476: ( SELECT wms_dispatched_tasks_s.NEXTVAL
9477: , l_transaction_temp_id
9478: , mmtt.organization_id
9479: , wdt.user_task_type
9480: , wdt.person_id

Line 9497: FROM wms_dispatched_tasks wdt

9493: , wdt.task_type
9494: , SYSDATE
9495: , mmtt.operation_plan_id
9496: , mmtt.move_order_line_id
9497: FROM wms_dispatched_tasks wdt
9498: , mtl_material_transactions_temp mmtt
9499: WHERE wdt.transaction_temp_id = l_parent_line_id
9500: AND mmtt.transaction_temp_id = l_transaction_temp_id
9501: AND rownum = 1

Line 9506: FROM wms_dispatched_tasks wdt

9502: );
9503:
9504: SELECT wdt.task_id
9505: INTO l_task_id
9506: FROM wms_dispatched_tasks wdt
9507: WHERE wdt.transaction_temp_id = l_transaction_temp_id;
9508:
9509: WHEN OTHERS THEN
9510: IF l_debug = 1 THEN

Line 9810: UPDATE wms_dispatched_tasks_history wdth

9806: --
9807: -- Update parent_transaction_id in WDTH
9808: --
9809: BEGIN
9810: UPDATE wms_dispatched_tasks_history wdth
9811: SET wdth.parent_transaction_id = l_parent_line_id
9812: , wdth.is_parent = 'N'
9813: WHERE task_id = l_task_id;
9814:

Line 9902: UPDATE wms_dispatched_tasks_history wdth

9898: --
9899: -- Update parent_transaction_id in WDTH
9900: --
9901: BEGIN
9902: UPDATE wms_dispatched_tasks_history wdth
9903: SET wdth.parent_transaction_id = wdth.transaction_id
9904: , wdth.is_parent = 'Y'
9905: WHERE wdth.task_id = parent_rec.task_id
9906: RETURNING wdth.transaction_id INTO l_parent_txn_id;

Line 9931: UPDATE wms_dispatched_tasks_history wdth

9927: --
9928: -- Update child lines
9929: --
9930: BEGIN
9931: UPDATE wms_dispatched_tasks_history wdth
9932: SET wdth.parent_transaction_id = l_parent_txn_id
9933: WHERE wdth.parent_transaction_id = parent_rec.transaction_temp_id;
9934:
9935: IF l_debug = 1 THEN