BOM Extract Query(Bill Of materials)

/* Formatted on 2020/02/25 16:49 (Formatter Plus v4.8.8) */
SELECT ood.organization_code, ood.organization_name, msi.segment1 bom_code,
       msi.description bom_desc, bic.item_num, bic.operation_seq_num,
       msi1.segment1 component_code, msi1.description component_desc,
       ml.meaning supply_type, bic.component_quantity, bic.effectivity_date,
       bic.disable_date, msi1.inventory_item_status_code,
       bic.supply_subinventory, bic.wip_supply_type
  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 ml.lookup_type(+) = 'WIP_SUPPLY'