<jsp:directive.page pageEncoding="UTF-8" />
<!-- 画面分類⇒コードリソース差分追加 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select SYSTEM_ID,CLASSIFY AS CODE,CLASSIFY AS LNAME,KBSAKU
	from  GEA11
	where SYSTEM_ID = '{@SYSTEM_ID}'
	and   KBSAKU   != '0'
	and   FGJ       = '1'
	and   ( CLASSIFY is not null and CLASSIFY != '' )
	and not exists (
			select * from GEA04 b
			where b.SYSTEM_ID = '{@SYSTEM_ID}'
			and   b.CLM       = 'CLASSIFY'
			and   b.CODE      = GEA11.CLASSIFY
			and   KBSAKU     != '0'
			and   FGJ         = '1'
		)
	group by SYSTEM_ID,CLASSIFY,KBSAKU
	order by SYSTEM_ID,CLASSIFY
</og:query>

<og:value key="lblKey" value="A" />

<og:hidden name="SQL" >
	INSERT INTO GEA04
		(CLM,CODE,SEQNO,LNAME,SYSTEM_ID,LANG,KBSAKU,
		 FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD)
	VALUES
		('CLASSIFY',[CODE],[SEQNO],[LNAME],[SYSTEM_ID],'ja',[KBSAKU],
		 '1','{@USER.YMDH}','{@USER.YMDH}','{@USER.ID}','{@USER.ID}','{@GUI.KEY}')
</og:hidden>

<og:viewLink command="{@command}">
	<og:link column="CODE" gamenId="GE0004" href="index.jsp" target="CONTENTS"
		keys="command,SYSTEM_ID,CLM,CODE,KBSAKU,LANG"
		vals="NEW,[SYSTEM_ID],CLASSIFY,[CODE],[KBSAKU],ja" />
</og:viewLink>
