Project

General

Profile

DELETE DATA UAT MS.txt

Luc Tran Van, 08/08/2022 10:12 AM

 
1
DELETE FROM TR_REQUEST_DOC
2
DELETE FROM TR_REQUEST_DOC_DT
3
DELETE FROM TR_REQUEST_DOC_PL_DT
4
DELETE FROM CM_SUPPLIER
5
DELETE FROM CM_HANGHOA
6
DELETE FROM BID_MASTER
7
DELETE FROM BID_CONTRACTOR_DT
8
DELETE FROM TR_PO_MASTER
9
DELETE FROM TR_PO_DETAIL
10
DELETE FROM TR_PO_PAYMENT
11
DELETE FROM TR_CONTRACT
12
DELETE FROM TR_CONTRACT_DT
13
DELETE FROM TR_CONTRACT_PAYMENT
14
DELETE FROM TR_REQ_DOC_XETGIA_DUOI_100M
15
DELETE FROM TR_REQ_DOC_XETGIA_DUOI_100M_DT
16
DELETE FROM TR_REQ_DOC_XETGIA_100M_500M
17
DELETE FROM TR_REQ_DOC_XETGIA_100M_500M_DT_DGC
18
DELETE FROM TR_REQ_DOC_XETGIA_100M_500M_DT_XG
19
DELETE FROM TR_REQ_DOC_XETGIA_100M_500M_XH
20
DELETE FROM TR_REQ_DOC_XETGIA_TREN_500M
21
DELETE FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_DGVG
22
DELETE FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_DPG
23
DELETE FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_KNNLNT
24
DELETE FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_KT
25
DELETE FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_XH
26
DELETE FROM PL_APPOINT_CONTRACTOR
27
DELETE FROM PL_APPOINT_CONTRACTOR_DT
28
DELETE FROM TR_RATE_SUPPLIER_MASTER
29
DELETE FROM TR_RATE_SUPPLIER_DT
30
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)
31
DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)
32
DELETE FROM PL_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)