--**************************************************************************
--*　指定された年月日のパルパー日報を取得
--*　
--**************************************************************************
[lselectRecords]
SELECT
	 TPD.NO_PULPER_DAIRY
	,TPD.DT_PULPER_DAIRY
	,TPD.DTS_YEAR
	,TPD.DTS_MONTH
	,TPD.DTS_DAY
	,TPD.NO_BATCH
	,TPD.CD_STAFF
	,TO_CHAR(TPD.START_TIME, 'HH24:MI') START_TIME
	,TO_CHAR(TPD.END_TIME, 'HH24:MI') END_TIME
	,TPD.THERMO
	,TPD.TIME_SHIP_WP
	,TPD.CHEMICALS_SHIP_WP
	,TPD.AMPERE_SHIP_WP
	,TPD.VOLUME_SHIP_WP
	,TPD.TIME_MELT1
	,TPD.CHEMICALS_MELT1
	,TPD.TIME_CHEMICALS_MELT1
	,TPD.AMPERE_MELT1
	,TPD.VOLUME_MELT1
	,TPD.TIME_NEUTRALIZE
	,TPD.CHEMICALS_NEUTRALIZE
	,TPD.TIME_MELT2
	,TPD.CHEMICALS_MELT2
	,TPD.AMPERE_MELT2
	,TPD.VOLUME_MELT2
	,TPD.TIME_SEND
	,TPD.TIME_BLOW
	,TPD.COMMENT1
	,TPD.COMMENT2
	,TPD.COMMENT3
	,TO_CHAR(TPD.TIME_VERIFICATION, 'HH24:MI') TIME_VERIFICATION
	,TPD.UP_KAIDO
	,TPD.REST_CHEST
	,TPD.PH
	,TPD.CONDITION
	,TPD.PUREWATER
	,TPD.DUST_COUNT
	,TPD.CHEMICALS_SEND
	,TPD.NO_DUST
	,TPD.WEIGHT_WP
	,MS.NAME_STAFF
FROM t_pulper_dairy tpd
LEFT OUTER JOIN m_staff ms ON (TPD.CD_STAFF = MS.CD_STAFF)
WHERE TPD.DTS_YEAR = ('&2' ::text) ::numeric
AND TPD.DTS_MONTH = ('&3' ::text) ::numeric
AND TPD.DTS_DAY = ('&4' ::text) ::numeric
order by NO_BATCH