DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

DECLARE @req_id varchar(20),@date DATETIME

SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000248'

SELECT @date = pac.REQ_DT FROM PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_ID = @req_id

SELECT * FROM PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_ID = @req_id

SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @req_id

SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT id FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @req_id)

SELECT * FROM PL_PROCESS WHERE REQ_ID = @req_id

SELECT @date