'FN' ),0) as clrdep_amt, nvl(( select sum(item_payamt) from slslippayindet where slslippayindet.payinslip_no = slslippayout.slipclear_no and slipitemtype_code = 'PKN' ),0) as clrins_amt, ( select sum(item_payamt) from slslippayindet where slslippayindet.payinslip_no = slslippayout.slipclear_no and slipitemtype_code = 'BJN' ) as clrbrij_amt, ( select sum(item_payamt) from slslippayindet where slslippayindet.payinslip_no = slslippayout.slipclear_no and slipitemtype_code = 'INF' ) as clrbinf_amt, ( select sum(item_payamt) from slslippayindet where slslippayindet.payinslip_no = slslippayout.slipclear_no and slipitemtype_code in( 'VAT','MFE', 'EMS', 'ONL', 'MTR' ) ) as clrmoneyorder_amt, ( select sum(item_payamt) from slslippayindet where slslippayindet.payinslip_no = slslippayout.slipclear_no and slipitemtype_code in( 'BFE','BTR' ) ) as clrmoneybank_amt, ( select sum(interest_payamt) from slslippayindet where slslippayindet.payinslip_no = slslippayout.slipclear_no and slslippayout.slip_status <> -9 ) as interest_amt, (select sum(intestimate_amt) from lnreqloan where lnreqloan.loancontract_no=slslippayout.loancontract_no and slslippayout.slip_status <> -9 and lnreqloan.loanrequest_status<>-9 )as intestimate_amt, (select period_payment from lncontmaster where lncontmaster.loancontract_no=slslippayout.loancontract_no and slslippayout.slip_status <> -9 and lncontmaster.contract_status<>-1 )as period_payment, (select period_payamt from lncontmaster where lncontmaster.loancontract_no=slslippayout.loancontract_no and slslippayout.slip_status <> -9 and lncontmaster.contract_status<>-1 )as period_payamt, slslippayout .payoutnet_amt, cmucfmoneytype.moneytype_desc, slslippayout .entry_id, slslippayout.shrlontype_code, slslippayout.moneytype_code, slslippayout.expense_bank, lnloantype.loangroup_code,lnloantype.loantype_desc from slslippayout ,mbmembmaster,mbucfmembgroup,mbucfprename,cmucfmoneytype,lnloantype where slslippayout.member_no =mbmembmaster.member_no and slslippayout.memcoop_id =mbmembmaster.coop_id and slslippayout.shrlontype_code =lnloantype.loantype_code and slslippayout.coop_id =lnloantype.coop_id and mbmembmaster.membgroup_code =mbucfmembgroup.membgroup_code and mbmembmaster.coop_id = mbucfmembgroup.coop_id and mbmembmaster.prename_code =mbucfprename.prename_code and slslippayout.moneytype_code = cmucfmoneytype.moneytype_code (+) and slslippayout.slip_date between $P{adtm_start} and $P{adtm_end} and slslippayout.slip_status <>-9 and slslippayout.rcv_period > 1 and slslippayout.shrlontype_code between $P{as_startlntype} and $P{as_endlntype} and slslippayout.sliptype_code ='LWD' order by slslippayout .loancontract_no asc]]>