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_OP_INBOUND_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 761: UPDATE mtl_txn_request_lines

757: SAVEPOINT sp_revert_crossdock;
758:
759: l_progress := 20;
760:
761: UPDATE mtl_txn_request_lines
762: SET backorder_delivery_detail_id = NULL
763: , to_subinventory_code = NULL
764: , to_locator_id = NULL
765: , crossdock_type = NULL

Line 1069: mtl_txn_request_lines mol

1065: mmtt.transfer_to_location,
1066: mmtt.locator_id
1067: FROM mtl_material_transactions_temp mmtt,
1068: mtl_secondary_inventories msi,
1069: mtl_txn_request_lines mol
1070: WHERE mmtt.transaction_temp_id = p_source_task_id
1071: AND Nvl(mmtt.transfer_subinventory, mmtt.subinventory_code) = msi.secondary_inventory_name (+)
1072: AND mmtt.organization_id = msi.organization_id (+)
1073: AND mol.line_id = mmtt.move_order_line_id;

Line 1223: FROM mtl_txn_request_lines

1219: l_progress := 42;
1220:
1221: SELECT backorder_delivery_detail_id
1222: INTO l_backorder_delivery_detail_id
1223: FROM mtl_txn_request_lines
1224: WHERE line_id = p_document_rec.move_order_line_id;
1225:
1226: l_progress := 44;
1227:

Line 1442: FROM mtl_txn_request_lines

1438: l_progress := 49;
1439:
1440: SELECT uom_code,secondary_uom_code --Bug#7716519, stored sec_uom from MTRL in l_mol_sec_uom_code
1441: INTO l_mol_uom_code,l_mol_sec_uom_code
1442: FROM mtl_txn_request_lines
1443: WHERE line_id = p_document_rec.move_order_line_id;
1444: l_progress := 50;
1445:
1446: IF (l_debug=1) THEN

Line 1488: UPDATE mtl_txn_request_lines

1484:
1485: END IF; -- IF l_mol_uom_code <> p_document_rec.transaction_uom
1486: l_progress := 80;
1487:
1488: UPDATE mtl_txn_request_lines
1489: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
1490: secondary_quantity_detailed = secondary_quantity_detailed - l_mol_sec_qty, --Bug#7716519
1491: lpn_id =(SELECT Nvl(mmtt.transfer_lpn_id, mmtt.content_lpn_id)
1492: FROM mtl_material_transactions_temp mmtt

Line 1589: FROM mtl_txn_request_lines

1585:
1586: -- if MOL UOM has not been queried previously
1587: SELECT uom_code
1588: INTO l_mol_uom_code
1589: FROM mtl_txn_request_lines
1590: WHERE line_id = p_document_rec.move_order_line_id;
1591:
1592: l_progress := 140;
1593:

Line 1645: UPDATE mtl_txn_request_lines

1641: print_debug('Before update MOL.quantity_delivered. l_sec_qty_in_mol_uom = '||l_mol_sec_qty, l_module_name,4); --Bug# 7716519
1642: END IF;
1643:
1644: l_progress := 170;
1645: UPDATE mtl_txn_request_lines
1646: SET line_status = g_to_status_closed,
1647: quantity_delivered = Nvl(quantity_delivered, 0) + l_qty_in_mol_uom,
1648: secondary_quantity_delivered = Nvl(secondary_quantity_delivered, 0) + l_mol_sec_qty -- Bug# 7716519
1649: WHERE line_id = p_document_rec.move_order_line_id;

Line 1673: FROM mtl_txn_request_lines

1669: l_progress := 190;
1670:
1671: SELECT uom_code
1672: INTO l_mol_uom_code
1673: FROM mtl_txn_request_lines
1674: WHERE line_id = p_document_rec.move_order_line_id;
1675:
1676: l_progress := 200;
1677:

Line 1722: UPDATE mtl_txn_request_lines

1718: END IF; -- IF l_mol_uom_code <> p_document_rec.transaction_uom
1719:
1720: l_progress := 230;
1721:
1722: UPDATE mtl_txn_request_lines
1723: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
1724: secondary_quantity_detailed = secondary_quantity_detailed - l_mol_sec_qty
1725: WHERE line_id = p_document_rec.move_order_line_id;
1726:

Line 1883: UPDATE mtl_txn_request_lines

1879: -- In this case this LPN becomes the lpn_id for next MMTT.
1880:
1881: l_new_lpn_id := Nvl(l_mmtt_data_rec.transfer_lpn_id, l_mmtt_data_rec.content_lpn_id);
1882:
1883: UPDATE mtl_txn_request_lines
1884: SET lpn_id = Nvl(l_mmtt_data_rec.transfer_lpn_id, l_mmtt_data_rec.content_lpn_id)
1885: WHERE line_id = p_document_rec.move_order_line_id;
1886:
1887: l_progress := 258;

Line 2344: FROM mtl_txn_request_lines mol

2340: l_progress := 30;
2341:
2342: SELECT mol.lpn_id
2343: INTO l_mol_lpn_id
2344: FROM mtl_txn_request_lines mol
2345: WHERE mol.line_id =
2346: (SELECT move_order_line_id
2347: FROM mtl_material_transactions_temp
2348: WHERE transaction_temp_id = p_source_task_id);

Line 2598: mtl_txn_request_lines mol

2594: mmtt.operation_seq_num,
2595: mmtt.primary_quantity,
2596: mmtt.secondary_transaction_quantity --BUG10285949
2597: FROM mtl_material_transactions_temp mmtt,
2598: mtl_txn_request_lines mol
2599: WHERE transaction_temp_id = p_source_task_id
2600: AND mmtt.move_order_line_id = mol.line_id;
2601:
2602: CURSOR c_parent_mmtt_rec(v_txn_temp_id NUMBER) IS

Line 2796: UPDATE mtl_txn_request_lines

2792: IF (l_debug=1) THEN
2793: print_debug('Task is loaded... do not update quantity_detailed. '||l_return_status,l_module_name,4);
2794: END IF;
2795: ELSE
2796: UPDATE mtl_txn_request_lines
2797: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
2798: secondary_quantity_detailed = secondary_quantity_detailed - l_sec_qty_in_mol --BUG10285949
2799: WHERE line_id = l_mmtt_data_rec.move_order_line_id;
2800:

Line 2818: UPDATE mtl_txn_request_lines

2814: END IF;
2815:
2816: l_progress := 100;
2817:
2818: UPDATE mtl_txn_request_lines
2819: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
2820: secondary_quantity_detailed = secondary_quantity_detailed - l_sec_qty_in_mol, --BUG10285949
2821: line_status = g_to_status_closed
2822: WHERE line_id = l_mmtt_data_rec.move_order_line_id;