CREATE VIEW VU_ACTCASHBANKUNION AS (SELECT     1 AS ROOT, VE_ACT.COMPANYID, VE_ACT.ACTNO, VE_ACT.ACTNAME, VE_ACT.REMTOTAL, VE_ACT.CURRCODE, VE_ACT.CURRREMTOTAL, VE_ACT.REMTYPENAME, 
                      VE_ACT.ACTID, VE_ACC.ACCNO, VE_ACC.ACCID
FROM         VE_ACT LEFT OUTER JOIN
                      VE_ACC ON (VE_ACT.COMPANYID = VE_ACC.COMPANYID) AND (VE_ACT.ACCID = VE_ACC.ACCID)
WHERE     VE_ACT.CURRCODE <> 'TL'
UNION ALL
SELECT     2 AS ROOT, VE_CASH.COMPANYID, VE_CASH.CASHNO, VE_CASH.CASHNAME, VE_CASH.REMTOTAL, VE_CASH.CURRCODE, VE_CASH.CURRREMTOTAL, 
                      VE_CASH.REMTYPENAME, VE_CASH.CASHID, VE_ACC.ACCNO, VE_ACC.ACCID
FROM         VE_CASH LEFT OUTER JOIN
                      VE_ACC ON (VE_CASH.COMPANYID = VE_ACC.COMPANYID) AND (VE_CASH.ACCID = VE_ACC.ACCID)
WHERE     VE_CASH.CURRCODE <> 'TL' AND CASHTYPE = 700
UNION ALL
SELECT     3 AS ROOT, VE_BANK.COMPANYID, VE_BANK.BANKNO, VE_BANK.BANKNAME, VE_BANK.REMTOTAL, VE_BANK.CURRCODE, VE_BANK.CURRREMTOTAL, 
                      VE_BANK.REMTYPENAME, VE_BANK.BANKID, VE_ACC.ACCNO, VE_ACC.ACCID
FROM         VE_BANK LEFT OUTER JOIN
                      VE_ACC ON (VE_BANK.COMPANYID = VE_ACC.COMPANYID) AND (VE_BANK.ACCID = VE_ACC.ACCID)
WHERE     VE_BANK.CURRCODE <> 'TL' AND VE_BANK.BILLTYPE IN (1400, 1401))