0 and tt.contno = lc.loancontract_no and lc.member_no = mm.member_no and lc.coop_id = mm.coop_id ) tmp , lncontmaster lm , mbmembmaster mm , mbucfprename mp , mbucfmembgroup mg, lnloantype lty,"LNUCFLOANOBJECTIVE","MBUCFMEMBTYPE" where ("MBUCFMEMBTYPE"."MEMBTYPE_CODE" = mm."MEMBTYPE_CODE") and ("LNUCFLOANOBJECTIVE"."LOANOBJECTIVE_CODE" = lm."LOANOBJECTIVE_CODE") and tmp.contno = lm.loancontract_no and lm.member_no = mm.member_no and lm.coop_id = mm.coop_id and mm.prename_code = mp.prename_code and mm.membgroup_code = mg.membgroup_code and mm.coop_id = mg.coop_id and lm.coop_id = $P{as_coopid} and lm.loantype_code = lty.loantype_code and lty.loangroup_code like $P{as_loangrp} order by mg.membgroup_code]]>