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