Project

General

Profile

Support #516

Bấm gửi phê duyệt TT điều chuyển ngân sách - Thông báo ngân sách điều chuyển không đủ - Check data thì thấy đã đủ ngân sách.

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

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

0%

Estimated time:
DATA TO TRINH DIEU CHUYEN NGAN SACH 0069 0690604.xlsx (27.6 KB) DATA TO TRINH DIEU CHUYEN NGAN SACH 0069 0690604.xlsx Luc Tran Van, 10/23/2020 10:47 AM
FILE 3.txt (14.3 KB) FILE 3.txt Truong Nguyen Vu, 10/23/2020 11:15 AM

History

#2 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0069/2020/TTr-0690604'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200360'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200360'

SELECT SUM FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200360'
AND REQDT_TYPE ='O'
SELECT SUM FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200360'

SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200360')

SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200360')

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed
  • Assignee set to Luc Tran Van

Also available in: Atom PDF