Project

General

Profile

Support #683

Tờ trình chủ trương số 0006, 0027 /0692103 đang dừng lại ở bước GDK phê duyệt và hoàn tất (Khách hàng phản hồi phải qua TGD)

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/27/2020
Due date:
% Done:

0%

Estimated time:

Description

DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0006/2020/TTr-0692103')
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)

0006 0692103.xlsx (29.8 KB) 0006 0692103.xlsx Luc Tran Van, 11/27/2020 10:31 AM
0027 0692103.xlsx (29.7 KB) 0027 0692103.xlsx Luc Tran Van, 11/27/2020 10:32 AM

History

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF