select lcm.collmast_no, lcm.collmast_refno, lmt.collmasttype_desc, lcm.collmast_desc, lcm.estimate_price from lncollmaster lcm , lnucfcollmasttype lmt where lcm.collmasttype_code = lmt.collmasttype_code and lcm.coop_id = :as_coopid and lcm.member_no = :as_memno and lcm.redeem_flag = 0