1781: FROM oe_order_headers_all ooh,
1782: oe_order_lines_all ool,
1783: mtl_system_items msi,
1784: mtl_unit_transactions mut,
1785: mtl_material_transactions mmt,
1786: mtl_secondary_inventories msei,
1787: hr_all_organization_units haou
1788: WHERE mmt.transaction_id = p_trx_id
1789: AND mmt.transaction_id = mut.transaction_id(+)
1842: oe_order_lines_all ool,
1843: mtl_system_items msi,
1844: mtl_unit_transactions mut,
1845: mtl_transaction_lot_numbers mtln,
1846: mtl_material_transactions mmt,
1847: mtl_secondary_inventories msei,
1848: hr_all_organization_units haou
1849: WHERE mmt.transaction_id = p_trx_id
1850: AND mmt.transaction_id = mtln.transaction_id(+)
8792: INTO l_inventory_item_id,
8793: l_organization_id,
8794: l_source_line_id,
8795: l_source_quantity
8796: FROM mtl_material_transactions
8797: WHERE transaction_id = p_mtl_txn_id;
8798:
8799: csi_interface_pkg.get_source_info(
8800: p_source_table => l_oke_source_table,