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.

[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 23: FROM mtl_material_transactions_temp mmtt

19: SELECT mmtt.transaction_temp_id
20: , mmtt.transaction_type_id
21: , mmtt.move_order_line_id
22: , mol.line_status
23: FROM mtl_material_transactions_temp mmtt
24: , mtl_txn_request_lines mol
25: WHERE mmtt.transfer_lpn_id = p_lpn_id
26: AND mmtt.move_order_line_id = mol.line_id
27: AND mol.line_status = inv_globals.g_to_status_cancel_by_source;

Line 114: FROM mtl_material_transactions_temp mmtt

110:
111: CURSOR mmtt_to_del(mol_id NUMBER) IS
112: SELECT mmtt.transaction_temp_id
113: , ABS(mmtt.transaction_quantity) --mmtt.primary_quantity
114: FROM mtl_material_transactions_temp mmtt
115: WHERE mmtt.move_order_line_id = mol_id
116: AND NOT EXISTS(
117: SELECT wdt.transaction_temp_id
118: FROM wms_dispatched_tasks wdt

Line 200: FROM mtl_material_transactions_temp

196: , l_item_id
197: , l_content_lpn_id
198: , l_transfer_lpn_id
199: , l_wms_task_types
200: FROM mtl_material_transactions_temp
201: WHERE transaction_temp_id = p_temp_id;
202:
203: IF (l_debug = 1) THEN
204: mydebug(' mol_id ' || mol_id);

Line 211: mydebug(' No data found in mtl_material_transactions_temp ');

207: END IF;
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: IF (l_debug = 1) THEN
211: mydebug(' No data found in mtl_material_transactions_temp ');
212: END IF;
213:
214: mol_id := -1;
215: END;

Line 309: FROM mtl_material_transactions_temp mmtt

305: END IF;
306:
307: SELECT COUNT(transaction_temp_id)
308: INTO cnt
309: FROM mtl_material_transactions_temp mmtt
310: WHERE mmtt.move_order_line_id = mol_id;
311:
312: IF (cnt = 0) THEN
313: IF (l_debug = 1) THEN

Line 340: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

336: SELECT msi.lot_control_code
337: , msi.serial_number_control_code
338: INTO v_lot_control_code
339: , v_serial_control_code
340: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
341: WHERE msi.inventory_item_id = mmtt.inventory_item_id
342: AND msi.organization_id = mmtt.organization_id
343: AND mmtt.transaction_temp_id = p_temp_id;
344:

Line 347: FROM mtl_parameters mp, mtl_material_transactions_temp mmtt

343: AND mmtt.transaction_temp_id = p_temp_id;
344:
345: SELECT nvl(mp.allocate_serial_flag,'N') /*Bug#4003553.Added NVL function*/
346: INTO v_allocate_serial_flag
347: FROM mtl_parameters mp, mtl_material_transactions_temp mmtt
348: WHERE mp.organization_id = mmtt.organization_id
349: AND mmtt.transaction_temp_id = p_temp_id;
350:
351: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN

Line 490: UPDATE mtl_material_transactions_temp

486:
487: END IF;
488:
489: --The lpn ids must be set to null for this task
490: UPDATE mtl_material_transactions_temp
491: SET lpn_id = NULL
492: , content_lpn_id = NULL
493: , transfer_lpn_id = NULL
494: WHERE transaction_temp_id = p_temp_id;

Line 504: DELETE FROM mtl_material_transactions_temp

500: mydebug('deleted WDT with temp_id ' || p_temp_id);
501: END IF;
502:
503: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
504: DELETE FROM mtl_material_transactions_temp
505: WHERE transaction_temp_id = p_temp_id;
506: END IF;
507: END IF;
508:

Line 521: FROM mtl_material_transactions_temp

517: )
518: THEN
519: SELECT COUNT(1)
520: INTO l_count
521: FROM mtl_material_transactions_temp
522: WHERE transfer_lpn_id = l_transfer_lpn_id;
523:
524: IF l_count = 0 THEN -- no more rows and the current row is the
525: --last allocation

Line 652: FROM mtl_material_transactions_temp

648: SELECT 'E'
649: INTO l_processed
650: FROM DUAL
651: WHERE EXISTS(SELECT 1
652: FROM mtl_material_transactions_temp
653: WHERE transaction_header_id = p_header_id
654: AND process_flag = 'E');
655:
656: IF (l_debug = 1) THEN

Line 677: FROM mtl_material_transactions

673: SELECT 'Y'
674: INTO l_processed
675: FROM DUAL
676: WHERE EXISTS(SELECT transaction_set_id
677: FROM mtl_material_transactions
678: WHERE transaction_set_id = p_header_id);
679:
680: IF (l_debug = 1) THEN
681: mydebug('After the select: l_processed ' || l_processed);

Line 871: FROM mtl_material_transactions

867: v_allocate_serial_flag VARCHAR2(1) := 'X';
868:
869: CURSOR mmt(p_set_id NUMBER) IS
870: SELECT *
871: FROM mtl_material_transactions
872: WHERE transaction_set_id = p_set_id;
873:
874: CURSOR mtln(p_set_id NUMBER) IS
875: SELECT *

Line 878: FROM mtl_material_transactions

874: CURSOR mtln(p_set_id NUMBER) IS
875: SELECT *
876: FROM mtl_transaction_lot_numbers
877: WHERE transaction_id IN(SELECT transaction_id
878: FROM mtl_material_transactions
879: WHERE transaction_set_id = p_set_id);
880:
881: CURSOR mut1(p_set_id NUMBER) IS
882: SELECT *

Line 885: FROM mtl_material_transactions

881: CURSOR mut1(p_set_id NUMBER) IS
882: SELECT *
883: FROM mtl_unit_transactions
884: WHERE transaction_id IN(SELECT transaction_id
885: FROM mtl_material_transactions
886: WHERE transaction_set_id = p_set_id);
887:
888: CURSOR mut2(p_set_id NUMBER) IS
889: SELECT *

Line 894: FROM mtl_material_transactions

890: FROM mtl_unit_transactions
891: WHERE transaction_id IN(SELECT serial_transaction_id
892: FROM mtl_transaction_lot_numbers
893: WHERE transaction_id IN(SELECT transaction_id
894: FROM mtl_material_transactions
895: WHERE transaction_set_id = p_set_id));
896:
897: mmtt_table mmtt_tb;
898: mmtt_row mmtt_type;

Line 1528: FROM mtl_txn_request_lines mtrl, mtl_material_transactions mmt

1524: INTO l_crossdocked
1525: FROM DUAL
1526: WHERE EXISTS(
1527: SELECT mtrl.line_id
1528: FROM mtl_txn_request_lines mtrl, mtl_material_transactions mmt
1529: WHERE mtrl.line_id = mmt.move_order_line_id
1530: AND mtrl.backorder_delivery_detail_id IS NOT NULL
1531: AND mmt.transaction_set_id = p_old_header_id);
1532: EXCEPTION

Line 1570: SELECT mtl_material_transactions_s.NEXTVAL

1566: IF (l_debug = 1) THEN
1567: mydebug('After calling get_temp_tables ');
1568: END IF;
1569:
1570: SELECT mtl_material_transactions_s.NEXTVAL
1571: INTO new_txn_header_id
1572: FROM DUAL;
1573:
1574: IF (l_debug = 1) THEN

Line 1633: SELECT mtl_material_transactions_s.NEXTVAL

1629: IF (l_debug = 1) THEN
1630: mydebug(' source and destination sub location are not same ');
1631: END IF;
1632:
1633: SELECT mtl_material_transactions_s.NEXTVAL
1634: INTO new_txn_temp_id
1635: FROM DUAL;
1636:
1637: IF (l_debug = 1) THEN

Line 2063: SELECT mtl_material_transactions_s.NEXTVAL

2059: RAISE g_qty_not_avail;
2060: END IF;
2061:
2062: /**2706001 moved this out of below loop **/
2063: SELECT mtl_material_transactions_s.NEXTVAL
2064: INTO ser_transaction_temp_id
2065: FROM dual;
2066:
2067: /**2706001 was using cnt6 earlier **/

Line 2296: FROM mtl_material_transactions_temp mmtt

2292: AND device_request_id IS NOT NULL;
2293:
2294: CURSOR c_mo_line_id IS
2295: SELECT mtrl.line_id
2296: FROM mtl_material_transactions_temp mmtt
2297: , mtl_txn_request_lines mtrl
2298: WHERE (mmtt.transaction_temp_id = p_temp_id OR mmtt.parent_line_id = p_temp_id)
2299: AND mtrl.line_id = mmtt.move_order_line_id
2300: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;

Line 2304: FROM mtl_material_transactions_temp mmtt

2300: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;
2301:
2302: CURSOR c_mmtt_to_del IS
2303: SELECT mmtt.transaction_temp_id, mmtt.primary_quantity
2304: FROM mtl_material_transactions_temp mmtt
2305: WHERE mmtt.move_order_line_id = l_mo_line_id
2306: AND NOT EXISTS(SELECT 1
2307: FROM mtl_material_transactions_temp t1
2308: WHERE t1.parent_line_id = mmtt.transaction_temp_id)

Line 2307: FROM mtl_material_transactions_temp t1

2303: SELECT mmtt.transaction_temp_id, mmtt.primary_quantity
2304: FROM mtl_material_transactions_temp mmtt
2305: WHERE mmtt.move_order_line_id = l_mo_line_id
2306: AND NOT EXISTS(SELECT 1
2307: FROM mtl_material_transactions_temp t1
2308: WHERE t1.parent_line_id = mmtt.transaction_temp_id)
2309: AND NOT EXISTS(SELECT 1
2310: FROM wms_dispatched_tasks wdt
2311: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id);

Line 2315: FROM mtl_material_transactions_temp mmtt

2311: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id);
2312:
2313: CURSOR c_get_mmtt_count IS
2314: SELECT count(*)
2315: FROM mtl_material_transactions_temp mmtt
2316: WHERE mmtt.move_order_line_id = l_mo_line_id
2317: AND NOT EXISTS ( SELECT 1
2318: FROM mtl_material_transactions_temp t1
2319: WHERE t1.parent_line_id = mmtt.transaction_temp_id);

Line 2318: FROM mtl_material_transactions_temp t1

2314: SELECT count(*)
2315: FROM mtl_material_transactions_temp mmtt
2316: WHERE mmtt.move_order_line_id = l_mo_line_id
2317: AND NOT EXISTS ( SELECT 1
2318: FROM mtl_material_transactions_temp t1
2319: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
2320:
2321: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2322: BEGIN

Line 2450: FROM mtl_material_transactions_temp

2446: END IF;
2447:
2448: SELECT transfer_lpn_id
2449: INTO l_transfer_lpn_id
2450: FROM mtl_material_transactions_temp
2451: WHERE transaction_temp_id = p_temp_id
2452: AND content_lpn_id = transfer_lpn_id;
2453:
2454: IF (l_debug = 1) THEN

Line 2483: FROM mtl_material_transactions_temp

2479: SELECT 'Y'
2480: INTO l_multiple_rows
2481: FROM DUAL
2482: WHERE EXISTS(SELECT transaction_temp_id
2483: FROM mtl_material_transactions_temp
2484: WHERE transfer_lpn_id = l_transfer_lpn_id
2485: AND transaction_temp_id <> p_temp_id);
2486:
2487: IF (l_debug = 1) THEN