= $P{adtm_sdate} ) and ( DPDEPTSLIP.DEPTSLIP_DATE <= $P{adtm_edate} ) and ( DPDEPTMASTER.DEPTCLOSE_STATUS = 1 ) and ( DPUCFDEPTITEMTYPE.DEPTITEM_GROUP = 'CLS' ) and ( DPDEPTSLIP.COOP_ID = $P{coop_id} ) and ( DPDEPTMIDGROUP.DEPTTYPE_GROUP >= $P{as_type1} ) and ( DPDEPTMIDGROUP.DEPTTYPE_GROUP <= $P{as_type2} ) and ( DPDEPTSLIP.SHOWFOR_DEPT = 1 ) and ( DPDEPTSLIP.ITEM_STATUS = 1 ) order by depttype_group]]>