DELETE FROM "LNCOLLMASTPROP" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNCOLLMASTPROP" ("COOP_ID", "COLLMAST_NO", "SEQ_NO", "PROP_DESC") VALUES (:COOP_ID, :COLLMAST_NO, :SEQ_NO, :PROP_DESC) select * from LNCOLLMASTPROP UPDATE "LNCOLLMASTPROP" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "SEQ_NO" = :SEQ_NO, "PROP_DESC" = :PROP_DESC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "COLLMASTTYPE_CODE", "LAND_RAVANG", "LAND_DOCNO", "LAND_LANDNO", "LAND_SURVEY", "LAND_BOOKNO", "LAND_PAGENO", "POS_TAMBOL", "POS_AMPHUR", "POS_PROVINCE", "PHOTOAIR_PROVINCE", "PHOTOAIR_NUMBER", "PHOTOAIR_PAGE", "PRICEPER_UNIT") VALUES (:COOP_ID, :COLLMAST_NO, :COLLMASTTYPE_CODE, :LAND_RAVANG, :LAND_DOCNO, :LAND_LANDNO, :LAND_SURVEY, :LAND_BOOKNO, :LAND_PAGENO, :POS_TAMBOL, :POS_AMPHUR, :POS_PROVINCE, :PHOTOAIR_PROVINCE, :PHOTOAIR_NUMBER, :PHOTOAIR_PAGE, :PRICEPER_UNIT) SELECT COOP_ID, COLLMAST_NO, COLLMASTTYPE_CODE, LAND_RAVANG, LAND_DOCNO, LAND_LANDNO, LAND_SURVEY, LAND_BOOKNO, LAND_PAGENO, POS_TAMBOL, POS_AMPHUR, POS_PROVINCE, PHOTOAIR_PROVINCE, PHOTOAIR_NUMBER, PHOTOAIR_PAGE, PRICEPER_UNIT FROM LNCOLLMASTER UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "COLLMASTTYPE_CODE" = :COLLMASTTYPE_CODE, "LAND_RAVANG" = :LAND_RAVANG, "LAND_DOCNO" = :LAND_DOCNO, "LAND_LANDNO" = :LAND_LANDNO, "LAND_SURVEY" = :LAND_SURVEY, "LAND_BOOKNO" = :LAND_BOOKNO, "LAND_PAGENO" = :LAND_PAGENO, "POS_TAMBOL" = :POS_TAMBOL, "POS_AMPHUR" = :POS_AMPHUR, "POS_PROVINCE" = :POS_PROVINCE, "PHOTOAIR_PROVINCE" = :PHOTOAIR_PROVINCE, "PHOTOAIR_NUMBER" = :PHOTOAIR_NUMBER, "PHOTOAIR_PAGE" = :PHOTOAIR_PAGE, "PRICEPER_UNIT" = :PRICEPER_UNIT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "DOL_PRINCE", "EST_PERCENT", "EST_PRICE", "MORTGAGE_PRICE") VALUES (:COOP_ID, :COLLMAST_NO, :DOL_PRINCE, :EST_PERCENT, :EST_PRICE, :MORTGAGE_PRICE) select coop_id, collmast_no, dol_prince, est_percent, est_price, mortgage_price from lncollmaster UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "DOL_PRINCE" = :DOL_PRINCE, "EST_PERCENT" = :EST_PERCENT, "EST_PRICE" = :EST_PRICE, "MORTGAGE_PRICE" = :MORTGAGE_PRICE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) select coop_id, collmast_no, collmasttype_code, bd_village, bd_addrno, bd_addrmoo, bd_soi, bd_road, bd_tambol, bd_amphur, bd_province, bd_type, bd_depreciation, bd_onlandno, bd_sumprice, bd_age from lncollmaster DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "COLLMAST_DESC", "MEMBER_NO", "COLLMASTTYPE_GRP") VALUES (:COOP_ID, :COLLMAST_NO, :COLLMAST_DESC, :MEMBER_NO, :COLLMASTTYPE_GRP) SELECT COOP_ID, COLLMAST_NO, COLLMAST_DESC, MEMBER_NO, COLLMASTTYPE_GRP FROM LNCOLLMASTER UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "COLLMAST_DESC" = :COLLMAST_DESC, "MEMBER_NO" = :MEMBER_NO, "COLLMASTTYPE_GRP" = :COLLMASTTYPE_GRP WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNCOLLMASTBUILDING" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("FLOOR_NO" = :Original_FLOOR_NO)) INSERT INTO "LNCOLLMASTBUILDING" ("COOP_ID", "COLLMAST_NO", "FLOOR_NO", "FLOOR_SQUARE", "FLOOR_PRICESQUARE", "FLOOR_SUMPRICE") VALUES (:COOP_ID, :COLLMAST_NO, :FLOOR_NO, :FLOOR_SQUARE, :FLOOR_PRICESQUARE, :FLOOR_SUMPRICE) select coop_id, collmast_no, floor_no, floor_square, floor_pricesquare, floor_sumprice from lncollmastbuilding UPDATE "LNCOLLMASTBUILDING" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "FLOOR_NO" = :FLOOR_NO, "FLOOR_SQUARE" = :FLOOR_SQUARE, "FLOOR_PRICESQUARE" = :FLOOR_PRICESQUARE, "FLOOR_SUMPRICE" = :FLOOR_SUMPRICE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("FLOOR_NO" = :Original_FLOOR_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "DESC_POSITION", "DESC_UTILITY", "DESC_TRAVEL", "DESC_ETC") VALUES (:COOP_ID, :COLLMAST_NO, :DESC_POSITION, :DESC_UTILITY, :DESC_TRAVEL, :DESC_ETC) select coop_id, collmast_no, desc_position, desc_utility, desc_travel, desc_etc from lncollmaster UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "DESC_POSITION" = :DESC_POSITION, "DESC_UTILITY" = :DESC_UTILITY, "DESC_TRAVEL" = :DESC_TRAVEL, "DESC_ETC" = :DESC_ETC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "CONDO_REGISTNO", "CONDO_NAME", "CONDO_TOWERNO", "CONDO_FLOOR", "CONDO_ROOMNO", "CONDO_ROOMSIZE", "CONDO_PRICESQUARE", "POS_TAMBOL", "POS_AMPHUR", "POS_PROVINCE", "CONDO_DEPRECIATION", "CONDO_AGE") VALUES (:COOP_ID, :COLLMAST_NO, :CONDO_REGISTNO, :CONDO_NAME, :CONDO_TOWERNO, :CONDO_FLOOR, :CONDO_ROOMNO, :CONDO_ROOMSIZE, :CONDO_PRICESQUARE, :POS_TAMBOL, :POS_AMPHUR, :POS_PROVINCE, :CONDO_DEPRECIATION, :CONDO_AGE) select coop_id, collmast_no, condo_registno, condo_name, condo_towerno, condo_floor, condo_roomno, condo_roomsize, condo_pricesquare, pos_tambol, pos_amphur, pos_province, condo_depreciation, condo_age from lncollmaster UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "CONDO_REGISTNO" = :CONDO_REGISTNO, "CONDO_NAME" = :CONDO_NAME, "CONDO_TOWERNO" = :CONDO_TOWERNO, "CONDO_FLOOR" = :CONDO_FLOOR, "CONDO_ROOMNO" = :CONDO_ROOMNO, "CONDO_ROOMSIZE" = :CONDO_ROOMSIZE, "CONDO_PRICESQUARE" = :CONDO_PRICESQUARE, "POS_TAMBOL" = :POS_TAMBOL, "POS_AMPHUR" = :POS_AMPHUR, "POS_PROVINCE" = :POS_PROVINCE, "CONDO_DEPRECIATION" = :CONDO_DEPRECIATION, "CONDO_AGE" = :CONDO_AGE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNMRTGMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MRTGMAST_NO" = :Original_MRTGMAST_NO)) INSERT INTO "LNMRTGMASTER" ("COOP_ID", "MRTGMAST_NO", "MEMBER_NO", "COLLMATE_FLAG", "COLLMATE_MEMNO", "ASSETTYPE_CODE", "MORTGAGE_TYPE", "MORTGAGE_LANDNUM", "MORTGAGE_PARTNAME", "MORTGAGE_PARTAMT", "MORTGAGE_PARTALL", "MORTGAGE_DATE", "MORTGAGE_GRTNAME", "INTEREST_RATE", "MORTGAGEFIRST_AMT", "MORTGAGESUM_AMT", "LAND_OFFICE", "MRTGMAST_STATUS", "ENTRY_ID") VALUES (:COOP_ID, :MRTGMAST_NO, :MEMBER_NO, :COLLMATE_FLAG, :COLLMATE_MEMNO, :ASSETTYPE_CODE, :MORTGAGE_TYPE, :MORTGAGE_LANDNUM, :MORTGAGE_PARTNAME, :MORTGAGE_PARTAMT, :MORTGAGE_PARTALL, :MORTGAGE_DATE, :MORTGAGE_GRTNAME, :INTEREST_RATE, :MORTGAGEFIRST_AMT, :MORTGAGESUM_AMT, :LAND_OFFICE, :MRTGMAST_STATUS, :ENTRY_ID) select coop_id, mrtgmast_no, member_no, collmate_flag, collmate_memno, assettype_code, mortgage_type, mortgage_landnum, mortgage_partname, mortgage_partamt, mortgage_partall, mortgage_date, mortgage_grtname, interest_rate, mortgagefirst_amt, mortgagesum_amt, land_office, mrtgmast_status, entry_id from lnmrtgmaster where coop_id = :as_coopid and mrtgmast_no = :as_mrtgno UPDATE "LNMRTGMASTER" SET "COOP_ID" = :COOP_ID, "MRTGMAST_NO" = :MRTGMAST_NO, "MEMBER_NO" = :MEMBER_NO, "COLLMATE_FLAG" = :COLLMATE_FLAG, "COLLMATE_MEMNO" = :COLLMATE_MEMNO, "ASSETTYPE_CODE" = :ASSETTYPE_CODE, "MORTGAGE_TYPE" = :MORTGAGE_TYPE, "MORTGAGE_LANDNUM" = :MORTGAGE_LANDNUM, "MORTGAGE_PARTNAME" = :MORTGAGE_PARTNAME, "MORTGAGE_PARTAMT" = :MORTGAGE_PARTAMT, "MORTGAGE_PARTALL" = :MORTGAGE_PARTALL, "MORTGAGE_DATE" = :MORTGAGE_DATE, "MORTGAGE_GRTNAME" = :MORTGAGE_GRTNAME, "INTEREST_RATE" = :INTEREST_RATE, "MORTGAGEFIRST_AMT" = :MORTGAGEFIRST_AMT, "MORTGAGESUM_AMT" = :MORTGAGESUM_AMT, "LAND_OFFICE" = :LAND_OFFICE, "MRTGMAST_STATUS" = :MRTGMAST_STATUS, "ENTRY_ID" = :ENTRY_ID WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MRTGMAST_NO" = :Original_MRTGMAST_NO)) DELETE FROM "LNMRTGMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MRTGMAST_NO" = :Original_MRTGMAST_NO)) INSERT INTO "LNMRTGMASTER" ("COOP_ID", "MRTGMAST_NO", "MEMBER_NO", "MRTG_NAME1", "MRTG_NAME2", "MRTG_PERSONID1", "MRTG_PERSONID2", "MRTG_AGE1", "MRTG_AGE2", "MRTG_NATIONALITY1", "MRTG_NATIONALITY2", "MRTG_CITIZENSHIP1", "MRTG_CITIZENSHIP2", "MRTG_PARENTNAME1", "MRTG_PARENTNAME2", "MRTG_MATENAME1", "MRTG_MATENAME2", "MRTG_VILLAGE1", "MRTG_VILLAGE2", "MRTG_ADDRESS1", "MRTG_ADDRESS2", "MRTG_MOO1", "MRTG_MOO2", "MRTG_SOI1", "MRTG_SOI2", "MRTG_ROAD1", "MRTG_ROAD2", "MRTG_TAMBOL1", "MRTG_TAMBOL2", "MRTG_AMPHUR1", "MRTG_AMPHUR2", "MRTG_PROVINCE1", "MRTG_PROVINCE2") VALUES (:COOP_ID, :MRTGMAST_NO, :MEMBER_NO, :MRTG_NAME1, :MRTG_NAME2, :MRTG_PERSONID1, :MRTG_PERSONID2, :MRTG_AGE1, :MRTG_AGE2, :MRTG_NATIONALITY1, :MRTG_NATIONALITY2, :MRTG_CITIZENSHIP1, :MRTG_CITIZENSHIP2, :MRTG_PARENTNAME1, :MRTG_PARENTNAME2, :MRTG_MATENAME1, :MRTG_MATENAME2, :MRTG_VILLAGE1, :MRTG_VILLAGE2, :MRTG_ADDRESS1, :MRTG_ADDRESS2, :MRTG_MOO1, :MRTG_MOO2, :MRTG_SOI1, :MRTG_SOI2, :MRTG_ROAD1, :MRTG_ROAD2, :MRTG_TAMBOL1, :MRTG_TAMBOL2, :MRTG_AMPHUR1, :MRTG_AMPHUR2, :MRTG_PROVINCE1, :MRTG_PROVINCE2) SELECT COOP_ID, MRTGMAST_NO, MEMBER_NO, MRTG_NAME1, MRTG_NAME2, MRTG_PERSONID1, MRTG_PERSONID2, MRTG_AGE1, MRTG_AGE2, MRTG_NATIONALITY1, MRTG_NATIONALITY2, MRTG_CITIZENSHIP1, MRTG_CITIZENSHIP2, MRTG_PARENTNAME1, MRTG_PARENTNAME2, MRTG_MATENAME1, MRTG_MATENAME2, MRTG_VILLAGE1, MRTG_VILLAGE2, MRTG_ADDRESS1, MRTG_ADDRESS2, MRTG_MOO1, MRTG_MOO2, MRTG_SOI1, MRTG_SOI2, MRTG_ROAD1, MRTG_ROAD2, MRTG_TAMBOL1, MRTG_TAMBOL2, MRTG_AMPHUR1, MRTG_AMPHUR2, MRTG_PROVINCE1, MRTG_PROVINCE2 FROM LNMRTGMASTER WHERE (COOP_ID = :as_coopid) AND (MRTGMAST_NO = :as_mrtgno) UPDATE "LNMRTGMASTER" SET "COOP_ID" = :COOP_ID, "MRTGMAST_NO" = :MRTGMAST_NO, "MEMBER_NO" = :MEMBER_NO, "MRTG_NAME1" = :MRTG_NAME1, "MRTG_NAME2" = :MRTG_NAME2, "MRTG_PERSONID1" = :MRTG_PERSONID1, "MRTG_PERSONID2" = :MRTG_PERSONID2, "MRTG_AGE1" = :MRTG_AGE1, "MRTG_AGE2" = :MRTG_AGE2, "MRTG_NATIONALITY1" = :MRTG_NATIONALITY1, "MRTG_NATIONALITY2" = :MRTG_NATIONALITY2, "MRTG_CITIZENSHIP1" = :MRTG_CITIZENSHIP1, "MRTG_CITIZENSHIP2" = :MRTG_CITIZENSHIP2, "MRTG_PARENTNAME1" = :MRTG_PARENTNAME1, "MRTG_PARENTNAME2" = :MRTG_PARENTNAME2, "MRTG_MATENAME1" = :MRTG_MATENAME1, "MRTG_MATENAME2" = :MRTG_MATENAME2, "MRTG_VILLAGE1" = :MRTG_VILLAGE1, "MRTG_VILLAGE2" = :MRTG_VILLAGE2, "MRTG_ADDRESS1" = :MRTG_ADDRESS1, "MRTG_ADDRESS2" = :MRTG_ADDRESS2, "MRTG_MOO1" = :MRTG_MOO1, "MRTG_MOO2" = :MRTG_MOO2, "MRTG_SOI1" = :MRTG_SOI1, "MRTG_SOI2" = :MRTG_SOI2, "MRTG_ROAD1" = :MRTG_ROAD1, "MRTG_ROAD2" = :MRTG_ROAD2, "MRTG_TAMBOL1" = :MRTG_TAMBOL1, "MRTG_TAMBOL2" = :MRTG_TAMBOL2, "MRTG_AMPHUR1" = :MRTG_AMPHUR1, "MRTG_AMPHUR2" = :MRTG_AMPHUR2, "MRTG_PROVINCE1" = :MRTG_PROVINCE1, "MRTG_PROVINCE2" = :MRTG_PROVINCE2 WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MRTGMAST_NO" = :Original_MRTGMAST_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "COLLMAST_REFNO", "COLLMASTTYPE_CODE", "COLLMAST_DESC", "LANDESTIMATE_AMT", "HOUSEESTIMATE_AMT", "ESTIMATE_PRICE", "MORTGAGE_PRICE", "MORTGAGE_DATE", "EXPIRE_DATE", "REDEEM_FLAG", "REDEEM_DATE", "REMARK", "BLINDLAND_FLAG", "MEMBER_NO", "LANDSIDE_NO", "COLLRELATION_CODE", "OWNER_RELATION", "LAND_DEPARTMENT", "LAND_NO", "SURVEY_NO", "BOOK_NO", "PAGE_NO", "GROUP_NO", "LOANREQUEST_DOCNO", "COLLMAST_DATE", "MEMCOOP_ID", "COLLMAST_PRICE", "LAND_RAVANG", "LAND_DOCNO", "LAND_LANDNO", "LAND_SURVEY", "LAND_BOOKNO", "LAND_PAGENO", "POS_TAMBOL", "POS_AMPHUR", "POS_PROVINCE", "SIZE_RAI", "SIZE_NGAN", "SIZE_WA", "PHOTOAIR_PROVINCE", "PHOTOAIR_NUMBER", "PHOTOAIR_PAGE", "PRICEPER_UNIT", "DOL_PRINCE", "EST_PERCENT", "EST_PRICE", "BD_VILLAGE", "BD_ADDRNO", "BD_ADDRMOO", "BD_SOI", "BD_ROAD", "BD_TAMBOL", "BD_AMPHUR", "BD_PROVINCE", "BD_TYPE", "BD_DEPRECIATION", "BD_ONLANDNO", "CONDO_REGISTNO", "CONDO_NAME", "CONDO_TOWERNO", "CONDO_FLOOR", "CONDO_ROOMNO", "CONDO_ROOMSIZE", "CONDO_PRICESQUARE", "COLLMASTTYPE_GRP", "BD_SUMPRICE", "BD_AGE", "CONDO_DEPRECIATION", "CONDO_AGE", "DESC_POSITION", "DESC_UTILITY", "DESC_TRAVEL", "DESC_ETC", "OTHERNET_AMT", "OTHERNET_PERCENT", "OTHEREST_AMT", "OTHEREST_DESC", "HOUSEEST_PERCENT", "HOUSEESTIMATE2_AMT", "PRICE_AREA2", "TOTAL_AREA2", "LANDEST_PERCENT", "HOUSEESTIMATE1_AMT", "PRICE_AREA1", "TOTAL_AREA1", "INSPECTER_DESC", "MORTGAGE_TYPE", "MORTGAGE_LANDNUM", "FATHER_NAME", "MATHER_NAME", "MORTGAGE_PARTAMT", "MORTGAGE_PARTALL", "REFCOLL_NAME", "LAND_OFFICE", "MRTG_NAME1", "MRTG_PERSONID1", "MRTG_AGE1", "MRTG_NATIONALITY1", "MRTG_CITIZENSHIP1", "MRTG_VILLAGE1", "MRTG_ADDRESS1", "MRTG_MOO1", "MRTG_SOI1", "MRTG_ROAD1", "MRTG_TAMBOL1", "MRTG_AMPHUR1", "MRTG_PROVINCE1", "MRTG_NAME2", "MRTG_PERSONID2", "MRTG_AGE2", "MRTG_NATIONALITY2", "MRTG_CITIZENSHIP2", "MRTG_VILLAGE2", "MRTG_ADDRESS2", "MRTG_MOO2", "MRTG_SOI2", "MRTG_ROAD2", "MRTG_TAMBOL2", "MRTG_AMPHUR2", "MRTG_PROVINCE2", "DETAIL3", "DETAIL4", "PEOPLE_NAME", "PEOPLE_POSITION", "MRTG_PARENTNAME2", "MRTG_MATENAME2", "REFCOLL_MEMNO", "MRTG_MATENAME1", "POS_MOO", "POS_ADDNO") VALUES (:COOP_ID, :COLLMAST_NO, :COLLMAST_REFNO, :COLLMASTTYPE_CODE, :COLLMAST_DESC, :LANDESTIMATE_AMT, :HOUSEESTIMATE_AMT, :ESTIMATE_PRICE, :MORTGAGE_PRICE, :MORTGAGE_DATE, :EXPIRE_DATE, :REDEEM_FLAG, :REDEEM_DATE, :REMARK, :BLINDLAND_FLAG, :MEMBER_NO, :LANDSIDE_NO, :COLLRELATION_CODE, :OWNER_RELATION, :LAND_DEPARTMENT, :LAND_NO, :SURVEY_NO, :BOOK_NO, :PAGE_NO, :GROUP_NO, :LOANREQUEST_DOCNO, :COLLMAST_DATE, :MEMCOOP_ID, :COLLMAST_PRICE, :LAND_RAVANG, :LAND_DOCNO, :LAND_LANDNO, :LAND_SURVEY, :LAND_BOOKNO, :LAND_PAGENO, :POS_TAMBOL, :POS_AMPHUR, :POS_PROVINCE, :SIZE_RAI, :SIZE_NGAN, :SIZE_WA, :PHOTOAIR_PROVINCE, :PHOTOAIR_NUMBER, :PHOTOAIR_PAGE, :PRICEPER_UNIT, :DOL_PRINCE, :EST_PERCENT, :EST_PRICE, :BD_VILLAGE, :BD_ADDRNO, :BD_ADDRMOO, :BD_SOI, :BD_ROAD, :BD_TAMBOL, :BD_AMPHUR, :BD_PROVINCE, :BD_TYPE, :BD_DEPRECIATION, :BD_ONLANDNO, :CONDO_REGISTNO, :CONDO_NAME, :CONDO_TOWERNO, :CONDO_FLOOR, :CONDO_ROOMNO, :CONDO_ROOMSIZE, :CONDO_PRICESQUARE, :COLLMASTTYPE_GRP, :BD_SUMPRICE, :BD_AGE, :CONDO_DEPRECIATION, :CONDO_AGE, :DESC_POSITION, :DESC_UTILITY, :DESC_TRAVEL, :DESC_ETC, :OTHERNET_AMT, :OTHERNET_PERCENT, :OTHEREST_AMT, :OTHEREST_DESC, :HOUSEEST_PERCENT, :HOUSEESTIMATE2_AMT, :PRICE_AREA2, :TOTAL_AREA2, :LANDEST_PERCENT, :HOUSEESTIMATE1_AMT, :PRICE_AREA1, :TOTAL_AREA1, :INSPECTER_DESC, :MORTGAGE_TYPE, :MORTGAGE_LANDNUM, :FATHER_NAME, :MATHER_NAME, :MORTGAGE_PARTAMT, :MORTGAGE_PARTALL, :REFCOLL_NAME, :LAND_OFFICE, :MRTG_NAME1, :MRTG_PERSONID1, :MRTG_AGE1, :MRTG_NATIONALITY1, :MRTG_CITIZENSHIP1, :MRTG_VILLAGE1, :MRTG_ADDRESS1, :MRTG_MOO1, :MRTG_SOI1, :MRTG_ROAD1, :MRTG_TAMBOL1, :MRTG_AMPHUR1, :MRTG_PROVINCE1, :MRTG_NAME2, :MRTG_PERSONID2, :MRTG_AGE2, :MRTG_NATIONALITY2, :MRTG_CITIZENSHIP2, :MRTG_VILLAGE2, :MRTG_ADDRESS2, :MRTG_MOO2, :MRTG_SOI2, :MRTG_ROAD2, :MRTG_TAMBOL2, :MRTG_AMPHUR2, :MRTG_PROVINCE2, :DETAIL3, :DETAIL4, :PEOPLE_NAME, :PEOPLE_POSITION, :MRTG_PARENTNAME2, :MRTG_MATENAME2, :REFCOLL_MEMNO, :MRTG_MATENAME1, :POS_MOO, :POS_ADDNO) SELECT COOP_ID, COLLMAST_NO, COLLMAST_REFNO, COLLMASTTYPE_CODE, COLLMAST_DESC, LANDESTIMATE_AMT, HOUSEESTIMATE_AMT, ESTIMATE_PRICE, MORTGAGE_PRICE, MORTGAGE_DATE, EXPIRE_DATE, REDEEM_FLAG, REDEEM_DATE, REMARK, BLINDLAND_FLAG, MEMBER_NO, LANDSIDE_NO, COLLRELATION_CODE, OWNER_RELATION, LAND_DEPARTMENT, LAND_NO, SURVEY_NO, BOOK_NO, PAGE_NO, GROUP_NO, LOANREQUEST_DOCNO, COLLMAST_DATE, MEMCOOP_ID, COLLMAST_PRICE, LAND_RAVANG, LAND_DOCNO, LAND_LANDNO, LAND_SURVEY, LAND_BOOKNO, LAND_PAGENO, POS_TAMBOL, POS_AMPHUR, POS_PROVINCE, SIZE_RAI, SIZE_NGAN, SIZE_WA, PHOTOAIR_PROVINCE, PHOTOAIR_NUMBER, PHOTOAIR_PAGE, PRICEPER_UNIT, DOL_PRINCE, EST_PERCENT, EST_PRICE, BD_VILLAGE, BD_ADDRNO, BD_ADDRMOO, BD_SOI, BD_ROAD, BD_TAMBOL, BD_AMPHUR, BD_PROVINCE, BD_TYPE, BD_DEPRECIATION, BD_ONLANDNO, CONDO_REGISTNO, CONDO_NAME, CONDO_TOWERNO, CONDO_FLOOR, CONDO_ROOMNO, CONDO_ROOMSIZE, CONDO_PRICESQUARE, COLLMASTTYPE_GRP, BD_SUMPRICE, BD_AGE, CONDO_DEPRECIATION, CONDO_AGE, DESC_POSITION, DESC_UTILITY, DESC_TRAVEL, DESC_ETC, OTHERNET_AMT, OTHERNET_PERCENT, OTHEREST_AMT, OTHEREST_DESC, HOUSEEST_PERCENT, HOUSEESTIMATE2_AMT, PRICE_AREA2, TOTAL_AREA2, LANDEST_PERCENT, HOUSEESTIMATE1_AMT, PRICE_AREA1, TOTAL_AREA1, INSPECTER_DESC, MORTGAGE_TYPE, MORTGAGE_LANDNUM, FATHER_NAME, MATHER_NAME, MORTGAGE_PARTAMT, MORTGAGE_PARTALL, REFCOLL_NAME, LAND_OFFICE, MRTG_NAME1, MRTG_PERSONID1, MRTG_AGE1, MRTG_NATIONALITY1, MRTG_CITIZENSHIP1, MRTG_VILLAGE1, MRTG_ADDRESS1, MRTG_MOO1, MRTG_SOI1, MRTG_ROAD1, MRTG_TAMBOL1, MRTG_AMPHUR1, MRTG_PROVINCE1, MRTG_NAME2, MRTG_PERSONID2, MRTG_AGE2, MRTG_NATIONALITY2, MRTG_CITIZENSHIP2, MRTG_VILLAGE2, MRTG_ADDRESS2, MRTG_MOO2, MRTG_SOI2, MRTG_ROAD2, MRTG_TAMBOL2, MRTG_AMPHUR2, MRTG_PROVINCE2, DETAIL3, DETAIL4, PEOPLE_NAME, PEOPLE_POSITION ,mrtg_parentname2,mrtg_matename2,refcoll_memno,mrtg_matename1,pos_moo,pos_addno FROM LNCOLLMASTER UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "COLLMAST_REFNO" = :COLLMAST_REFNO, "COLLMASTTYPE_CODE" = :COLLMASTTYPE_CODE, "COLLMAST_DESC" = :COLLMAST_DESC, "LANDESTIMATE_AMT" = :LANDESTIMATE_AMT, "HOUSEESTIMATE_AMT" = :HOUSEESTIMATE_AMT, "ESTIMATE_PRICE" = :ESTIMATE_PRICE, "MORTGAGE_PRICE" = :MORTGAGE_PRICE, "MORTGAGE_DATE" = :MORTGAGE_DATE, "EXPIRE_DATE" = :EXPIRE_DATE, "REDEEM_FLAG" = :REDEEM_FLAG, "REDEEM_DATE" = :REDEEM_DATE, "REMARK" = :REMARK, "BLINDLAND_FLAG" = :BLINDLAND_FLAG, "MEMBER_NO" = :MEMBER_NO, "LANDSIDE_NO" = :LANDSIDE_NO, "COLLRELATION_CODE" = :COLLRELATION_CODE, "OWNER_RELATION" = :OWNER_RELATION, "LAND_DEPARTMENT" = :LAND_DEPARTMENT, "LAND_NO" = :LAND_NO, "SURVEY_NO" = :SURVEY_NO, "BOOK_NO" = :BOOK_NO, "PAGE_NO" = :PAGE_NO, "GROUP_NO" = :GROUP_NO, "LOANREQUEST_DOCNO" = :LOANREQUEST_DOCNO, "COLLMAST_DATE" = :COLLMAST_DATE, "MEMCOOP_ID" = :MEMCOOP_ID, "COLLMAST_PRICE" = :COLLMAST_PRICE, "LAND_RAVANG" = :LAND_RAVANG, "LAND_DOCNO" = :LAND_DOCNO, "LAND_LANDNO" = :LAND_LANDNO, "LAND_SURVEY" = :LAND_SURVEY, "LAND_BOOKNO" = :LAND_BOOKNO, "LAND_PAGENO" = :LAND_PAGENO, "POS_TAMBOL" = :POS_TAMBOL, "POS_AMPHUR" = :POS_AMPHUR, "POS_PROVINCE" = :POS_PROVINCE, "SIZE_RAI" = :SIZE_RAI, "SIZE_NGAN" = :SIZE_NGAN, "SIZE_WA" = :SIZE_WA, "PHOTOAIR_PROVINCE" = :PHOTOAIR_PROVINCE, "PHOTOAIR_NUMBER" = :PHOTOAIR_NUMBER, "PHOTOAIR_PAGE" = :PHOTOAIR_PAGE, "PRICEPER_UNIT" = :PRICEPER_UNIT, "DOL_PRINCE" = :DOL_PRINCE, "EST_PERCENT" = :EST_PERCENT, "EST_PRICE" = :EST_PRICE, "BD_VILLAGE" = :BD_VILLAGE, "BD_ADDRNO" = :BD_ADDRNO, "BD_ADDRMOO" = :BD_ADDRMOO, "BD_SOI" = :BD_SOI, "BD_ROAD" = :BD_ROAD, "BD_TAMBOL" = :BD_TAMBOL, "BD_AMPHUR" = :BD_AMPHUR, "BD_PROVINCE" = :BD_PROVINCE, "BD_TYPE" = :BD_TYPE, "BD_DEPRECIATION" = :BD_DEPRECIATION, "BD_ONLANDNO" = :BD_ONLANDNO, "CONDO_REGISTNO" = :CONDO_REGISTNO, "CONDO_NAME" = :CONDO_NAME, "CONDO_TOWERNO" = :CONDO_TOWERNO, "CONDO_FLOOR" = :CONDO_FLOOR, "CONDO_ROOMNO" = :CONDO_ROOMNO, "CONDO_ROOMSIZE" = :CONDO_ROOMSIZE, "CONDO_PRICESQUARE" = :CONDO_PRICESQUARE, "COLLMASTTYPE_GRP" = :COLLMASTTYPE_GRP, "BD_SUMPRICE" = :BD_SUMPRICE, "BD_AGE" = :BD_AGE, "CONDO_DEPRECIATION" = :CONDO_DEPRECIATION, "CONDO_AGE" = :CONDO_AGE, "DESC_POSITION" = :DESC_POSITION, "DESC_UTILITY" = :DESC_UTILITY, "DESC_TRAVEL" = :DESC_TRAVEL, "DESC_ETC" = :DESC_ETC, "OTHERNET_AMT" = :OTHERNET_AMT, "OTHERNET_PERCENT" = :OTHERNET_PERCENT, "OTHEREST_AMT" = :OTHEREST_AMT, "OTHEREST_DESC" = :OTHEREST_DESC, "HOUSEEST_PERCENT" = :HOUSEEST_PERCENT, "HOUSEESTIMATE2_AMT" = :HOUSEESTIMATE2_AMT, "PRICE_AREA2" = :PRICE_AREA2, "TOTAL_AREA2" = :TOTAL_AREA2, "LANDEST_PERCENT" = :LANDEST_PERCENT, "HOUSEESTIMATE1_AMT" = :HOUSEESTIMATE1_AMT, "PRICE_AREA1" = :PRICE_AREA1, "TOTAL_AREA1" = :TOTAL_AREA1, "INSPECTER_DESC" = :INSPECTER_DESC, "MORTGAGE_TYPE" = :MORTGAGE_TYPE, "MORTGAGE_LANDNUM" = :MORTGAGE_LANDNUM, "FATHER_NAME" = :FATHER_NAME, "MATHER_NAME" = :MATHER_NAME, "MORTGAGE_PARTAMT" = :MORTGAGE_PARTAMT, "MORTGAGE_PARTALL" = :MORTGAGE_PARTALL, "REFCOLL_NAME" = :REFCOLL_NAME, "LAND_OFFICE" = :LAND_OFFICE, "MRTG_NAME1" = :MRTG_NAME1, "MRTG_PERSONID1" = :MRTG_PERSONID1, "MRTG_AGE1" = :MRTG_AGE1, "MRTG_NATIONALITY1" = :MRTG_NATIONALITY1, "MRTG_CITIZENSHIP1" = :MRTG_CITIZENSHIP1, "MRTG_VILLAGE1" = :MRTG_VILLAGE1, "MRTG_ADDRESS1" = :MRTG_ADDRESS1, "MRTG_MOO1" = :MRTG_MOO1, "MRTG_SOI1" = :MRTG_SOI1, "MRTG_ROAD1" = :MRTG_ROAD1, "MRTG_TAMBOL1" = :MRTG_TAMBOL1, "MRTG_AMPHUR1" = :MRTG_AMPHUR1, "MRTG_PROVINCE1" = :MRTG_PROVINCE1, "MRTG_NAME2" = :MRTG_NAME2, "MRTG_PERSONID2" = :MRTG_PERSONID2, "MRTG_AGE2" = :MRTG_AGE2, "MRTG_NATIONALITY2" = :MRTG_NATIONALITY2, "MRTG_CITIZENSHIP2" = :MRTG_CITIZENSHIP2, "MRTG_VILLAGE2" = :MRTG_VILLAGE2, "MRTG_ADDRESS2" = :MRTG_ADDRESS2, "MRTG_MOO2" = :MRTG_MOO2, "MRTG_SOI2" = :MRTG_SOI2, "MRTG_ROAD2" = :MRTG_ROAD2, "MRTG_TAMBOL2" = :MRTG_TAMBOL2, "MRTG_AMPHUR2" = :MRTG_AMPHUR2, "MRTG_PROVINCE2" = :MRTG_PROVINCE2, "DETAIL3" = :DETAIL3, "DETAIL4" = :DETAIL4, "PEOPLE_NAME" = :PEOPLE_NAME, "PEOPLE_POSITION" = :PEOPLE_POSITION, "MRTG_PARENTNAME2" = :MRTG_PARENTNAME2, "MRTG_MATENAME2" = :MRTG_MATENAME2, "REFCOLL_MEMNO" = :REFCOLL_MEMNO, "MRTG_MATENAME1" = :MRTG_MATENAME1, "POS_MOO" = :POS_MOO, "POS_ADDNO" = :POS_ADDNO WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) SELECT COOP_ID, COLLMAST_NO, COLLMAST_REFNO, COLLMASTTYPE_CODE, COLLMAST_DESC, LANDESTIMATE_AMT, HOUSEESTIMATE_AMT, ESTIMATE_PRICE, MORTGAGE_PRICE, MORTGAGE_DATE, EXPIRE_DATE, REDEEM_FLAG, REDEEM_DATE, REMARK, BLINDLAND_FLAG, MEMBER_NO, LANDSIDE_NO, COLLRELATION_CODE, OWNER_RELATION, LAND_DEPARTMENT, LAND_NO, SURVEY_NO, BOOK_NO, PAGE_NO, GROUP_NO, LOANREQUEST_DOCNO, COLLMAST_DATE, MEMCOOP_ID, COLLMAST_PRICE, LAND_RAVANG, LAND_DOCNO, LAND_LANDNO, LAND_SURVEY, LAND_BOOKNO, LAND_PAGENO, POS_TAMBOL, POS_AMPHUR, POS_PROVINCE, SIZE_RAI, SIZE_NGAN, SIZE_WA, PHOTOAIR_PROVINCE, PHOTOAIR_NUMBER, PHOTOAIR_PAGE, PRICEPER_UNIT, DOL_PRINCE, EST_PERCENT, EST_PRICE, BD_VILLAGE, BD_ADDRNO, BD_ADDRMOO, BD_SOI, BD_ROAD, BD_TAMBOL, BD_AMPHUR, BD_PROVINCE, BD_TYPE, BD_DEPRECIATION, BD_ONLANDNO, CONDO_REGISTNO, CONDO_NAME, CONDO_TOWERNO, CONDO_FLOOR, CONDO_ROOMNO, CONDO_ROOMSIZE, CONDO_PRICESQUARE, COLLMASTTYPE_GRP, BD_SUMPRICE, BD_AGE, CONDO_DEPRECIATION, CONDO_AGE, DESC_POSITION, DESC_UTILITY, DESC_TRAVEL, DESC_ETC, OTHERNET_AMT, OTHERNET_PERCENT, OTHEREST_AMT, OTHEREST_DESC, HOUSEEST_PERCENT, HOUSEESTIMATE2_AMT, PRICE_AREA2, TOTAL_AREA2, LANDEST_PERCENT, HOUSEESTIMATE1_AMT, PRICE_AREA1, TOTAL_AREA1, INSPECTER_DESC, MORTGAGE_TYPE, MORTGAGE_LANDNUM, FATHER_NAME, MATHER_NAME, MORTGAGE_PARTAMT, MORTGAGE_PARTALL, REFCOLL_NAME, LAND_OFFICE, MRTG_NAME1, MRTG_PERSONID1, MRTG_AGE1, MRTG_NATIONALITY1, MRTG_CITIZENSHIP1, MRTG_VILLAGE1, MRTG_ADDRESS1, MRTG_MOO1, MRTG_SOI1, MRTG_ROAD1, MRTG_TAMBOL1, MRTG_AMPHUR1, MRTG_PROVINCE1, MRTG_NAME2, MRTG_PERSONID2, MRTG_AGE2, MRTG_NATIONALITY2, MRTG_CITIZENSHIP2, MRTG_VILLAGE2, MRTG_ADDRESS2, MRTG_MOO2, MRTG_SOI2, MRTG_ROAD2, MRTG_TAMBOL2, MRTG_AMPHUR2, MRTG_PROVINCE2, DETAIL3, DETAIL4, PEOPLE_NAME, PEOPLE_POSITION ,mrtg_parentname2,mrtg_matename2,refcoll_memno,mrtg_matename1,pos_moo,pos_addno FROM LNCOLLMASTER DELETE FROM "LNCOLLCONSTANT" WHERE (("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNCOLLCONSTANT" ("COOP_ID", "OFFICE_COLL", "INT_RATE", "PEOPLE_NAME", "PEOPLE_POSITION", "DETAIL3", "DETAIL4") VALUES (:COOP_ID, :OFFICE_COLL, :INT_RATE, :PEOPLE_NAME, :PEOPLE_POSITION, :DETAIL3, :DETAIL4) select * from lncollconstant UPDATE "LNCOLLCONSTANT" SET "COOP_ID" = :COOP_ID, "OFFICE_COLL" = :OFFICE_COLL, "INT_RATE" = :INT_RATE, "PEOPLE_NAME" = :PEOPLE_NAME, "PEOPLE_POSITION" = :PEOPLE_POSITION, "DETAIL3" = :DETAIL3, "DETAIL4" = :DETAIL4 WHERE (("COOP_ID" = :Original_COOP_ID))