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_UNLOAD_UTILS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 58: FROM mtl_material_transactions_temp mmtt

54:
55: CURSOR mmtt_to_del(mol_id NUMBER) IS
56: SELECT mmtt.transaction_temp_id
57: , ABS(mmtt.transaction_quantity) --mmtt.primary_quantity
58: FROM mtl_material_transactions_temp mmtt
59: WHERE mmtt.move_order_line_id = mol_id
60: AND NOT EXISTS(
61: SELECT wdt.transaction_temp_id
62: FROM wms_dispatched_tasks wdt

Line 132: FROM mtl_material_transactions_temp

128: , l_item_id
129: , l_content_lpn_id
130: , l_transfer_lpn_id
131: , l_wms_task_types
132: FROM mtl_material_transactions_temp
133: WHERE transaction_temp_id = p_temp_id;
134:
135: IF (l_debug = 1) THEN
136: mydebug(' mol_id ' || mol_id);

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

139: END IF;
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN
142: IF (l_debug = 1) THEN
143: mydebug(' No data found in mtl_material_transactions_temp ');
144: END IF;
145:
146: mol_id := -1;
147: END;

Line 241: FROM mtl_material_transactions_temp mmtt

237: END IF;
238:
239: SELECT COUNT(transaction_temp_id)
240: INTO cnt
241: FROM mtl_material_transactions_temp mmtt
242: WHERE mmtt.move_order_line_id = mol_id;
243:
244: IF (cnt = 0) THEN
245: IF (l_debug = 1) THEN

Line 275: , mtl_material_transactions_temp mmtt

271: INTO v_lot_control_code
272: , v_serial_control_code
273: , v_allocate_serial_flag
274: FROM mtl_system_items msi
275: , mtl_material_transactions_temp mmtt
276: WHERE msi.inventory_item_id = mmtt.inventory_item_id
277: AND msi.organization_id = mmtt.organization_id
278: AND mmtt.transaction_temp_id = p_temp_id;
279:

Line 418: UPDATE mtl_material_transactions_temp

414:
415: END IF;
416:
417: --The lpn ids must be set to null for this task
418: UPDATE mtl_material_transactions_temp
419: SET lpn_id = NULL
420: , content_lpn_id = NULL
421: , transfer_lpn_id = NULL
422: , wms_task_status = 1 -- Bug4185621: update mmtt task status back to pending

Line 433: DELETE FROM mtl_material_transactions_temp

429: mydebug('deleted WDT with temp_id ' || p_temp_id);
430: END IF;
431:
432: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
433: DELETE FROM mtl_material_transactions_temp
434: WHERE transaction_temp_id = p_temp_id;
435: END IF;
436: END IF;
437:

Line 451: FROM mtl_material_transactions_temp

447: )
448: THEN
449: SELECT COUNT(1)
450: INTO l_count
451: FROM mtl_material_transactions_temp
452: WHERE transfer_lpn_id = l_transfer_lpn_id;
453:
454: IF l_count = 0 THEN -- no more rows and the current row is the
455: --last allocation

Line 599: FROM mtl_material_transactions_temp mmtt

595: , ABS(mmtt.transaction_quantity)
596: , mmtt.transaction_uom
597: , mmtt.move_order_line_id
598: , mtrl.uom_code
599: FROM mtl_material_transactions_temp mmtt
600: , mtl_txn_request_lines mtrl
601: WHERE mmtt.parent_line_id = p_temp_id
602: AND mtrl.line_id = mmtt.move_order_line_id
603: AND mtrl.line_status = 9

Line 611: FROM mtl_material_transactions_temp mmtt

607: , ABS(mmtt.transaction_quantity)
608: , mmtt.transaction_uom
609: , to_number(NULL)
610: , to_char(NULL)
611: FROM mtl_material_transactions_temp mmtt
612: WHERE mmtt.parent_line_id = p_temp_id
613: AND mmtt.transaction_temp_id <> mmtt.parent_line_id
614: AND mmtt.transaction_action_id = 2
615: AND mmtt.move_order_line_id IS NULL;

Line 652: , mtl_material_transactions_temp m

648: -- Material packed into content LPNs
649: SELECT m.transaction_temp_id
650: , 1 dummy_sort
651: FROM wms_dispatched_tasks w
652: , mtl_material_transactions_temp m
653: WHERE m.transfer_lpn_id = p_xfer_lpn_id
654: AND m.transaction_temp_id <> p_temp_id
655: AND m.transaction_temp_id = m.parent_line_id
656: AND w.transaction_temp_id = m.transaction_temp_id

Line 660: FROM mtl_material_transactions_temp m2

656: AND w.transaction_temp_id = m.transaction_temp_id
657: AND w.status = 4
658: AND EXISTS
659: ( SELECT 'x'
660: FROM mtl_material_transactions_temp m2
661: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
662: AND m2.organization_id = m.organization_id
663: AND m2.transaction_temp_id = m2.parent_line_id
664: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 673: , mtl_material_transactions_temp m

669: -- Content LPNs
670: SELECT m.transaction_temp_id
671: , 2 dummy_sort
672: FROM wms_dispatched_tasks w
673: , mtl_material_transactions_temp m
674: WHERE m.transfer_lpn_id = p_xfer_lpn_id
675: AND m.transaction_temp_id <> p_temp_id
676: AND m.transaction_temp_id = m.parent_line_id
677: AND w.transaction_temp_id = m.transaction_temp_id

Line 685: , mtl_material_transactions_temp m

681: -- Material unpacked from content LPNs
682: SELECT m.transaction_temp_id
683: , 3 dummy_sort
684: FROM wms_dispatched_tasks w
685: , mtl_material_transactions_temp m
686: WHERE m.transfer_lpn_id = p_xfer_lpn_id
687: AND m.transaction_temp_id <> p_temp_id
688: AND m.transaction_temp_id = m.parent_line_id
689: AND w.transaction_temp_id = m.transaction_temp_id

Line 693: FROM mtl_material_transactions_temp m2

689: AND w.transaction_temp_id = m.transaction_temp_id
690: AND w.status = 4
691: AND EXISTS
692: ( SELECT 'x'
693: FROM mtl_material_transactions_temp m2
694: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
695: AND m2.organization_id = m.organization_id
696: AND m2.transaction_temp_id = m2.parent_line_id
697: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 706: , mtl_material_transactions_temp m

702: -- All other picked material
703: SELECT m.transaction_temp_id
704: , 4 dummy_sort
705: FROM wms_dispatched_tasks w
706: , mtl_material_transactions_temp m
707: WHERE m.transfer_lpn_id = p_xfer_lpn_id
708: AND m.transaction_temp_id <> p_temp_id
709: AND m.transaction_temp_id = m.parent_line_id
710: AND w.transaction_temp_id = m.transaction_temp_id

Line 716: FROM mtl_material_transactions_temp m2

712: AND m.content_lpn_id IS NULL
713: AND ( (m.lpn_id IS NOT NULL
714: AND NOT EXISTS
715: ( SELECT 'x'
716: FROM mtl_material_transactions_temp m2
717: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
718: AND m2.organization_id = m.organization_id
719: AND m2.transaction_temp_id = m2.parent_line_id
720: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 729: FROM mtl_material_transactions_temp m3

725: OR m.lpn_id IS NULL
726: )
727: AND NOT EXISTS
728: ( SELECT 'x'
729: FROM mtl_material_transactions_temp m3
730: WHERE m3.transfer_lpn_id = m.transfer_lpn_id
731: AND m3.organization_id = m.organization_id
732: AND m3.transaction_temp_id = m3.parent_line_id
733: AND m3.transaction_temp_id <> m.transaction_temp_id

Line 769: FROM mtl_material_transactions_temp

765: INTO l_org_id
766: , l_item_id
767: , l_content_lpn_id
768: , l_transfer_lpn_id
769: FROM mtl_material_transactions_temp
770: WHERE transaction_temp_id = p_txn_temp_id;
771:
772: IF (l_debug = 1) THEN
773: mydebug('Org_id: ' || to_char(l_org_id) ||

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

778: END IF;
779: EXCEPTION
780: WHEN NO_DATA_FOUND THEN
781: IF (l_debug = 1) THEN
782: mydebug(' No data found in mtl_material_transactions_temp ');
783: END IF;
784: END;
785:
786: IF l_content_lpn_id IS NOT NULL THEN

Line 893: FROM mtl_material_transactions_temp mmtt

889: END IF;
890:
891: SELECT COUNT(transaction_temp_id)
892: INTO l_count
893: FROM mtl_material_transactions_temp mmtt
894: WHERE mmtt.move_order_line_id = l_mo_line_id;
895:
896: IF (l_count = 0) THEN
897: IF (l_debug = 1) THEN

Line 923: , mtl_material_transactions_temp mmtt

919: INTO v_lot_control_code
920: , v_serial_control_code
921: , v_allocate_serial_flag
922: FROM mtl_system_items msi
923: , mtl_material_transactions_temp mmtt
924: WHERE msi.inventory_item_id = mmtt.inventory_item_id
925: AND msi.organization_id = mmtt.organization_id
926: AND mmtt.transaction_temp_id = p_txn_temp_id;
927: EXCEPTION

Line 1047: UPDATE mtl_material_transactions_temp

1043: --
1044: -- The lpn ids must be set to null for this task
1045: -- for both parent and child records
1046: --
1047: UPDATE mtl_material_transactions_temp
1048: SET lpn_id = NULL
1049: , content_lpn_id = NULL
1050: , transfer_lpn_id = NULL
1051: , wms_task_status = 1 -- Bug4185621: update mmtt task status back to pending

Line 1059: FROM mtl_material_transactions_temp

1055:
1056: l_count := 0;
1057: SELECT COUNT(*)
1058: INTO l_count
1059: FROM mtl_material_transactions_temp
1060: WHERE transfer_lpn_id = l_transfer_lpn_id;
1061:
1062: IF l_count = 0 THEN
1063: --