DECLARE @REQ_CODE varchar(50) = 'PUR/2023/000456', @REQ_ID varchar(50), @RECORD_ID varchar(50)
SELECT @REQ_ID = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = @REQ_CODE
SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_ID = @REQ_ID
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_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)
IF(EXISTS(SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID))
BEGIN
  SELECT @RECORD_ID = trdxdm.RECORD_ID FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M_DT trdxdmd WHERE trdxdmd.RECORD_MASTER_ID = @RECORD_ID
END
ELSE IF(EXISTS(SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M trdxmm WHERE trdxmm.REQ_DOC_ID = @REQ_ID))
BEGIN
  SELECT @RECORD_ID = trdxdm.RECORD_ID FROM TR_REQ_DOC_XETGIA_100M_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
  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  trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_XH    trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
END
ELSE IF(EXISTS(SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M trdxmm WHERE trdxmm.REQ_DOC_ID = @REQ_ID))
BEGIN
  SELECT @RECORD_ID = trdxdm.RECORD_ID FROM TR_REQ_DOC_XETGIA_TREN_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_DGVG trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_DPG  trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_KNNLNT   trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_KT trdxdm WHERE trdxdm.RECORD_MASTER_ID = @RECORD_ID
  SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_XH trdxdm WHERE trdxdm.RECORD_MASTER_ID = @RECORD_ID
END
ELSE IF(EXISTS(SELECT * FROM PL_APPOINT_CONTRACTOR trdxmm WHERE trdxmm.TR_REQUEST_DOC_ID = @REQ_ID))
BEGIN
  SELECT @RECORD_ID = trdxmm.REQ_ID FROM PL_APPOINT_CONTRACTOR trdxmm WHERE trdxmm.TR_REQUEST_DOC_ID = @REQ_ID
  SELECT * FROM PL_APPOINT_CONTRACTOR_DT trdxmm WHERE trdxmm.REQ_ID = @RECORD_ID
END