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

SELECT * FROM CM_GOODS WHERE GD_CODE ='GA.I.N.OE.0007'

SELECT * FROM CM_GOODS WHERE GD_CODE ='GA.I.N.OE.0029'

SELECT * FROM CM_BRANCH WHERE BRANCH_CODE =''

SELECT * FROM dbo.CM_DEPARTMENT WHERE BRANCH_ID='DV0001'

SELECT * FROM PL_MASTER WHERE BRANCH_ID ='DV0001' AND DEPT_ID='DEP000000000023'

SELECT * FROM dbo.PL_TRADEDETAIL WHERE GOODS_ID='GOO000001061885' AND PLAN_ID IN (SELECT PLAN_ID FROM PL_MASTER WHERE BRANCH_ID ='DV0001' AND DEPT_ID='DEP000000000023')

SELECT * FROM dbo.PL_TRADEDETAIL WHERE GOODS_ID='GOO000001061929' AND PLAN_ID IN (SELECT PLAN_ID FROM PL_MASTER WHERE BRANCH_ID ='DV0001' AND DEPT_ID='DEP000000000023')

UPDATE dbo.PL_TRADEDETAIL SET AMT_TF='2500000' WHERE TRADE_ID='PLT000000074189'

UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF='2500000' WHERE TRADE_ID='PLT000000074192'

UPDATE dbo.PL_TRADEDETAIL SET AMT_TF='6000000' WHERE TRADE_ID='PLT000000077002'

UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF='6000000' WHERE TRADE_ID='PLT000000077007'