<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report3" pageWidth="612" pageHeight="845" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="26"/>
	<property name="ireport.y" value="0"/>
	<queryString>
		<![CDATA[SELECT A.ITEM_CODE, A.LOT_NO
FROM STOCK A, INVSTAT B, ITEM C, LOCATION D
WHERE A.LOC_CODE = D.LOC_CODE
AND D.INV_STAT = B.INV_STAT AND A.ITEM_CODE = C.ITEM_CODE
AND B.AVAILABLE = 'Y' AND (CASE WHEN B.STAT_TYPE IS NULL THEN ' ' ELSE
B.STAT_TYPE END
) <> 'S' AND (CASE WHEN A.QUANTITY IS NULL THEN 0 ELSE A.QUANTITY END) > 0
AND D.INV_STAT
 IN ('PSO', 'DSO' , 'CASPK') AND A.EXP_DATE IS NOT NULL
 AND nvl(CHECK_PHYSCAN_VALUE(A.ITEM_CODE, A.SITE_CODE, A.LOC_CODE,
A.LOT_NO, A.LOT_SL, 'EXP_LOCK' , 'NEXP_LOCK'),0) <> 1]]>
	</queryString>
	<field name="item_code" class="java.lang.String"/>
	<field name="lot_no" class="java.lang.String"/>
	<variable name="barcode" class="java.lang.String">
		<variableExpression><![CDATA[new java.lang.String(ibase.webitm.reports.sun.BaseReportGFMethods.gf_bar_code(ibase.webitm.reports.utility.BaseReportMethods.trim( $F{item_code}) +"-"+ibase.webitm.reports.utility.BaseReportMethods.trim( $F{lot_no})) )]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="109" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement x="10" y="39" width="547" height="60"/>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font fontName="Code 128AB" size="66"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{barcode}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="178" y="12" width="100" height="20"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{item_code}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="294" y="12" width="100" height="20"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{lot_no}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
