Project

General

Profile

Bug #685

Cập nhật tờ trình điều chuyển chi phí nội bộ về trạng thái Hoàn Tất. 0009 0570005

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/30/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 ='0009/2020/TTr-0570005')
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)

TT 0009 0570005.xlsx (32.6 KB) TT 0009 0570005.xlsx Luc Tran Van, 11/30/2020 10:05 AM
TT 0009 0570005- SAU KHI CAP NHAT.xlsx (29.5 KB) TT 0009 0570005- SAU KHI CAP NHAT.xlsx Luc Tran Van, 11/30/2020 10:27 AM

History

#1 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 ='0009/2020/TTr-0570005')
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)
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='8223'
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='8224'
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='8225'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID =@REQ_ID
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='KT' WHERE ID ='8226'
UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF = 1260000 WHERE TRADE_ID ='PLT000000074165'
UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF = 1260000 WHERE TRADE_ID ='PLT000000074167'

#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 ='0009/2020/TTr-0570005')
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)
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='8223'
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='8224'
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='8225'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID =@REQ_ID
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='KT' WHERE ID ='8226'
UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF = 1260000 WHERE TRADE_ID ='PLT000000074165'
UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF = 0, AMT_TF = 1260000 WHERE TRADE_ID ='PLT000000074167'

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF