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 87: FROM mtl_material_transactions_temp mmtt

83: CURSOR mmtt_to_del(mol_id NUMBER) IS
84: SELECT mmtt.transaction_temp_id
85: , ABS(mmtt.transaction_quantity) --mmtt.primary_quantity
86: , ABS(mmtt.secondary_transaction_quantity) -- Added for bug 8703085
87: FROM mtl_material_transactions_temp mmtt
88: WHERE mmtt.move_order_line_id = mol_id
89: AND NOT EXISTS(
90: SELECT wdt.transaction_temp_id
91: FROM wms_dispatched_tasks wdt

Line 171: FROM mtl_material_transactions_temp

167: , l_subinventory -- Added for 14699845 (Flexible Lot Allocation)
168: , l_locator_id -- Added for 14699845 (Flexible Lot Allocation)
169: , l_revision -- Added for 14699845 (Flexible Lot Allocation)
170: , l_allocated_lpn_id -- Added for 14699845 (Flexible Lot Allocation)
171: FROM mtl_material_transactions_temp
172: WHERE transaction_temp_id = p_temp_id;
173:
174: IF (l_debug = 1) THEN
175: mydebug(' mol_id ' || mol_id);

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

181: END IF;
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN
184: IF (l_debug = 1) THEN
185: mydebug(' No data found in mtl_material_transactions_temp ');
186: END IF;
187:
188: mol_id := -1;
189: END;

Line 286: FROM mtl_material_transactions_temp mmtt

282: END IF;
283:
284: SELECT COUNT(transaction_temp_id)
285: INTO cnt
286: FROM mtl_material_transactions_temp mmtt
287: WHERE mmtt.move_order_line_id = mol_id;
288:
289: IF (cnt = 0) THEN
290: IF (l_debug = 1) THEN

Line 320: , mtl_material_transactions_temp mmtt

316: INTO v_lot_control_code
317: , v_serial_control_code
318: , v_allocate_serial_flag
319: FROM mtl_system_items msi
320: , mtl_material_transactions_temp mmtt
321: WHERE msi.inventory_item_id = mmtt.inventory_item_id
322: AND msi.organization_id = mmtt.organization_id
323: AND mmtt.transaction_temp_id = p_temp_id;
324:

Line 343: FROM mtl_material_transactions_temp

339: IF (v_lot_control_code = 2 )THEN
340: IF l_org_id IS NULL THEN
341: SELECT organization_id
342: INTO l_org_id
343: FROM mtl_material_transactions_temp
344: WHERE transaction_temp_id = p_temp_id;
345: END IF;
346: IF ( l_debug = 1 ) THEN
347: mydebug('l_org_id '||l_org_id);

Line 395: FROM mtl_material_transactions_temp mmtt,

391: BEGIN
392:
393: SELECT NVL(mr.lot_number, mtrl.lot_number)
394: INTO l_reserved_lot
395: FROM mtl_material_transactions_temp mmtt,
396: mtl_reservations mr,
397: mtl_txn_request_lines mtrl
398: WHERE mmtt.transaction_temp_id = p_temp_id
399: AND mmtt.organization_id = l_org_id

Line 568: UPDATE mtl_material_transactions_temp

564:
565: END IF;
566:
567: --The lpn ids must be set to null for this task
568: UPDATE mtl_material_transactions_temp
569: SET lpn_id = NULL
570: , content_lpn_id = NULL
571: , transfer_lpn_id = NULL
572: , wms_task_status = 1 -- Bug4185621: update mmtt task status back to pending

Line 583: DELETE FROM mtl_material_transactions_temp

579: mydebug('deleted WDT with temp_id ' || p_temp_id);
580: END IF;
581:
582: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
583: DELETE FROM mtl_material_transactions_temp
584: WHERE transaction_temp_id = p_temp_id;
585: END IF;
586: END IF;
587:

Line 602: FROM mtl_material_transactions_temp

598: )
599: THEN
600: SELECT COUNT(1)
601: INTO l_count
602: FROM mtl_material_transactions_temp
603: WHERE transfer_lpn_id = l_transfer_lpn_id;
604:
605: IF l_count = 0 THEN -- no more rows and the current row is the
606: --last allocation

Line 794: FROM mtl_material_transactions_temp mmtt

790: , ABS(mmtt.transaction_quantity)
791: , mmtt.transaction_uom
792: , mmtt.move_order_line_id
793: , mtrl.uom_code
794: FROM mtl_material_transactions_temp mmtt
795: , mtl_txn_request_lines mtrl
796: WHERE mmtt.parent_line_id = p_temp_id
797: AND mtrl.line_id = mmtt.move_order_line_id
798: AND mtrl.line_status = 9

Line 806: FROM mtl_material_transactions_temp mmtt

802: , ABS(mmtt.transaction_quantity)
803: , mmtt.transaction_uom
804: , to_number(NULL)
805: , to_char(NULL)
806: FROM mtl_material_transactions_temp mmtt
807: WHERE mmtt.parent_line_id = p_temp_id
808: AND mmtt.transaction_temp_id <> mmtt.parent_line_id
809: AND mmtt.transaction_action_id = 2
810: AND mmtt.move_order_line_id IS NULL;

Line 847: , mtl_material_transactions_temp m

843: -- Material packed into content LPNs
844: SELECT m.transaction_temp_id
845: , 1 dummy_sort
846: FROM wms_dispatched_tasks w
847: , mtl_material_transactions_temp m
848: WHERE m.transfer_lpn_id = p_xfer_lpn_id
849: AND m.transaction_temp_id <> p_temp_id
850: AND m.transaction_temp_id = m.parent_line_id
851: AND w.transaction_temp_id = m.transaction_temp_id

Line 855: FROM mtl_material_transactions_temp m2

851: AND w.transaction_temp_id = m.transaction_temp_id
852: AND w.status = 4
853: AND EXISTS
854: ( SELECT 'x'
855: FROM mtl_material_transactions_temp m2
856: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
857: AND m2.organization_id = m.organization_id
858: AND m2.transaction_temp_id = m2.parent_line_id
859: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 868: , mtl_material_transactions_temp m

864: -- Content LPNs
865: SELECT m.transaction_temp_id
866: , 2 dummy_sort
867: FROM wms_dispatched_tasks w
868: , mtl_material_transactions_temp m
869: WHERE m.transfer_lpn_id = p_xfer_lpn_id
870: AND m.transaction_temp_id <> p_temp_id
871: AND m.transaction_temp_id = m.parent_line_id
872: AND w.transaction_temp_id = m.transaction_temp_id

Line 880: , mtl_material_transactions_temp m

876: -- Material unpacked from content LPNs
877: SELECT m.transaction_temp_id
878: , 3 dummy_sort
879: FROM wms_dispatched_tasks w
880: , mtl_material_transactions_temp m
881: WHERE m.transfer_lpn_id = p_xfer_lpn_id
882: AND m.transaction_temp_id <> p_temp_id
883: AND m.transaction_temp_id = m.parent_line_id
884: AND w.transaction_temp_id = m.transaction_temp_id

Line 888: FROM mtl_material_transactions_temp m2

884: AND w.transaction_temp_id = m.transaction_temp_id
885: AND w.status = 4
886: AND EXISTS
887: ( SELECT 'x'
888: FROM mtl_material_transactions_temp m2
889: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
890: AND m2.organization_id = m.organization_id
891: AND m2.transaction_temp_id = m2.parent_line_id
892: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 901: , mtl_material_transactions_temp m

897: -- All other picked material
898: SELECT m.transaction_temp_id
899: , 4 dummy_sort
900: FROM wms_dispatched_tasks w
901: , mtl_material_transactions_temp m
902: WHERE m.transfer_lpn_id = p_xfer_lpn_id
903: AND m.transaction_temp_id <> p_temp_id
904: AND m.transaction_temp_id = m.parent_line_id
905: AND w.transaction_temp_id = m.transaction_temp_id

Line 911: FROM mtl_material_transactions_temp m2

907: AND m.content_lpn_id IS NULL
908: AND ( (m.lpn_id IS NOT NULL
909: AND NOT EXISTS
910: ( SELECT 'x'
911: FROM mtl_material_transactions_temp m2
912: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
913: AND m2.organization_id = m.organization_id
914: AND m2.transaction_temp_id = m2.parent_line_id
915: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 924: FROM mtl_material_transactions_temp m3

920: OR m.lpn_id IS NULL
921: )
922: AND NOT EXISTS
923: ( SELECT 'x'
924: FROM mtl_material_transactions_temp m3
925: WHERE m3.transfer_lpn_id = m.transfer_lpn_id
926: AND m3.organization_id = m.organization_id
927: AND m3.transaction_temp_id = m3.parent_line_id
928: AND m3.transaction_temp_id <> m.transaction_temp_id

Line 981: FROM mtl_material_transactions_temp

977: , l_mol_id -- Added for 14699845 (Flexible Lot Allocation)
978: , l_subinventory -- Added for 14699845 (Flexible Lot Allocation)
979: , l_locator_id -- Added for 14699845 (Flexible Lot Allocation)
980: , l_revision -- Added for 14699845 (Flexible Lot Allocation)
981: FROM mtl_material_transactions_temp
982: WHERE transaction_temp_id = p_txn_temp_id;
983:
984: IF (l_debug = 1) THEN
985: mydebug('Org_id: ' || to_char(l_org_id) ||

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

990: END IF;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: IF (l_debug = 1) THEN
994: mydebug(' No data found in mtl_material_transactions_temp ');
995: END IF;
996: END;
997:
998: IF l_content_lpn_id IS NOT NULL THEN

Line 1105: FROM mtl_material_transactions_temp mmtt

1101: END IF;
1102:
1103: SELECT COUNT(transaction_temp_id)
1104: INTO l_count
1105: FROM mtl_material_transactions_temp mmtt
1106: WHERE mmtt.move_order_line_id = l_mo_line_id;
1107:
1108: IF (l_count = 0) THEN
1109: IF (l_debug = 1) THEN

Line 1135: , mtl_material_transactions_temp mmtt

1131: INTO v_lot_control_code
1132: , v_serial_control_code
1133: , v_allocate_serial_flag
1134: FROM mtl_system_items msi
1135: , mtl_material_transactions_temp mmtt
1136: WHERE msi.inventory_item_id = mmtt.inventory_item_id
1137: AND msi.organization_id = mmtt.organization_id
1138: AND mmtt.transaction_temp_id = p_txn_temp_id;
1139: EXCEPTION

Line 1161: FROM mtl_material_transactions_temp

1157: IF (v_lot_control_code = 2 )THEN
1158: IF l_org_id IS NULL THEN
1159: SELECT organization_id
1160: INTO l_org_id
1161: FROM mtl_material_transactions_temp
1162: WHERE transaction_temp_id = p_txn_temp_id;
1163: END IF;
1164: IF ( l_debug = 1 ) THEN
1165: mydebug('l_org_id '||l_org_id);

Line 1181: FROM mtl_material_transactions_temp mmttc, mtl_material_transactions_temp mmttp

1177:
1178: BEGIN
1179: SELECT mmttc.move_order_line_id
1180: INTO l_mol_id
1181: FROM mtl_material_transactions_temp mmttc, mtl_material_transactions_temp mmttp
1182: WHERE mmttc.parent_line_id = mmttp.transaction_temp_id
1183: AND mmttc.parent_line_id <> mmttc.transaction_temp_id
1184: AND mmttc.organization_id = mmttp.organization_id
1185: AND mmttc.organization_id = l_org_id

Line 1226: FROM mtl_material_transactions_temp mmttc, mtl_material_transactions_temp mmttp,

1222: BEGIN
1223:
1224: SELECT mr.lot_number
1225: INTO l_reserved_lot
1226: FROM mtl_material_transactions_temp mmttc, mtl_material_transactions_temp mmttp,
1227: mtl_reservations mr
1228: WHERE mmttc.parent_line_id = mmttp.transaction_temp_id
1229: AND mmttc.transaction_temp_id <> mmttc.parent_line_id
1230: AND mmttc.organization_id = l_org_id

Line 1381: UPDATE mtl_material_transactions_temp

1377: --
1378: -- The lpn ids must be set to null for this task
1379: -- for both parent and child records
1380: --
1381: UPDATE mtl_material_transactions_temp
1382: SET lpn_id = NULL
1383: , content_lpn_id = NULL
1384: , transfer_lpn_id = NULL
1385: , wms_task_status = 1 -- Bug4185621: update mmtt task status back to pending

Line 1393: FROM mtl_material_transactions_temp

1389:
1390: l_count := 0;
1391: SELECT COUNT(*)
1392: INTO l_count
1393: FROM mtl_material_transactions_temp
1394: WHERE transfer_lpn_id = l_transfer_lpn_id;
1395:
1396: IF l_count = 0 THEN
1397: --

Line 1487: FROM mtl_material_transactions_temp

1483: IF(p_allocate_lot_flag <> 'Y' AND p_reserved_lot IS NULL) THEN
1484: IF (p_is_bulk_task = 'Y') THEN
1485: DELETE FROM MTL_TRANSACTION_LOTS_TEMP
1486: WHERE transaction_temp_id IN (SELECT transaction_temp_id
1487: FROM mtl_material_transactions_temp
1488: WHERE parent_line_id = p_txn_temp_id);
1489: ELSE
1490: DELETE FROM MTL_TRANSACTION_LOTS_TEMP
1491: WHERE transaction_temp_id = p_txn_temp_id;

Line 1531: FROM mtl_material_transactions_temp mmtt, mtl_reservations mr

1527: END IF;
1528:
1529: SELECT mr.lot_number
1530: INTO l_reserved_lot
1531: FROM mtl_material_transactions_temp mmtt, mtl_reservations mr
1532: WHERE mmtt.transaction_temp_id = p_temp_id
1533: AND mmtt.organization_id = p_org_id
1534: AND mmtt.reservation_id = mr.reservation_id;
1535: IF ( l_debug = 1 ) THEN