Project

General

Profile

Support #652

Tờ trình đi sai cấp phê duyệt: TC duyệt xong hoàn tất mặc dù tờ trình hơn 1 tỷ VNĐ 0007 0690903

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

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

0%

Estimated time:

Description

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0007/2020/TTr-0690903'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200616'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200616'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200616'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200616')
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200616')

DATA TT 0007 0690903.xlsx (28.9 KB) DATA TT 0007 0690903.xlsx Luc Tran Van, 11/19/2020 10:53 AM
FILE TTCT 007.txt (1.65 KB) FILE TTCT 007.txt Truong Nguyen Vu, 11/19/2020 11:29 AM
PL_REQ_DOC_UPDATE_AFTER_APPROVE.txt (7.78 KB) PL_REQ_DOC_UPDATE_AFTER_APPROVE.txt Truong Nguyen Vu, 11/19/2020 11:30 AM
DATA TT 0037.xlsx (36.1 KB) DATA TT 0037.xlsx Luc Tran Van, 11/20/2020 11:03 AM

History

#3 Updated by Truong Nguyen Vu over 4 years ago

UPDATE dbo.PL_TRADEDETAIL SET AMT_TF=AMT_TF- 1789000000 WHERE TRADE_ID='PLT000000070425'
UPDATE dbo.PL_TRADEDETAIL SET AMT_TF=AMT_TF- 111000000 WHERE TRADE_ID='PLT000000070440'

#4 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0037/2020/TTr-0690605'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200622'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200622'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200622'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200622')
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200622')

#6 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF