Project

General

Profile

Support #708

Phê duyệt cấp TGĐ cho TTCT số 0012/2020/TTr-0690604

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/07/2020
Due date:
% Done:

0%

Estimated time:
DATA TRINH CHU TRUONG 0115 0690604.xlsx (41.3 KB) DATA TRINH CHU TRUONG 0115 0690604.xlsx Luc Tran Van, 12/07/2020 09:02 AM

History

#1 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0112/2020/TTr-0690604')
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)

#2 Updated by Luc Tran Van over 4 years ago

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200667', -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '2020-12-07 8:35:56 AM', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

#4 Updated by Luc Tran Van over 4 years ago

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200578', -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '2020-12-09 4:00:56 PM', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

Also available in: Atom PDF