DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

EXEC TR_CHECK_ROLE_APPROVE @TYPE = 'TTCT-PDTT'
,@p_REQ_ID = 'PLRD00000205895'
,@p_USER_LOGIN = 'trungnq1'
EXEC TR_CHECK_ROLE_APPROVE @TYPE = 'TTCT-PDTT'
,@p_REQ_ID = 'PLRD00000205904'
,@p_USER_LOGIN = 'trungnq1'

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0003/2022/TTr-0692105')
SELECT * FROM PL_REQUEST_DOC 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 PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT 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)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODSTYPE
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID

EXEC sp_helptext N'[dbo].[CON_REQUEST_DOC_InsXml]'

UPDATE PL_REQUEST_PROCESS SET BRANCH_ID = '' WHERE ID = 83526 OR ID = 83523

EXEC PL_REQ_DOC_UPDATE_AFTER_APPROVE 'PLRD00000205322'
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC 'PLRD00000205322'

UPDATE PL_REQUEST_PROCESS SET BRANCH_ID ='' WHERE PROCESS_ID='TGD' AND BRANCH_ID='DV0001'

UPDATE PL_REQUEST_PROCESS SET BRANCH_ID ='' WHERE PROCESS_ID='HDQT' AND BRANCH_ID='DV0001'