Project

General

Profile

Support #612

Cập nhật mã điều chuyển NS TTCT 0023/2020/TTr-0692103

Added by Truong Nguyen Vu over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
11/11/2020
Due date:
% Done:

0%

Estimated time:

UPDATE TTCT 0023-2020-TTr-0692103.txt (304 Bytes) UPDATE TTCT 0023-2020-TTr-0692103.txt Truong Nguyen Vu, 11/11/2020 10:20 AM
DATA TTCT 0023 0692103.xlsx (26.3 KB) DATA TTCT 0023 0692103.xlsx Luc Tran Van, 11/11/2020 03:52 PM
UPDATE TTCT 0023-2020-TTr-0692103 LAN 2.txt (304 Bytes) UPDATE TTCT 0023-2020-TTr-0692103 LAN 2.txt Truong Nguyen Vu, 11/11/2020 04:12 PM
DATA TTCT SỐ 0023.xlsx (26.9 KB) DATA TTCT SỐ 0023.xlsx Luc Tran Van, 11/12/2020 09:18 AM
UPDATE TTCT 0023-2020-TTr-0692103 LAN 3.txt (304 Bytes) UPDATE TTCT 0023-2020-TTr-0692103 LAN 3.txt Truong Nguyen Vu, 11/12/2020 09:20 AM
DATA TO TRINH SO 23 SAU KHI DIEU CHINH.xlsx (26.9 KB) DATA TO TRINH SO 23 SAU KHI DIEU CHINH.xlsx Luc Tran Van, 11/12/2020 09:27 AM
PL_REQUEST_DOC_SendApp.txt (13.4 KB) PL_REQUEST_DOC_SendApp.txt Truong Nguyen Vu, 11/12/2020 10:52 AM

History

#1 Updated by Truong Nguyen Vu over 4 years ago

  • Status changed from New to Closed

#2 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0023/2020/TTr-0692103'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200595'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200595'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200595')
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200595')

Also available in: Atom PDF