CREATE OR REPLACE VIEW KYOWA.V_Žd“üƒf�[ƒ^
	(ƒtƒ@ƒCƒ‹‹æ•ª, “`•[”Ô�†, �s”Ô�†, Žd“ü�溰ÄÞ, Žd“ü“¾ˆÓ�溰ÄÞ, “X•Ü—p¸ÞÙ°Ìߺ°ÄÞ, •¨Œ�º°ÄÞ, Ò°¶°º°ÄÞ, 
	•”º°ÄÞ, ‰Ûº°ÄÞ, ’S“–ŽÒº°ÄÞ, “ü‰×“ú, Œv�ã�ˆ—�“ú, “`•[“ú•t, Žx•¥�溰ÄÞ, �Á”ï�ŋ敪, Žæˆø‹æ•ª, �¤•iº°ÄÞ, 
	�¤•i–¼, ‹KŠi–¼, �Á”ï�Å—¦, �Á”ï�ÅŒvŽZ’PˆÊ, ’è”ԋ敪, “ü—Í’PˆÊ, “ü�”, �”—Ê, ÊÞ×�”—Ê, ’PˆÊ–¼�̋敪, ’艿, ’P‰¿, 
	‹àŠz, �Á”ï�ÅŠz–¾�×, “`•[�‡Œv‹àŠz, “`•[�‡Œv�Á”ï�ÅŠz, “`•[’lˆø‹àŠz, ‘Î�ÛŽx•¥’÷“ú, ‘Î�ÛŒŽŽŸ’÷“ú, ‘Î�ÛŽx•¥�ϋ敪, 
	‘Î�ÛŒŽŽŸ�ϋ敪, “E—v, �s”õ�l, ‹’“_º°ÄÞ, “ü—Í’S“–ŽÒº°ÄÞ, “`•[�sŽ}”Ô, ’ù�³“`•[”Ô�†, ”­’��溰ÄÞ, ”­’�’P‰¿, 
	�X�VµÍßÚ°Àº°ÄÞ, Žd“ü�æ”[•i�‘NO, Žd—l‚P, Žd—l‚Q, �¡–@) 
AS 
SELECT
     '1'                  as ƒtƒ@ƒCƒ‹‹æ•ª
    ,T.“ü‰×”Ô�†             as “`•[”Ô�†
    ,T.“ü‰×�s               as �s”Ô�†
    ,T.Žd“ü�溰ÄÞ           as Žd“ü�溰ÄÞ
    ,T.Žd“ü“¾ˆÓ�溰ÄÞ       as Žd“ü“¾ˆÓ�溰ÄÞ
    ,M.“X•Ü—p¸ÞÙ°Ìߺ°ÄÞ     as “X•Ü—p¸ÞÙ°Ìߺ°ÄÞ
    ,T.Œ»�꺰ÄÞ             as •¨Œ�º°ÄÞ
    ,T.Ò°¶°º°ÄÞ             as Ò°¶°º°ÄÞ
    ,T.•”º°ÄÞ               as •”º°ÄÞ
    ,T.‰Ûº°ÄÞ               as ‰Ûº°ÄÞ
    ,T.Žd“ü’S“–º°ÄÞ         as ’S“–ŽÒº°ÄÞ
    ,T.“ü‰×“ú               as “ü‰×“ú
    ,T.Žd“üŒv�ã�ˆ—�“ú       as Œv�ã�ˆ—�“ú
    ,T.Žd“ü“`•[“ú•t         as “`•[“ú•t
    ,T.Žd“ü�溰ÄÞ           as Žx•¥�溰ÄÞ
    ,T.�Á”ï�ŋ敪           as �Á”ï�ŋ敪
    ,T.Žæˆø‹æ•ª             as Žæˆø‹æ•ª
    ,T.�¤•iº°ÄÞ             as �¤•iº°ÄÞ
    ,T.�¤•i–¼               as �¤•i–¼
    ,T.‹KŠi–¼               as ‹KŠi–¼
    ,T.�¤•i�Á”ï�Å—¦         as �Á”ï�Å—¦
    ,T.�Á”ï�ÅŒvŽZ’PˆÊ       as �Á”ï�ÅŒvŽZ’PˆÊ
    ,T.’è”ԋ敪             as ’è”ԋ敪
    ,T.“ü‰×“ü—Í’PˆÊ         as “ü—Í’PˆÊ
    ,T.¹°½“ü�”              as “ü�”
    ,T.Žd“ü�”—Ê             as �”—Ê
    ,T.Žd“üÊÞ×�”—Ê          as ÊÞ×�”—Ê
    ,T.’PˆÊº°ÄÞ             as ’PˆÊ–¼�̋敪
    ,T.’艿                 as ’艿
    ,T.Žd“ü’P‰¿             as ’P‰¿
    ,T.Žd“ü‹àŠz             as ‹àŠz
    ,T.Žd“ü�Á”ï�Å–¾�×       as �Á”ï�ÅŠz–¾�×
    ,T.Žd“ü“`•[�‡Œv‹àŠz     as “`•[�‡Œv‹àŠz
    ,T.Žd“ü“`•[�Á”ï�ÅŠz     as “`•[�‡Œv�Á”ï�ÅŠz
    ,T.Žd“ü“`•[’lˆø‹àŠz     as “`•[’lˆø‹àŠz
    ,0                    as ‘Î�ÛŽx•¥’÷“ú
    ,0                    as ‘Î�ÛŒŽŽŸ’÷“ú
    ,' '                  as ‘Î�ÛŽx•¥�ϋ敪
    ,' '                  as ‘Î�ÛŒŽŽŸ�ϋ敪
    ,T.“E—v                 as “E—v
    ,T.�s”õ�l               as �s”õ�l
    ,T.“ü—Í‹’“_º°ÄÞ         as ‹’“_º°ÄÞ
    ,T.“ü—Í’S“–ŽÒº°ÄÞ       as “ü—Í’S“–ŽÒº°ÄÞ
    ,T.“ü‰×�sŽ}”Ô           as “`•[�sŽ}”Ô
    ,T.’ù�³“`•[”Ô�†         as ’ù�³“`•[”Ô�†
    ,T.Žd“ü�溰ÄÞ           as ”­’��溰ÄÞ
    ,T.”­’�’P‰¿             as ”­’�’P‰¿
    ,T.�X�VµÍßÚ°Àº°ÄÞ       as �X�VµÍßÚ°Àº°ÄÞ
    ,T.Žd“ü�æ”[•i�‘”Ô�†Í¯ÀÞ as Žd“ü�æ”[•i�‘No
    ,T.Žd—l‚P               as Žd—l‚P
    ,T.Žd—l‚Q               as Žd—l‚Q
    ,T.�¡–@                 as �¡–@
 FROM FE_NYUKA T,MM_TOK M
 WHERE T.Žd“ü“¾ˆÓ�溰ÄÞ=M.“¾ˆÓ�溰ÄÞ(+)
	and T.�í�œÌ׸Þ='0'
 UNION ALL
 SELECT
     '0'                  as ƒtƒ@ƒCƒ‹‹æ•ª
    ,“`•[”Ô�†             as “`•[”Ô�†
    ,�s”Ô�†               as �s”Ô�†
    ,Žæˆø�溰ÄÞ           as Žd“ü�溰ÄÞ
    ,Žd“ü“¾ˆÓ�溰ÄÞ       as Žd“ü“¾ˆÓ�溰ÄÞ
    ,“X•Ü—p¸ÞÙ°Ìߺ°ÄÞ     as “X•Ü—p¸ÞÙ°Ìߺ°ÄÞ
    ,Œ»�꺰ÄÞ             as •¨Œ�º°ÄÞ
    ,Ò°¶°º°ÄÞ             as Ò°¶°º°ÄÞ
    ,•”º°ÄÞ               as •”º°ÄÞ
    ,‰Ûº°ÄÞ               as ‰Ûº°ÄÞ
    ,’S“–ŽÒº°ÄÞ           as ’S“–ŽÒº°ÄÞ
    ,“ü‰×“ú               as “ü‰×“ú
    ,Œv�ã�ˆ—�“ú           as Œv�ã�ˆ—�“ú
    ,“`•[“ú•t             as “`•[“ú•t
    ,�¿‹�Žx•¥�溰ÄÞ       as Žx•¥�溰ÄÞ
    ,�Á”ï�ŋ敪           as �Á”ï�ŋ敪
    ,Žæˆø‹æ•ª             as Žæˆø‹æ•ª
    ,�¤•iº°ÄÞ             as �¤•iº°ÄÞ
    ,�¤•i–¼               as �¤•i–¼
    ,‹KŠi–¼               as ‹KŠi–¼
    ,�Á”ï�Å—¦             as �Á”ï�Å—¦
    ,�Á”ï�ÅŒvŽZ’PˆÊ       as �Á”ï�ÅŒvŽZ’PˆÊ
    ,’è”ԋ敪             as ’è”ԋ敪
    ,“ü—Í’PˆÊ             as “ü—Í’PˆÊ
    ,“ü�”                 as “ü�”
    ,�”—Ê                 as �”—Ê
    ,ÊÞ×�”—Ê              as ÊÞ×�”—Ê
    ,’PˆÊ–¼�̋敪         as ’PˆÊ–¼�̋敪
    ,�¬”„’P‰¿             as ’艿
    ,’P‰¿                 as ’P‰¿
    ,‹àŠz                 as ‹àŠz
    ,�Á”ï�ÅŠz–¾�×         as �Á”ï�ÅŠz–¾�×
    ,“`•[�‡Œv‹àŠz         as “`•[�‡Œv‹àŠz
    ,“`•[�‡Œv�Á”ï�ÅŠz     as “`•[�‡Œv�Á”ï�ÅŠz
    ,“`•[’lˆø‹àŠz         as “`•[’lˆø‹àŠz
    ,‘Î�ÛŽx•¥’÷“ú         as ‘Î�ÛŽx•¥’÷“ú
    ,‘Î�ÛŒŽŽŸ’÷“ú         as ‘Î�ÛŒŽŽŸ’÷“ú
    ,‘Î�ÛŽx•¥�ϋ敪       as ‘Î�ÛŽx•¥�ϋ敪
    ,‘Î�ÛŒŽŽŸ�ϋ敪       as ‘Î�ÛŒŽŽŸ�ϋ敪
    ,“E—v                 as “E—v
    ,�s”õ�l               as �s”õ�l
    ,‹’“_º°ÄÞ             as ‹’“_º°ÄÞ
    ,“ü—Í’S“–ŽÒº°ÄÞ       as “ü—Í’S“–ŽÒº°ÄÞ
    ,“`•[�sŽ}”Ô           as “`•[�sŽ}”Ô
    ,’ù�³“`•[”Ô�†         as ’ù�³“`•[”Ô�†
    ,Žæˆø�溰ÄÞ           as ”­’��溰ÄÞ
    ,Žó”­’�’P‰¿           as ”­’�’P‰¿
    ,�X�VµÍßÚ°Àº°ÄÞ       as �X�VµÍßÚ°Àº°ÄÞ
    ,Žd“ü�æ”[•i�‘NoͯÀÞ   as Žd“ü�æ”[•i�‘No
    ,Žd—l‚P               as Žd—l‚P
    ,Žd—l‚Q               as Žd—l‚Q
    ,�¡–@                 as �¡–@
 FROM FB_RUISEKUK
 WHERE
 FB_RUISEKUK.ŽæˆøŽí•Ê = '02' and
 FB_RUISEKUK.�í�œÌ×¸Þ = '0'
 ORDER BY
    “`•[”Ô�†
/