/* ------- ƒJƒeƒSƒŠ -------- */

CREATE OR REPLACE VIEW V_KATE AS
SELECT
	 ‘ć•Ș—Țș°ÄȚ		"‘ć•Ș—Țș°ÄȚ"
	,SUBSTR(¶ĂșȚŰș°ÄȚ,1,2)	"Ź•Ș—Țș°ÄȚ"
	,SUBSTR(¶ĂșȚŰș°ÄȚ,3,2)	"Ś•Ș—Țș°ÄȚ"
	,–ŒÌ			"¶ĂșȚۖŒ"
FROM
    MM_KATE
WHERE
    Ží•Ê = 'Ś•Ș—Ț'
;

/* -------- ‹’“_ -------- */


CREATE OR REPLACE VIEW V_KYOTEN AS
SELECT
	 ‘gDș°ÄȚ_ăˆÊ || ‘gDș°ÄȚ_‰șˆÊ	"‹’“_ș°ÄȚ"
	,‘gD–Œ			"‹’“_–Œ"
FROM
    MM_SISIKI
;

/* -------- •”‰Û -------- */


CREATE OR REPLACE VIEW V_BUKA AS
SELECT
	 SUBSTR(–ŒÌ·°2,1,1)	"•”"
	,SUBSTR(–ŒÌ·°2,2,1)	"‰Û"
	,–ŒÌ			"•”‰Û–Œ"
FROM
    MM_MEI
WHERE
    –ŒÌ·°1 = '‰Û'
;

/* -------- •”‰Û iVE¶ŽYàj-------- */


CREATE OR REPLACE VIEW V_BUKA AS
SELECT
	 SUBSTR(–ŒÌ·°2,1,3)	"•”"
	,SUBSTR(–ŒÌ·°2,4,2)	"‰Û"
	,–ŒÌ			"•”‰Û–Œ"
FROM
    MM_MEI
WHERE
    –ŒÌ·°1 = '‰Û'
;

/* -------- ĆV’S“–ŽÒ(“ŸˆÓæƒ}ƒXƒ^‚©‚ç) -------- */

CREATE OR REPLACE VIEW V_TANTO AS
select
 A.“ŸˆÓæș°ÄȚ “ŸˆÓæș°ÄȚ
,case
 when (A.‰c‹Æ’S“–ŠJŽn“ú•t2>=A.‰c‹Æ’S“–ŠJŽn“ú•t1 AND B.”„ăŽd“ü“–“ú“ú•t>=A.‰c‹Æ’S“–ŠJŽn“ú•t2 OR A.‰c‹Æ’S“–ŠJŽn“ú•t2<A.‰c‹Æ’S“–ŠJŽn“ú•t1 AND B.”„ăŽd“ü“–“ú“ú•t<A.‰c‹Æ’S“–ŠJŽn“ú•t1) AND A.‰c‹Æ’S“–ș°ÄȚ2<>'' then A.‰c‹Æ’S“–ș°ÄȚ2
 else A.‰c‹Æ’S“–ș°ÄȚ1
end ‰c‹Æ’S“–ș°ÄȚ
from
 MM_TOK A
,FE_TODAY B
where
 B.‚j‚d‚x = '‹Æ–±“ú•tƒ}ƒXƒ^'
;

/* -------- “–“ú’S“–ŽÒ(“ŸˆÓæƒ}ƒXƒ^‚©‚ç) -------- */

CREATE OR REPLACE VIEW V_TANTONOW AS
select
 A.“ŸˆÓæș°ÄȚ “ŸˆÓæș°ÄȚ
,decode(A.‰c‹Æ’S“–ș°ÄȚ2,' ',A.‰c‹Æ’S“–ș°ÄȚ1,
	decode(sign(A.‰c‹Æ’S“–ŠJŽn“ú•t2-A.‰c‹Æ’S“–ŠJŽn“ú•t1),-1,
		decode(sign(to_nchar(sysdate,'YYYYMMDD')-A.‰c‹Æ’S“–ŠJŽn“ú•t1),-1,A.‰c‹Æ’S“–ș°ÄȚ2,A.‰c‹Æ’S“–ș°ÄȚ1), 
		decode(sign(to_nchar(sysdate,'YYYYMMDD')-A.‰c‹Æ’S“–ŠJŽn“ú•t2),-1,A.‰c‹Æ’S“–ș°ÄȚ1,A.‰c‹Æ’S“–ș°ÄȚ2))) ‰c‹Æ’S“–ș°ÄȚ
from
 MM_TOK A
;