Support #617: Lấy dữ liệu tờ trình số 0023 2020 TTr 0690902 - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Support #617

Lấy dữ liệu tờ trình số 0023 2020 TTr 0690902

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/12/2020

Due date:

% Done:

Estimated time:

Description

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0006/2020/TTr-0690902'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200545'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200545'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200545')
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200545')

DATA TỜ TRÌNH SỐ 0006 0690902.xlsx (24.9 KB) DATA TỜ TRÌNH SỐ 0006 0690902.xlsx		Luc Tran Van, 11/12/2020 11:09 AM
UPDATE NS TTCT 0006.txt (413 Bytes) UPDATE NS TTCT 0006.txt		Truong Nguyen Vu, 11/12/2020 11:17 AM