SELECT "MBUCFMEMBGROUP"."MEMBGROUP_CODE", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_ENAME", "MBMEMBMASTER"."MEMBER_STATUS", "MBMEMBMASTER"."MEMBER_DATE", "MBMEMBMASTER"."RESIGN_STATUS", "MBMEMBMASTER"."RESIGN_DATE", "MBUCFMEMBTYPE"."MEMBTYPE_CODE", "MBUCFMEMBTYPE"."MEMBTYPE_DESC", "MBMEMBMASTER"."COOP_ID", "MBMEMBMASTER"."MEMBER_NO", "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."MEMB_ESURNAME" FROM "MBMEMBMASTER", "MBUCFMEMBGROUP", "MBUCFPRENAME", "MBUCFMEMBTYPE" select 0 as operate_flag , sa.coop_id , sa.adjslip_no , kmr.receipt_no , sa.adjslip_date , sa.ref_recvperiod , sa.slip_amt , sa.cancel_id , sa.slip_status , sa.ref_slipdate , sa.entry_id from slslipadjust sa , kpmastreceive kmr where sa.coop_id = kmr.coop_id and sa.ref_slipno = kmr.kpslip_no select 0 as operate_flag , sa.coop_id , sa.adjslip_no , sa.adjslip_date , ft_cnvtdate( sa.adjslip_date , 1 ) as adjslip_tdate , sa.ref_recvperiod , sa.slip_amt , sa.tofrom_accid, sad.bfmthpay_kpitemtyp , kui.keepitemtype_desc , sad.seq_no, sad.shrlontype_code , sad.loancontract_no , sad.principal_adjamt , sad.interest_adjamt , sad.intarrear_adjamt , sad.item_adjamt , kui.sort_in_receive from slslipadjust sa , slslipadjustdet sad , kpucfkeepitemtype kui where sa.coop_id = sad.coop_id and sa.adjslip_no = sad.adjslip_no and sad.coop_id = kui.coop_id and sad.bfmthpay_kpitemtyp = kui.keepitemtype_code and sa.coop_id = :as_coopid and sa.adjslip_no = :as_adjslip