
CREATE VIEW BOLGEVEPROJEKODU AS 
 SELECT    (Select  T.ACIKLAMA  FROM TBLBEYANREHBER T  
								WHERE  (T.TAG = 'TeknoBolge') and (T.KOD=B.ALANDEGER) AND ROWNUM=1)
								+ '-' + 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         TBLBEYANBASIM
                           WHERE     (ALANADI LIKE '%gvk4691isyeriProjeKodu%'))  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         TBLBEYANBASIM
                                WHERE     (ALANADI LIKE '%gvk4691isyeriBolge%'))  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  T.ACIKLAMA  FROM TBLBEYANREHBER T  
								WHERE  (T.TAG = 'serbestBolge') and (T.KOD=B.ALANDEGER) and (ROWNUM=1))
								+ '-' + 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         TBLBEYANBASIM
                           WHERE     (ALANADI LIKE '%SBGRuhsatNo%'))  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         TBLBEYANBASIM
                                WHERE     (ALANADI LIKE '%SBGSerbestBolge%'))  B 
								ON A.L_YEDEK1 = B.L_YEDEK1 AND A.BEYANKOD = B.BEYANKOD AND A.DUZELTMEYAPANKUL = B.DUZELTMEYAPANKUL
							