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

DECLARE @GODD_ID VARCHAR(20) = '', @TRADE_ID VARCHAR(20) = '', @REQ_PAY_ID VARCHAR(20) = ''

SET @GODD_ID = (SELECT TOP 1 GD_ID FROM CM_GOODS WHERE GD_CODE = 'HR.I.N.OE.0068.2023')

SET @REQ_PAY_ID = (SELECT TOP 1 REQ_PAY_ID from TR_REQ_PAYMENT where REQ_PAY_CODE = '042023/000360')

SET @TRADE_ID = ( SELECT TOP 1 TRADE_ID FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID = @REQ_PAY_ID)

select REQ_PAY_CODE, AUTH_STATUS, AUTH_STATUS_KT from TR_REQ_PAYMENT where REQ_PAY_CODE = '042023/000360'

select TRADE_ID, GOODS_ID, AMT_APP, AMT_ETM, AMT_EXE from PL_TRADEDETAIL where TRADE_ID = @TRADE_ID AND GOODS_ID = @GODD_ID

SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID = @REQ_PAY_ID

--update 26042023_secretkey