
CREATE VIEW BOLGEVEPROJEKODU AS 
 SELECT    (Select top 1 T.ACIKLAMA  FROM dbo.TBLBEYANREHBER T  
								WHERE  (T.TAG = 'TeknoBolge') and (T.KOD=B.ALANDEGER))
								+ '-' + A.ALANDEGER AS ISYERIBOLGEVEPROJEKODU, A.BEYANKOD AS TESPITSEKLI, A.KAYNAKADI, A.KAYITTIP, A.DUZELTMEYAPANKUL
FROM         (SELECT   BEYANKOD, KAYNAKADI, KAYITTIP, ALANADI, ALANDEGER, KAYITYAPANKUL, KAYITTARIHI, DUZELTMEYAPANKUL, DUZELTMETARIHI, C_YEDEK1, C_YEDEK2, L_YEDEK1, 
                                                    L_YEDEK2, F_YEDEK1, F_YEDEK2, D_YEDEK1, D_YEDEK2, ISLETME_KODU, VDKOD
                           FROM         dbo.TBLBEYANBASIM
                           WHERE     (ALANADI LIKE '%gvk4691isyeriProjeKodu%')) AS A INNER JOIN
                             (SELECT   BEYANKOD, KAYNAKADI, KAYITTIP, ALANADI, ALANDEGER, KAYITYAPANKUL, KAYITTARIHI, DUZELTMEYAPANKUL, DUZELTMETARIHI, C_YEDEK1, C_YEDEK2, L_YEDEK1, 
                                                         L_YEDEK2, F_YEDEK1, F_YEDEK2, D_YEDEK1, D_YEDEK2, ISLETME_KODU, VDKOD
                                FROM         dbo.TBLBEYANBASIM
                                WHERE     (ALANADI LIKE '%gvk4691isyeriBolge%')) AS B 
								ON A.L_YEDEK1 = B.L_YEDEK1 AND A.BEYANKOD = B.BEYANKOD AND A.DUZELTMEYAPANKUL = B.DUZELTMEYAPANKUL
GO
CREATE VIEW SBOLGERUHSATNO AS 								
SELECT    (Select top 1 T.ACIKLAMA  FROM dbo.TBLBEYANREHBER T  
								WHERE  (T.TAG = 'serbestBolge') and (T.KOD=B.ALANDEGER))
								+ '-' + A.ALANDEGER AS SERBESTBOLGEVERUHSATNO, A.BEYANKOD AS TESPITSEKLI, A.KAYNAKADI, A.KAYITTIP, A.DUZELTMEYAPANKUL
FROM         (SELECT   BEYANKOD, KAYNAKADI, KAYITTIP, ALANADI, ALANDEGER, KAYITYAPANKUL, KAYITTARIHI, DUZELTMEYAPANKUL, DUZELTMETARIHI, C_YEDEK1, C_YEDEK2, L_YEDEK1, 
                                                    L_YEDEK2, F_YEDEK1, F_YEDEK2, D_YEDEK1, D_YEDEK2, ISLETME_KODU, VDKOD
                           FROM         dbo.TBLBEYANBASIM
                           WHERE     (ALANADI LIKE '%SBGRuhsatNo%')) AS A INNER JOIN
                             (SELECT   BEYANKOD, KAYNAKADI, KAYITTIP, ALANADI, ALANDEGER, KAYITYAPANKUL, KAYITTARIHI, DUZELTMEYAPANKUL, DUZELTMETARIHI, C_YEDEK1, C_YEDEK2, L_YEDEK1, 
                                                         L_YEDEK2, F_YEDEK1, F_YEDEK2, D_YEDEK1, D_YEDEK2, ISLETME_KODU, VDKOD
                                FROM         dbo.TBLBEYANBASIM
                                WHERE     (ALANADI LIKE '%SBGSerbestBolge%')) AS B 
								ON A.L_YEDEK1 = B.L_YEDEK1 AND A.BEYANKOD = B.BEYANKOD AND A.DUZELTMEYAPANKUL = B.DUZELTMEYAPANKUL
	