Oracle Ebs-sql (BOM-18): Checks the BOM against the route. SQL

/* There is a route, no BOM */

Select Msi.segment1,

Msi.description

From apps. Bom_operational_routings Bor,

Apps.mtl_system_items_b MSI

where msi.organization_id=y

and bor.organization_id=msi.organization_id

and bor.assembly_item_id=msi.inventory_item_id

And NOT EXISTS (select ' X '

From apps. Bom_bill_of_materials Bbom

where bbom.assembly_item_id=bor.assembly_item_id

and bbom.organization_id=bor.organization_id)

--------------------------------------------------------------------------------------------

/* No route, BOM list */

Select Msi.segment1,

Msi.description

From apps. Bom_bill_of_materials Bbom,

Apps.mtl_system_items_b MSI

where msi.organization_id=y

and bbom.organization_id=msi.organization_id

and bbom.assembly_item_id=msi.inventory_item_id

And NOT EXISTS (select ' X '

From apps. Bom_operational_routings Bor

where bor.assembly_item_id=bbom.assembly_item_id

                               and    bor.organization_id= BBOM.ORGANIZATION_ID)