Project

General

Profile

Support #905

Hủy tờ trình chủ trương do sai sót khâu chọn ngân sách

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

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
02/24/2021
Due date:
% Done:

0%

Estimated time:

Description

DECLARE @REQ_ID VARCHAR
--SET @REQ_ID = (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0003/2021/TTr-0380005')
--SELECT * FROM PL_REQUEST_DOC 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_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
--SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
--SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
--SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
--SELECT * FROM TR_REQUEST_DOC WHERE PL_REQ_ID =@REQ_ID
--SELECT * FROM TR_PO_MASTER WHERE REQ_DOC_ID ='TRRD00000252235'

SET @REQ_ID = (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0007/2020/TTr-0380005')
SELECT * FROM PL_REQUEST_DOC 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 FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TO_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC WHERE PL_REQ_ID =@REQ_ID
SELECT * FROM TR_PO_MASTER WHERE REQ_DOC_ID ='TRRD00000252235'

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF