Aviod or in SQL Queries

General

Aviod or in SQL Queries

I have SQL query where I need to use OR extensively .THis query spools out since it uses product join.

Is there any way I can rewrite the below query

SELECT SUM ( T241."DOLLAR_ALLOCATION_PERCENTAGE" * T440."COMP_US_NET_PRICE_AMOUNT" ) AS c1,

        T214834."CEC_ID" AS c2,

        T214831."MANAGER_CEC_ID" AS c3,

        T214834."QUOTA_NAME" AS c4,

        T214834."SALES_TERR_NAME" AS c5

        FROM "BV_TMS_SALES_ALLOCATED" T241,

            "BV_SALES_HIERARCHY" T262,

            "BV_BOOKINGS" T440,

            "BV_MANAGER_VIEW" T214831,

            "BV_MT_PSS_TMS_SALES_TERR_LINK" T214834

        WHERE ( T241."ITEM_KEY" = T440."PRODUCT_KEY"

                      AND T262."SALES_TERRITORY_KEY" = T440."SALES_TERRITORY_KEY"

                    AND T440."CORPORATE_BOOKINGS_FLG" = 'Y'

                 AND T440."SERVICE_FLG" = 'N'

AND T214831."MANAGER_CEC_ID" = T214834."CEC_ID"

AND T214831."MANAGER_CEC_ID" = 'bpitts'

AND T214834."SALES_HIER_TYPE_CD" = 'CORP. REVENUE'

AND T214834."PRODUCT_OR_SERVICE_CD" = 'PRODUCT'

AND ( T241."L3_TECHNOLOGY_MKT_SEGMENT_NAME" = T214834."TECH_MKT_SEGMENT_NAME"

OR T241."L1_TECHNOLOGY_MKT_SEGMENT_NAME" = T214834."TECH_MKT_SEGMENT_NAME"

OR T241."L2_TECHNOLOGY_MKT_SEGMENT_NAME" = T214834."TECH_MKT_SEGMENT_NAME"

OR T241."L4_TECHNOLOGY_MKT_SEGMENT_NAME" = T214834."TECH_MKT_SEGMENT_NAME" )

 AND ( T262."L5_SALES_TERRITORY_DESCR" = T214834."SALES_TERRITORY_DESC"

OR T262."L4_SALES_TERRITORY_DESCR" = T214834."SALES_TERRITORY_DESC"

OR T262."L3_SALES_TERRITORY_DESCR" = T214834."SALES_TERRITORY_DESC"

OR T262."L1_SALES_TERRITORY_DESCR" = T214834."SALES_TERRITORY_DESC"

OR T262."L2_SALES_TERRITORY_DESCR" = T214834."SALES_TERRITORY_DESC"

OR T262."L6_SALES_TERRITORY_DESCR" = T214834."SALES_TERRITORY_DESC" ) )

        GROUP BY T214831."MANAGER_CEC_ID",

            T214834."CEC_ID",

            T214834."SALES_TERR_NAME",

            T214834."QUOTA_NAME"