SELECT * FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287'
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287')
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M trdxmm WHERE trdxmm.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287')
DECLARE @RECORD_ID VARCHAR(50)
SELECT @RECORD_ID = trdxmm.RECORD_ID FROM TR_REQ_DOC_XETGIA_100M_500M trdxmm WHERE trdxmm.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287')
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_DT_DGC trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_DT_XG trdxmmdx WHERE trdxmmdx.RECORD_MASTER_ID = @RECORD_ID
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_XH trdxmmx WHERE trdxmmx.RECORD_MASTER_ID = @RECORD_ID