CREATE OR REPLACE VIEW GEA10V01
AS
SELECT
	 SYSTEM_ID
	,USERID
	,PASSWD
	,LANG
	,NAME_JA
	,ROLES
	,DROLES
	,FGJ
	,FGDEFAULT
FROM GEA10
WHERE FGJ  = '1'
AND   DYVALID >= to_char(timestamp 'now','YYYYMMDDHH24MISS')
;