create table prd_base_info_20220425_tmp select * from prd_base_info where prd_code = 'RXX110001'; create table pay_credit_app_20220425_tmp select * from pay_credit_app where prd_code = 'RXX110001' and acct_type = 'ZY'; create table biz_cus_acct_20220425_tmp select * from biz_cus_acct where cont_no in (select cont_no from ctr_loan_cont where prd_code = 'RXX110001') and acct_type = 'ZY'; create table pay_payout_app_20220425_tmp select * from pay_payout_app where prd_code = 'RXX110001' and acct_type = 'ZY'; create table fac_loan_duebill_20220425_tmp select * from fac_loan_duebill where prd_code = 'RXX110001'; create table biz_accounting_record_20220425_tmp select * from biz_accounting_record; create table biz_accounting_detail_20220425_tmp select * from biz_accounting_detail where id in ('616666160875839488','616667171132678144');