Oracle Ebs-sql (BOM-11): Check for assemblies without BOM. SQL

Select Msi.segment1,

Msi.description,,

Msi.item_type,

Msi.inventory_item_status_code status

From Inv.mtl_system_items_b MSI

where msi.organization_id = X

and Msi.item_type in (' FG ', ' SA ')

and Msi.inventory_item_status_code <> ' Inactive '

And NOT EXISTS (select null from Bom.bom_structures_b BSB,

Bom.bom_components_b BCB

where bsb.organization_id = msi.organization_id

and bsb.assembly_item_id = msi.inventory_item_id

and bsb.bill_sequence_id = bcb.bill_sequence_id

and NVL (bcb.disable_date,sysdate+1) > Sysdate

and rownum = 1)