BOM Explosion

➜ Back to Library
Description
Run BOM Explosion and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
CAC Calculate ICP PII Item Costs by Where Used WSH Packing Slip Report PDF Output BOM Bill of Material Structure TESTEP BOM XXDPF Shortages WIP MES Job Traveler Data Template BOM Models BOM Bill of Material Loop Report GUI BOM Structure Report for Lead Times
Blitz Report™

Blitz Report™ provides multiple benefits: