tháng 1 04, 2024
Trước khi xóa báo User vào tự reject, trường hợp không được thì xóa.
Xóa bút toán TDSF - Backup
update intellect.wf110tb set status ='R', auth_id='SYSTEM', auth_dt =sysdate where ref_no in ('TDSF200523361320') --and status ='R'$$
update intellect.wf130tb set ACTIVITY ='R' where ref_no in ('TDSF200523361320') and ACTIVITY ='F'$$
delete intellect.wf120tb where ref_no in ('TDSF200523361320')$$
delete intellect.wf140tb where ref_no in ('TDSF200523361320') and status ='F'$$
delete intellect.wf210tb where ref_no in ('TDSF200523361320')$$
delete intellect.ca080tb where (REV_REF_NO in ('E89790000500') or ref_no in ('TDSF200523361320')) and auth_id is null$$
delete intellect.td702mb where BASE_NO||DEP_SER_NO||AUTO_REN_NO in ('E89790000500') and status ='U'$$
delete intellect.td703mb where ref_no in ('E89790000500') and status ='U'$$
delete intellect.td803Mb where ref_no in ('E89790000500') and status ='U'$$
delete intellect.td722tb where ref_no like 'E89790000500%' and status ='U'$$
delete intellect.TD203MB where REFERENCE_NUMBER in ('E89790000500')$$
