SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2022/003178'
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/2022/003178')