<?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="d_recv_ws_subreport1" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="792" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="433"/>
	<property name="ireport.y" value="0"/>
	<parameter name="ASN_NO" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT
     CASE WHEN  ASD.ITEM_CODE IS NULL THEN ' ' ELSE ASD.ITEM_CODE END AS SKU,
     CASE WHEN  IT.DESCR IS NULL THEN ' ' ELSE IT.DESCR END AS SKU_DESCR,
	  ' ' AS IMMD_NEED,
     CASE WHEN  ASD.QUANTITY IS NULL THEN 0 ELSE ASD.QUANTITY END AS SHIP_UNIT,
	  ' ' AS SHIP_LPN,
     '9999999.99' AS INN_PCK_QTY,
     ' ' AS LOCATION,
     ' ' AS MNF_CODE,
	  ' ' AS CS_TIER,
	  ' ' AS TR_PALTS,
	  'UNIT TAR LPN TAR PAL' AS PUT_TYPE
FROM
     ASN_DET ASD,
     ASN_HDR ASH,
     ITEM IT

WHERE
   ASD.TRAN_ID = ASH.TRAN_ID
   AND ASD.ITEM_CODE = IT.ITEM_CODE
   AND ASH.ASN_NO = '$P!{ASN_NO}']]>
	</queryString>
	<field name="SKU" class="java.lang.String"/>
	<field name="SKU_DESCR" class="java.lang.String"/>
	<field name="IMMD_NEED" class="java.lang.String"/>
	<field name="SHIP_UNIT" class="java.lang.Double"/>
	<field name="SHIP_LPN" class="java.lang.String"/>
	<field name="INN_PCK_QTY" class="java.lang.String"/>
	<field name="LOCATION" class="java.lang.String"/>
	<field name="PUT_TYPE" class="java.lang.String"/>
	<field name="CS_TIER" class="java.lang.String"/>
	<field name="TR_PALTS" class="java.lang.String"/>
	<field name="MNF_CODE" class="java.lang.String"/>
	<variable name="tot_po" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{SHIP_UNIT}]]></variableExpression>
	</variable>
	<variable name="tot_ship" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{SHIP_UNIT}]]></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="42" splitType="Stretch">
			<staticText>
				<reportElement x="500" y="22" width="80" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Tiers / Pallet :]]></text>
			</staticText>
			<staticText>
				<reportElement x="340" y="22" width="74" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Cases / Tier  :]]></text>
			</staticText>
			<staticText>
				<reportElement x="340" y="32" width="74" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<text><![CDATA[Putaway Types :]]></text>
			</staticText>
			<elementGroup/>
			<textField isBlankWhenNull="true">
				<reportElement x="18" y="4" width="97" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SKU}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="125" y="4" width="160" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SKU_DESCR}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="296" y="4" width="31" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{IMMD_NEED}]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement x="338" y="4" width="60" height="10"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{SHIP_UNIT}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="414" y="4" width="74" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SHIP_LPN}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="500" y="4" width="38" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INN_PCK_QTY}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="558" y="4" width="74" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{LOCATION}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="639" y="4" width="74" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MNF_CODE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="414" y="32" width="144" height="10"/>
				<textElement>
					<font fontName="Courier New" size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PUT_TYPE}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band/>
	</pageFooter>
	<lastPageFooter>
		<band/>
	</lastPageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
