title: How to replace the IN operator with EXISTS operator, for the where clause part of the query?
body: <pre><code>WHERE ( 
  ((SERVICECOMPONENT_ID IN (123, 150, 198, 199, 290, 287, 291, 289, 288, 286, 282, 281)))  
  
  OR ((SERVICEREQUEST_ID IN ( 
          SELECT distinct(SR.SERVICEREQUEST_ID) 
          FROM SERVICE_REQUEST SR,ASSIGNED_SR_PROJECTS ASP,PROJECT_RESOURCES PRS 
          WHERE SR.SERVICEREQUEST_ID = ASP.SERVICEREQUEST_ID 
          AND PRS.PROJECT_ID = ASP.PROJECT_ID 
          AND PRS.RESPONSIBILITY IN ('MANAGER','LEAD') 
          AND PRS.RESOURCE_ID =180 )) )
  </code></pre>
  
  <p>)</p>