Project

General

Profile

Bug #1040

Tờ trình chủ trương 30 triệu VNĐ - Của ĐVKD điều chuyển - Nhưng lên tới cấp TGĐ (Chọn NS nhận trong kế hoạch) : 0005/2021/TTr-0790005

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

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
04/19/2021
Due date:
% Done:

0%

Estimated time:

Description

UPDATE TL_USER SET EMAIL ='' WHERE TLNANME ='phuongnht'
UPDATE TL_USER SET EMAIL ='' WHERE TLNANME ='trungnq1'
UPDATE TL_USER SET EMAIL ='' WHERE TLNANME ='khoadm'
UPDATE TL_USER SET EMAIL ='' WHERE TLNANME ='trungnq1'
UPDATE TL_USER SET EMAIL ='' WHERE TLNANME ='toailc'

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0005/2021/TTr-0790005'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000201416'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000201416'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000201416'

SELECT * FROM CM_DVDM WHERE DVDM_ID ='DM0000000000017'

UPDATE PL_REQUEST_PROCESS SET REQ_ID =LEFT (REQ_ID,14)+'X' WHERE ID ='19769'
UPDATE PL_REQUEST_PROCESS SET REQ_ID =LEFT (REQ_ID,14)+'X' WHERE ID ='19770'
UPDATE PL_TRADEDETAIL SET AMT_ETM =ISNULL 12093290 , AMT_RECEIVE_TF = ISNULL - 30000000.00 WHERE TRADE_ID ='PLT000000255042'
UPDATE PL_TRADEDETAIL SET AMT_TF = ISNULL - 12093290.00 WHERE TRADE_ID ='PLT000000257429'
UPDATE PL_TRADEDETAIL SET AMT_ETM =ISNULL 2409000.00 WHERE TRADE_ID ='PLT000000255043'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='19161'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_CODE ='0005/2021/TTr-0790005'
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC 'PLRD00000201416'

SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID ='PLT000000255042'

UPDATE PL_REQUEST_PROCESS SET PROCESS_ID ='GDK_TT', REQ_ID ='PLRD00000201416', ROLE_USER ='GDK', STATUS ='C', NOTES =N'Chờ giám đốc khối xác nhận' WHERE ID ='19769'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='GDK_TT' WHERE REQ_CODE ='0005/2021/TTr-0790005'
UPDATE PL_REQUEST_PROCESS SET REQ_ID =LEFT (REQ_ID,14)+'X' WHERE ID ='19770'
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='GDK_TT', STATUS ='U' WHERE ID ='19161'
UPDATE CM_DVDM SET IS_PTGD =0, IS_KHOI =1 WHERE DVDM_ID ='DM0000000000017'
UPDATE PL_REQUEST_PROCESS SET ROLE_USER ='GDK', NOTES =N'Chờ giám đốc khối xác nhận' WHERE DVDM_ID ='DM0000000000017' AND STATUS ='C' AND ROLE_USER ='PTGD'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TADY00001121780'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='C' WHERE ID ='39879'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE REQ_ID ='TADY00001121780' and ROLE_USER ='TKTGD'
UPDATE PL_REQUEST_PROCESS SET STATUS ='U' WHERE REQ_ID ='TADY00001121780' and ROLE_USER ='TGD'

History

#1 Updated by Luc Tran Van about 4 years ago

  • Status changed from New to In Progress

#2 Updated by Luc Tran Van about 4 years ago

  • Status changed from In Progress to Closed

Also available in: Atom PDF