1722: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1723: FROM oe_order_headers_all ooh,
1724: oe_order_lines_all ool,
1725: mtl_system_items msi,
1726: mtl_unit_transactions mut,
1727: mtl_material_transactions mmt,
1728: mtl_secondary_inventories msei,
1729: hr_all_organization_units haou
1730: WHERE mmt.transaction_id = p_trx_id
1781: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1782: FROM oe_order_headers_all ooh,
1783: oe_order_lines_all ool,
1784: mtl_system_items msi,
1785: mtl_unit_transactions mut,
1786: mtl_transaction_lot_numbers mtln,
1787: mtl_material_transactions mmt,
1788: mtl_secondary_inventories msei,
1789: hr_all_organization_units haou