ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A794BDEC93CA0780E053B46B6358206B 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 Y US BOM Explosion 1=1