Project

General

Profile

Download (308 Bytes)

2.5 GET DATA TTCT PTGDK HO TRO.txt

Luc Tran Van, 10/25/2022 02:51 PM

 
1 
SELECT P.REQ_ID, P.REQ_CODE, P.AUTH_STATUS, P.PROCESS_ID FROM PL_REQUEST_DOC P
2 
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID =R.REQ_ID AND R.PROCESS_ID ='PTGDK_TT' AND R.STATUS IN ('C','U')
3 
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR(CREATE_DT)=2022 AND  P.PROCESS_ID<> 'REJECT' AND R.DVDM_ID ='DM0000000000015'