0 ) and ( DPDEPTSLIP.SHOWFOR_DEPT = 1 ) and cmcoopmaster.coop_id =$P{coop_id} GROUP BY DPDEPTSLIP.ENTRY_DATE ,DPDEPTSLIP.RECPPAYTYPE_CODE ,DPDEPTTYPE.DEPTTYPE_DESC, cmcoopmaster.coop_name order by DPDEPTTYPE.DEPTTYPE_DESC]]>