DECLARE @REQ_ID VARCHAR(20)
SELECT @REQ_ID = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/001215'
SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_ID = @REQ_ID
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_ID = @REQ_ID
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @REQ_ID
SELECT * FROM PL_PROCESS pp WHERE pp.REQ_ID = @REQ_ID