Oracle Ebs-sql (BOM-5): Checks for items that have a BOM but the item status is new. SQL

Select DISTINCT
     msi.segment1  finished encoding
   , Msi.description finished product description
   , msi.item_type item type
    ,msi.inventory_item_status_code status
   , Msi.build_in_wip_flag allows the manufacture of
from
    INV. Mtl_system_items_b MSI,
    apps. Bom_bill_of_materials BOM,
    apps. Bom_inventory_components Bic
where
         msi.organization_id=x
   BOM. Organization_id=x
   and  bom.assembly_item_id=msi.inventory_item_id
   and bom.bill_sequence_id=bic.bill_sequence_id
   and Bic. Disable_date is null
--and msi.build_in_wip_flag = ' N '   --can be manufactured
   and Msi.inventory_item_ Status_code= ' New '
Order by msi.segment1