data PYCMS 1215.txt
| 1 |
DECLARE @REQ_ID VARCHAR(20) |
|---|---|
| 2 |
SELECT @REQ_ID = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/001215' |
| 3 |
SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_ID = @REQ_ID |
| 4 |
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_ID = @REQ_ID |
| 5 |
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @REQ_ID |
| 6 |
SELECT * FROM PL_PROCESS pp WHERE pp.REQ_ID = @REQ_ID |