Project

General

Profile

Download (459 Bytes)

data_pycms595.txt

Luc Tran Van, 04/18/2023 09:35 AM

 
1 
DECLARE @REQ_ID VARCHAR
2 
SELECT @REQ_ID = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000595'
3 
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_ID = @REQ_ID
4 
SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
5 
SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M_DT trdxmmdx WHERE trdxmmdx.RECORD_MASTER_ID IN (SELECT trdxdm.RECORD_ID FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID)