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", "INSPECTOR_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", "INT_RATE", "MRTG_MATENAME1", "REFCOLL_MEMNO", "MRTG_PARENTNAME2", "MRTG_MATENAME2", "MRTG_PARENTNAME1", "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, :INSPECTOR_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, :INT_RATE, :MRTG_MATENAME1, :REFCOLL_MEMNO, :MRTG_PARENTNAME2, :MRTG_MATENAME2, :MRTG_PARENTNAME1, :POS_MOO, :POS_ADDNO) select * 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, "INSPECTOR_DESC" = :INSPECTOR_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, "INT_RATE" = :INT_RATE, "MRTG_MATENAME1" = :MRTG_MATENAME1, "REFCOLL_MEMNO" = :REFCOLL_MEMNO, "MRTG_PARENTNAME2" = :MRTG_PARENTNAME2, "MRTG_MATENAME2" = :MRTG_MATENAME2, "MRTG_PARENTNAME1" = :MRTG_PARENTNAME1, "POS_MOO" = :POS_MOO, "POS_ADDNO" = :POS_ADDNO WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNCOLLMASTER" ("MORTGAGE_COUNT", "FIRST_MRTG_AMT", "SECOUND_MRTG_AMT", "THREE_MRTG_AMT", "FOUR_MRTG_AMT", "FIVE_MRTG_AMT", "OLD_MRTG_AMT", "THIS_MRTG_AMT", "SIX_MRTG_AMT", "COLLMAST_NO", "COOP_ID", "MONEY_DETAIL1", "MONEY_DETAIL2", "MONEY_DETAIL3") VALUES (:MORTGAGE_COUNT, :FIRST_MRTG_AMT, :SECOUND_MRTG_AMT, :THREE_MRTG_AMT, :FOUR_MRTG_AMT, :FIVE_MRTG_AMT, :OLD_MRTG_AMT, :THIS_MRTG_AMT, :SIX_MRTG_AMT, :COLLMAST_NO, :COOP_ID, :MONEY_DETAIL1, :MONEY_DETAIL2, :MONEY_DETAIL3) SELECT MORTGAGE_COUNT, FIRST_MRTG_AMT, SECOUND_MRTG_AMT, THREE_MRTG_AMT, FOUR_MRTG_AMT, FIVE_MRTG_AMT, OLD_MRTG_AMT, THIS_MRTG_AMT, SIX_MRTG_AMT, COLLMAST_NO, COOP_ID,money_detail1,money_detail2,money_detail3 FROM LNCOLLMASTER UPDATE "LNCOLLMASTER" SET "MORTGAGE_COUNT" = :MORTGAGE_COUNT, "FIRST_MRTG_AMT" = :FIRST_MRTG_AMT, "SECOUND_MRTG_AMT" = :SECOUND_MRTG_AMT, "THREE_MRTG_AMT" = :THREE_MRTG_AMT, "FOUR_MRTG_AMT" = :FOUR_MRTG_AMT, "FIVE_MRTG_AMT" = :FIVE_MRTG_AMT, "OLD_MRTG_AMT" = :OLD_MRTG_AMT, "THIS_MRTG_AMT" = :THIS_MRTG_AMT, "SIX_MRTG_AMT" = :SIX_MRTG_AMT, "COLLMAST_NO" = :COLLMAST_NO, "COOP_ID" = :COOP_ID, "MONEY_DETAIL1" = :MONEY_DETAIL1, "MONEY_DETAIL2" = :MONEY_DETAIL2, "MONEY_DETAIL3" = :MONEY_DETAIL3 WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID))