select ECONOMIC_ACTS_RECID , ECONOMIC_ACT_DESC , CLAUSE_CODE , CLAUSE_ARTICLE_ID , CLAUSE_Desc , DEPT_NAME , CNT from
(select TBL.ECONOMIC_ACTS_RECID , TBL.ECONOMIC_ACT_DESC , TBL.CLAUSE_CODE , TBL.CLAUSE_ARTICLE_ID , TBL.CLAUSE_Desc , TBL.DEPT_NAME , TBL.CNT , ROWNUM RN  from
 ( SELECT m.ECONOMIC_ACTS_RECID ,
  (SELECT act.ECONOMIC_ACT_DESC
  FROM MOSAL_USER.PMP_ECONMIC_ACTS act
  WHERE act.ECONOMIC_ACTS_RECID = m.ECONOMIC_ACTS_RECID
  ) ECONOMIC_ACT_DESC,
  d.CLAUSE_CODE,
  (SELECT cla.LAW_ARTICLE_ID
  FROM INS_LAW_CLAUSE cla
  WHERE cla.CLAUSE_CODE = d.CLAUSE_CODE
  ) CLAUSE_ARTICLE_ID ,
  (SELECT cla.LAW_ARTICLE_DESC
  FROM INS_LAW_CLAUSE cla
  WHERE cla.CLAUSE_CODE = d.CLAUSE_CODE
  ) CLAUSE_Desc ,
  SYS_PKG.GET_LOOKUP_NAME(2,DEPT_CODE) DEPT_name,
  COUNT(*) CNT
FROM INS_VISIT_ORDER R,
  INS_VIOLATION_AVOIDANCE_DTL D,
  (SELECT LF_RECID,ECONOMIC_ACTS_RECID,DEPT_CODE FROM NMP_LICNFILE_MV
  )M
WHERE M.LF_RECID           = R.LF_RECID
AND D.VISIT_ID             = R.VISIT_ID
AND M.ECONOMIC_ACTS_RECID IS NOT NULL
AND DEPT_CODE              = :pDeptId
GROUP BY ECONOMIC_ACTS_RECID ,
  CLAUSE_CODE,
  DEPT_CODE
order by COUNT(*)DESC ) TBL)