Finding Parent Instance by using Child instance in Installed base 11i

Hi,

I m working on query to find the Parent using Child instance in Installed base 11i.

I will be passing child instance id as a input parameter and i would need all its parents as shown below.

If you have any query ..could you share

122-XXX-YYY        => Parent Instance id

   755-XXX-YYY     => Parent Instance id

      343-XXX-YYY  => Parent Instance id

        64700000    => Child instance id

select distinct ciip.serial_number,

ciip.instance_id parent_instance_id,

ciic.instance_id child_instance_id

from

csi_item_instances ciip,

csi_ii_relationships cir,

csi_item_instances ciic,

mtl_system_items_b msip,

mtl_system_items_b msic