schockalingam

SELECT
   unpostable.created,
   unpostable.id,
   erarecord.controlnumber,
   unpostable.unpostabletypeid,
   kickreasoncategory.name,
   CASE WHEN regexp_like(erarecord.controlnumber,?) THEN 1 ELSE 0 END firsttest,
   CASE WHEN regexp_like(erarecord.controlnumber,?) THEN 1 ELSE 0 END secondtest,
   CASE WHEN regexp_like(erarecord.controlnumber,?) THEN 1 ELSE 0 END thirdtest,
   CASE WHEN regexp_like(erarecord.controlnumber,?) THEN 1 ELSE 0 END fourthtest,
FROM
   erarecord,
   unpostable,
   kickreasoncategory
WHERE
   unpostable.erarecordid = erarecord.id (+)
   AND ( regexp_like(erarecord.controlnumber,?)
           OR regexp_like(erarecord.controlnumber,?)
           OR regexp_like(erarecord.controlnumber,?)
           OR regexp_like(erarecord.controlnumber,?)
    )
    AND unpostable.created BETWEEN to_date(?,'MM/DD/YYYY') AND to_date(?, 'MM/DD/YYYY')
    AND unpostable.kickreasoncategoryid = kickreasoncategory.id
    AND unpostable.unpostabletypeid NOT IN ('NOMATCHINGCHARGE','ROUTETOOTHER')
    AND unpostable.createdby <> 'ATHENA'
    AND unpostable.voided IS NULL