Project

General

Profile

Bug #735

Kiểm tra tờ trình chủ trương số 0117/2020/TTr-0690604 - Có chỉ định thầu nhưng TC duyệt xong hoàn tất.

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

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

0%

Estimated time:

Description

Dear Lực,
Tờ trình 0117/2020/TTr-0690604 tờ trình này chưa tới cấp lãnh mà đã hoàn tất, nhờ Lực xem lại và hỗ trợ giúp.
Trân trọng
Châu Nhật Hùng (Ông)
Nhân Viên Hành Chính
Phòng Hành Chính

NGÂN HÀNG BẢN VIỆT
A: 412 Nguyễn Thị Minh Khai, Phường 5, Quận 3, Tp.Hồ Chí Minh, Việt Nam
T: (+84 028) 62679679 | ext: 190 | F: (+84 028) 62638668
M: (+84) 902882496 | E:

W: www.vietcapitalbank.com.vn | Hotline: 1900 555 596

TT Chu Truong 0117 0690604 TC duyet xong hoan tat.xlsx (32.1 KB) TT Chu Truong 0117 0690604 TC duyet xong hoan tat.xlsx Luc Tran Van, 12/22/2020 09:59 AM
TT Chu truong 0106 0690604.xlsx (31.6 KB) TT Chu truong 0106 0690604.xlsx Luc Tran Van, 12/22/2020 01:16 PM
TTCT 0117.txt (2.21 KB) TTCT 0117.txt Truong Nguyen Vu, 12/22/2020 01:28 PM

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to In Progress

#2 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0117/2020/TTr-0690604')
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_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_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)

#3 Updated by Luc Tran Van over 4 years ago

Tiếp tục thêm 1 TTCT TC duyệt xong hoàn tất.
DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0106/2020/TTr-0690604')
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_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_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)

#5 Updated by Luc Tran Van over 4 years ago

  • Status changed from In Progress to Closed

Also available in: Atom PDF