select mbucfprename.prename_desc, mbmembmaster.memb_name, mbmembmaster.memb_surname, mbmembmaster.membgroup_code, mbucfmembgroup.membgroup_desc, lnreqchgcontlaw.coop_id, lnreqchgcontlaw.lnchgcontlaw_docno, lnreqchgcontlaw.lnchgcontlaw_date, lnreqchgcontlaw.memcoop_id, lnreqchgcontlaw.member_no, lnreqchgcontlaw.concoop_id, lnreqchgcontlaw.loancontract_no, lnreqchgcontlaw.bfprnbal_amt, lnreqchgcontlaw.bfintarrear_amt, lnreqchgcontlaw.bfintarrset_amt, lnreqchgcontlaw.bflastcalint_date, lnreqchgcontlaw.bfcontlaw_status, lnreqchgcontlaw.contlaw_prnset, lnreqchgcontlaw.contlaw_intarrset, lnreqchgcontlaw.contlaw_chgtostatus, lnreqchgcontlaw.lnchgcontlaw_status, lnreqchgcontlaw.entry_id, lnreqchgcontlaw.entry_date, lnreqchgcontlaw.entry_bycoopid from lnreqchgcontlaw, mbmembmaster, mbucfprename, mbucfmembgroup where ( lnreqchgcontlaw.memcoop_id = mbmembmaster.coop_id ) and ( lnreqchgcontlaw.member_no = mbmembmaster.member_no ) and ( mbmembmaster.prename_code = mbucfprename.prename_code ) and ( mbmembmaster.coop_id = mbucfmembgroup.coop_id ) and ( mbmembmaster.membgroup_code = mbucfmembgroup.membgroup_code ) and ( ( lnreqchgcontlaw.coop_id = :as_coopid ) and ( lnreqchgcontlaw.lnchgcontlaw_docno = :as_reqno ) ) select mbucfprename.prename_desc, mbmembmaster.memb_name, mbmembmaster.memb_surname, lnreqchgcontlawcoll.coop_id, lnreqchgcontlawcoll.lnchgcontlaw_docno, lnreqchgcontlawcoll.seq_no, lnreqchgcontlawcoll.trn_concoopid, lnreqchgcontlawcoll.trn_contractno, lnreqchgcontlawcoll.trn_memcoopid, lnreqchgcontlawcoll.trn_memno, lnreqchgcontlawcoll.collprnbal_amt, lnreqchgcontlawcoll.collintsetarr_amt, lnreqchgcontlawcoll.collcontlaw_status from lnreqchgcontlawcoll, mbmembmaster, mbucfprename where ( lnreqchgcontlawcoll.trn_memcoopid = mbmembmaster.coop_id ) and ( lnreqchgcontlawcoll.trn_memno = mbmembmaster.member_no ) and ( mbmembmaster.prename_code = mbucfprename.prename_code ) and ( ( lnreqchgcontlawcoll.coop_id = :as_reqno ) and ( lnreqchgcontlawcoll.lnchgcontlaw_docno = :as_reqno ) )