--SELECT * FROM TL_USER WHERE TLSUBBRID = 'BRN000000000416'
--SELECT * FROM TL_USER WHERE TLNANME = 'thuyhtt'

-- KHAI BAO BIEN
DECLARE @BRANCH_ID VARCHAR(20), @PRICE_CODE VARCHAR(20), @PRICE_ID VARCHAR(20), @MAST_BAL_ID VARCHAR(20)
-- BIEN KHOI DAU
SET @PRICE_CODE = '069VPQC210018001'
-- GAN BIEN
SET @BRANCH_ID = (select BRANCH_ID from CM_BRANCH where BRANCH_NAME like '%SO SAO%')
SET @PRICE_ID = (select PRICE_ID from MW_MAST_PRICE where PRICE_CODE = @PRICE_CODE)
SET @MAST_BAL_ID = (select MAST_BAL_ID from MW_MAST_BAL where PRICE_ID = @PRICE_ID and BRANCH_ID = @BRANCH_ID)

SELECT 'MW_MAST_PRICE' AS TEN_TABLE, * FROM MW_MAST_PRICE WHERE PRICE_ID = @PRICE_ID
SELECT 'MW_MAST_BAL' AS TEN_TABLE, * FROM MW_MAST_BAL WHERE PRICE_ID = @PRICE_ID AND BRANCH_ID = @BRANCH_ID
SELECT 'MW_MAST_BAL_STMT' AS TEN_TABLE, * FROM MW_MAST_BAL_STMT WHERE MAST_BAL_ID = @MAST_BAL_ID

--update MW_MAST_BAL set QTY_BALANCE =51, TOTAL_AMT = 48750*51 where MAST_BAL_ID = 'MWMASTBAL001572'

/*
069CSKH200084006	
069CSKH200084007
069CSKH200084008
069CSKH210059003
069VPQC210018001
069VPQC210018002
069VPQC210018003
*/