/*清理表单*/
/*后台操作日志表*/
truncate table SYS_RUNTIME_REQUEST_DETAIL;
truncate table sys_runtime_request_record;
truncate table sys_runtime_exception_log;
truncate table sys_runtime_req_url_detail;
truncate table SYS_RUNTIME_REQ_REC_ARCHIVE;
truncate table SYS_RUNTIME_EXP_LOG_ARCHIVE;
truncate table SYS_RUNTIME_REQ_TOP_TIMEUSE;
truncate table SYS_RUNTIME_REQ_TOP_USE;


drop sequence SYS_RUNTIME_REQ_TOP_USE_s;
create sequence SYS_RUNTIME_REQ_TOP_USE_s;
drop sequence SYS_RUNTIME_REQ_TOP_TIMEUSE_s;
create sequence SYS_RUNTIME_REQ_TOP_TIMEUSE_s;
drop sequence sys_runtime_req_url_detail_s;
create sequence sys_runtime_req_url_detail_s;


/*关键功能操作记录删除*/
truncate table hls_doc_operate_history;
drop sequence hls_doc_operate_history_s;
create sequence hls_doc_operate_history_s;
/*单据序列*/
drop sequence hls_document_s;
create sequence hls_document_s;

/*关联项目(租赁申请单)*/

truncate table prj_project;
truncate table prj_project_bp;
truncate table prj_project_bp_contact_info;
truncate table prj_project_lease_item;
truncate table prj_project_credit;
truncate table prj_project_content;
truncate table con_contract_content_history;





/*关联到租金计算*/
truncate table hls_fin_calculator_logs;
truncate table hls_fin_calculator_hd;
truncate table HLS_FIN_CALCULATOR_LN;
truncate table prj_quotation;
truncate table HLS_FIN_CALCULATOR_LN_FORMULA;
truncate table HLS_FIN_CALCULATOR_HD_FORMULA;






--关联到cdd_list_iterm
truncate table prj_cdd_item;
truncate table prj_cdd_item_doc_ref;
truncate table prj_cdd_item_check;
truncate table con_contract_item_detail;




/*工作流相关*/
truncate table zj_wfl_workflow_instance;
truncate table zj_wfl_workflow_instance_para;
truncate table zj_wfl_approve_record;
truncate table zj_wfl_instance_log;
truncate table zj_wfl_instance_node_hierarchy;
truncate table zj_wfl_instance_node_history;
truncate table zj_wfl_instance_node_rcpt_ht;
truncate table zj_wfl_instance_node_recipient;
truncate table zj_wfl_instance_node_hirc_ht;
truncate table ZJ_SYS_NOTIFY_LOGS;

drop sequence zj_wfl_workflow_instance_s;
create sequence zj_wfl_workflow_instance_s;

drop sequence zj_wfl_approve_record_s;
create sequence zj_wfl_approve_record_s;

drop sequence zj_wfl_instance_log_s;
create sequence zj_wfl_instance_log_s;

drop sequence zj_wfl_instance_node_hirc_s;
create sequence zj_wfl_instance_node_hirc_s;

drop sequence zj_wfl_instance_node_hsty_s;
create sequence zj_wfl_instance_node_hsty_s;

drop sequence zj_wfl_instance_node_rcpt_s;
create sequence zj_wfl_instance_node_rcpt_s;
/*合同相关表*/
truncate table con_contract;
truncate table con_contract_bp;
truncate table con_contract_billing_method;
truncate table con_contract_cashflow;
truncate table con_contract_cf_item;
truncate table con_contract_change_req;
truncate table con_contract_change_req_cf;
truncate table con_contract_change_req_flt;
truncate table con_contract_et_hd;
truncate table con_contract_et_ln;
truncate table con_contract_insurance;
truncate table con_contract_je;
truncate table con_contract_lease_item;
truncate table con_contract_zero_bc;
truncate table con_finance_income;
truncate table con_unearned_finance_income;
truncate table con_contract_content;
truncate table CON_CONTRACT_MORTGAGE;




/*导入临时表*/
truncate table fnd_interface_headers;
truncate table fnd_interface_lines;
truncate table fnd_interface_log;
drop sequence fnd_interface_headers_s;
create sequence fnd_interface_headers_s;
drop sequence fnd_interface_lines_s;
create sequence fnd_interface_lines_s;
drop sequence fnd_interface_log_s;
create sequence fnd_interface_log_s;

/*附件表*/
/*truncate table fnd_atm_attachment;
truncate table fnd_atm_attachment_multi;*/

DELETE FROM  fnd_atm_attachment fa where fa.attachment_id in(
    select attachment_id from FND_ATM_ATTACHMENT_MULTI t where t.table_name not in ('HLS_NOTICE_DEFINITION','HLS_DOC_FILE_TEMPLET')
  );

 DELETE FROM FND_ATM_ATTACHMENT_MULTI t where t.table_name not in ('HLS_NOTICE_DEFINITION','HLS_DOC_FILE_TEMPLET');


/*drop sequence fnd_atm_attachment_s;
create sequence fnd_atm_attachment_s;

drop sequence fnd_atm_attachment_multi_s;
create sequence fnd_atm_attachment_multi_s;
*/
/*相关事务表*/
truncate table csh_transaction;
truncate table csh_write_off;



drop sequence csh_write_off_s;
create sequence csh_write_off_s;

/*
  应收发票
*/

truncate table  acr_invoice_hd;
truncate table acr_invoice_ln;


/*付款*/
truncate table csh_payment_req_hd;
truncate table csh_payment_req_ln;


/*凭证相关*/

-- truncate table hls_journal_header;
-- truncate table hls_journal_detail;
--
-- drop sequence hls_journal_header_s;
-- create sequence hls_journal_header_s;
-- drop sequence hls_journal_detail_s;
-- create sequence hls_journal_detail_s;




/*用户登陆记录表*/
truncate table SYS_USER_LOGINS;
drop sequence SYS_USER_LOGINS_s;
create sequence SYS_USER_LOGINS_s;


/*事件与错误日志*/
truncate table EVT_EVENT_RECORD;
drop sequence EVT_EVENT_RECORD_s;
create sequence EVT_EVENT_RECORD_s;

truncate table EVT_EVENT_HANDLE_LOG;
drop sequence EVT_EVENT_HANDLE_LOG_s;
create sequence EVT_EVENT_HANDLE_LOG_s;

truncate table SYS_RAISE_APP_ERRORS;
drop sequence SYS_RAISE_APP_ERRORS_s;
create sequence SYS_RAISE_APP_ERRORS_s;


truncate table GLD_ACCOUNT_ASGN_CM_TMP;

truncate table HLS_DOCUMENT_HISTORY;

truncate table HLS_DOCUMENT_HISTORY_REF;
drop sequence HLS_DOCUMENT_HISTORY_REF_s;
create sequence HLS_DOCUMENT_HISTORY_REF_s;

/*月结标志重置*/
/*update GLD_PERIOD_STATUS t
   set t.monthly_closed_flag = '';*/





/*清除会计期间*/
/*truncate table GLD_PERIODS;
truncate table gld_period_status;*/

/*job相关*/
/*
truncate table sch_concurrent_job jo where jo.job_id !=0;
truncate table  sch_concurrent_job_log;
*/
/*临时表*/
truncate table FND_AGING_RESULT_LN_TMP;
truncate table FND_AGING_RESULT_HD_TMP;
truncate table SYS_CONDITION_MATCHING;
drop sequence SYS_CONDITION_MATCHING_s;
create sequence SYS_CONDITION_MATCHING_s;


/**/






truncate table hls_standard_history;
drop sequence hls_standard_history_s;
create sequence hls_standard_history_s;

/*update fnd_coding_rule_values fc
  set fc.current_value =1;
*/
truncate table SYS_CONDITION_DETAIL;

truncate table GLD_MAPPING_CONDITIONS;
drop sequence GLD_MAPPING_CONDITIONS_s;
create sequence GLD_MAPPING_CONDITIONS_s;

truncate table HLS_FINANCIAL_CALC_LOGS;


truncate table hls_ws_requests;
drop sequence hls_ws_requests_s;
create sequence hls_ws_requests_s;
truncate table hls_ws_tab_values;

--?????ӱ?????
truncate table csh_transaction_return;
truncate table CSH_TRANSACTION_WFL;

truncate table HLS_VAT_INVOICE_TMP;
truncate table HLS_VAT_IMPORT_INTERFACE;
truncate table HLS_VAT_IMPORT_LOGS;
truncate table HLS_VAT_IMPORT_TMP;
truncate table acr_interface_tmp;

truncate table csh_write_off_temp;
truncate table csh_write_off_temp_wfl;
truncate table hls_common_wfl;
truncate table CSH_WRITE_OFF_TEMP_wfl;
truncate table hls_zx_post_identity;
truncate table hls_ccb_manual_doc_tmp;
truncate table hls_ccb_manual_tmp;
truncate table hls_ebank_document_detail;
truncate table HLS_EBANK_CCB_TRANS_QRY;
truncate table HLS_EBANK_CCB_TRANSACTION;
truncate table HLS_SAP_ACCOUNTS_IFACE;
truncate table HLS_SAP_ACCOUNTS_PROCESS;
truncate table hls_zx_post;
truncate table hls_zx_post_base;
truncate table hls_zx_post_con;
truncate table csh_write_off_log;
truncate table PRJ_PROJECT_RECORD;
truncate table HLS_EBANK_CCBTR_FAILST;

/*Doosan  begin*/
truncate table hls_bp_master;
truncate table con_collection;
truncate table con_collection_persons;
truncate table con_collection_call_hd;
truncate table CON_CONTRACT_CASHFLOW_WFL;
truncate table HLS_DOCUMENT_WFL_HISTORY;
truncate table HLS_DOC_OPERATE_HISTORY;

truncate table CON_COLLECTION_CALLBACK;
drop sequence CON_COLLECTION_CALLBACK_S;
create sequence CON_COLLECTION_CALLBACK_S;

truncate table CON_COL_MANAGEMENT_HD;
drop sequence CON_COL_MANAGEMENT_HD_S;
create sequence CON_COL_MANAGEMENT_HD_S;

  truncate table CON_COL_MANAGEMENT_LN;
drop sequence CON_COL_MANAGEMENT_LN_S;
create sequence CON_COL_MANAGEMENT_LN_S;

  truncate table KINGDEE_INTERFACE_LOGS;
drop sequence KINGDEE_INTERFACE_LOGS_S;
create sequence KINGDEE_INTERFACE_LOGS_S;

  truncate table csh_deduction_interface;
drop sequence csh_deduction_interface_S;
create sequence csh_deduction_interface_S;
  drop sequence csh_deduction_ifc_batch_s;
create sequence csh_deduction_ifc_batch_s;

  truncate table vfs_command;
drop sequence vfs_command_S;
create sequence vfs_command_S;

truncate table t_td_report;
drop sequence t_td_report_S;
create sequence t_td_report_S;

truncate table PT_LOCK;

truncate table VFS_VARIABLE;


truncate table hls_auto_allocation_record;
drop sequence hls_auto_allocation_record_s;
create sequence hls_auto_allocation_record_s;

truncate table PRO_PROJECT_INVESTMENT_RETURN;
drop sequence PRO_PROJECT_INVE_RETURN_s;
create sequence PRO_PROJECT_INVE_RETURN_s;

truncate table pro_project_own_car_info;
drop sequence pro_project_own_car_info_s;
create sequence pro_project_own_car_info_s;

truncate table PRO_PROJECT_MAIN_FAM;
drop sequence PRO_PROJECT_MAIN_FAM_s;
create sequence PRO_PROJECT_MAIN_FAM_s;

truncate table PRJ_project_main_management;
drop sequence PRJ_project_main_management_S;
create sequence PRJ_project_main_management_S;

truncate table PRJ_project_share_info;
drop sequence PRJ_project_share_info_S;
create sequence PRJ_project_share_info_S;

truncate table prj_project_phone_verify;
drop sequence prj_project_phone_verify_s;
create sequence prj_project_phone_verify_s;

truncate table hls_bp_master_agent_loan;
drop sequence hls_bp_master_agent_loan_s;
create sequence hls_bp_master_agent_loan_s;

truncate table hls_bp_master_agent_rebate;
drop sequence hls_bp_master_agent_rebate_s;
create sequence hls_bp_master_agent_rebate_s;

truncate table hls_bp_master_agent_sale;
drop sequence hls_bp_master_agent_sale_s;
create sequence hls_bp_master_agent_sale_s;

truncate table hls_bp_master_ag_sale;
drop sequence hls_bp_master_ag_sale_s;
create sequence hls_bp_master_ag_sale_s;

truncate TABLE ACR_INVOICE_MANAGE;
drop sequence ACR_INVOICE_MANAGE_S;
CREATE sequence ACR_INVOICE_MANAGE_S;

truncate TABLE CON_ACCOUNTING_MANAGE_ATTCH;
drop sequence CON_ACCOUNTING_MANAGE_ATTCH_S;
CREATE sequence CON_ACCOUNTING_MANAGE_ATTCH_S;

truncate TABLE CON_ACCOUNTING_MANAGE;
drop sequence CON_ACCOUNTING_MANAGE_S;
CREATE sequence CON_ACCOUNTING_MANAGE_S;

truncate TABLE CON_CAR_INSURANCE_RECORDS;
drop sequence CON_CAR_INSURANCE_RECORDS_S;
CREATE sequence CON_CAR_INSURANCE_RECORDS_S;

truncate TABLE CON_CAR_INSURANCE;
drop sequence CON_CAR_INSURANCE_S;
CREATE sequence CON_CAR_INSURANCE_S;

truncate TABLE CON_CONTRACT_GPS;
drop sequence CON_CONTRACT_GPS_S;
CREATE sequence CON_CONTRACT_GPS_S;

truncate TABLE CON_FILE_INFO;
drop sequence CON_FILE_INFO_S;
CREATE sequence CON_FILE_INFO_S;

truncate TABLE HLS_BP_MASTER_AGENT_LA_TEMP;
drop sequence HLS_BP_MASTER_AGENT_LA_TEMP_S;
CREATE sequence HLS_BP_MASTER_AGENT_LA_TEMP_S;

truncate TABLE HLS_BP_MASTER_AGENT_RB_TEMP;
drop sequence HLS_BP_MASTER_AGENT_RB_TEMP_S;
CREATE sequence HLS_BP_MASTER_AGENT_RB_TEMP_S;

truncate TABLE HLS_BP_MASTER_AGENT_SL_TEMP;
drop sequence HLS_BP_MASTER_AGENT_SL_TEMP_S;
CREATE sequence HLS_BP_MASTER_AGENT_SL_TEMP_S;

truncate TABLE MOR_REGISTER;
drop sequence MOR_REGISTER_S;
CREATE sequence MOR_REGISTER_S;

truncate TABLE PRJ_FILE_INFO;
drop sequence PRJ_FILE_INFO_S;
CREATE sequence PRJ_FILE_INFO_S;

truncate TABLE PRJ_PROJECT_FACTOR_INFO;
drop sequence PRJ_PROJECT_FACTOR_INFO_S;
CREATE sequence PRJ_PROJECT_FACTOR_INFO_S;

truncate TABLE PRJ_PROJECT_RECONSIDER_ATT;
drop sequence PRJ_PROJECT_RECONSIDER_ATT_S;
CREATE sequence PRJ_PROJECT_RECONSIDER_ATT_S;

truncate TABLE PRJ_PROJECT_RECONSIDER;
drop sequence PRJ_PROJECT_RECONSIDER_S;
CREATE sequence PRJ_PROJECT_RECONSIDER_S;

truncate TABLE YONDA_DOCUMENT_LEND_RECORD_HD;
drop sequence YONDA_DOCUMENT_LEND_HD_S;
CREATE sequence YONDA_DOCUMENT_LEND_HD_S;

truncate TABLE YONDA_DOCUMENT_LEND_RECORD_LN;
drop sequence YONDA_DOCUMENT_LEND_LN_S;
CREATE sequence YONDA_DOCUMENT_LEND_LN_S;

truncate TABLE CON_CONTRACT_CASHFLOW_REQ;
drop sequence CON_CONTRACT_CASHFLOW_REQ_S;
CREATE sequence CON_CONTRACT_CASHFLOW_REQ_S;

truncate TABLE CON_BATCH_DOWNLOAD_attch_temp;
drop sequence CON_BATCH_DOWNLOAD_TEMP_S;
CREATE sequence CON_BATCH_DOWNLOAD_TEMP_S;

truncate TABLE CON_CONTRACT_LEASE_TEMP;
drop sequence CON_CONTRACT_LEASE_TEMP_S;
CREATE sequence CON_CONTRACT_LEASE_TEMP_S;

truncate TABLE HLS_BP_MASTER_CREDIT_HD;
drop sequence HLS_BP_MASTER_CREDIT_HD_S;
CREATE sequence HLS_BP_MASTER_CREDIT_HD_S;

truncate TABLE HLS_BP_MASTER_CREDIT_LN;
drop sequence HLS_BP_MASTER_CREDIT_LN_S;
CREATE sequence HLS_BP_MASTER_CREDIT_LN_S;

truncate TABLE HLS_BP_MASTER_CREDIT_ASSIGN;
drop sequence HLS_BP_MASTER_CREDIT_ASSIGN_S;
CREATE sequence HLS_BP_MASTER_CREDIT_ASSIGN_S;


truncate TABLE HLS_ATTACHMENT_MODULE;
drop sequence HLS_ATTACHMENT_MODULE_S;
CREATE sequence HLS_ATTACHMENT_MODULE_S;
/*end*/


truncate TABLE TRE_LOAN_CON_REPAYMENT_PLAN;
drop sequence TRE_LOAN_CON_REPAYMENT_PLAN_S;
CREATE sequence TRE_LOAN_CON_REPAYMENT_PLAN_S;

truncate TABLE TRE_LOAN_CON_WITHDRAWAL_PLAN;
drop sequence TRE_LOAN_CON_WITHDRAWAL_PLAN_S;
CREATE sequence TRE_LOAN_CON_WITHDRAWAL_PLAN_S;

truncate TABLE TRE_ACCRUED_INTEREST;
drop sequence TRE_ACCRUED_INTEREST_S;
CREATE sequence TRE_ACCRUED_INTEREST_S;

truncate TABLE TRE_LOAN_CONTRACT;
drop sequence TRE_LOAN_CONTRACT_S;
CREATE sequence TRE_LOAN_CONTRACT_S;

truncate TABLE SYS_RUNTIME_REQUEST_RECORD;
drop sequence SYS_RUNTIME_REQUEST_RECORD_S;
CREATE sequence SYS_RUNTIME_REQUEST_RECORD_S;
--短信
truncate TABLE SYS_SMS_LIST;
drop sequence SYS_SMS_LIST_S;
CREATE sequence SYS_SMS_LIST_S;

truncate TABLE SYS_SMS_HISTORY;
drop sequence SYS_SMS_HISTORY_S;
CREATE sequence SYS_SMS_HISTORY_S;

truncate TABLE sys_sms_list_log;
drop sequence sys_sms_list_log_S;
CREATE sequence sys_sms_list_log_S;
--
truncate TABLE FND_ATM_ATTACHMENT;
drop sequence FND_ATM_ATTACHMENT_S;
CREATE sequence FND_ATM_ATTACHMENT_S;
--邮箱
truncate TABLE ZJ_SYS_MAILING_LIST;
drop sequence ZJ_SYS_MAILING_LIST_S;
CREATE sequence ZJ_SYS_MAILING_LIST_S;

truncate TABLE ZJ_SYS_MAILING_LIST_HT;
drop sequence ZJ_SYS_MAILING_LIST_HT_S;
CREATE sequence ZJ_SYS_MAILING_LIST_HT_S;

truncate table hls_bp_master_role;
DROP SEQUENCE hls_bp_master_role_s;
CREATE SEQUENCE hls_bp_master_role_s;

truncate TABLE COL_COLLECTION_ATTACHMENT;
drop sequence COL_COLLECTION_ATTACHMENT_S;
CREATE sequence COL_COLLECTION_ATTACHMENT_S;

truncate TABLE hls_bp_agent_relation;
drop sequence hls_bp_agent_relation_S;
CREATE sequence hls_bp_agent_relation_S;

truncate TABLE CON_DFF_ATTACHMENT;
drop sequence CON_DFF_ATTACHMENT_S;
CREATE sequence CON_DFF_ATTACHMENT_S;

truncate table sys_runtime_request_record;
DROP SEQUENCE sys_runtime_request_record_s;
CREATE SEQUENCE sys_runtime_request_record_s;


truncate table hls_bp_master_bank_account;
DROP SEQUENCE hls_bp_master_bank_account_s;
CREATE SEQUENCE hls_bp_master_bank_account_s;


truncate table hls_bp_master_contact_info;
DROP SEQUENCE hls_bp_master_contact_info_s;
CREATE SEQUENCE hls_bp_master_contact_info_s;

--add by chenlingfeng
truncate table  hls_bp_master_taxpayer_type;
DROP SEQUENCE hls_bp_master_taxpayer_type_s;
CREATE SEQUENCE hls_bp_master_taxpayer_type_s;

--migration总删除脚本 --start
truncate table hls_bp_master;
truncate table hls_bp_assets;
truncate table hls_bp_bank_flow;
truncate table hls_bp_master_address;
truncate table hls_bp_master_bank_account;
truncate table bp_ccx_info;
truncate table hls_bp_master_role;

truncate table hls_lease_arch_agreement;
DROP SEQUENCE hls_lease_arch_agreement_s;
CREATE SEQUENCE hls_lease_arch_agreement_s;

truncate table hls_bp_agent_renew;
truncate table hls_bp_master_company;

truncate table con_contract;
truncate table prj_project;
truncate table con_contract_bp;
truncate table con_contract_lease_item;

truncate table tre_loan_contract;
truncate table tre_assets_contract;
truncate table tre_assets_contract_ln;
truncate table tre_loan_con_withdrawal_plan;
truncate table tre_loan_con_repayment_plan;
truncate table tre_loan_con_repayment_dtl;
truncate table tre_loan_contract_repayment;

truncate table call_agency_distribution;
truncate table work_orders;
truncate table call_verify;
truncate table call_detail;
truncate table call_reference;
truncate table call_record;
truncate table call_detail_record_map;

truncate table sys_sms_history;
truncate table acp_invoice_ln;
truncate table con_contract_et_document;
truncate table acr_invoice_hd;

truncate table con_contract_cashflow;
truncate table csh_transaction;
truncate table csh_write_off;

truncate table con_contract_change_req;
truncate table CON_CONTRACT_PENALTY_REDUCE;
truncate table con_contract_case_record;

drop sequence hls_bp_master_s ;
drop sequence hls_bp_assets_s ;
drop sequence hls_bp_bank_flow_s  ;
drop sequence hls_bp_master_address_s ;
drop sequence CSH_BANK_ACCOUNT_S  ;
drop sequence bp_ccx_info_s ;
drop sequence hls_bp_master_role_s  ;

drop sequence hls_bp_agent_renew_s  ;
drop sequence hls_bp_master_company_s ;
drop sequence hls_document_s;
drop sequence con_contract_bp_s ;
drop sequence con_contract_lease_item_s ;
drop sequence tre_assets_contract_s ;
drop sequence tre_assets_contract_ln_s  ;
drop sequence tre_loan_con_withdrawal_plan_s  ;
drop sequence tre_loan_con_repayment_plan_s ;
drop sequence tre_loan_con_repayment_dtl_s  ;
drop sequence tre_loan_contract_repayment_s ;
drop sequence call_agency_distribution_s  ;
drop sequence work_orders_s ;
drop sequence call_verify_s ;
drop sequence call_detail_s ;
drop sequence call_reference_s  ;
drop sequence call_record_s ;
drop sequence call_detail_record_map_s  ;
drop sequence sys_sms_list_s  ;
drop sequence acp_invoice_ln_s  ;
drop sequence con_contract_et_document_s  ;
drop sequence hls_document_ln_s;
drop sequence csh_write_off_s ;
DROP SEQUENCE CON_CONTRACT_PENALTY_REDUCE_S;
DROP SEQUENCE con_contract_case_record_S;

create sequence hls_bp_master_s ;
create sequence hls_bp_assets_s ;
create sequence hls_bp_bank_flow_s  ;
create sequence hls_bp_master_address_s ;
create sequence CSH_BANK_ACCOUNT_S  ;
create sequence bp_ccx_info_s ;
create sequence hls_bp_master_role_s  ;

create sequence hls_bp_agent_renew_s  ;
create sequence hls_bp_master_company_s ;
create sequence hls_document_s;
create sequence con_contract_bp_s ;
create sequence con_contract_lease_item_s ;
create sequence tre_assets_contract_s ;
create sequence tre_assets_contract_ln_s  ;
create sequence tre_loan_con_withdrawal_plan_s  ;
create sequence tre_loan_con_repayment_plan_s ;
create sequence tre_loan_con_repayment_dtl_s  ;
create sequence tre_loan_contract_repayment_s ;
create sequence call_agency_distribution_s  ;
create sequence work_orders_s ;
create sequence call_verify_s ;
create sequence call_detail_s ;
create sequence call_reference_s  ;
create sequence call_record_s ;
create sequence call_detail_record_map_s  ;
create sequence sys_sms_list_s  ;
create sequence acp_invoice_ln_s  ;
create sequence con_contract_et_document_s  ;
create sequence hls_document_ln_s;
create sequence csh_write_off_s ;
CREATE SEQUENCE CON_CONTRACT_PENALTY_REDUCE_S;
CREATE SEQUENCE con_contract_case_record_S;
----migration总删除脚本 --start


--liu

truncate table csh_payment_req_attch;
DROP SEQUENCE csh_payment_req_attch_s;
CREATE SEQUENCE csh_payment_req_attch_s;

truncate table hls_bp_master_credit_attch;
DROP SEQUENCE hls_bp_master_credit_attch_s;
CREATE SEQUENCE hls_bp_master_credit_attch_s;

truncate table hls_credit_line;
DROP SEQUENCE hls_credit_line_s;
CREATE SEQUENCE hls_credit_line_s;

truncate table lon_credit_contract;
DROP SEQUENCE lon_credit_contract_s;
CREATE SEQUENCE lon_credit_contract_s;

truncate table lon_credit_contract_attch;
DROP SEQUENCE lon_credit_contract_attch_s;
CREATE SEQUENCE lon_credit_contract_attch_s;

truncate table tre_contract_repayment_attch;
DROP SEQUENCE tre_contract_repayment_attch_s;
CREATE SEQUENCE tre_contract_repayment_attch_s;

truncate table tre_loan_con_change_req_attch;
DROP SEQUENCE tre_loan_change_req_attch_s;
CREATE SEQUENCE tre_loan_change_req_attch_s;

truncate table tre_loan_contract_attch;
DROP SEQUENCE tre_loan_contract_attch_s;
CREATE SEQUENCE tre_loan_contract_attch_s;

truncate table tre_loan_con_change_req;



--短信相关

truncate table  sys_sms_list;

drop sequence sys_sms_list_s;
create sequence sys_sms_list_s;

truncate table sys_sms_list_log;

drop sequence sys_sms_list_log_s;
create sequence sys_sms_list_log_s;

truncate table sys_sms_history;

drop sequence sys_sms_history_s;
create sequence sys_sms_history_s;

truncate table ds_sys_sms_list_batch;

drop sequence ds_sys_sms_list_batch_s;
create sequence ds_sys_sms_list_batch_s;

truncate table ds_sys_sms_list;

drop sequence ds_sys_sms_list_s;
create sequence ds_sys_sms_list_s;


--短信白名单
truncate table  DS_SMS_SEND_WHITE_LIST;

drop sequence DS_SMS_SEND_WHITE_LIST_S;

create sequence DS_SMS_SEND_WHITE_LIST_S;



--doodream

drop sequence con_contract_case_record_s;
create sequence con_contract_case_record_s;
truncate con_contract_case_record;

--商业伙伴

truncate table  hls_bp_bank_flow;

drop sequence hls_bp_bank_flow_s;
create sequence hls_bp_bank_flow_s;

--接口
truncate table ds_bp_interface;
truncate table ds_project_interface;
truncate table ds_guarantor_interface;
truncate table ds_dcs_saleorder_interface;
truncate table ds_org_contract;
truncate table ds_np_contract;
truncate table ds_app_change_tenant;
drop sequence ds_app_change_tenant_s;
create sequence ds_app_change_tenant_s;

truncate table DS_DOCUMENT_INTERFACE_LOG;
drop sequence DS_DOCUMENT_INTERFACE_LOG_s;
create sequence DS_DOCUMENT_INTERFACE_LOG_s;

--导出
truncate table  EXCEL_EXPORT_INFO;
drop sequence   EXCEL_EXPORT_INFO_S;
create sequence   EXCEL_EXPORT_INFO_S;
--借阅
truncate table  con_doc_lend_record_hd;
drop sequence con_doc_lend_record_hd_s;
create sequence con_doc_lend_record_hd_s;
truncate table  con_doc_lend_record_ln;
drop sequence con_doc_lend_record_ln_s;
create sequence con_doc_lend_record_ln_s;


truncate table  con_contract_et_document;
drop sequence con_contract_et_document_s;
create sequence con_contract_et_document_s;

truncate table  con_contract_archive;
drop sequence con_contract_archive_s;
create sequence con_contract_archive_s;
--起案状态数据记录表
truncate table  con_contract_case_record;
drop sequence con_contract_case_record_s;
create sequence con_contract_case_record_s;

truncate table  con_contract_case_detail;
drop sequence con_contract_case_detail_s;
create sequence con_contract_case_detail_s;

truncate table  hls_bp_agent_renew;
drop sequence hls_bp_agent_renew_s;
create sequence hls_bp_agent_renew_s;

truncate table  hls_sap_interface_payment;

truncate table  et_account_info;

truncate table  csh_receipt_bank_account;
drop sequence csh_receipt_bank_account_s;
create sequence csh_receipt_bank_account_s;

--商品政策
truncate table  t_goods_batch;
drop sequence t_goods_batch_s;
create sequence t_goods_batch_s;

truncate table  t_goods_batch_detail;
truncate table  t_goods_info;
truncate table  t_goods_name;

--AS BS
drop sequence con_contract_bs_score_s;
create sequence con_contract_bs_score_s;
truncate table  con_contract_bs_score;

--法大大
drop sequence con_contract_signature_s;
create sequence con_contract_signature_s;
truncate table  con_contract_signature;

--网银代扣
drop sequence hls_ebank_batch_s;
create sequence hls_ebank_batch_s;
truncate table  hls_ebank_batch;

drop sequence hls_ebank_batch_hd_s;
create sequence hls_ebank_batch_hd_s;
truncate table  hls_ebank_batch_hd;

drop sequence hls_ebank_batch_ln_s;
create sequence hls_ebank_batch_ln_s;
truncate table  hls_ebank_batch_ln;

drop sequence hls_ebank_batch_group_s;
create sequence hls_ebank_batch_group_s;
truncate table  hls_ebank_batch_group;


--callCenter相关
truncate table work_orders;
truncate table call_agency_distribution;
truncate table call_agent;
truncate table call_detail;
truncate table call_detail_record_map;
truncate table call_record;
truncate table call_reference;
truncate table call_sundry;
truncate table call_verify;
--truncate table call_verify_set;
truncate table call_new_tenant;
truncate table call_change_tenant;

--变更附件
--合同变更申请-承租人变更
truncate table  CCR_UNIVERSAL_LEASSE_ATTH;
drop sequence CCR_UNIVERSAL_LEASSE_ATTH_s;
create sequence CCR_UNIVERSAL_LEASSE_ATTH_s;
--合同变更申请-冬雨季延期
truncate table  CCR_UNIVERSAL_E_ATTH;
drop sequence CCR_UNIVERSAL_E_ATTH_s;
create sequence CCR_UNIVERSAL_E_ATTH_s;
--合同变更申请-非月付转月付
truncate table  CCR_UNIVERSAL_PAY_ATTH;
drop sequence CCR_UNIVERSAL_PAY_ATTH_s;
create sequence CCR_UNIVERSAL_PAY_ATTH_s;
--合同变更申请-租赁物变更
truncate table  CCR_UNIVERSAL_LH_ATTH;
drop sequence CCR_UNIVERSAL_LH_ATTH_s;
create sequence CCR_UNIVERSAL_LH_ATTH_s;
--合同变更申请-债权债务变更
truncate table  CCR_UNIVERSAL_DEPT_ATTH;
drop sequence CCR_UNIVERSAL_DEPT_ATTH_s;
create sequence CCR_UNIVERSAL_DEPT_ATTH_s;
--合同变更申请-部分变更
truncate table  CCR_UNIVERSAL_PART_ATTH;
drop sequence CCR_UNIVERSAL_PART_ATTH_s;
create sequence CCR_UNIVERSAL_PART_ATTH_s;
--合同变更申请-还款日变更
truncate table  CCR_UNIVERSAL_PAYDATE_ATTH;
drop sequence CCR_UNIVERSAL_PAYDATE_ATTH_s;
create sequence CCR_UNIVERSAL_PAYDATE_ATTH_s;
--合同变更申请-缩期变更
truncate table  CCR_UNIVERSAL_CUT_ATTH;
drop sequence CCR_UNIVERSAL_CUT_ATTH_s;
create sequence CCR_UNIVERSAL_CUT_ATTH_s;

--中诚信接口
truncate table  CCX_ENTERPRISE_ZCXX;
drop sequence CCX_ENTERPRISE_ZCXX_s;
create sequence CCX_ENTERPRISE_ZCXX_s;
truncate table  CCX_ENTERPRISE_GDXX;
drop sequence CCX_ENTERPRISE_GDXX_s;
create sequence CCX_ENTERPRISE_GDXX_s;
truncate table  CCX_ENTERPRISE_GGXX;
drop sequence CCX_ENTERPRISE_GGXX_s;
create sequence CCX_ENTERPRISE_GGXX_s;
truncate table  CCX_ENTERPRISE_FRDWTZXX;
drop sequence CCX_ENTERPRISE_FRDWTZXX_s;
create sequence CCX_ENTERPRISE_FRDWTZXX_s;
truncate table  CCX_ENTERPRISE_FRQTRZXX;
drop sequence CCX_ENTERPRISE_FRQTRZXX_s;
create sequence CCX_ENTERPRISE_FRQTRZXX_s;
truncate table  CCX_ENTERPRISE_QYDWTZXX;
drop sequence CCX_ENTERPRISE_QYDWTZXX_s;
create sequence CCX_ENTERPRISE_QYDWTZXX_s;
truncate table  CCX_ENTERPRISE_BGXX;
drop sequence CCX_ENTERPRISE_BGXX_s;
create sequence CCX_ENTERPRISE_BGXX_s;
truncate table  CCX_ENTERPRISE_FZJJXX;
drop sequence CCX_ENTERPRISE_FZJJXX_s;
create sequence CCX_ENTERPRISE_FZJJXX_s;
truncate table  CCX_ENTERPRISE_GQCZLSXX;
drop sequence CCX_ENTERPRISE_GQCZLSXX_s;
create sequence CCX_ENTERPRISE_GQCZLSXX_s;
truncate table  CCX_ENTERPRISE_DCDYXX;
drop sequence CCX_ENTERPRISE_DCDYXX_s;
create sequence CCX_ENTERPRISE_DCDYXX_s;
truncate table  CCX_ENTERPRISE_DCDYWXX;
drop sequence CCX_ENTERPRISE_DCDYWXX_s;
create sequence CCX_ENTERPRISE_DCDYWXX_s;
truncate table  CCX_ENTERPRISE_SXBZXRXX;
drop sequence CCX_ENTERPRISE_SXBZXRXX_s;
create sequence CCX_ENTERPRISE_SXBZXRXX_s;
truncate table  CCX_ENTERPRISE_BZXRXX;
drop sequence CCX_ENTERPRISE_BZXRXX_s;
create sequence CCX_ENTERPRISE_BZXRXX_s;
truncate table  CCX_ENTERPRISE_GQDJLSXX;
drop sequence CCX_ENTERPRISE_GQDJLSXX_s;
create sequence CCX_ENTERPRISE_GQDJLSXX_s;
truncate table  CCX_ENTERPRISE_XZCFLS;
drop sequence CCX_ENTERPRISE_XZCFLS_s;
create sequence CCX_ENTERPRISE_XZCFLS_s;
truncate table  CCX_ENTERPRISE_JYYC;
drop sequence CCX_ENTERPRISE_JYYC_s;
create sequence CCX_ENTERPRISE_JYYC_s;
truncate table  CCX_ENTERPRISE_ZLXX;
drop sequence CCX_ENTERPRISE_ZLXX_s;
create sequence CCX_ENTERPRISE_ZLXX_s;
truncate table  CCX_ENTERPRISE_SBXX;
drop sequence CCX_ENTERPRISE_SBXX_s;
create sequence CCX_ENTERPRISE_SBXX_s;
truncate table  CCX_ENTERPRISE_PMXX;
drop sequence CCX_ENTERPRISE_PMXX_s;
create sequence CCX_ENTERPRISE_PMXX_s;
truncate table  CCX_ENTERPRISE_HYSJPM;
drop sequence CCX_ENTERPRISE_HYSJPM_s;
create sequence CCX_ENTERPRISE_HYSJPM_s;
truncate table  CCX_ENTERPRISE_CWSJ;
drop sequence CCX_ENTERPRISE_CWSJ_s;
create sequence CCX_ENTERPRISE_CWSJ_s;
truncate table  CCX_ENTERPRISE_HYPJ;
drop sequence CCX_ENTERPRISE_HYPJ_s;
create sequence CCX_ENTERPRISE_HYPJ_s;
truncate table  CCX_ENTERPRISE_CHK;
drop sequence CCX_ENTERPRISE_CHK_s;
create sequence CCX_ENTERPRISE_CHK_s;

--tms接口
truncate table  BP_CCX_INFO;
drop sequence BP_CCX_INFO_s;
create sequence BP_CCX_INFO_s;

--收车确认
truncate table  CON_CAR_COLLECTING;
drop sequence CON_CAR_COLLECTING_s;
create sequence CON_CAR_COLLECTING_s;

--中途偿还 中间表
truncate table con_contract_cashflow_h;

--核销分配相关
truncate table CSH_TRX_BATCH_INTERFACE;
truncate table csh_transaction_interface;
truncate table csh_transaction_interface_log;
truncate table csh_write_off_interface;
truncate table csh_write_off_temp;

truncate table csh_transaction_interface;
truncate table csh_transaction_interface_log;
truncate table csh_trx_batch_interface;
truncate table csh_write_off_interface;
truncate table CSH_WRITE_OFF_ASSIGNS;
truncate table CSH_WRITE_OFF_IFS_HIST;
drop sequence csh_write_off_interface_s;
create sequence csh_write_off_interface_s;
drop sequence csh_transaction_interface_s;
create sequence csh_transaction_interface_s;

drop sequence CSH_WRITE_OFF_ASSIGNS_s;
create sequence CSH_WRITE_OFF_ASSIGNS_s;

truncate table HLS_BP_CSH_TRX_BANK;
drop sequence HLS_BP_CSH_TRX_BANK_s;
create sequence HLS_BP_CSH_TRX_BANK_s;


--电子发票
truncate table acr_ele_invoice_hd;
drop sequence acr_ele_invoice_hd_s;
create sequence acr_ele_invoice_hd_s;

truncate table acr_ele_invoice_ln;
drop sequence acr_ele_invoice_ln_s;
create sequence acr_ele_invoice_ln_s;

--罚息减免
truncate table con_contract_penalty_reduce;
drop sequence con_contract_penalty_reduce_s;
create sequence con_contract_penalty_reduce_s;

truncate table con_contract_penalty_info;
drop sequence con_contract_penalty_info_s;
create sequence con_contract_penalty_info_s;

truncate table ds_tax_class_num;
drop sequence ds_tax_class_num_s;
create sequence ds_tax_class_num_s;

truncate table con_collection_management;
drop sequence con_collection_management_s;
create sequence con_collection_management_s;

/*truncate table hls_match_price_list;
drop sequence hls_match_price_list_s;
create sequence hls_match_price_list_s;*/

truncate table con_collection_sale;
drop sequence con_collection_sale_s;
create sequence con_collection_sale_s;

truncate table con_collection_redeem;
drop sequence con_collection_redeem_s;
create sequence con_collection_redeem_s;

--业务联络函
truncate table business_contacts;

--工行接口
truncate table icbc_interface_record;

truncate table con_archive_atth_note;
drop sequence con_archive_atth_note_s;
create sequence con_archive_atth_note_s;

--导入临时表表
truncate table con_contract_archive_temp;
drop sequence con_contract_archive_temp_s;
create sequence con_contract_archive_temp_s;

truncate table acp_invoice_ln_temp;
drop sequence acp_invoice_ln_temp_s;
create sequence acp_invoice_ln_temp_s;


--进项发票
TRUNCATE TABLE ACP_INVOICE_REVERSE_RECORD;
DROP SEQUENCE ACP_INVOICE_REVERSE_RECORD_S;
CREATE SEQUENCE ACP_INVOICE_REVERSE_RECORD_S;

--liyuan
TRUNCATE TABLE CON_CONTRACT_COST_SUPPORT;
DROP CON_CONTRACT_COST_SUPPORT_S;
CREATE CON_CONTRACT_COST_SUPPORT_S;

TRUNCATE TABLE CON_CONTRACT_LOSS_SHARE;
DROP CON_CONTRACT_LOSS_SHARE_S;
CREATE CON_CONTRACT_LOSS_SHARE_S;
--liyuan

TRUNCATE TABLE tre_loan_contract_withdraw;
DROP SEQUENCE tre_loan_contract_withdraw_S;
CREATE SEQUENCE tre_loan_contract_withdraw_S;



--融资合同
TRUNCATE TABLE  TRE_CON_DEPOSIT_FEE;

DROP SEQUENCE TRE_CON_DEPOSIT_FEE_S;
CREATE SEQUENCE TRE_CON_DEPOSIT_FEE_S;

--sap银行付款信息记录
TRUNCATE TABLE  SAP_BANK_PAYMENT_INFO;
DROP SEQUENCE SAP_BANK_PAYMENT_INFO_S;
CREATE SEQUENCE SAP_BANK_PAYMENT_INFO_S;


truncate table tre_con_deposit_fee;
drop sequence tre_con_deposit_fee_s;
create sequence tre_con_deposit_fee_s;

--合同诉讼相关
truncate table hls_litigation;
drop sequence hls_litigation_s;
create sequence hls_litigation_s;

truncate table hls_litigation_cost;
drop sequence hls_litigation_cost_s;
create sequence hls_litigation_cost_s;

truncate table hls_litigation_progress;
drop sequence hls_litigation_progress_s;
create sequence hls_litigation_progress_s;

truncate table hls_litigation_received;
drop sequence hls_litigation_received_s;
create sequence hls_litigation_received_s;

truncate table hls_litigation_info;
drop sequence hls_litigation_info_s;
create sequence hls_litigation_info_s;

truncate table hls_litigation_agent_info;
drop sequence hls_litigation_agent_info_s;
create sequence hls_litigation_agent_info_s;

truncate table hls_litigation_attch;
drop sequence hls_litigation_attch_s;
create sequence hls_litigation_attch_s;

truncate table acr_delivery_import_temp;
drop sequence acr_delivery_import_temp_s;
create sequence acr_delivery_import_temp_s;


--fengdong 诉讼模块
truncate table hls_litigation;
truncate table hls_litigation_info;
truncate table hls_litigation_cost;
truncate table hls_litigation_received;
truncate table hls_litigation_agent_info;

drop sequence hls_litigation_s;
drop sequence hls_litigation_info_s;
drop sequence hls_litigation_cost_s;
drop sequence hls_litigation_received_s;
drop sequence hls_litigation_agent_info_s;

create sequence hls_litigation_s;
create sequence hls_litigation_info_s;
create sequence hls_litigation_cost_s;
create sequence hls_litigation_received_s;
create sequence hls_litigation_agent_info_s;


truncate table wx_trailer_interface;
drop sequence wx_trailer_interface_s;
create sequence wx_trailer_interface_s;

truncate table con_trailer_info;
drop sequence con_trailer_info_s;
create sequence con_trailer_info_s;

truncate table prj_cdd_item_list_grp_tab;
drop sequence prj_cdd_item_list_grp_tab_s;
create sequence prj_cdd_item_list_grp_tab_s;

truncate table prj_cdd_item;
drop sequence prj_cdd_item_s;
create sequence prj_cdd_item_s;


--农行代扣相关
TRUNCATE TABLE hls_ebank_ccb_document;
DROP SEQUENCE hls_ebank_ccb_document_S;
CREATE SEQUENCE hls_ebank_ccb_document_S;


TRUNCATE TABLE hls_ebank_document_detail;

TRUNCATE TABLE hls_ebank_boc_transqry;
DROP SEQUENCE hls_ebank_boc_transqry_S;
CREATE SEQUENCE hls_ebank_boc_transqry_S;

TRUNCATE TABLE hls_ebank_boctr_failst;
DROP SEQUENCE hls_ebank_boctr_failst_S;
CREATE SEQUENCE hls_ebank_boctr_failst_S;

TRUNCATE TABLE hls_ebank_ccb_transaction;
DROP SEQUENCE hls_ebank_ccb_transaction_S;
CREATE SEQUENCE hls_ebank_ccb_transaction_S;


TRUNCATE TABLE ds_abc_interface_hd;
DROP SEQUENCE ds_abc_interface_hd_s;
CREATE SEQUENCE ds_abc_interface_hd_s;

TRUNCATE TABLE ds_abc_interface_ln;
DROP SEQUENCE ds_abc_interface_ln_s;
CREATE SEQUENCE ds_abc_interface_ln_s;

truncate table ds_abc_interface_assign;
drop sequence ds_abc_interface_assign_s;
create sequence ds_abc_interface_assign_s;

--
delete FROM fnd_coding_rule_values;

truncate table aut_trx_user_authorize;
DROP SEQUENCE aut_trx_user_authorize_s;
CREATE SEQUENCE aut_trx_user_authorize_s;

truncate table aut_owner_user_authorize;

truncate table t_goods_name_z;
truncate table t_goods_info_z;

--月结
truncate table HLS_MONTHEND_STATIC_DATA;
truncate table HLS_MONTHEND_STATIC_DATA_TMP;

--as/bs报表
truncate table  con_as_score_report;
truncate table  con_bs_score_report;
truncate table  CON_AS_DISCERNMENT_REPORT;
truncate table  CON_BS_DISCERNMENT_REPORT;
truncate table   con_bs_tm_report
--分期按揭
truncate table  INSTALLMENT_MORTGAGE_BALANCE;
drop sequence INSTALLMENT_MORTGAGE_BALANCE_S;
create sequence INSTALLMENT_MORTGAGE_BALANCE_S;
truncate table  CUS_INFORMATION_MANAGEMENT;
drop sequence CUS_INFORMATION_MANAGEMENT_S;
create sequence CUS_INFORMATION_MANAGEMENT_S;


truncate table csh_transaction_plan;
drop sequence csh_transaction_plan_s;
create sequence csh_transaction_plan_s;

truncate table csh_transaction_import_temp;
drop sequence csh_transaction_import_temp_s;
create sequence csh_transaction_import_temp_s;

truncate table gld_write_off;
drop sequence gld_write_off_s;
create sequence gld_write_off_s;

truncate table HL_SBO_RESPONSE_QUERY;
drop sequence HL_SBO_RESPONSE_QUERY_s;
create sequence HL_SBO_RESPONSE_QUERY_s;

truncate table HL_SBO_TEMP;
drop sequence HL_SBO_TEMP_s;
create sequence HL_SBO_TEMP_s;

truncate table HL_TRANSACTION_SPLIT;
drop sequence HL_TRANSACTION_SPLIT_s;
create sequence HL_TRANSACTION_SPLIT_s;

truncate table HL_TRANSPORT_XML;
drop sequence HL_TRANSPORT_XML_s;
create sequence HL_TRANSPORT_XML_s;

truncate table hls_ebank_batch_import_log;
drop sequence hls_ebank_batch_import_log_s;
create sequence hls_ebank_batch_import_log_s;

truncate table SYS_WEBSERVICE_INVOKE_RECORDS;
drop sequence sys_ws_invoke_records_s;
create sequence sys_ws_invoke_records_s;



truncate table hls_bp_master_agent_division;
drop sequence hls_bp_master_agent_division_s;
create sequence hls_bp_master_agent_division_s;

truncate table cus_deposit_calc_overdue_tmp;
drop sequence cus_deposit_calc_overdue_tmp_s;
create sequence cus_deposit_calc_overdue_tmp_s;

truncate table hls_document_use_seal;
drop sequence hls_document_use_seal_s;
create sequence hls_document_use_seal_s;

TRUNCATE TABLE hls_lease_item;
DROP SEQUENCE hls_lease_item_s;
CREATE SEQUENCE hls_lease_item_s;