CREATE VIEW dbo.CARI_KART_DETAYLARI
AS
SELECT        CC.CODE AS [FIRMA KODU], CC.DEFINITION_ AS [FIRMA ÜNVANI], CC.SPECODE AS [ÖZEL KOD], CC.INCHARGE AS [YETKILI KISI], CC.SPECODE2 AS PLASIYER, CC.DISCRATE AS ISKONTO, { fn CONCAT({ fn CONCAT(CC.TELNRS1,
                          ' ') }, CC.TELNRS2) } AS TELEFON, CC.FAXNR AS FAX, CC.EMAILADDR AS EPOSTA, { fn CONCAT({ fn CONCAT(CC.ADDR1, ' ') }, CC.ADDR2) } AS ADRES, UPPER(CC.TOWN) AS ILÇE, UPPER(CC.CITY) AS SEHIR, 
                         CC.TCKNO AS [KIMLIK NO], CC.TAXNR AS [VERGI NO], CC.TAXOFFICE AS [VERGI DAIRESI], CASE WHEN ISPERSCOMP = 1 THEN 'SAHIS' ELSE 'SIRKET' END AS [FIRMA TÜRÜ], CC.DEFINITION2 AS AÇIKLAMA, 
                         CASE WHEN ACTIVE = 0 THEN 'KULLANIMDA' ELSE 'KULLANIM DISI' END AS DURUM, CC.SPECODE4 AS [ÖZEL KOD4], CC.SPECODE5 AS [ÖZEL KOD5], ISNULL(XT.TURU, '') AS [ÇALISMA TÜRÜ]
FROM            dbo.LG_011_CLCARD AS CC LEFT OUTER JOIN
                         dbo.LG_XT1015_011 AS XT ON XT.PARLOGREF = CC.LOGICALREF