SQL query running very slow

Hi Team,

We're executing the below SQL query, but looks like the query is running very slow:

SELECT DISTINCT i.itemcode, i.type, i.baseitemcode, i.itemtype, i.name, i.status, i.label, i.description, i.orderable, i.ownerid, i.updatedby, i.lastupdateddate, i.cwcreatedby, i.cwcreated, i.cwdocstamp, i.startdate, i.enddate, i.classificationtypes, enforceactions FROM CWPC_ITEM i where i.ITEMTYPE = 'OptionPack' AND i.itemcode in (select distinct ia0.ITEMCODE from CWPC_ITEMATTRIBUTE_V ia0 where ia0.itemcode like 'OP_%' AND ia0.startdate < TO_DATE('2017-04-26 16:48:32', 'YYYY-MM-DD HH24:MI:SS') AND ia0.ATTRIBUTECODE='Circle' AND ia0.DEFAULTVALUE = 'MH' AND ia0.itemcode in (select distinct ia1.ITEMCODE from CWPC_ITEMATTRIBUTE_V ia1 where ia1.itemcode like 'OP_%' AND ia1.startdate < TO_DATE('2017-04-26 16:48:32', 'YYYY-MM-DD HH24:MI:SS') AND ia1.ATTRIBUTECODE='BillPlanCode' AND ia1.DEFAULTVALUE = 'MH_BP_00092' ))