/*清理表单*/ /*后台操作日志表*/ 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;