Project

General

Profile

Document #415

[SCRIPT] HỦY TỜ TRÌNH CHỦ TRƯƠNG

Added by Luc Tran Van almost 5 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
10/12/2020
Due date:
% Done:

0%

Estimated time:

Description

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0006/2020/TTr-0690905'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200106'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200106'
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID ='PLRD00000200106'
SELECT * FROM PL_PROCESS WHERE REQ_ID ='PLRD00000200106'
SELECT * FROM TR_REQUEST_DOC WHERE PL_REQ_ID='PLRD00000200106'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251080'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID ='PLT000000071010'
-- HUY
UPDATE PL_REQUEST_DOC SET RECORD_STATUS ='0' WHERE REQ_ID ='PLRD00000200106'
UPDATE TR_REQUEST_DOC SET RECORD_STATUS ='0' WHERE REQ_ID ='TRRD00000251080'
UPDATE PL_TRADEDETAIL SET AMT_ETM = AMT_ETM + 297000000 WHERE TRADE_ID ='PLT000000071010'

Also available in: Atom PDF