|
1
|
DECLARE @REQ_CODE varchar(50) = 'PUR/2023/000456', @REQ_ID varchar(50), @RECORD_ID varchar(50)
|
|
2
|
SELECT @REQ_ID = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = @REQ_CODE
|
|
3
|
SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_ID = @REQ_ID
|
|
4
|
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_ID = @REQ_ID
|
|
5
|
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @REQ_ID
|
|
6
|
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)
|
|
7
|
IF(EXISTS(SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID))
|
|
8
|
BEGIN
|
|
9
|
SELECT @RECORD_ID = trdxdm.RECORD_ID FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
|
|
10
|
SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
|
|
11
|
SELECT * FROM TR_REQ_DOC_XETGIA_DUOI_100M_DT trdxdmd WHERE trdxdmd.RECORD_MASTER_ID = @RECORD_ID
|
|
12
|
END
|
|
13
|
ELSE IF(EXISTS(SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M trdxmm WHERE trdxmm.REQ_DOC_ID = @REQ_ID))
|
|
14
|
BEGIN
|
|
15
|
SELECT @RECORD_ID = trdxdm.RECORD_ID FROM TR_REQ_DOC_XETGIA_100M_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
|
|
16
|
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
|
|
17
|
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_DT_DGC trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
|
|
18
|
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_DT_XG trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
|
|
19
|
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_XH trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
|
|
20
|
END
|
|
21
|
ELSE IF(EXISTS(SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M trdxmm WHERE trdxmm.REQ_DOC_ID = @REQ_ID))
|
|
22
|
BEGIN
|
|
23
|
SELECT @RECORD_ID = trdxdm.RECORD_ID FROM TR_REQ_DOC_XETGIA_TREN_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
|
|
24
|
SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M trdxdm WHERE trdxdm.REQ_DOC_ID = @REQ_ID
|
|
25
|
SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_DGVG trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
|
|
26
|
SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_DPG trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
|
|
27
|
SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_KNNLNT trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID
|
|
28
|
SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_KT trdxdm WHERE trdxdm.RECORD_MASTER_ID = @RECORD_ID
|
|
29
|
SELECT * FROM TR_REQ_DOC_XETGIA_TREN_500M_DT_XH trdxdm WHERE trdxdm.RECORD_MASTER_ID = @RECORD_ID
|
|
30
|
END
|
|
31
|
ELSE IF(EXISTS(SELECT * FROM PL_APPOINT_CONTRACTOR trdxmm WHERE trdxmm.TR_REQUEST_DOC_ID = @REQ_ID))
|
|
32
|
BEGIN
|
|
33
|
SELECT @RECORD_ID = trdxmm.REQ_ID FROM PL_APPOINT_CONTRACTOR trdxmm WHERE trdxmm.TR_REQUEST_DOC_ID = @REQ_ID
|
|
34
|
SELECT * FROM PL_APPOINT_CONTRACTOR_DT trdxmm WHERE trdxmm.REQ_ID = @RECORD_ID
|
|
35
|
END
|