Oracle Ebs-sql (BOM-9): Checks the total system BOM. SQL

SELECT
Itm. SEGMENT1 Material Coding
Itm. DESCRIPTION Material Description
, Bom2. Creation_date Date Created
, BOM2. Alternate_bom_designator Alternative BOM
, fu.description operator
From INV. Mtl_system_items_b ITM,
Apps. Bom_bill_of_materials Bom2,
Applsys.fnd_user FU
WHERE
Itm. Inventory_item_status_code <> ' Inactive ' and
EXISTS
(
SELECT com.component_item_id
From apps. Bom_inventory_components COM,
Apps. Bom_bill_of_materials BOM
WHERE
Rownum=1 and
Com. Effectivity_date<=sysdate and
(COM. Disable_date is NULL OR COM. Disable_date>sysdate) and
Bom. Bill_sequence_id=com. BILL_SEQUENCE_ID and
Bom. Assembly_item_id=itm. INVENTORY_ITEM_ID and
BOM.ORGANIZATION_ID=ITM.ORGANIZATION_ID) and
itm.organization_id =x and
FU. User_id=bom2. Created_by and
Bom2. ASSEMBLY_ITEM_ID=ITM.INVENTORY_ITEM_ID and
bom2.organization_id =x and
Itm. SEGMENT1 like ' 31% '