      INSERT
      /*+ APPEND PARALLEL(STG_EBV_DEPOSIT_ACCOUNTS, DEFAULT, DEFAULT)  */
      INTO
        "DWH_OWNER"."STG_EBV_DEPOSIT_ACCOUNTS"
        ("ACC_KEY",
        "ACC_MASTER_KEY",
        "ORG_KEY",
        "CLOSETP_KEY",
        "ACCSCH_KEY",
        "PT_KEY",
        "PTORI_KEY",
        "ACCTP_KEY",
        "ACCTP_MASTER_KEY",
        "ACCLS_KEY",
        "ACCLS_DISPO_KEY",
        "ACCLS_WORST_KEY",
        "CURR_KEY",
        "ACCPRP_KEY_BANK_PURP",
        "ACCPRP_KEY_STATUTORY_PURP",
        "ACCPRP_KEY_BUILDING_PURP",
        "PROD_KEY",
        "ACCST_KEY",
        "ACCPAYTP_KEY",
        "ACCPAYTP_PRINCIPAL_KEY",
        "ACCOBJ_KEY",
        "ACPHASE_KEY",
        "ACCWOTP_KEY",
        "CONTRST_KEY",
        "PERTYPE_KEY",
        "PERTYPE_INTEREST_KEY",
        "ACCPAYMT_PRINCIPAL_KEY",
        "ACCPAYMT_INTEREST_KEY",
        "ACC_SOURCE_ID",
        "ACC_SOURCE_SYSTEM_ID",
        "ACC_ACCOUNT_PREFIX",
        "ACC_ACCOUNT_NUMBER",
        "ACC_ACCOUNT_SPECIFIC_SYMBOL",
        "ACC_ACCOUNT_FULL_NUMBER",
        "ACC_CONTRACT_NUMBER",
        "ACC_OPEN_DATE",
        "ACC_APPROVAL_DATE",
        "ACC_CONTRACT_SIGNATURE_DATE",
        "ACC_CLOSE_FLAG",
        "ACC_CLOSE_DATE",
        "ACC_WRITEOFF_DATE",
        "ACC_WRITEOFF_FLAG",
        "ACC_COLLECTIONS_FLAG",
        "ACC_COLLECTIONS_DATE",
        "ACC_SETTLE_BANK_CODE",
        "ACC_SETTLE_ACCOUNT_NUMBER",
        "ACC_TAX_CODE",
        "ACC_DISPO_RESTRICTION_DATE",
        "ACC_LIMIT_CHANGE_DATE",
        "ACC_DEPO_MANDATORY_MIN_BAL",
        "ACC_DEPO_CONTRACT_MIN_AMOUNT",
        "ACC_DEPO_SAVING_INSTAL_AMOUNT",
        "ACC_DEPO_SAVING_TARGET_AMOUNT",
        "ACC_DEPO_CYCLE_START_DATE",
        "ACC_DEPO_CYCLE_END_DATE",
        "ACC_DEPO_REVOLVING_FLAG",
        "ACC_DEPO_STD_MATURITY_FLAG",
        "ACC_DEPO_STD_INTEREST_FLAG",
        "ACC_DEPO_FINAL_MATURITY_DATE",
        "ACC_DEPO_PRINC_TIME_COUNT",
        "ACC_DEPO_INT_TIME_COUNT",
        "ACC_DEPO_EXTENSION_COUNT",
        "ACC_DEPO_INT_SETTLE_BANK_CODE",
        "ACC_DEPO_INT_SETTLE_ACC_NUM",
        "ACC_DEPO_LOAN_FLAG",
        "ACC_DEPO_LOAN_TITLE_DATE",
        "ACC_DEPO_LOAN_OFFER_DATE",
        "ACC_DEPO_LOAN_ACCOUNT_NUMBER",
        "ACC_DEPO_LOAN_BOOKING_FLAG",
        "ACC_DEPO_ADVANTAGE_FLAG",
        "ACC_INSERTED_DATETIME",
        "ACC_UPDATED_DATETIME",
        "ACC_INSERT_PROCESS_KEY",
        "ACC_UPDATE_PROCESS_KEY")
        (SELECT
          "DWH_OWNER_DEPOSIT_AC35572447"."ACC_KEY" "ACC_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACC_MASTER_KEY" "ACC_MASTER_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ORG_KEY" "ORG_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."CLOSETP_KEY" "CLOSETP_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCSCH_KEY" "ACCSCH_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."PT_KEY" "PT_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."PTORI_KEY" "PTORI_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCTP_KEY" "ACCTP_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCTP_MASTER_KEY" "ACCTP_MASTER_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCLS_KEY" "ACCLS_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCLS_DISPO_KEY" "ACCLS_DISPO_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCLS_WORST_KEY" "ACCLS_WORST_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."CURR_KEY" "CURR_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCPRP_KEY_BANK_PURP" "ACCPRP_KEY_BANK_PURP$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCPRP_KEY_STATUTORY_PURP" "ACCPRP_KEY_STATUTORY_PURP$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCPRP_KEY_BUILDING_PURP" "ACCPRP_KEY_BUILDING_PURP$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."PROD_KEY" "PROD_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCST_KEY" "ACCST_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCPAYTP_KEY" "ACCPAYTP_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCPAYTP_PRINCIPAL_KEY" "ACCPAYTP_PRINCIPAL_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCOBJ_KEY" "ACCOBJ_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACPHASE_KEY" "ACPHASE_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCWOTP_KEY" "ACCWOTP_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."CONTRST_KEY" "CONTRST_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."PERTYPE_KEY" "PERTYPE_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."PERTYPE_INTEREST_KEY" "PERTYPE_INTEREST_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCPAYMT_PRINCIPAL_KEY" "ACCPAYMT_PRINCIPAL_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCPAYMT_INTEREST_KEY" "ACCPAYMT_INTEREST_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_SOURCE_ID" "ACCH_SOURCE_ID$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_SOURCE_SYSTEM_ID" "ACCH_SOURCE_SYSTEM_ID$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_ACCOUNT_PREFIX" "ACCH_ACCOUNT_PREFIX$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_ACCOUNT_NUMBER" "ACCH_ACCOUNT_NUMBER$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_ACCOUNT_SPECIFIC_SYMBOL" "ACCH_ACCOUNT_SPECIFIC_SYMBOL$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_ACCOUNT_FULL_NUMBER" "ACCH_ACCOUNT_FULL_NUMBER$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_CONTRACT_NUMBER" "ACCH_CONTRACT_NUMBER$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_OPEN_DATE" "ACCH_OPEN_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_APPROVAL_DATE" "ACCH_APPROVAL_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_CONTRACT_SIGNATURE_DATE" "ACCH_CONTRACT_SIGNATURE_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_CLOSE_FLAG" "ACCH_CLOSE_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_CLOSE_DATE" "ACCH_CLOSE_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_WRITEOFF_DATE" "ACCH_WRITEOFF_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_WRITEOFF_FLAG" "ACCH_WRITEOFF_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_COLLECTIONS_FLAG" "ACCH_COLLECTIONS_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_COLLECTIONS_DATE" "ACCH_COLLECTIONS_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_SETTLE_BANK_CODE" "ACCH_SETTLE_BANK_CODE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_SETTLE_ACCOUNT_NUMBER" "ACCH_SETTLE_ACCOUNT_NUMBER$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_TAX_CODE" "ACCH_TAX_CODE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DISPO_RESTRICTION_DATE" "ACCH_DISPO_RESTRICTION_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_LIMIT_CHANGE_DATE" "ACCH_LIMIT_CHANGE_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_MANDATORY_MIN_BAL" "ACCH_DEPO_MANDATORY_MIN_BAL$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_CONTRACT_MIN_AMOUNT" "ACCH_DEPO_CONTRACT_MIN_AMOUN$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_SAVING_INSTAL_AMOUNT" "ACCH_DEPO_SAVING_INSTAL_AMOU$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_SAVING_TARGET_AMOUNT" "ACCH_DEPO_SAVING_TARGET_AMOU$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_CYCLE_START_DATE" "ACCH_DEPO_CYCLE_START_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_CYCLE_END_DATE" "ACCH_DEPO_CYCLE_END_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_REVOLVING_FLAG" "ACCH_DEPO_REVOLVING_FLAG$0",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_STD_MATURITY_FLAG" "ACCH_DEPO_STD_MATURITY_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_STD_INTEREST_FLAG" "ACCH_DEPO_STD_INTEREST_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_FINAL_MATURITY_DATE" "ACCH_DEPO_FINAL_MATURITY_DAT$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_PRINC_TIME_COUNT" "ACCH_DEPO_PRINC_TIME_COUNT$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_INT_TIME_COUNT" "ACCH_DEPO_INT_TIME_COUNT$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_EXTENSION_COUNT" "ACCH_DEPO_EXTENSION_COUNT$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_INT_SETTLE_BANK_CODE" "ACCH_DEPO_INT_SETTLE_BANK_CO$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_INT_SETTLE_ACC_NUM" "ACCH_DEPO_INT_SETTLE_ACC_NUM$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_LOAN_FLAG" "ACCH_DEPO_LOAN_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_LOAN_TITLE_DATE" "ACCH_DEPO_LOAN_TITLE_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_LOAN_OFFER_DATE" "ACCH_DEPO_LOAN_OFFER_DATE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_LOAN_ACCOUNT_NUMBER" "ACCH_DEPO_LOAN_ACCOUNT_NUMBE$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_LOAN_BOOKING_FLAG" "ACCH_DEPO_LOAN_BOOKING_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_DEPO_ADVANTAGE_FLAG" "ACCH_DEPO_ADVANTAGE_FLAG$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_INSERTED_DATETIME" "ACCH_INSERTED_DATETIME$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_UPDATED_DATETIME" "ACCH_UPDATED_DATETIME$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_INSERT_PROCESS_KEY" "ACCH_INSERT_PROCESS_KEY$1",
          "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_UPDATE_PROCESS_KEY" "ACCH_UPDATE_PROCESS_KEY$1"
        FROM  "DWH_OWNER"."DEPOSIT_ACCOUNT_HISTORY" "DWH_OWNER_DEPOSIT_AC35572447"  WHERE ( (MS_DWH_OUTEBV_STG_DEPO_M8A."P_EFFECTIVE_DATE") between "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_VALID_FROM" AND "DWH_OWNER_DEPOSIT_AC35572447"."ACCH_VALID_TO" ) AND
( "DWH_OWNER_DEPOSIT_AC35572447"."ACCTP_KEY" = 203 )
);