SELECT LNCOLLMASTER.COLLMAST_REFNO , LNCOLLMASTER.COLLMAST_DESC , LNCOLLMASTER.mortgage_price , LNCOLLMASTER.mortgage_DATE , MBUCFPRENAME.PRENAME_DESC , MBMEMBMASTER.MEMB_NAME , MBMEMBMASTER.MEMB_SURNAME , LNREQCOLLMASTREDEEM.COOP_ID , LNREQCOLLMASTREDEEM.REDEEM_DOCNO , LNREQCOLLMASTREDEEM.MEMCOOP_ID , LNREQCOLLMASTREDEEM.MEMBER_NO , LNREQCOLLMASTREDEEM.COLLCOOP_ID , LNREQCOLLMASTREDEEM.COLLMAST_NO , LNREQCOLLMASTREDEEM.REDEEM_DATE , LNREQCOLLMASTREDEEM.REDEEM_CAUSE , LNREQCOLLMASTREDEEM.REDEEM_STATUS , LNREQCOLLMASTREDEEM.ENTRY_ID , LNREQCOLLMASTREDEEM.ENTRY_DATE , LNREQCOLLMASTREDEEM.ENTRY_BYCOOPID , LNREQCOLLMASTREDEEM.CANCEL_ID , LNREQCOLLMASTREDEEM.CANCEL_DATE , LNREQCOLLMASTREDEEM.CANCEL_BYCOOPID, LNREQCOLLMASTREDEEM.LNOVERRETRY_STATUS FROM LNREQCOLLMASTREDEEM , LNCOLLMASTER , MBMEMBMASTER , MBUCFPRENAME WHERE ( LNREQCOLLMASTREDEEM.COLLCOOP_ID = LNCOLLMASTER.COOP_ID ) and ( LNREQCOLLMASTREDEEM.COLLMAST_NO = LNCOLLMASTER.COLLMAST_NO ) and ( LNREQCOLLMASTREDEEM.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( LNREQCOLLMASTREDEEM.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) and ( ( LNREQCOLLMASTREDEEM.COOP_id = :as_coopid ) and ( LNREQCOLLMASTREDEEM.redeem_docno = :as_reqno ) )