SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448'

SELECT * FROM TR_REQUEST_DOC_DT trdd where trdd.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448')

SELECT * FROM TR_REQUEST_DOC_PL_DT trdpd WHERE trdpd.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448')

SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448')

SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT prp.ID FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448'))