DECLARE @REQ_ID VARCHAR(15) = NULL
SELECT @REQ_ID = REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE WHERE REPORT_NO = '000688/2023/TTr-0690803' 
SELECT * FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = @REQ_ID
SELECT * FROM CM_APPROVE_GROUP WHERE REQ_ID = @REQ_ID
SELECT * FROM CM_TEMPLATE_LOG WHERE REQ_ID = @REQ_ID
SELECT * FROM CM_ATTACH_FILE WHERE REF_MASTER = @REQ_ID
SELECT * FROM CM_ATTACH_FILE_HIST WHERE REF_ID = @REQ_ID