select mbucfprename.prename_desc , mbmembmaster.memb_name , mbmembmaster.memb_surname , lnnplsue.coop_id , lnnplsue.sue_no , lnnplsue.memcoop_id , lnnplsue.member_no , lnnplsue.sue_date , lnnplsue.lawset_status, lnnplsue.mav_status , lnnplsue.mavtrn_status, lnnplsue.tracking_no FROM LNNPLSUE , MBMEMBMASTER , MBUCFPRENAME WHERE ( LNNPLSUE.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( LNNPLSUE.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) select lnnplsuecont.coop_id, lnnplsuecont.sue_no, lnnplsuecont.loancontract_no, lnnplsuecont.paytype_status, lnnplsuecont.sueprn_amt, lnnplsuecont.sueintarr_amt, lnnplsuecont.suspect_code, lnnplsuecont.judgeintrate_percent, lnnplsuecont.identifycont_date, lncontmaster.lastpayment_date, lncontmaster.lastcalint_date , lncontmaster.principal_balance, lncontmaster.intset_arrear, lncontmaster.prncbalbegin_amt, lncontmaster.intsetbegin_amt from lnnplsuecont, lncontmaster where ( lnnplsuecont.coop_id = lncontmaster.coop_id ) and ( lnnplsuecont.loancontract_no = lncontmaster.loancontract_no ) SELECT LNCONTMASTER.PRINCIPAL_BALANCE, LNCONTMASTER.INTSET_ARREAR, LNCONTMASTER.PRNCBALBEGIN_AMT, LNCONTMASTER.INTSETBEGIN_AMT, LNNPLSUECONT.COOP_ID, LNNPLSUECONT.SUE_NO, LNNPLSUECONT.LOANCONTRACT_NO, LNNPLSUECONT.PAYTYPE_STATUS, LNNPLSUECONT.SUEPRN_AMT, LNNPLSUECONT.SUEINTARR_AMT, LNNPLSUECONT.SUSPECT_CODE, LNNPLSUECONT.JUDGEINTRATE_PERCENT, LNNPLSUECONT.IDENTIFYCONT_DATE, LNCONTMASTER.LASTPAYMENT_DATE, LNCONTMASTER.LASTCALINT_DATE FROM LNNPLSUECONT, LNCONTMASTER WHERE ( LNNPLSUECONT.COOP_ID = LNCONTMASTER.COOP_ID ) and ( LNNPLSUECONT.LOANCONTRACT_NO = LNCONTMASTER.LOANCONTRACT_NO ) DELETE FROM "LNNPLSUE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) INSERT INTO "LNNPLSUE" ("MAVSET_BAL", "MAVREAL_BAL", "MAV_STATUS", "MAVTRN_STATUS", "COOP_ID", "SUE_NO") VALUES (:MAVSET_BAL, :MAVREAL_BAL, :MAV_STATUS, :MAVTRN_STATUS, :COOP_ID, :SUE_NO) SELECT MAVSET_BAL, MAVREAL_BAL, MAV_STATUS, MAVTRN_STATUS, COOP_ID, SUE_NO FROM LNNPLSUE UPDATE "LNNPLSUE" SET "MAVSET_BAL" = :MAVSET_BAL, "MAVREAL_BAL" = :MAVREAL_BAL, "MAV_STATUS" = :MAV_STATUS, "MAVTRN_STATUS" = :MAVTRN_STATUS, "COOP_ID" = :COOP_ID, "SUE_NO" = :SUE_NO WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) DELETE FROM "LNNPLSUEMAVSTATEMENT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNNPLSUEMAVSTATEMENT" ("COOP_ID", "SUE_NO", "SEQ_NO", "SLIP_DATE", "OPERATE_DATE", "MAVITEMTYPE_CODE", "MAV_AMT", "MAV_BAL") VALUES (:COOP_ID, :SUE_NO, :SEQ_NO, :SLIP_DATE, :OPERATE_DATE, :MAVITEMTYPE_CODE, :MAV_AMT, :MAV_BAL) select coop_id, sue_no, seq_no, slip_date, operate_date, mavitemtype_code, mav_amt, mav_bal from lnnplsuemavstatement UPDATE "LNNPLSUEMAVSTATEMENT" SET "COOP_ID" = :COOP_ID, "SUE_NO" = :SUE_NO, "SEQ_NO" = :SEQ_NO, "SLIP_DATE" = :SLIP_DATE, "OPERATE_DATE" = :OPERATE_DATE, "MAVITEMTYPE_CODE" = :MAVITEMTYPE_CODE, "MAV_AMT" = :MAV_AMT, "MAV_BAL" = :MAV_BAL WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) select mbucfprename.prename_desc ,mbmembmaster.memb_name,mbmembmaster.memb_surname,lnnplsuemavcoll.coop_id,lnnplsuemavcoll.sue_no,lnnplsuemavcoll.member_no,lnnplsuemavcoll.mavtrn_amt,lnnplsuemavcoll.mavbal_amt from mbmembmaster ,mbucfprename , lnnplsuemavcoll where (mbmembmaster.prename_code = mbucfprename.prename_code) and (lnnplsuemavcoll.member_no = mbmembmaster.member_no) DELETE FROM "LNNPLSUETODOLIST" WHERE (("SEQ_NO" = :Original_SEQ_NO) AND ("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) INSERT INTO "LNNPLSUETODOLIST" ("SEQ_NO", "COOP_ID", "SUE_NO", "TODO_TOPIC", "TODO_DESC", "TODO_DATE", "TODO_STATUS") VALUES (:SEQ_NO, :COOP_ID, :SUE_NO, :TODO_TOPIC, :TODO_DESC, :TODO_DATE, :TODO_STATUS) select * from lnnplsuetodolist UPDATE "LNNPLSUETODOLIST" SET "SEQ_NO" = :SEQ_NO, "COOP_ID" = :COOP_ID, "SUE_NO" = :SUE_NO, "TODO_TOPIC" = :TODO_TOPIC, "TODO_DESC" = :TODO_DESC, "TODO_DATE" = :TODO_DATE, "TODO_STATUS" = :TODO_STATUS WHERE (("SEQ_NO" = :Original_SEQ_NO) AND ("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) DELETE FROM "LNNPLSUE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) INSERT INTO "LNNPLSUE" ("COOP_ID", "SUE_NO", "COURT_NAME", "JUDGE_DATE", "LAWTYPE_CODE", "CASEBLACK_NO", "CASERED_NO", "WORKSTEP_CODE", "DEBTCLASS_CODE", "REMARK", "JUDGE_EVENT", "NOTICECONTROL_DATE") VALUES (:COOP_ID, :SUE_NO, :COURT_NAME, :JUDGE_DATE, :LAWTYPE_CODE, :CASEBLACK_NO, :CASERED_NO, :WORKSTEP_CODE, :DEBTCLASS_CODE, :REMARK, :JUDGE_EVENT, :NOTICECONTROL_DATE) select lnnplsue.coop_id , lnnplsue.sue_no , lnnplsue.court_name , lnnplsue.judge_date , lnnplsue.lawtype_code , lnnplsue.caseblack_no , lnnplsue.casered_no , lnnplsue.workstep_code , lnnplsue.debtclass_code , lnnplsue.remark , lnnplsue.judge_event , lnnplsue.noticecontrol_date FROM LNNPLSUE UPDATE "LNNPLSUE" SET "COOP_ID" = :COOP_ID, "SUE_NO" = :SUE_NO, "COURT_NAME" = :COURT_NAME, "JUDGE_DATE" = :JUDGE_DATE, "LAWTYPE_CODE" = :LAWTYPE_CODE, "CASEBLACK_NO" = :CASEBLACK_NO, "CASERED_NO" = :CASERED_NO, "WORKSTEP_CODE" = :WORKSTEP_CODE, "DEBTCLASS_CODE" = :DEBTCLASS_CODE, "REMARK" = :REMARK, "JUDGE_EVENT" = :JUDGE_EVENT, "NOTICECONTROL_DATE" = :NOTICECONTROL_DATE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO))