|
1
|
INSERT INTO dbo.PL_REQUEST_PROCESS_CHILD
|
|
2
|
(REQ_ID,PROCESS_ID,TLNAME,TYPE_JOB,LEVEL_JOB,STATUS_JOB,RECORD_STATUS,MAKER_ID,TRANFER_DT
|
|
3
|
)
|
|
4
|
VALUES
|
|
5
|
( 'TRRD00000251083','1928', 'chittn', 'TP', 1,'U', '1', 'chittn' ,GETDATE())
|
|
6
|
INSERT INTO dbo.PL_REQUEST_PROCESS_CHILD
|
|
7
|
(REQ_ID,PROCESS_ID,TLNAME,TYPE_JOB,LEVEL_JOB,STATUS_JOB,RECORD_STATUS,MAKER_ID,TRANFER_DT
|
|
8
|
)
|
|
9
|
VALUES
|
|
10
|
( 'TRRD00000251083','1928', 'xuanpt', 'KS', 2,'U', '1', 'chittn' ,GETDATE())
|
|
11
|
INSERT INTO dbo.PL_REQUEST_PROCESS_CHILD
|
|
12
|
(REQ_ID,PROCESS_ID,TLNAME,TYPE_JOB,LEVEL_JOB,STATUS_JOB,RECORD_STATUS,MAKER_ID,TRANFER_DT
|
|
13
|
)
|
|
14
|
VALUES
|
|
15
|
( 'TRRD00000251083','1928', 'suunc', 'XL', 3,'C', '1', 'xuanpt' ,GETDATE())
|
|
16
|
|
|
17
|
|
|
18
|
UPDATE dbo.TR_REQUEST_DOC SET USER_DVMS='suunc' WHERE REQ_ID='TRRD00000251083'
|