lay_data (1).txt
| 1 |
DECLARE @REQ_ID NVARCHAR(20) = NULL |
|---|---|
| 2 |
SELECT @REQ_ID = REQUEST_TEMPLATE_ID |
| 3 |
FROM dbo.CM_REQUEST_TEMPLATE |
| 4 |
WHERE REPORT_NO = '000211/2023/TTr-0220003' |
| 5 |
|
| 6 |
SELECT * FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = @REQ_ID |
| 7 |
SELECT * FROM dbo.CM_APPROVE_GROUP WHERE REQ_ID = @REQ_ID |
| 8 |
SELECT * FROM dbo.CM_TEMPLATE_LOG WHERE REQ_ID = @REQ_ID |
| 9 |
SELECT * FROM dbo.CM_SENT_TO_TEMPLATE WHERE TEMPLATE_ID = @REQ_ID |
| 10 |
SELECT * FROM dbo.CM_ATTACH_FILE WHERE REF_MASTER = @REQ_ID |
| 11 |
SELECT * FROM dbo.CM_ATTACH_FILE_HIST WHERE REF_ID = @REQ_ID |