$P{adtm_end} ) ) OR ( ( dpdeptmaster.deptclose_status = 1 ) AND ( DPDEPTMASTER.DEPTCLOSE_DATE between $P{adtm_bf} and $P{adtm_end} ) ) ) ) AND ( DPDEPTSTATEMENT.OPERATE_DATE between $P{adtm_start} and $P{adtm_end} ) AND ( DPDEPTTYPE.DEPTTYPE_CODE between $P{as_start_type} and $P{as_end_type} AND "MBMEMBMASTER"."MEMBGROUP_CODE" between $P{membgroup_start} and $P{membgroup_end} ) AND "DPDEPTSTATEMENT"."DEPTITEMTYPE_CODE" <> 'AJO' AND "DPDEPTSTATEMENT"."ITEM_STATUS" = 1 GROUP BY DPDEPTTYPE.DEPTTYPE_CODE, DPDEPTTYPE.DEPTTYPE_DESC, MBUCFMEMBGROUP.MEMBGROUP_CODE, MBUCFMEMBGROUP.MEMBGROUP_DESC, MBMEMBMASTER.MEMBER_NO, MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, DPDEPTMASTER.DEPTACCOUNT_NO,"CMCOOPMASTER"."COOP_NAME" order by DPDEPTTYPE.DEPTTYPE_CODE,MBUCFMEMBGROUP.MEMBGROUP_CODE]]>