Query to findout list of components for manufactured Bill of material

select  distinct ood.organization_code,
--ood.organization_id,
--bom.assembly_item_id,
  msi.segment1, 
msi.description ,
bic.item_num,
bic.operation_seq_num,
--bic.component_item_id, 
msi1.segment1 COMPONENT,
ml.meaning,
--bic.wip_supply_type,
bic.effectivity_date,
bic.disable_date
--bic.*
from
mtl_system_items_b msi,
org_organization_definitions ood,
bom_bill_of_materials bom,
bom_inventory_components bic,
mtl_system_items_b msi1,
mfg_lookups ml
where bom.assembly_item_id = msi.inventory_item_id
and bom.bill_sequence_id = bic.bill_sequence_id
and msi.organization_id = ood.organization_id
and bom.organization_id = ood.organization_id
and msi1.inventory_item_status_code ='Active'
and bic.component_item_id = msi1.inventory_item_id
and msi1.organization_id = ood.organization_id
and ml.lookup_code(+) = bic.wip_supply_type
and bic.wip_supply_type =4
--and nvl(bic.disable_date,sysdate) >= sysdate
and ml.lookup_type(+) = 'WIP_SUPPLY'
and ood.organization_id = 143
and  msi.segment1 in ('08140070');
--and  msi1.segment1 in ('01000013');