=$P{adtm_sdate} OR "MBMEMBMASTER"."RESIGN_DATE" is null OR to_char( mbmembmaster.resign_date,'dd/mm/yyyy') = '01/01/1900' ) AND MBMEMBMASTER.MEMBER_DATE <=$P{adtm_edate} ) GROUP BY "MBMEMBMASTER"."MEMB_NAME","MBMEMBMASTER"."MEMBER_NO", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_SURNAME","MBMEMBMASTER"."CARD_PERSON", "MBMEMBMASTER"."MEMBGROUP_CODE","MBMEMBMASTER"."SEX", "CMCOOPMASTER"."COOP_NAME", "MBUCFMEMBGROUP"."MEMBGROUP_DESC","SHSHAREMASTER".sharebegin_amt, "MBMEMBMASTER"."MEMBER_DATE" ,"MBMEMBMASTER"."RESIGN_STATUS" HAVING sum( case when ( shsharestatement.shritemtype_code in ('SPX','SPN','SPM','RPM') and TRUNC(shsharestatement.slip_date) >= $P{adtm_sdate} and TRUNC(shsharestatement.slip_date) <= $P{adtm_edate} ) then shsharestatement.share_amount else 0 end ) >0 or abs(sum( case when ( shsharestatement.shritemtype_code in ('SWD','RWD','STL','RTL') and TRUNC(shsharestatement.slip_date) >= $P{adtm_sdate} and TRUNC(shsharestatement.slip_date) <= $P{adtm_edate} ) then shsharestatement.share_amount else 0 end ))>0 or SHAREBEGIN_AMT >0 order by "MBMEMBMASTER"."MEMBGROUP_CODE","MBMEMBMASTER"."MEMBER_NO","MBUCFMEMBGROUP"."MEMBGROUP_DESC"]]>