Query to find BOM Components

SELECT msi.segment1 “Parent material coding”,
       msi.description “Parent item description”,
       msi1.segment1 “Sub item code”,
       msi1.description “Sub item description”
  FROM mtl_system_items_b msi,
       bom_bill_of_materials bom,
       bom_inventory_components bic,
       mtl_system_items_b msi1
 WHERE     1 = 1
       AND msi.organization_id = 91
       AND msi.inventory_item_id = bom.assembly_item_id
       AND msi.organization_id = bom.organization_id
       AND bom.organization_id = 91
       AND bom.alternate_bom_designator IS NULL
       AND bom.bill_sequence_id = bic.bill_sequence_id
       AND bic.disable_date IS NULL
       AND bic.component_item_id = msi1.inventory_item_id
       AND msi1.organization_id = 91
       AND msi.segment1 IN (‘00603141A48R’)         — Parent Item
—   AND msi1.segment1 in (‘MD150’) — The child