CREATE OR REPLACE VIEW KYOWA.V_”„ãƒf[ƒ^ (ƒf[ƒ^Ží•Ę, “`•[”ԍ†, s”ԍ†, “`•[sŽ}”Ô, •ĻŒš°ÄÞ, “ūˆÓæš°ÄÞ, “X•Ü—pļÞŲ°Ėßš°ÄÞ, Ō°ķ°š°ÄÞ, •”š°ÄÞ, ‰Ûš°ÄÞ, ‰c‹Æ’S“–ŽŌš°ÄÞ, ’n‹æš°ÄÞ, Žó’“ú, Œvãˆ—“ú, “`•[“ú•t, ŋ‹æš°ÄÞ, ’ ’[‹æ•Š, ’ ’[‰ņ”, ”„ãŽd“ü“`•[”ԍ†, Žó’”ԍ†, Žó’s, ”­’”ԍ†, ”­’s, Á”ïÅ‹æ•Š, d“_“ūˆÓæ‹æ•Š, Žæˆø‹æ•Š, Ī•iš°ÄÞ, ķÚÞØš°ÄÞ, ķÚÞؗ\”õ, Ī•i–ž, ‹KŠi–ž, Á”ïÅ—Ķ, Á”ïÅŒvŽZ’PˆĘ, ’č”Ô‹æ•Š, “ü”, ”—Ę, “ü—Í’PˆĘ, ĘÞŨ”—Ę, ’PˆĘ‹æ•Š, ’č‰ŋ, ’P‰ŋ, Œī‰ŋ’P‰ŋ, ‹āŠz, Œī‰ŋ‹āŠz, ‘e—˜‰v, Á”ïÅŠz–ūŨ, “`•[‡Œv‹āŠz, “`•[‡ŒvŒī‰ŋ‹āŠz, “`•[‡Œv‘e—˜‰v, “`•[‡ŒvÁ”ïÅŠz, ‘Ώېŋ‹’ũ“ú, ‘ΏیŽŽŸ’ũ“ú, ‘Ώېŋ‹Ï‹æ•Š, ‘ΏیŽŽŸÏ‹æ•Š, “E—v, s”õl, ‘qŒÉš°ÄÞ, ‰^‘—•Öš°ÄÞ, Žó—Ė‘ÁžÏ‹æ•Š, ‹’“_š°ÄÞ, “ü—Í’S“–ŽŌš°ÄÞ, •i”Ô, ’ųģ“`•[”ԍ†, o‰Ũ—\’č“ú, XVĩÍßÚ°Āš°ÄÞ, ’P‰ŋŠ|—Ķ, ”õl_”[•i, Ô•’ųģŒã”­ķ‹æ•Š, Žd—l‚P, Žd—l‚Q) AS SELECT '0' as ƒf[ƒ^Ží•Ę ,“`•[”ԍ† as “`•[”ԍ† ,s”ԍ† as s”ԍ† ,“`•[sŽ}”Ô as “`•[sŽ}”Ô ,Œŧęš°ÄÞ as •ĻŒš°ÄÞ ,Žæˆøæš°ÄÞ as “ūˆÓæš°ÄÞ ,“X•Ü—pļÞŲ°Ėßš°ÄÞ as “X•Ü—pļÞŲ°Ėßš°ÄÞ ,Ō°ķ°š°ÄÞ as Ō°ķ°š°ÄÞ ,•”š°ÄÞ as •”š°ÄÞ ,‰Ûš°ÄÞ as ‰Ûš°ÄÞ ,’S“–ŽŌš°ÄÞ as ‰c‹Æ’S“–ŽŌš°ÄÞ ,’n‹æš°ÄÞ as ’n‹æš°ÄÞ ,Žó”­’“ú as Žó’“ú ,Œvãˆ—“ú as Œvãˆ— ,“`•[“ú•t as “`•[“ú•t ,ÍŊĀސŋ‹æš°ÄÞ as ŋ‹æš°ÄÞ ,’ ’[‹æ•Š as ’ ’[‹æ•Š ,’ ’[‰ņ” as ’ ’[‰ņ” ,”„ãŽd“ü“`•[”ԍ† as ”„ãŽd“ü“`•[”ԍ† ,Žó’”ԍ† as Žó’”ԍ† ,Žó’s as Žó’s ,”­’”ԍ† as ”­’”ԍ† ,”­’s as ”­’s ,Á”ïÅ‹æ•Š as Á”ïÅ‹æ•Š ,d“_“ūˆÓæ‹æ•Š as d“_“ūˆÓæ‹æ•Š ,Žæˆø‹æ•Š as Žæˆø‹æ•Š ,Ī•iš°ÄÞ as Ī•iš°ÄÞ ,ķÚÞØš°ÄÞ as ķÚÞØš°ÄÞ ,ķÚÞؗ\”õ as ķÚÞؗ\”õ ,Ī•i–ž as Ī•i–ž ,‹KŠi–ž as ‹KŠi–ž ,Á”ïÅ—Ķ as Á”ïÅ—Ķ ,Á”ïÅŒvŽZ’PˆĘ as Á”ïÅŒvŽZ’PˆĘ ,’č”Ô‹æ•Š as ’č”Ô‹æ•Š ,“ü” as “ü” ,”—Ę as ”—Ę ,“ü—Í’PˆĘ as “ü—Í’PˆĘ ,ĘÞŨ”—Ę as ĘÞŨ”—Ę ,’PˆĘ–žĖ‹æ•Š as ’PˆĘ‹æ•Š ,Œī‰ŋ_’č‰ŋ as ’č‰ŋ ,’P‰ŋ as ’P‰ŋ ,Œī‰ŋ’P‰ŋ as Œī‰ŋ’P‰ŋ ,‹āŠz as ‹āŠz ,Œī‰ŋ‹āŠz as Œī‰ŋ‹āŠz ,‘e—˜‰v as ‘e—˜‰v ,Á”ïÅŠz–ūŨ as Á”ïÅŠz–ūŨ ,“`•[‡Œv‹āŠz as “`•[‡Œv‹āŠz ,“`•[‡ŒvŒī‰ŋ‹āŠz as “`•[‡ŒvŒī‰ŋ‹āŠz ,“`•[‡Œv‘e—˜‰v as “`•[‡Œv‘e—˜‰v ,“`•[‡ŒvÁ”ïÅŠz as “`•[‡ŒvÁ”ïÅŠz ,‘Ώېŋ‹’ũ“ú as ‘Ώېŋ‹’ũ“ú ,‘ΏیŽŽŸ’ũ“ú as ‘ΏیŽŽŸ’ũ“ú ,‘Ώېŋ‹Ï‹æ•Š as ‘Ώېŋ‹Ï‹æ•Š ,‘ΏیŽŽŸÏ‹æ•Š as ‘ΏیŽŽŸÏ‹æ•Š ,“E—v as “E—v ,s”õl as s”õl ,‘qŒÉš°ÄÞ as ‘qŒÉš°ÄÞ ,‰^‘—•Öš°ÄÞ as ‰^‘—•Öš°ÄÞ ,Žó—Ė‘ÁžÏ‹æ•Š as Žó—Ė‘ÁžÏ‹æ•Š ,‹’“_š°ÄÞ as ‹’“_š°ÄÞ ,“ü—Í’S“–ŽŌš°ÄÞ as “ü—Í’S“–ŽŌš°ÄÞ ,•i”Ô as •i”Ô ,’ųģ“`•[”ԍ† as ’ųģ“`•[”ԍ† ,o‰Ũ—\’č“ú as o‰Ũ—\’č“ú ,XVĩÍßÚ°Āš°ÄÞ as XVĩÍßÚ°Āš°ÄÞ ,’P‰ŋŠ|—Ķ as ’P‰ŋŠ|—Ķ ,”õl_”[•i as ”õl_”[•i ,Ô•’ųģŒã”­ķ‹æ•Š as Ô•’ųģŒã”­ķ‹æ•Š ,Žd—l‚P as Žd—l‚P ,Žd—l‚Q as Žd—l‚Q FROM FB_RUISEKUK WHERE FB_RUISEKUK.ŽæˆøŽí•Ę = '01' and FB_RUISEKUK.íœĖŨļÞ = '0' UNION ALL SELECT '1' as ƒf[ƒ^Ží•Ę ,”„ã“`•[”ԍ† as “`•[”ԍ† ,”„ã“`•[s as s”ԍ† ,”„ãsŽ}”Ô as “`•[sŽ}”Ô ,Œŧęš°ÄÞ as •ĻŒš°ÄÞ ,“ūˆÓæš°ÄÞ as “ūˆÓæš°ÄÞ ,“X•Ü—pļÞŲ°Ėßš°ÄÞ as “X•Ü—pļÞŲ°Ėßš°ÄÞ ,Ō°ķ°š°ÄÞ as Ō°ķ°š°ÄÞ ,•”š°ÄÞ as •”š°ÄÞ ,‰Ûš°ÄÞ as ‰Ûš°ÄÞ ,‰c‹Æ’S“–š°ÄÞ as ‰c‹Æ’S“–ŽŌš°ÄÞ ,’n‹æš°ÄÞ as ’n‹æš°ÄÞ ,Žó’“ú as Žó’“ú ,0 as Œvãˆ—“ú ,o‰Ũ“ú as “`•[“ú•t ,' ' as ŋ‹æš°ÄÞ ,0 as ’ ’[‹æ•Š ,’ ’[‰ņ” as ’ ’[‰ņ” ,Žd“ü“`•[”ԍ† as ”„ãŽd“ü“`•[”ԍ† ,Žó’”ԍ† as Žó’”ԍ† ,Žó’s as Žó’s ,”­’”ԍ† as ”­’”ԍ† ,”­’s as ”­’s ,Á”ïÅ‹æ•Š as Á”ïÅ‹æ•Š ,d“_“ūˆÓæ‹æ•Š as d“_“ūˆÓæ‹æ•Š ,Žæˆø‹æ•Š as Žæˆø‹æ•Š ,Ī•iš°ÄÞ as Ī•iš°ÄÞ ,ķÚÞØš°ÄÞ as ķÚÞØš°ÄÞ ,ķÚÞؗ\”õ as ķÚÞؗ\”õ ,Ī•i–ž as Ī•i–ž ,‹KŠi–ž as ‹KŠi–ž ,Á”ïÅ—Ķ as Á”ïÅ—Ķ ,Á”ïÅŒvŽZ’PˆĘ as Á”ïÅŒvŽZ’PˆĘ ,’č”Ô‹æ•Š as ’č”Ô‹æ•Š ,đ°―“ü” as “ü” ,”„ã”—Ę as ”—Ę ,”„ã“ü—Í’PˆĘ as “ü—Í’PˆĘ ,”„ãĘÞŨ”—Ę as ĘÞŨ”—Ę ,' ' as ’PˆĘ‹æ•Š ,Œī‰ŋ_’č‰ŋ as ’č‰ŋ ,”„ã’P‰ŋ as ’P‰ŋ ,”„ãŒī‰ŋ’P‰ŋ as Œī‰ŋ’P‰ŋ ,”„ã‹āŠz as ‹āŠz ,”„ãŒī‰ŋ‹āŠz as Œī‰ŋ‹āŠz ,”„ã‘e—˜‰v as ‘e—˜‰v ,”„ãÁ”ïÅŠz–ūŨ as Á”ïÅŠz–ūŨ ,”„ã“`•[‡Œv‹āŠz as “`•[‡Œv‹āŠz ,”„ã“`•[‡ŒvŒī‰ŋ‹āŠz as “`•[‡ŒvŒī‰ŋ‹āŠz ,”„ã“`•[‡Œv‘e—˜‰v as “`•[‡Œv‘e—˜‰v ,”„ã“`•[Á”ïÅŠz as “`•[‡ŒvÁ”ïÅŠz ,0 as ‘Ώېŋ‹’ũ“ú ,0 as ‘ΏیŽŽŸ’ũ“ú ,' ' as ‘Ώېŋ‹Ï‹æ•Š ,' ' as ‘ΏیŽŽŸÏ‹æ•Š ,“E—v_”­’’S“–ŽŌ–ž as “E—v ,s”õl as s”õl ,‘qŒÉš°ÄÞ as ‘qŒÉš°ÄÞ ,‰^‘—•Öš°ÄÞ as ‰^‘—•Öš°ÄÞ ,' ' as Žó—Ė‘ÁžÏ‹æ•Š ,“ü—Í‹’“_š°ÄÞ as “ü—Í‹’“_š°ÄÞ ,“ü—Í’S“–ŽŌš°ÄÞ as “ü—Í’S“–ŽŌš°ÄÞ ,•i”Ô as •i”Ô ,’ųģ“`•[”ԍ† as ’ųģ“`•[”ԍ† ,o‰Ũ—\’č“ú as o‰Ũ—\’č“ú ,XVĩÍßÚ°Āš°ÄÞ as XVĩÍßÚ°Āš°ÄÞ ,’P‰ŋŠ|—Ķ as ’P‰ŋŠ|—Ķ ,”õl_”[•i as ”õl_”[•i ,Ô•’ųģŒã”­ķ‹æ•Š as Ô•’ųģŒã”­ķ‹æ•Š ,Žd—l‚P as Žd—l‚P ,Žd—l‚Q as Žd—l‚Q FROM FE_SYUKA WHERE FE_SYUKA.íœĖŨļÞ = '0' /