Oracle R12 lot genealogy

Query to find lot genealogy

SELECT   TO_CHAR (mmt.transaction_date, 'DD-MON-YYYY') transaction_date,
         mln.lot_number, msi.segment1 item,msi.description,
         transaction_quantity,msi.primary_uom_code uom,mmt.new_cost cost
    FROM (
          SELECT     mog.object_id , ROWNUM slno, origin_txn_id
                FROM mtl_object_genealogy mog
               WHERE 1 = 1
          CONNECT BY PRIOR mog.object_id IN (mog.parent_object_id)
          START WITH mog.parent_object_id = 1103) hier,
         mtl_lot_numbers mln,
         mtl_material_transactions mmt,
         mtl_system_items_b msi,
         mtl_transaction_types mtt
   WHERE hier.object_id = mln.gen_object_id
     AND hier.origin_txn_id = mmt.transaction_id
     AND mmt.inventory_item_id = msi.inventory_item_id
     AND mmt.organization_id = msi.organization_id
     AND mmt.transaction_type_id = mtt.transaction_type_id
ORDER BY hier.slno