1841: FROM oe_order_headers_all ooh,
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