lay_data.txt
| 1 |
DECLARE @REQ_ID VARCHAR(15) = NULL |
|---|---|
| 2 |
SELECT @REQ_ID = REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE WHERE REPORT_NO = '000688/2023/TTr-0690803' |
| 3 |
SELECT * FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = @REQ_ID |
| 4 |
SELECT * FROM CM_APPROVE_GROUP WHERE REQ_ID = @REQ_ID |
| 5 |
SELECT * FROM CM_TEMPLATE_LOG WHERE REQ_ID = @REQ_ID |
| 6 |
SELECT * FROM CM_ATTACH_FILE WHERE REF_MASTER = @REQ_ID |
| 7 |
SELECT * FROM CM_ATTACH_FILE_HIST WHERE REF_ID = @REQ_ID |