= $P{adtm_sdate} and TRUNC(shsharestatement.slip_date) <= $P{adtm_edate} ) then shsharestatement.share_amount *shsharetype.share_value * shucfshritemtype.sign_flag else 0 end ) as share_px, 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 *shsharetype.share_value * shucfshritemtype.sign_flag else 0 end )) as share_swd, "MBMEMBMASTER"."MEMBER_NO", ( select b.sharestk_amt*10 from shsharestatement b where b.member_no = "MBMEMBMASTER"."MEMBER_NO" and b.slip_date <= $P{adtm_edate} and b.seq_no = (select max(seq_no) from shsharestatement c where c.member_no = "MBMEMBMASTER"."MEMBER_NO" and c.slip_date <= $P{adtm_edate} and c.shritemtype_code = 'B/F' )) as share_begin, ( select b.sharestk_amt*10 from shsharestatement b where b.member_no = "MBMEMBMASTER"."MEMBER_NO" and b.slip_date <= $P{adtm_edate} and b.seq_no = (select max(seq_no) from shsharestatement c where c.member_no = "MBMEMBMASTER"."MEMBER_NO" and c.slip_date <= $P{adtm_edate} )) as share_forward, "MBMEMBMASTER"."MEMBER_DATE" ,"SHSHAREMASTER".sharebegin_amt, shsharetype.share_value FROM "MBMEMBMASTER", "MBUCFMEMBGROUP", "MBUCFPRENAME", "SHSHARESTATEMENT", "SHSHARETYPE", "CMCOOPMASTER", "SHUCFSHRITEMTYPE", "SHSHAREMASTER" WHERE ( shsharestatement.member_no (+) = mbmembmaster.member_no) and (mbmembmaster.member_no = SHSHAREMASTER.member_no) and ( "MBUCFMEMBGROUP"."MEMBGROUP_CODE" = "MBMEMBMASTER"."MEMBGROUP_CODE" ) and ( "MBUCFPRENAME"."PRENAME_CODE" = "MBMEMBMASTER"."PRENAME_CODE" ) and ( "SHSHARESTATEMENT"."SHRITEMTYPE_CODE" = "SHUCFSHRITEMTYPE"."SHRITEMTYPE_CODE" ) and ( "SHSHARESTATEMENT"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" ) and ( ( "MBMEMBMASTER"."MEMBGROUP_CODE" between $P{membgroup_start} and $P{membgroup_end}) AND ( "MBMEMBMASTER"."COOP_ID" = $P{coop_id} ) AND ( ("MBMEMBMASTER"."RESIGN_DATE" is null OR "MBMEMBMASTER"."RESIGN_DATE" >= $P{adtm_sdate} OR to_char( mbmembmaster.resign_date,'dd/mm/yyyy') = '01/01/1900' )) AND MBMEMBMASTER.MEMBER_DATE <= $P{adtm_edate} ) GROUP BY "MBMEMBMASTER"."MEMBER_NO", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME","MBMEMBMASTER"."MEMBTYPE_CODE", "MBMEMBMASTER"."MEMBGROUP_CODE","MBMEMBMASTER"."CARD_PERSON", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBUCFPRENAME"."PRENAME_DESC", "CMCOOPMASTER"."COOP_NAME", "MBMEMBMASTER"."MEMBER_DATE", "SHSHAREMASTER".sharebegin_amt, shsharetype.share_value, shsharemaster.sharestk_amt HAVING sum( case when ( shsharestatement.shritemtype_code in ('SPX','RPX','SPN','RPN','SPM','RPM') and TRUNC(shsharestatement.slip_date) >= $P{adtm_sdate} and TRUNC(shsharestatement.slip_date) <= $P{adtm_edate} ) then shsharestatement.share_amount *shsharetype.share_value * shucfshritemtype.sign_flag 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 *shsharetype.share_value * shucfshritemtype.sign_flag else 0 end ))>0 or SHAREBEGIN_AMT*SHARE_VALUE >0 or shsharemaster.sharestk_amt * SHARE_VALUE >0 order by "MBMEMBMASTER"."MEMBGROUP_CODE","MBMEMBMASTER"."MEMBER_NO","MBUCFMEMBGROUP"."MEMBGROUP_DESC"]]>