select mbmembmaster.coop_id, mbmembmaster.membtype_code, mbmembmaster.birth_date, mbmembmaster.work_date, mbmembmaster.member_date, mbmembmaster.retry_date, mbmembmaster.salary_id, mbmembmaster.membgroup_code, mbucfmembgroup.membgroup_desc, mbucfmembtype.membtype_desc, lnreqloan.loanrequest_docno, lnreqloan.member_no, lnreqloan.loantype_code, lnreqloan.loanrequest_date, lnreqloan.loanrequest_type, lnreqloan.ref_contmastno, lnreqloan.ref_registerno, lnreqloan.loancredit_amt, lnreqloan.loangrpcredit_amt, lnreqloan.loangrpuse_amt, lnreqloan.loanmaxreq_amt, lnreqloan.loanpermiss_amt, lnreqloan.loanrequest_amt, lnreqloan.receiveperiod_flag, lnreqloan.custompayment_flag, lnreqloan.loanpayment_type, lnreqloan.maxperiod_payamt, lnreqloan.maxsend_payamt, lnreqloan.period_payamt, lnreqloan.period_payment, lnreqloan.contract_time, lnreqloan.buyshare_flag, lnreqloan.buyshare_amt, lnreqloan.clearloan_flag, lnreqloan.sum_clear, lnreqloan.contractint_type, lnreqloan.contractint_time, lnreqloan.contract_interest, lnreqloan.loanobjective_code, lnreqloan.sharestk_value, lnreqloan.periodshare_value, lnreqloan.share_lastperiod, lnreqloan.salary_amt, lnreqloan.minsalary_perc, lnreqloan.minsalary_amt, lnreqloan.paymonth_other, lnreqloan.paymonth_coop, lnreqloan.loanrequest_status, lnreqloan.expense_code, lnreqloan.expense_bank, lnreqloan.expense_branch, lnreqloan.expense_accid, lnreqloan.approve_date, lnreqloan.approve_id, lnreqloan.loanapprove_amt, lnreqloan.loancontract_no, lnreqloan.intestimate_amt, lnreqloan.apvimmediate_flag, lnreqloan.od_flag, lnreqloan.entry_id, lnreqloan.entry_date, lnreqloan.remark, lnreqloan.loanreqregis_amt, lnreqloan.paymonth_exp, lnreqloan.sharepay_status, lnreqloan.incomemonth_other, lnreqloan.incomemonth_fixed, lnreqloan.minsalary_inc, lnreqloan.otherclr_flag, lnreqloan.otherclr_amt, lnreqloan.loanrcvfix_flag, lnreqloan.loanrcvfix_date, lnreqloan.ownclear_flag, lnreqloan.committee_time, lnreqloan.committee_group, lnreqloan.inspayment_amt, lnreqloan.instype_code, lnreqloan.startkeep_date, lnreqloan.cancel_id, lnreqloan.loanrcv_date, lnreqloan.int_continttype, lnreqloan.int_contintrate, lnreqloan.int_continttabcode, lnreqloan.int_contintincrease, lnreqloan.int_intsteptype, lnreqloan.loanins_amt, lnreqloan.member_remark, lnreqloan.bankfee_amt, lnreqloan.banksrv_amt, lnreqloan.postagefee_amt, lnreqloan.emsfee_amt, lnreqloan.tax_amt, lnreqloan.onlinefee_amt, lnreqloan.postagesrv_amt, lnreqloan.paytoorder_desc, lnreqloan.period_lastpayment, lnreqloan.cancel_date, lnreqloan.agencyclr_amt, lnreqloan.gunprice_amt, lnreqloan.manage_amt, lnreqloan.loanobjective_desc, lnreqloan.salarybal_amt, lnreqloan.coop_id, lnreqloan.memcoop_id, lnreqloan.intcertificate_status, lnreqloan.intendorse_amt, lnreqloan.loanpayment_status, lnreqloan.loanrighttype_code, lnreqloan.netincome_amt, lnreqloan.return_coop, lnreqloan.return_other, lnreqloan.salarybal_flag, lnreqloan.loanright_percshare, lnreqloan.loanright_percsalary, lnreqloan.clear_amt, lnreqloan.share_periodvalue, lnreqloan.share_paystatus, lnreqloan.apvimmediate_status, lnreqloan.loanpay_code, lnreqloan.loanpay_bank, lnreqloan.loanpay_branch, lnreqloan.loanpay_accid, lnreqloan.intfuture_amt from lnreqloan, mbmembmaster, mbucfprename, mbucfmembgroup, mbucfmembtype where ( lnreqloan.member_no = mbmembmaster.member_no ) and ( lnreqloan.memcoop_id = mbmembmaster.coop_id ) and ( mbmembmaster.prename_code = mbucfprename.prename_code ) and ( mbmembmaster.membtype_code = mbucfmembtype.membtype_code ) and ( mbmembmaster.membgroup_code = mbucfmembgroup.membgroup_code ) and ( mbmembmaster.coop_id = mbucfmembgroup.coop_id ) and ( mbmembmaster.coop_id = mbucfmembtype.coop_id ) and ( ( lnreqloan.loanrequest_docno = :as_docno ) )