APPS.WMS_OP_INBOUND_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 749: UPDATE mtl_txn_request_lines

745: SAVEPOINT sp_revert_crossdock;
746:
747: l_progress := 20;
748:
749: UPDATE mtl_txn_request_lines
750: SET backorder_delivery_detail_id = NULL
751: , to_subinventory_code = NULL
752: , to_locator_id = NULL
753: , crossdock_type = NULL

Line 1030: mtl_txn_request_lines mol

1026: mmtt.transfer_to_location,
1027: mmtt.locator_id
1028: FROM mtl_material_transactions_temp mmtt,
1029: mtl_secondary_inventories msi,
1030: mtl_txn_request_lines mol
1031: WHERE mmtt.transaction_temp_id = p_source_task_id
1032: AND Nvl(mmtt.transfer_subinventory, mmtt.subinventory_code) = msi.secondary_inventory_name (+)
1033: AND mmtt.organization_id = msi.organization_id (+)
1034: AND mol.line_id = mmtt.move_order_line_id;

Line 1184: FROM mtl_txn_request_lines

1180: l_progress := 42;
1181:
1182: SELECT backorder_delivery_detail_id
1183: INTO l_backorder_delivery_detail_id
1184: FROM mtl_txn_request_lines
1185: WHERE line_id = p_document_rec.move_order_line_id;
1186:
1187: l_progress := 44;
1188:

Line 1403: FROM mtl_txn_request_lines

1399: l_progress := 49;
1400:
1401: SELECT uom_code
1402: INTO l_mol_uom_code
1403: FROM mtl_txn_request_lines
1404: WHERE line_id = p_document_rec.move_order_line_id;
1405:
1406: l_progress := 50;
1407:

Line 1450: UPDATE mtl_txn_request_lines

1446: END IF; -- IF l_mol_uom_code <> p_document_rec.transaction_uom
1447:
1448: l_progress := 80;
1449:
1450: UPDATE mtl_txn_request_lines
1451: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
1452: lpn_id =(SELECT Nvl(mmtt.transfer_lpn_id, mmtt.content_lpn_id)
1453: FROM mtl_material_transactions_temp mmtt
1454: WHERE mmtt.transaction_temp_id = p_document_rec.transaction_temp_id),

Line 1549: FROM mtl_txn_request_lines

1545:
1546: -- if MOL UOM has not been queried previously
1547: SELECT uom_code
1548: INTO l_mol_uom_code
1549: FROM mtl_txn_request_lines
1550: WHERE line_id = p_document_rec.move_order_line_id;
1551:
1552: l_progress := 140;
1553:

Line 1601: UPDATE mtl_txn_request_lines

1597: print_debug('Before update MOL.quantity_delivered. l_qty_in_mol_uom = '||l_qty_in_mol_uom, l_module_name,4);
1598: END IF;
1599:
1600: l_progress := 170;
1601: UPDATE mtl_txn_request_lines
1602: SET line_status = g_to_status_closed,
1603: quantity_delivered = Nvl(quantity_delivered, 0) + l_qty_in_mol_uom --,
1604: -- lpn_id =(SELECT Nvl(mmtt.transfer_lpn_id, mmtt.content_lpn_id)
1605: -- FROM mtl_material_transactions_temp mmtt

Line 1631: FROM mtl_txn_request_lines

1627: l_progress := 190;
1628:
1629: SELECT uom_code
1630: INTO l_mol_uom_code
1631: FROM mtl_txn_request_lines
1632: WHERE line_id = p_document_rec.move_order_line_id;
1633:
1634: l_progress := 200;
1635:

Line 1679: UPDATE mtl_txn_request_lines

1675: END IF; -- IF l_mol_uom_code <> p_document_rec.transaction_uom
1676:
1677: l_progress := 230;
1678:
1679: UPDATE mtl_txn_request_lines
1680: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom
1681: WHERE line_id = p_document_rec.move_order_line_id;
1682:
1683: l_progress := 240;

Line 1839: UPDATE mtl_txn_request_lines

1835: -- In this case this LPN becomes the lpn_id for next MMTT.
1836:
1837: l_new_lpn_id := Nvl(l_mmtt_data_rec.transfer_lpn_id, l_mmtt_data_rec.content_lpn_id);
1838:
1839: UPDATE mtl_txn_request_lines
1840: SET lpn_id = Nvl(l_mmtt_data_rec.transfer_lpn_id, l_mmtt_data_rec.content_lpn_id)
1841: WHERE line_id = p_document_rec.move_order_line_id;
1842:
1843: l_progress := 258;

Line 2276: FROM mtl_txn_request_lines mol

2272: l_progress := 30;
2273:
2274: SELECT mol.lpn_id
2275: INTO l_mol_lpn_id
2276: FROM mtl_txn_request_lines mol
2277: WHERE mol.line_id =
2278: (SELECT move_order_line_id
2279: FROM mtl_material_transactions_temp
2280: WHERE transaction_temp_id = p_source_task_id);

Line 2527: mtl_txn_request_lines mol

2523: mmtt.repetitive_line_id,
2524: mmtt.operation_seq_num,
2525: mmtt.primary_quantity
2526: FROM mtl_material_transactions_temp mmtt,
2527: mtl_txn_request_lines mol
2528: WHERE transaction_temp_id = p_source_task_id
2529: AND mmtt.move_order_line_id = mol.line_id;
2530:
2531: CURSOR c_parent_mmtt_rec(v_txn_temp_id NUMBER) IS

Line 2722: UPDATE mtl_txn_request_lines

2718: IF (l_debug=1) THEN
2719: print_debug('Task is loaded... do not update quantity_detailed. '||l_return_status,l_module_name,4);
2720: END IF;
2721: ELSE
2722: UPDATE mtl_txn_request_lines
2723: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom
2724: WHERE line_id = l_mmtt_data_rec.move_order_line_id;
2725:
2726: IF (l_debug=1) THEN

Line 2743: UPDATE mtl_txn_request_lines

2739: END IF;
2740:
2741: l_progress := 100;
2742:
2743: UPDATE mtl_txn_request_lines
2744: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
2745: line_status = g_to_status_closed
2746: WHERE line_id = l_mmtt_data_rec.move_order_line_id;
2747: