Project

General

Profile

Feature #1538

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 5.06.2023

Added by Luc Tran Van about 2 years ago. Updated about 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
06/05/2023
Due date:
% Done:

0%

Estimated time:
DATA_#1.xlsx (13.5 KB) DATA_#1.xlsx Luc Tran Van, 06/05/2023 10:00 AM
create_req_payment_from_scan_bill.txt (19 KB) create_req_payment_from_scan_bill.txt Luc Tran Van, 06/05/2023 10:22 AM
DATA_#4.xlsx (12.3 KB) DATA_#4.xlsx Luc Tran Van, 06/05/2023 10:41 AM

History

#1 Updated by Luc Tran Van about 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001259')
SELECT * FROM TR_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 TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001023')
SELECT * FROM TR_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 TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

#4 Updated by Luc Tran Van about 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001260')
SELECT * FROM TR_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 TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

#6 Updated by Luc Tran Van about 2 years ago

UPDATE TR_REQUEST_DOC SET DMMS_ID='DM0000000000004' WHERE REQ_ID='TRRD00000259169'
UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000004' WHERE ID='116964' ---05062023_SECRETKEY

Also available in: Atom PDF