SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000123'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000123')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000123')
SELECT * FROM CM_DMMS