SELECT LNNPLTRACKING.COOP_ID, LNNPLTRACKING.TRACKING_NO, LNNPLTRACKING.MEMCOOP_ID, LNNPLTRACKING.MEMBER_NO, LNNPLTRACKING.TRACKING_DATE, LNNPLTRACKING.TRACKING_STATUS, MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.ADDR_NO, MBMEMBMASTER.ADDR_MOO, MBMEMBMASTER.ADDR_SOI, MBMEMBMASTER.ADDR_VILLAGE, MBMEMBMASTER.ADDR_ROAD, MBUCFTAMBOL.TAMBOL_DESC, MBUCFDISTRICT.DISTRICT_DESC, MBUCFPROVINCE.PROVINCE_CODE, MBUCFPROVINCE.PROVINCE_DESC, MBMEMBMASTER.ADDR_POSTCODE, MBMEMBMASTER.ADDR_PHONE, MBMEMBMASTER.ADDR_MOBILEPHONE, MBMEMBMASTER.CARD_PERSON FROM LNNPLTRACKING, MBMEMBMASTER, MBUCFPRENAME, MBUCFPROVINCE, MBUCFDISTRICT, MBUCFTAMBOL WHERE ( LNNPLTRACKING.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( LNNPLTRACKING.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) and ( MBMEMBMASTER.PROVINCE_CODE = MBUCFPROVINCE.PROVINCE_CODE ) and ( MBMEMBMASTER.AMPHUR_CODE = MBUCFDISTRICT.DISTRICT_CODE ) and ( MBMEMBMASTER.TAMBOL_CODE = MBUCFTAMBOL.TAMBOL_CODE ) select lnnpltrackingcont.*, lncontmaster.principal_balance from lnnpltrackingcont, lncontmaster where ( lnnpltrackingcont.coop_id = lncontmaster.coop_id ) and ( lnnpltrackingcont.loancontract_no = lncontmaster.loancontract_no ) DELETE FROM "LNNPLTRACKINGMEETING" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("TRACKING_NO" = :Original_TRACKING_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNNPLTRACKINGMEETING" ("COOP_ID", "TRACKING_NO", "SEQ_NO", "MEETING_DATE", "COMMITTEE_CODE", "MEETING_TOPIC", "MEETING_DESC", "MEETING_CONCLUSION") VALUES (:COOP_ID, :TRACKING_NO, :SEQ_NO, :MEETING_DATE, :COMMITTEE_CODE, :MEETING_TOPIC, :MEETING_DESC, :MEETING_CONCLUSION) SELECT LNNPLTRACKINGMEETING.COOP_ID, LNNPLTRACKINGMEETING.TRACKING_NO, LNNPLTRACKINGMEETING.SEQ_NO, LNNPLTRACKINGMEETING.MEETING_DATE, LNNPLTRACKINGMEETING.COMMITTEE_CODE, LNNPLTRACKINGMEETING.MEETING_TOPIC, LNNPLTRACKINGMEETING.MEETING_DESC, LNNPLTRACKINGMEETING.MEETING_CONCLUSION FROM LNNPLTRACKINGMEETING UPDATE "LNNPLTRACKINGMEETING" SET "COOP_ID" = :COOP_ID, "TRACKING_NO" = :TRACKING_NO, "SEQ_NO" = :SEQ_NO, "MEETING_DATE" = :MEETING_DATE, "COMMITTEE_CODE" = :COMMITTEE_CODE, "MEETING_TOPIC" = :MEETING_TOPIC, "MEETING_DESC" = :MEETING_DESC, "MEETING_CONCLUSION" = :MEETING_CONCLUSION WHERE (("COOP_ID" = :Original_COOP_ID) AND ("TRACKING_NO" = :Original_TRACKING_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "LNNPLTRACKINGTODOLIST" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("TRACKING_NO" = :Original_TRACKING_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNNPLTRACKINGTODOLIST" ("COOP_ID", "TRACKING_NO", "SEQ_NO", "TODO_TOPIC", "TODO_DESC", "TODO_DATE", "TODO_STATUS") VALUES (:COOP_ID, :TRACKING_NO, :SEQ_NO, :TODO_TOPIC, :TODO_DESC, :TODO_DATE, :TODO_STATUS) SELECT LNNPLTRACKINGTODOLIST.COOP_ID, LNNPLTRACKINGTODOLIST.TRACKING_NO, LNNPLTRACKINGTODOLIST.SEQ_NO, LNNPLTRACKINGTODOLIST.TODO_TOPIC, LNNPLTRACKINGTODOLIST.TODO_DESC, LNNPLTRACKINGTODOLIST.TODO_DATE, LNNPLTRACKINGTODOLIST.TODO_STATUS FROM LNNPLTRACKINGTODOLIST UPDATE "LNNPLTRACKINGTODOLIST" SET "COOP_ID" = :COOP_ID, "TRACKING_NO" = :TRACKING_NO, "SEQ_NO" = :SEQ_NO, "TODO_TOPIC" = :TODO_TOPIC, "TODO_DESC" = :TODO_DESC, "TODO_DATE" = :TODO_DATE, "TODO_STATUS" = :TODO_STATUS WHERE (("COOP_ID" = :Original_COOP_ID) AND ("TRACKING_NO" = :Original_TRACKING_NO) AND ("SEQ_NO" = :Original_SEQ_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", "MEMCOOP_ID", "MEMBER_NO", "SUE_DATE", "RECEIVE_DATE", "JUDGE_DATE", "LAWSET_STATUS", "LAWTYPE_CODE", "CASEBLACK_NO", "CASERED_NO", "WORKSTEP_CODE", "DEBTCLASS_CODE", "PAYTYPE_STATUS", "REMARK", "JUDGE_EVENT", "NOTICECONTROL_DATE", "MAVSET_BAL", "MAVREAL_BAL", "MAV_STATUS", "MAVTRN_STATUS", "TRACKING_NO") VALUES (:COOP_ID, :SUE_NO, :COURT_NAME, :MEMCOOP_ID, :MEMBER_NO, :SUE_DATE, :RECEIVE_DATE, :JUDGE_DATE, :LAWSET_STATUS, :LAWTYPE_CODE, :CASEBLACK_NO, :CASERED_NO, :WORKSTEP_CODE, :DEBTCLASS_CODE, :PAYTYPE_STATUS, :REMARK, :JUDGE_EVENT, :NOTICECONTROL_DATE, :MAVSET_BAL, :MAVREAL_BAL, :MAV_STATUS, :MAVTRN_STATUS, :TRACKING_NO) select * from lnnplsue UPDATE "LNNPLSUE" SET "COOP_ID" = :COOP_ID, "SUE_NO" = :SUE_NO, "COURT_NAME" = :COURT_NAME, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "SUE_DATE" = :SUE_DATE, "RECEIVE_DATE" = :RECEIVE_DATE, "JUDGE_DATE" = :JUDGE_DATE, "LAWSET_STATUS" = :LAWSET_STATUS, "LAWTYPE_CODE" = :LAWTYPE_CODE, "CASEBLACK_NO" = :CASEBLACK_NO, "CASERED_NO" = :CASERED_NO, "WORKSTEP_CODE" = :WORKSTEP_CODE, "DEBTCLASS_CODE" = :DEBTCLASS_CODE, "PAYTYPE_STATUS" = :PAYTYPE_STATUS, "REMARK" = :REMARK, "JUDGE_EVENT" = :JUDGE_EVENT, "NOTICECONTROL_DATE" = :NOTICECONTROL_DATE, "MAVSET_BAL" = :MAVSET_BAL, "MAVREAL_BAL" = :MAVREAL_BAL, "MAV_STATUS" = :MAV_STATUS, "MAVTRN_STATUS" = :MAVTRN_STATUS, "TRACKING_NO" = :TRACKING_NO WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) select lnnpltrackingcont.*, lncontmaster.lastpayment_date, lncontmaster.lastcalint_date , lncontmaster.principal_balance, lncontmaster.intset_arrear, lncontmaster.prncbalbegin_amt, lncontmaster.intsetbegin_amt from lnnpltrackingcont, lncontmaster where ( lnnpltrackingcont.coop_id = lncontmaster.coop_id ) and ( lnnpltrackingcont.loancontract_no = lncontmaster.loancontract_no )