DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

UPDATE TR_REQ_PAY_INVOICE SET INVOICE_NO =INVOICE_NO+'REMOVE' WHERE REQ_PAY_ID NOT IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT)

DECLARE @PRICE_ID VARCHAR(15), @IN_ID VARCHAR(15)

SET @PRICE_ID =(SELECT TOP 1 PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE  ='069ATTD200016002')

SET @IN_ID =(SELECT MATERIAL_ID FROM MW_MAST_PRICE WHERE PRICE_ID =@PRICE_ID)

UPDATE MW_IN SET MATERIAL_ID = (SELECT MATERIAL_ID FROM MW_MATERIAL WHERE MATERIAL_CODE ='ATTD0006') WHERE IN_ID =@IN_ID

--UPDATE MW_OUT SET AUTH_STATUS ='U', CHECKER_ID ='', APPROVE_DT ='' WHERE OUT_CODE =''

DECLARE @REQ_ID VARCHAR(15)

SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NBO.2020.000162')

EXEC TR_REQ_ADVANCE_PAYMENT_Appr @REQ_ID,'trungnq1','A',''