BOM Explosion

Description
SELECT
level,
bom.assembly_item_id,
bic.component_item_id,
msi.inventory_item_id,
msi.segment1,
bom.alternate_bom_designator alterBom,
msil.segment1 Cod_Component,
msil.description Desc_Component,
BIC.component_quantity
from
mtl_system_items msi,
bom_bill_of_materials bom,
BOM_INVENTORY_COMPONENTS BIC,
MTL_SYSTEM_ITEMS MSIL
WHERE
1=1
and BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION
AND bom.bill_sequence_id = bic.bill_sequence_id
AND nvl(bic.disable_date, sysdate) >= SYSDATE
AND BIC.component_ITEM_ID = MSIL.INVENTORY_ITEM_ID
AND Bom.ORGANIZATION_ID = MSIL.ORGANIZATION_ID
connect by prior bic.component_item_id = bom.assembly_item_id
START WITH msi.inventory_item_id = 1