SELECT * FROM 
(SELECT r.*, ROWNUM RNUM, COUNT(*) OVER () totalNumberOfRecords  FROM 
(SELECT DISTINCT req.agcy_srvc_reqst_id reqId, req.SRVC_REQST_COR_RN refNo, req.reqstr_cd requesterCode, req.curr_reqst_status_cd requestStatusCode,
req.inqrd_party_cd partyTypeCode,req.SRVC_TYPE_CD serviceTypeCode, req.PROCESS_TYPE_CD processTypeCode, req.BUS_SRVC_CD businessServiceTypeCode,
execSum.STATUS executionStatus, execSum.POST_ACTION_SRN postActionSRN  
FROM agcy_srvc_reqst req  LEFT JOIN involved_party invparty ON invparty.agcy_srvc_reqst_id = req.agcy_srvc_reqst_id  
LEFT JOIN EXETR_SRVC_TASK exter ON req.agcy_srvc_reqst_id = exter.agcy_srvc_reqst_id  
LEFT JOIN EXEC_SUMMARY execSum ON execSum.srvc_reqst_srn = req.SRVC_REQST_COR_RN OR execSum.post_action_srn = req.SRVC_REQST_COR_RN 
LEFT JOIN EXEC_ACC_INFO execAcc ON exter.exetr_srvc_task_id = execAcc.exetr_srvc_task_id  
LEFT JOIN PRD_USR_LST prdusr ON prdusr.PRD_ID = execAcc.EXEC_ACC_INFO_ID  
WHERE 1=1  AND req.SRVC_REQST_COR_RN = ?  AND req.reqstr_cd = ? ) R) WHERE RNUM between ?  and ?