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 503: FROM wms_dispatched_tasks wdt

499: CURSOR c_get_task_type
500: ( p_temp_id IN NUMBER
501: ) IS
502: SELECT wdt.task_type
503: FROM wms_dispatched_tasks wdt
504: WHERE wdt.transaction_temp_id = p_temp_id;
505:
506: BEGIN
507: x_return_status := fnd_api.g_ret_sts_success;

Line 668: , wms_dispatched_tasks wdt

664: , wdt.created_by
665: , wdt.task_type
666: , wdt.loaded_time
667: FROM mtl_material_transactions_temp pmmtt
668: , wms_dispatched_tasks wdt
669: WHERE pmmtt.organization_id = p_org_id
670: AND pmmtt.transfer_lpn_id = p_lpn_id
671: AND pmmtt.transaction_temp_id = NVL(pmmtt.parent_line_id,0)
672: AND wdt.transaction_temp_id = pmmtt.parent_line_id;

Line 700: INSERT INTO wms_dispatched_tasks

696: , l_api_name
697: );
698: END IF;
699:
700: INSERT INTO wms_dispatched_tasks
701: ( task_id
702: , transaction_temp_id
703: , organization_id
704: , user_task_type

Line 723: ( SELECT wms_dispatched_tasks_s.NEXTVAL

719: , loaded_time
720: , operation_plan_id
721: , move_order_line_id
722: )
723: ( SELECT wms_dispatched_tasks_s.NEXTVAL
724: , mmtt.transaction_temp_id
725: , mmtt.organization_id
726: , c_parent_task_rec.user_task_type
727: , c_parent_task_rec.person_id

Line 749: FROM wms_dispatched_tasks wdt2

745: WHERE mmtt.parent_line_id = c_parent_task_rec.transaction_temp_id
746: AND mmtt.parent_line_id <> mmtt.transaction_temp_id
747: AND NOT EXISTS
748: ( SELECT 'x'
749: FROM wms_dispatched_tasks wdt2
750: WHERE wdt2.transaction_temp_id = mmtt.transaction_temp_id
751: )
752: );
753:

Line 3040: INSERT INTO wms_dispatched_tasks

3036: print_debug( 'About to insert WDT record', l_api_name);
3037: END IF;
3038:
3039: -- Bug 4884284: insert WDT record for new child MMTT
3040: INSERT INTO wms_dispatched_tasks
3041: ( task_id
3042: , transaction_temp_id
3043: , organization_id
3044: , user_task_type

Line 3063: ( SELECT wms_dispatched_tasks_s.NEXTVAL

3059: , loaded_time
3060: , operation_plan_id
3061: , move_order_line_id
3062: )
3063: ( SELECT wms_dispatched_tasks_s.NEXTVAL
3064: , l_new_temp_id
3065: , mmtt.organization_id
3066: , wdt.user_task_type
3067: , wdt.person_id

Line 3084: FROM wms_dispatched_tasks wdt

3080: , wdt.task_type
3081: , wdt.loaded_time
3082: , mmtt.operation_plan_id
3083: , mmtt.move_order_line_id
3084: FROM wms_dispatched_tasks wdt
3085: , mtl_material_transactions_temp mmtt
3086: WHERE mmtt.transaction_temp_id = p_temp_id
3087: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
3088: );

Line 3168: l_mmtt_cur_str :='SELECT mmtt.TRANSACTION_TEMP_ID FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt '||

3164: END LOOP;
3165:
3166: l_transaction_temp_id:=NULL;
3167:
3168: l_mmtt_cur_str :='SELECT mmtt.TRANSACTION_TEMP_ID FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt '||
3169: ' WHERE mmtt.TRANSACTION_TEMP_ID=wdt.TRANSACTION_TEMP_ID(+) and mmtt.TRANSACTION_TEMP_ID in ('||l_temp_ids||') ORDER BY wdt.loaded_time';
3170:
3171: ii := 1;
3172:

Line 3598: , wms_dispatched_tasks wdt -- Added for bug 12853197

3594: , mtl_secondary_inventories msi
3595: , mtl_item_locations mil
3596: , mtl_txn_request_lines mtrl
3597: , mtl_txn_request_headers mtrh
3598: , wms_dispatched_tasks wdt -- Added for bug 12853197
3599: WHERE mmtt.organization_id = p_org_id
3600: AND mmtt.transfer_lpn_id = p_lpn_id
3601: AND mmtt.transaction_action_id = 2
3602: AND ( (mmtt.parent_line_id IS NOT NULL

Line 7465: , wms_dispatched_tasks wdt

7461: mmtt4.parent_line_id <> mmtt4.transaction_temp_id
7462: )
7463: )
7464: ) mmtt
7465: , wms_dispatched_tasks wdt
7466: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
7467: AND wdt.suggested_dest_subinventory IS NOT NULL
7468: AND wdt.suggested_dest_locator_id IS NOT NULL;
7469:

Line 7535: UPDATE wms_dispatched_tasks

7531: print_debug('Updated dest sub, dest loc on MMTTs', l_api_name);
7532: END IF;
7533:
7534: FORALL jj IN v_temp_id_tbl.FIRST..v_temp_id_tbl.LAST
7535: UPDATE wms_dispatched_tasks
7536: SET suggested_dest_subinventory = NULL
7537: , suggested_dest_locator_id = NULL
7538: WHERE transaction_temp_id = v_temp_id_tbl(jj);
7539:

Line 7545: DELETE wms_dispatched_tasks

7541: print_debug('Updated suggested dest sub/loc on WDTs to NULL', l_api_name);
7542: END IF;
7543:
7544: -- Bug 4884284: Delete child WDT records
7545: DELETE wms_dispatched_tasks
7546: WHERE transaction_temp_id IN
7547: ( SELECT transaction_temp_id
7548: FROM mtl_material_transactions_temp mmtt
7549: WHERE mmtt.parent_line_id IS NOT NULL

Line 9321: ORDER BY 2,3,4,5,6,7 ) mmtt, wms_dispatched_tasks wdt

9317: AND mmtt.transfer_lpn_id = p_lpn_id
9318: AND mmtt.parent_line_id IS NULL
9319: AND mmtt.content_lpn_id IS NULL
9320: AND mmtt.lpn_id IS NULL
9321: ORDER BY 2,3,4,5,6,7 ) mmtt, wms_dispatched_tasks wdt
9322: WHERE mmtt.TRANSACTION_TEMP_ID=wdt.TRANSACTION_TEMP_ID(+)
9323: ORDER BY mmtt.organization_id,
9324: mmtt.inventory_item_id,
9325: mmtt.revision ,

Line 9349: , wms_dispatched_tasks wdt

9345: ) IS
9346: SELECT mmtt.transaction_temp_id
9347: , wdt.task_id
9348: FROM mtl_material_transactions_temp mmtt
9349: , wms_dispatched_tasks wdt
9350: WHERE mmtt.organization_id = p_org_id
9351: AND mmtt.transfer_lpn_id = p_lpn_id
9352: AND mmtt.parent_line_id IS NOT NULL
9353: AND mmtt.parent_line_id = mmtt.transaction_temp_id

Line 9768: FROM wms_dispatched_tasks wdt

9764: BEGIN
9765: BEGIN
9766: SELECT wdt.task_id
9767: INTO l_task_id
9768: FROM wms_dispatched_tasks wdt
9769: WHERE wdt.transaction_temp_id = l_transaction_temp_id;
9770: EXCEPTION
9771: WHEN NO_DATA_FOUND THEN
9772: INSERT INTO wms_dispatched_tasks

Line 9772: INSERT INTO wms_dispatched_tasks

9768: FROM wms_dispatched_tasks wdt
9769: WHERE wdt.transaction_temp_id = l_transaction_temp_id;
9770: EXCEPTION
9771: WHEN NO_DATA_FOUND THEN
9772: INSERT INTO wms_dispatched_tasks
9773: ( task_id
9774: , transaction_temp_id
9775: , organization_id
9776: , user_task_type

Line 9797: ( SELECT wms_dispatched_tasks_s.NEXTVAL

9793: , move_order_line_id
9794: , suggested_dest_subinventory --bug 7319244
9795: , suggested_dest_locator_id --bug 7319244
9796: )
9797: ( SELECT wms_dispatched_tasks_s.NEXTVAL
9798: , l_transaction_temp_id
9799: , mmtt.organization_id
9800: , wdt.user_task_type
9801: , wdt.person_id

Line 9820: FROM wms_dispatched_tasks wdt

9816: , mmtt.operation_plan_id
9817: , mmtt.move_order_line_id
9818: , mmtt.transfer_subinventory --bug 7319244
9819: , mmtt.transfer_to_location --bug 7319244
9820: FROM wms_dispatched_tasks wdt
9821: , mtl_material_transactions_temp mmtt
9822: WHERE wdt.transaction_temp_id = l_parent_line_id
9823: AND mmtt.transaction_temp_id = l_transaction_temp_id
9824: AND rownum = 1

Line 9829: FROM wms_dispatched_tasks wdt

9825: );
9826:
9827: SELECT wdt.task_id
9828: INTO l_task_id
9829: FROM wms_dispatched_tasks wdt
9830: WHERE wdt.transaction_temp_id = l_transaction_temp_id;
9831:
9832: WHEN OTHERS THEN
9833: IF l_debug = 1 THEN

Line 10133: UPDATE wms_dispatched_tasks_history wdth

10129: --
10130: -- Update parent_transaction_id in WDTH
10131: --
10132: BEGIN
10133: UPDATE wms_dispatched_tasks_history wdth
10134: SET wdth.parent_transaction_id = l_parent_line_id
10135: , wdth.is_parent = 'N'
10136: WHERE task_id = l_task_id;
10137:

Line 10225: UPDATE wms_dispatched_tasks_history wdth

10221: --
10222: -- Update parent_transaction_id in WDTH
10223: --
10224: BEGIN
10225: UPDATE wms_dispatched_tasks_history wdth
10226: SET wdth.parent_transaction_id = wdth.transaction_id
10227: , wdth.is_parent = 'Y'
10228: WHERE wdth.task_id = parent_rec.task_id
10229: RETURNING wdth.transaction_id INTO l_parent_txn_id;

Line 10254: UPDATE wms_dispatched_tasks_history wdth

10250: --
10251: -- Update child lines
10252: --
10253: BEGIN
10254: UPDATE wms_dispatched_tasks_history wdth
10255: SET wdth.parent_transaction_id = l_parent_txn_id
10256: WHERE wdth.parent_transaction_id = parent_rec.transaction_temp_id;
10257:
10258: IF l_debug = 1 THEN