DECLARE @rate_id varchar(15) =''
SELECT @rate_id= trsm.RATE_ID FROM TR_RATE_SUPPLIER_MASTER trsm WHERE trsm.RATE_REQ_NO='000010/2023/PĐG-0690604'
SELECT * FROM TR_RATE_SUPPLIER_MASTER trsm WHERE trsm.RATE_REQ_NO='000010/2023/PĐG-0690604'
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @rate_id
SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT id FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @rate_id)