qry :SELECT a.rec_key AS rec_key , c.species_key AS book_key , c.vol as vol , TO_CHAR(a.loan_date, "YYYY/MM/DD") AS loan_date , TO_CHAR(a.return_plan_date, "YYYY/MM/DD") AS return_plan_date , TO_CHAR(a.RESERVATION_DATE, "YYYY/MM/DD") AS RESERVATION_DATE, TO_CHAR(a.reservation_expire_date, "YYYY/MM/DD") AS reservation_expire_date , a.STATUS as STATUS ,a.TITLE as TITLE, b.MARC as MARC , d.description as shelfcode, c.class_no as class_no, c.book_code as book_code, c.vol_code as vol_code, c.copy_code as copy_code , e.description as shelfloc , a.book_key as bookey FROM CO_LOAN_TBL a , BO_SPECIES_TBL b , BO_BOOK_TBL c , CD_CODE_TBL d, CD_CODE_TBL e WHERE c.species_key = b.rec_key AND a.STATUS in ("0","2","3") AND (d.class(+) = "11" AND d.code(+) = c.separate_shelf_code) AND (e.class(+) = "19" AND e.code(+) = c.shelf_loc_code) AND c.rec_key = a.book_key AND a.USER_KEY = "70497851"