USE db_edits
UPDATE s_action_list SET action_type=7, condition_field='user_id, total', result_object='get_outstanding_transaction_staff_dashboard', result_field='username, user_fullname, total', default_order='user_fullname', created_by='KHU', created_date='2018-03-01 00:00:00', modified_by='KHU', modified_date='2018-03-01 00:00:00', is_delete='0' WHERE action_name='list_outstanding_transaction_staff_dashboard'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, document_id, document_code, description, remarks, eform_document_id, eform_id, minimum_files, maximum_files, seq_number, status_id', result_object='v_m_transaction_document', result_field='transaction_id, document_id, document_code, description, remarks, eform_document_id, eform_id, minimum_files, maximum_files, seq_number, status_id, jumlah_file, receive_doc_check', default_order='seq_number', created_by='PPM', created_date='2017-09-12 00:00:00', modified_by='PPM', modified_date='2017-09-12 00:00:00', is_delete='0' WHERE action_name='list_transaction_document'
UPDATE s_action_list SET action_type=1, condition_field='transaction_document_id, transaction_document_file_id, transaction_id, document_type_id, token, final_hashcode, final_document_index, final_document_name, document_name, document_url, hashcode_ori, hashcode', result_object='v_m_transaction_document_files', result_field='transaction_document_id,transaction_document_file_id,transaction_id,document_type_id,token,final_hashcode,final_document_index,final_document_name,document_name,document_url,hashcode_ori,hashcode,upload_by,upload_date,upload_date_str,receive_doc_check', default_order='', created_by='PPM', created_date='2017-09-13 00:00:00', modified_by='PPM', modified_date='2017-09-13 00:00:00', is_delete='0' WHERE action_name='list_transaction_document_files'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status,is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status,is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=1, condition_field='id_status_audit, description, created_by, created_date, modified_by, modified_date, is_delete', result_object='m_status_audit', result_field='id_status_audit, description, created_by, created_date, modified_by, modified_date, is_delete', default_order='description', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_audit_status'
UPDATE s_action_list SET action_type=2, condition_field='id_status_audit, description, created_by, created_date, modified_by, modified_date, is_delete', result_object='t_audit_history', result_field='id_status_audit, description, created_by, created_date, modified_by, modified_date, is_delete', default_order='', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='insert_audit'
UPDATE s_action_list SET action_type=2, condition_field='id_t_audit_history, id_transaction, register_number, id_status_audit, remarks, created_by, created_date, modified_by, modified_date, is_delete', result_object='t_audit_history', result_field='', default_order='', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='insert_audit'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=1, condition_field='transaction_document_id, transaction_document_file_id, transaction_id, document_type_id, token, final_hashcode, final_document_index, final_document_name, document_name, document_url, hashcode_ori, hashcode', result_object='v_m_transaction_document_files', result_field='transaction_document_id,transaction_document_file_id,transaction_id,document_type_id,token,final_hashcode,final_document_index,final_document_name,document_name,document_url,hashcode_ori,hashcode,upload_by,upload_date,upload_date_str', default_order='', created_by='PPM', created_date='2017-09-13 00:00:00', modified_by='PPM', modified_date='2017-09-13 00:00:00', is_delete='0' WHERE action_name='list_transaction_document_files'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, created_by, user_fullname, latest_auditor, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, branch_desc, trans_type_desc, stage_desc, status_desc, has_audit, latest_audit_status, latest_audit_date, created_by, user_fullname, latest_auditor, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=1, condition_field='id_t_audit_history, id_transaction, register_number, id_status_audit, description, remarks, created_by, created_date, created_date_time, user_fullname', result_object='v_t_transaction_audit_history', result_field='id_t_audit_history, id_transaction, register_number, id_status_audit, description, remarks, created_by, created_date, created_date_time, user_fullname', default_order='register_number', created_by='WHI', created_date='2018-01-11 00:00:00', modified_by='WHI', modified_date='2018-01-11 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit_history'
UPDATE s_action_list SET action_type=1, condition_field='id_t_audit_history, id_transaction, register_number, id_status_audit, description, remarks, created_by, created_date, created_date_time, user_fullname, is_delete', result_object='v_t_transaction_audit_history', result_field='id_t_audit_history, id_transaction, register_number, id_status_audit, description, remarks, created_by, created_date, created_date_time, user_fullname, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-11 00:00:00', modified_by='WHI', modified_date='2018-01-11 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit_history'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, latest_audit_date, created_by, user_fullname, latest_auditor, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, latest_audit_date, created_by, user_fullname, latest_auditor, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=1, condition_field='', result_object='v_user', result_field='user_id, username, user_fullname, branch_id, created_by, created_date, modified_by, modified_date, branch_code, description, status_id, organization', default_order='user_fullname', created_by='WHI', created_date='2017-06-07 00:00:00', modified_by='WHI', modified_date='2017-06-07 00:00:00', is_delete='0' WHERE action_name='list_user'
UPDATE s_action_list SET action_type=1, condition_field='user_id, username, user_fullname, branch_id, status_id, created_by, created_date, modified_by, modified_date, add_audit, view_history_audit, branch_code, description, organization_id, organization', result_object='v_user', result_field='user_id, username, user_fullname, branch_id, created_by, created_date, modified_by, modified_date, branch_code, description, status_id, organization', default_order='user_fullname', created_by='WHI', created_date='2017-06-07 00:00:00', modified_by='WHI', modified_date='2017-06-07 00:00:00', is_delete='0' WHERE action_name='list_user'
UPDATE s_action_list SET action_type=1, condition_field='user_id, username, user_fullname, branch_id, status_id, created_by, created_date, modified_by, modified_date, add_audit, view_history_audit, branch_code, description, organization_id, organization', result_object='v_user', result_field='user_id, username, user_fullname, branch_id, status_id, created_by, created_date, modified_by, modified_date, add_audit, view_history_audit, branch_code, description, organization_id, organization', default_order='user_fullname', created_by='WHI', created_date='2017-06-07 00:00:00', modified_by='WHI', modified_date='2017-06-07 00:00:00', is_delete='0' WHERE action_name='list_user'
UPDATE s_action_list SET action_type=1, condition_field='approv_matrix_detail_id, approv_matrix_id, maximum_value, level_type_id, level_type_desc,currency_id,currency_code,currency_description', result_object='v_m_approv_matrix_detail', result_field='approv_matrix_detail_id, approv_matrix_id, maximum_value, format_maximum_value, level_type_id, level_type_desc,currency_id,currency_code,currency_description', default_order='maximum_value', created_by='KHU', created_date='2017-07-24 00:00:00', modified_by='KHU', modified_date='2017-07-24 00:00:00', is_delete='0' WHERE action_name='list_approv_matrix_detail'
UPDATE s_action_list SET action_type=1, condition_field='approv_matrix_detail_id, approv_matrix_id, maximum_value, format_maximum_value, level_type_id, level_type_desc,currency_id,currency_code,currency_description', result_object='v_m_approv_matrix_detail', result_field='approv_matrix_detail_id, approv_matrix_id, maximum_value, format_maximum_value, level_type_id, level_type_desc,currency_id,currency_code,currency_description', default_order='maximum_value', created_by='KHU', created_date='2017-07-24 00:00:00', modified_by='KHU', modified_date='2017-07-24 00:00:00', is_delete='0' WHERE action_name='list_approv_matrix_detail'
INSERT INTO s_action_list (action_name,action_type,condition_field,result_object,result_field,default_order,created_by,created_date,modified_by,modified_date,is_delete) VALUES ('get_policy_insured_information','5','policy_no','EDITS.proc_get_policy_insured_information','','','PPM','2018-01-18 09:44:12','PPM','2018-01-18 09:44:12','0')
UPDATE s_action_list SET action_type=1, condition_field='eform_document_id, eform_id, document_id, applies_to, seq_number, status_id, is_delete', result_object='v_m_eform_document', result_field='eform_document_id, eform_id, document_id, document_code, description, minimum_files, maximum_files, applies_to, seq_number, status_id', default_order='seq_number', created_by='PPM', created_date='2017-07-23 00:00:00', modified_by='PPM', modified_date='2017-07-23 00:00:00', is_delete='0' WHERE action_name='list_eform_document'
UPDATE s_action_list SET action_type=3, condition_field='eform_document_id,eform_id,document_id,minimum_files,maximum_files,applies_to,seq_number,status_id,is_delete', result_object='m_eform_document', result_field='eform_document_id,eform_id,document_id,minimum_files,maximum_files,applies_to,seq_number,status_id,is_delete', default_order='', created_by='PPM', created_date='2017-08-21 00:00:00', modified_by='PPM', modified_date='2017-08-21 00:00:00', is_delete='0' WHERE action_name='update_eform_document'
UPDATE s_action_list SET action_type=2, condition_field='eform_id,document_id,minimum_files,maximum_files,applies_to,seq_number,status_id,is_delete', result_object='m_eform_document', result_field='eform_document_id', default_order='', created_by='PPM', created_date='2017-08-21 00:00:00', modified_by='PPM', modified_date='2017-08-21 00:00:00', is_delete='0' WHERE action_name='insert_eform_document'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, latest_audit_date, created_by, user_fullname, latest_auditor, status_id, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, latest_audit_date, created_by, user_fullname, latest_auditor, status_id, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=5, condition_field='policy_no', result_object='proc_get_policy_insured_information', result_field='', default_order='', created_by='PPM', created_date='2018-01-18 09:44:12', modified_by='PPM', modified_date='2018-01-18 09:44:12', is_delete='0' WHERE action_name='get_policy_insured_information'
UPDATE s_action_list SET action_type=5, condition_field='registration_no', result_object='proc_get_alteration_information', result_field='', default_order='', created_by='PPM', created_date='2017-11-03 00:00:00', modified_by='PPM', modified_date='2017-11-03 00:00:00', is_delete='0' WHERE action_name='get_alteration_information'
UPDATE s_action_list SET action_type=5, condition_field='proposal_no', result_object='proc_get_new_business_information', result_field='', default_order='', created_by='PPM', created_date='2017-11-03 00:00:00', modified_by='PPM', modified_date='2017-11-03 00:00:00', is_delete='0' WHERE action_name='get_new_business_information'
UPDATE s_action_list SET action_type=5, condition_field='claim_no', result_object='proc_get_claim_information', result_field='', default_order='', created_by='PPM', created_date='2017-11-03 00:00:00', modified_by='PPM', modified_date='2017-11-03 00:00:00', is_delete='0' WHERE action_name='get_claim_information'
UPDATE s_action_list SET action_type=1, condition_field='policy_no, policy_holder, date_of_birth', result_object='view_policy_information', result_field='policy_no, policy_holder, date_of_birth, plan, commencement_date, maturity_date, policy_status', default_order='policy_holder', created_by='PPM', created_date='2017-08-08 00:00:00', modified_by='PPM', modified_date='2017-08-08 00:00:00', is_delete='0' WHERE action_name='search_policy'
UPDATE s_action_list SET action_type=5, condition_field='policy_no', result_object='proc_get_policy_insured_information', result_field='policy_no, policy_insured_id, policy_insured_name', default_order='', created_by='PPM', created_date='2018-01-18 09:44:12', modified_by='PPM', modified_date='2018-01-18 09:44:12', is_delete='0' WHERE action_name='get_policy_insured_information'
UPDATE s_action_list SET action_type=5, condition_field='policy_no', result_object='proc_get_policy_insured_information', result_field='', default_order='', created_by='PPM', created_date='2018-01-18 09:44:12', modified_by='PPM', modified_date='2018-01-18 09:44:12', is_delete='0' WHERE action_name='get_policy_insured_information'
UPDATE s_action_list SET action_type=2, condition_field='', result_object='m_eform', result_field='', default_order='', created_by='KHU', created_date='2017-07-14 00:00:00', modified_by='KHU', modified_date='2017-07-14 00:00:00', is_delete='0' WHERE action_name='insert_eform_old'
UPDATE s_action_list SET action_type=5, condition_field='transaction_type_id, is_need_surat_kuasa, remarks, status_id, is_delete, user', result_object='proc_insert_eform', result_field=NULL, default_order=NULL, created_by='PPM', created_date='2018-01-19 14:08:10', modified_by='PPM', modified_date='2018-01-19 14:08:10', is_delete='0' WHERE action_name='insert_eform'
UPDATE s_action_list SET action_type=2, condition_field='transaction_form_id, transaction_id, register_number, transaction_sub_type, currency, money_loans, term, identity_date, amount, source_of_fund, gross_income, gross_income_year, is_settlement, settlement_name, policy_no, is_transfer_bank, in_currency, beneficiary_name, bank_name, branch, account_no, transfer_amount, remarks,insured_id,insured_name,created_by, created_date, modified_by, modified_date, is_delete', result_object='t_transaction_form', result_field='', default_order='', created_by='WHI', created_date='2017-09-13 00:00:00', modified_by='WHI', modified_date='2017-09-13 00:00:00', is_delete='0' WHERE action_name='insert_transaction_form'
UPDATE s_action_list SET action_type=3, condition_field='transaction_form_id, transaction_id, register_number, transaction_sub_type, currency, money_loans, term, identity_date, amount, source_of_fund, gross_income, gross_income_year, is_settlement, settlement_name, policy_no, is_transfer_bank, in_currency, beneficiary_name, bank_name, branch, account_no, transfer_amount, remarks, insured_id,insured_name,created_by, created_date, modified_by, modified_date, is_delete', result_object='t_transaction_form', result_field='', default_order='', created_by='WHI', created_date='2017-09-20 00:00:00', modified_by='WHI', modified_date='2017-09-20 00:00:00', is_delete='0' WHERE action_name='update_transaction_form'
UPDATE s_action_list SET action_type=3, condition_field='transaction_form_id, transaction_id, register_number, transaction_sub_type, currency, money_loans, term, identity_date, amount, source_of_fund, gross_income, gross_income_year, is_settlement, settlement_name, policy_no, is_transfer_bank, in_currency, beneficiary_name, bank_name, branch, account_no, transfer_amount, remarks,insured_id,insured_name,created_by, created_date, modified_by, modified_date, is_delete', result_object='t_transaction_form', result_field='', default_order='', created_by='WHI', created_date='2017-09-20 00:00:00', modified_by='WHI', modified_date='2017-09-20 00:00:00', is_delete='0' WHERE action_name='update_transaction_form'
UPDATE s_action_list SET action_type=5, condition_field='eform_id, eform_code, transaction_type_id, is_need_surat_kuasa, remarks, status_id, is_delete', result_object='proc_update_eform', result_field='', default_order='', created_by='KHU', created_date='2017-07-20 00:00:00', modified_by='PPM', modified_date='2018-01-19 15:35:35', is_delete='0' WHERE action_name='update_eform'
UPDATE s_action_list SET action_type=1, condition_field='id_status_audit, description, is_follow_up, is_complience, created_by, created_date, modified_by, modified_date, is_delete', result_object='m_status_audit', result_field='id_status_audit, description, created_by, created_date, modified_by, modified_date, is_delete', default_order='description', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_audit_status'
UPDATE s_action_list SET action_type=1, condition_field='id_status_audit, description, is_follow_up, is_complience, created_by, created_date, modified_by, modified_date, is_delete', result_object='m_status_audit', result_field='id_status_audit, description, is_follow_up, is_complience, created_by, created_date, modified_by, modified_date, is_delete', default_order='description', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_audit_status'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, is_follow_up_audit, is_complience_audit, latest_audit_date, created_by, user_fullname, latest_auditor, status_id, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, latest_audit_date, created_by, user_fullname, latest_auditor, status_id, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET action_type=1, condition_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, is_follow_up_audit, is_complience_audit, latest_audit_date, created_by, user_fullname, latest_auditor, status_id, is_delete', result_object='v_transaction_audit', result_field='transaction_id, register_number, policy_id_reference, policy_holder_reference, product_name_reference, reference_number, branch_id, transaction_type_id, branch_desc, trans_type_desc, stage_desc, status_desc, cat_desc, transaction_category_id, has_audit, latest_audit_status, is_follow_up_audit, is_complience_audit, latest_audit_date, created_by, user_fullname, latest_auditor, status_id, is_delete', default_order='register_number', created_by='WHI', created_date='2018-01-09 00:00:00', modified_by='WHI', modified_date='2018-01-09 00:00:00', is_delete='0' WHERE action_name='list_transaction_audit'
UPDATE s_action_list SET condition_field = 'transaction_form_id, transaction_id, register_number, transaction_sub_type, currency, money_loans, term, identity_date, amount, source_of_fund_id, gross_income, gross_income_year, is_settlement, settlement_name, policy_no, is_transfer_bank, in_currency, beneficiary_name, bank_name, branch, account_no, transfer_amount, remarks,insured_id,insured_name,created_by, created_date, modified_by, modified_date, is_delete' WHERE action_name = 'update_transaction_form'