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(+)
1790: AND msi.organization_id = mmt.organization_id
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(+)
1851: AND mtln.serial_transaction_id = mut.transaction_id(+)