select * from MW_TRANSFER_DT where ISNULL(TRANSFER_ID, '') = 'MWTF00000250287'



select * from CM_BRANCH where BRANCH_CODE = '056'
--BRN000000000818
--select * from MW_MAST_BAL where ISNULL(pricE_ID, '') = ''

--select * from MW_MAST_BAL where price = 266500

--select * from MW_TRANSFER_DT where TRANSFER_ID = 'MWTF00000250289'

--select * from MW_TRANSFER_DT where ISNULL(FR_PRICE_ID, '') = ''

--select * from MW_MAST_BAL where MAST_BAL_ID = 'MWMASTBAL257087'

select * from MW_MAST_BAL_STMT where ISNULL(MAST_BAL_ID, '') = 'MWMASTBAL257088'

--select * from MW_MAST_BAL where MAST_BAL_ID = 'MWMASTBAL257088'

--select * from MW_MAST_BAL where BRANCH_ID = 'BRN000000000818'