1. EXPORT PUR PHONG TAI CHINH 2021 1674.txt
1 |
DECLARE @REQ_ID VARCHAR(15) |
---|---|
2 |
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001674') |
3 |
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID |
4 |
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID |
5 |
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID |
6 |
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID |
7 |
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID |
8 |
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID |