<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<LOVS>
<!-- loader xml for Enginatics Blitz Report lov: INV Category Set -->
 <LOVS_ROW>
  <GUID>8E2FF36EDECA79D2E0530100007F1FF2</GUID>
  <LOV_NAME>INV Category Set</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select distinct
mcsv.category_set_name value,
mcsv.description
from
mtl_category_sets_vl mcsv
where
:$flex$.organization_code is null or
mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos; and mp.organization_id=mic.organization_id)
order by
mcsv.category_set_name</LOV_QUERY>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
<!-- loader xml for Enginatics Blitz Report lov: Yes -->
 <LOVS_ROW>
  <GUID>8E2FF36EDEA679D2E0530100007F1FF2</GUID>
  <LOV_NAME>Yes</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
</LOVS>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: OPM Batch Lot Cost Details -->
 <REPORTS_ROW>
  <GUID>3A3523DAAE7CAEF0E06362FB09055D29</GUID>
  <SQL_TEXT>with opm_batch_lot_costs as
(
select
x.top_batch_id,
x.top_item_id,
x.batch_id,
x.material_detail_id,
x.organization_id,
x.product_item_id,
x.inventory_item_id,
x.primary_uom_code,
x.dtl_um,
x.dtl_prim_uom_conv_rate,
x.plan_qty,
x.actual_qty,
x.scaled_actual_qty,
x.ingredient_usage_factor,
x.lot_number,
x.lot_cost * x.dtl_prim_uom_conv_rate lot_cost,
x.lot_qty,
x.scaled_lot_qty,
x.intermediate_ingred,
x.uom_conv_error,
x.line_type,
x.lot_source,
x.step_level,
x.sort_order,
x.group_id
from
xmltable
( &apos;/BATCHLOTCOST/ROW&apos;
  passing xxen_opm.get_report_xml
  columns
    top_batch_id            number          path &apos;TOP_BATCH_ID&apos;
  , top_item_id             number          path &apos;TOP_ITEM_ID&apos;
  , batch_id                number          path &apos;BATCH_ID&apos;
  , material_detail_id      number          path &apos;MATERIAL_DETAIL_ID&apos;
  , organization_id         number          path &apos;ORGANIZATION_ID&apos;
  , product_item_id         number          path &apos;PRODUCT_ITEM_ID&apos;
  , inventory_item_id       number          path &apos;INVENTORY_ITEM_ID&apos;
  , primary_uom_code        varchar2(3)     path &apos;PRIMARY_UOM_CODE&apos;
  , dtl_um                  varchar2(3)     path &apos;DTL_UM&apos;
  , dtl_prim_uom_conv_rate  number          path &apos;DTL_PRIM_UOM_CONV_RATE&apos;
  , plan_qty                number          path &apos;PLAN_QTY&apos;
  , actual_qty              number          path &apos;ACTUAL_QTY&apos;
  , scaled_actual_qty       number          path &apos;SCALED_ACTUAL_QTY&apos;
  , ingredient_usage_factor number          path &apos;SCALING_FACTOR&apos;
  , lot_number              varchar2(150)   path &apos;LOT_NUMBER&apos;
  , lot_cost                number          path &apos;LOT_COST&apos;
  , lot_qty                 number          path &apos;LOT_QTY&apos;
  , scaled_lot_qty          number          path &apos;SCALED_LOT_QTY&apos;
  , intermediate_ingred     varchar2(1)     path &apos;INTERMEDIATE_INGRED&apos;
  , uom_conv_error          varchar2(1)     path &apos;UOM_CONV_ERROR&apos;
  , line_type               number          path &apos;LINE_TYPE&apos;
  , lot_source              varchar2(150)   path &apos;LOT_SOURCE&apos;
  , step_level              number          path &apos;STEP_LEVEL&apos;
  , sort_order              varchar2(2000)  path &apos;SORT_ORDER&apos;
  , group_id                number          path &apos;GROUP_ID&apos;
) x
)
--
--
select
ood.organization_code organization,
gbh1.batch_no top_batch_no,
gbh2.batch_no,
(select gfc.formula_class_desc from fm_form_mst ffm,gmd_formula_class gfc where ffm.formula_class = gfc.formula_class and ffm.formula_id = gbh2.formula_id) batch_type,
gbh2.actual_cmplt_date batch_completion_date,
(select gllv.currency_code from gl_ledger_le_v gllv where gllv.ledger_id = ood.set_of_books_id) currency_code,
-- product
msiv1.concatenated_segments product,
msiv1.description product_desc,
xxen_util.meaning(msiv1.item_type,&apos;ITEM_TYPE&apos;,3) product_item_type,
oblcp.lot_number batch_lot_number,
oblcp.plan_qty batch_size,
oblcp.actual_qty batch_actual_output,
round(oblcp.actual_qty/oblcp.plan_qty*100,2) batch_yield,
trunc(oblcp.lot_cost * oblcp.actual_qty,:p_precision) batch_cost,
trunc(oblcp.lot_cost,:p_precision) batch_unit_cost,
oblcp.dtl_um batch_uom,
oblcp.primary_uom_code primary_uom,
-- ingredients
oblc.step_level &quot;Level&quot;,
xxen_util.meaning(oblc.line_type,&apos;GMD_FORMULA_ITEM_TYPE&apos;,552) material_type,
msiv2.concatenated_segments item,
msiv2.description item_desc,
xxen_util.meaning(msiv2.item_type,&apos;ITEM_TYPE&apos;,3) item_type,
-- lot
oblc.lot_number,
trunc(oblc.lot_cost,:p_precision) lot_cost,
trunc(oblc.lot_qty,:p_precision) lot_quantity,
trunc(trunc(oblc.lot_cost,:p_precision) * trunc(oblc.lot_qty,:p_precision),:p_precision) lot_extended_cost,
case when sum(trunc(oblc.lot_cost,:p_precision) * trunc(oblc.lot_qty,:p_precision)) over (partition by oblc.batch_id) != 0
then round(((trunc(oblc.lot_cost,:p_precision) * trunc(oblc.lot_qty,:p_precision)) / sum(trunc(oblc.lot_cost,:p_precision) * trunc(oblc.lot_qty,:p_precision)) over (partition by oblc.batch_id))*100,2)
else 0
end pct_of_cost,
decode(oblc.intermediate_ingred,&apos;Y&apos;,&apos;PRODUCTION BATCH&apos;,oblc.lot_source) lot_source,
oblc.dtl_um detail_uom,
xxen_util.meaning(oblc.uom_conv_error,&apos;YES_NO&apos;,0) uom_conv_error,
--
&amp;lp_prod_category_segments
&amp;lp_prod_catalog_elements
&amp;lp_prod_item_dff
&amp;lp_ingred_category_segments
&amp;lp_ingred_catalog_elements
&amp;lp_ingred_item_dff
--
oblc.sort_order sort_order,
oblc.top_batch_id,
oblc.batch_id,
oblc.material_detail_id
from
opm_batch_lot_costs oblc,
opm_batch_lot_costs oblcp,
gme_batch_header gbh1,
gme_batch_header gbh2,
org_organization_definitions ood,
mtl_system_items_vl msiv1,
mtl_system_items_vl msiv2
where
-- join the batch ingredient line to the batch product line for batch level kpis
oblc.top_batch_id = oblcp.top_batch_id and
oblc.batch_id = oblcp.batch_id and
oblc.product_item_id = oblcp.inventory_item_id and
oblcp.line_type = 1 and
--
oblc.top_batch_id = gbh1.batch_id and
oblc.batch_id = gbh2.batch_id and
gbh2.organization_id = ood.organization_id and
--
oblcp.organization_id = msiv1.organization_id and
oblcp.inventory_item_id = msiv1.inventory_item_id and
oblc.organization_id = msiv2.organization_id and
oblc.inventory_item_id = msiv2.inventory_item_id and
--
oblc.line_type = -1 and
1=1
order by
gbh1.batch_no,
oblc.step_level,
gbh2.batch_no,
oblc.sort_order</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <DB_PACKAGE>XXEN_OPM</DB_PACKAGE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>OPM Batch Lot Cost Details</REPORT_NAME>
    <DESCRIPTION>OPM Batch Lot Cost Details Report

This report shows the Batch Lot Costs details for completed batches in the specified from/to Date Range and for the specified Organization, Product, Formula Class (optional) and Batch (optional).

For each selected batch included in the report, the report details the lot cost details for that batch and for all child production batches consumed by that batch.

The quantities shown in the child batches are the actual quantities for that batch and it’s ingredients. This report does not apportion the child batch quantities based on the actual quantity consumed by the parent batches. 

The report allows the user to pull in several additional data points to allow further analysis of data based on the customer specific configuration. Specifically, for the both the batch product (same for all lines in the batch) and for the batch ingredients (are specific to each line in the batch), the following additional data can be pulled into the report.

- Item Catalog Descriptive Elements for a specific Item Catalog Group
- Item Category Segments for a specific Item Category Set
- Item Descriptive Flexfield Attributes   
</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>R12 only</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_ingred_catalog_elements</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_ingred_category_segments</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_ingred_item_dff</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_prod_catalog_elements</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_prod_category_segments</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_prod_item_dff</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_batch_no</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_cost_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_cost_type_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_date_from</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_date_to</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_formula_class</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_item</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_master_org_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_org_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_org_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_precision</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_report_code</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>-20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_report_code</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>OPM_BATCH_LOT_COST</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Report Code</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>-10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_precision</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>3</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Precision</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_org_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
goav.organization_code value,
goav.organization_name description
from
gmd_org_access_vw goav
order by
value</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;)</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_date_from</ANCHOR>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>From Date</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_date_to</ANCHOR>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>To Date</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>:p_item</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <FILTER_BEFORE_DISPLAY_DSP>Y</FILTER_BEFORE_DISPLAY_DSP>
    <LOV_QUERY_DSP>select
msiv.concatenated_segments value,
msiv.description
from
mtl_parameters mp,
mtl_system_items_vl msiv
where
msiv.organization_id=mp.organization_id and
xxen_util.contains(:$flex$.organization_code,mp.organization_code) = &apos;Y&apos; and
exists
(select
 null
 from
 gme_batch_header gbh,
 gme_material_details gmd,
 mtl_material_transactions mmt,
 mtl_transaction_lot_numbers mln
 where
 gbh.batch_id = gmd.batch_id and
 gbh.organization_id = msiv.organization_id and
 gmd.inventory_item_id = msiv.inventory_item_id and
 gmd.batch_id = mmt.transaction_source_id and
 gmd.material_detail_id = mmt.trx_source_line_id and
 gmd.inventory_item_id = mmt.inventory_item_id and
 mmt.transaction_source_type_id = 5 and
 mmt.transaction_id = mln.transaction_id and
 gmd.line_type = 1 and
 gbh.actual_cmplt_date is not null and
 trunc(gbh.actual_cmplt_date) between :$flex$.from_date and :$flex$.to_date and
 (:$flex$.formula_class is null or
  gbh.formula_id in (select ffm.formula_id from fm_form_mst ffm where ffm.formula_class = :$flex$.formula_class and ffm.owner_organization_id = mp.organization_id)
 )
)
order by
value</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Product</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>:p_formula_class</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select 
gfc.formula_class id,
gfc.formula_class_desc value,
null description
from 
gmd_formula_class gfc 
order by
value</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Formula Class</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>:p_batch_no</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
gbh.batch_no value,
to_char(gbh.actual_cmplt_date,&apos;DD-MM-YYYY HH24:MI:SS&apos;) description
from
mtl_parameters mp,
gme_batch_header gbh
where
gbh.organization_id = mp.organization_id and
xxen_util.contains(:$flex$.organization_code,mp.organization_code) = &apos;Y&apos; and
gbh.actual_cmplt_date is not null and
trunc(gbh.actual_cmplt_date) between :$flex$.from_date and :$flex$.to_date and
(:$flex$.formula_class is null or
 gbh.formula_id in (select ffm.formula_id from fm_form_mst ffm where ffm.formula_class = :$flex$.formula_class and ffm.owner_organization_id = mp.organization_id)
) and
exists
(select
 null
 from
 gme_material_details gmd,
 mtl_system_items_vl msiv,
 mtl_material_transactions mmt,
 mtl_transaction_lot_numbers mln
 where
 gmd.batch_id = gbh.batch_id and
 gmd.line_type = 1 and
 gmd.organization_id = msiv.organization_id and
 gmd.inventory_item_id = msiv.inventory_item_id and
 gmd.batch_id = mmt.transaction_source_id and
 gmd.material_detail_id = mmt.trx_source_line_id and
 gmd.inventory_item_id = mmt.inventory_item_id and
 mmt.transaction_source_type_id = 5 and
 mmt.transaction_id = mln.transaction_id and
 msiv.concatenated_segments = :$flex$.product
)
order by
value</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Batch</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>9</SORT_ORDER>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <ANCHOR>:p_cost_type_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
cmm.cost_type_id id,
cmm.cost_mthd_code value,
cmm.cost_mthd_desc  description
from
cm_mthd_mst cmm
where
cmm.cost_type = 6
order by
value</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
cmm.cost_mthd_code
from
mtl_parameters mp,
cm_mthd_mst cmm,
gmf_fiscal_policies gfp,
org_organization_definitions ood
where
cmm.default_lot_cost_type_id = gfp.cost_type_id and
gfp.legal_entity_id = ood.legal_entity and
xxen_util.contains(:$flex$.organization_code,ood.organization_code) = &apos;Y&apos;</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Cost Type</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>10</SORT_ORDER>
    <DISPLAY_SEQUENCE>80</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;lp_prod_category_segments</ANCHOR>
    <SQL_TEXT>select x.* from (
select
&apos;(select min(mcb.&apos;||lower(fifsv.application_column_name)||&apos;) keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_b mcb where mic.category_set_id=&apos; || mcsv.category_set_id || &apos; and msiv1.organization_id=mic.organization_id and msiv1.inventory_item_id=mic.inventory_item_id and mic.category_id=mcb.category_id) &quot;&apos;||substrb(&apos;Prd: &apos; || fifsv.form_left_prompt_,1,xxen_report.max_column_length)||&apos;&quot;,&apos; sql_text
from
mtl_category_sets_vl mcsv,
(select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv
where
mcsv.category_set_name=:p_prod_cat_set_name and
mcsv.structure_id=fifsv.id_flex_num and
fifsv.application_id=401 and
fifsv.id_flex_code=&apos;MCAT&apos; and
fifsv.enabled_flag=&apos;Y&apos;
order by
fifsv.id_flex_num,
fifsv.segment_num
) x</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select distinct
mcsv.category_set_name value,
mcsv.description
from
mtl_category_sets_vl mcsv
where
:$flex$.organization_code is null or
mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos; and mp.organization_id=mic.organization_id)
order by
mcsv.category_set_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Product Category Set</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>11</SORT_ORDER>
    <DISPLAY_SEQUENCE>90</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;lp_prod_catalog_elements</ANCHOR>
    <SQL_TEXT>select distinct
&apos;(select mdev.element_value from mtl_descr_element_values_v mdev where mdev.inventory_item_id = msiv1.inventory_item_id and mdev.item_catalog_group_id = msiv1.item_catalog_group_id and mdev.element_name = &apos;&apos;&apos; || mdv.element_name || &apos;&apos;&apos;)&apos; ||
&apos; &quot;&apos; || substrb(&apos;Prd: &apos; || mdv.element_name,1,xxen_report.max_column_length) || &apos;&quot;,&apos; value
from
mtl_descr_element_values_v mdv
where
mdv.item_catalog_group_id = :p_prod_catlg_grp_id
order by
value</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
micgbk.item_catalog_group_id id,
micgbk.concatenated_segments value,
null description
from
mtl_item_catalog_groups_b_kfv micgbk
where
exists
(select
 null
 from
 mtl_parameters mp,
 mtl_system_items_b msib
 where
 mp.organization_id = msib.organization_id and
 msib.item_catalog_group_id = micgbk.item_catalog_group_id and
 xxen_util.contains(:$flex$.organization_code,mp.organization_code) = &apos;Y&apos;
)</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Product Item Catalog</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>12</SORT_ORDER>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;lp_prod_item_dff</ANCHOR>
    <SQL_TEXT>select xxen_util.dff_columns(p_table_name=&gt;&apos;mtl_system_items_b&apos;,p_table_alias=&gt;&apos;msiv1&apos;, p_row_id=&gt;&apos;row_id&apos;,p_column_name_prefix=&gt;&apos;Prd: &apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show Product Item DFF</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>13</SORT_ORDER>
    <DISPLAY_SEQUENCE>110</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;lp_ingred_category_segments</ANCHOR>
    <SQL_TEXT>select x.* from (
select
&apos;(select min(mcb.&apos;||lower(fifsv.application_column_name)||&apos;) keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_b mcb where oblc.step_level &gt; 0 and mic.category_set_id=&apos; || mcsv.category_set_id || &apos; and msiv2.organization_id=mic.organization_id and msiv2.inventory_item_id=mic.inventory_item_id and mic.category_id=mcb.category_id) &quot;&apos;||substrb(&apos;Ing: &apos; || fifsv.form_left_prompt_,1,xxen_report.max_column_length)||&apos;&quot;,&apos; sql_text
from
mtl_category_sets_vl mcsv,
(select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv
where
mcsv.category_set_name=:p_ingred_cat_set_name and
mcsv.structure_id=fifsv.id_flex_num and
fifsv.application_id=401 and
fifsv.id_flex_code=&apos;MCAT&apos; and
fifsv.enabled_flag=&apos;Y&apos;
order by
fifsv.id_flex_num,
fifsv.segment_num
) x</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select distinct
mcsv.category_set_name value,
mcsv.description
from
mtl_category_sets_vl mcsv
where
:$flex$.organization_code is null or
mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos; and mp.organization_id=mic.organization_id)
order by
mcsv.category_set_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Ingredient Category Set</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>14</SORT_ORDER>
    <DISPLAY_SEQUENCE>120</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;lp_ingred_catalog_elements</ANCHOR>
    <SQL_TEXT>select distinct
&apos;(select mdev.element_value from mtl_descr_element_values_v mdev where oblc.step_level &gt; 0 and mdev.inventory_item_id = msiv2.inventory_item_id and mdev.item_catalog_group_id = msiv2.item_catalog_group_id and mdev.element_name = &apos;&apos;&apos; || mdv.element_name || &apos;&apos;&apos;)&apos; ||
&apos; &quot;&apos; || substrb(&apos;Ing: &apos; || mdv.element_name,1,xxen_report.max_column_length) || &apos;&quot;,&apos; value
from
mtl_descr_element_values_v mdv
where
mdv.item_catalog_group_id = :p_ingred_catlg_grp_id
order by
value</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
micgbk.item_catalog_group_id id,
micgbk.concatenated_segments value,
null description
from
mtl_item_catalog_groups_b_kfv micgbk
where
exists
(select
 null
 from
 mtl_parameters mp,
 mtl_system_items_b msib
 where
 mp.organization_id = msib.organization_id and
 msib.item_catalog_group_id = micgbk.item_catalog_group_id and
 xxen_util.contains(:$flex$.organization_code,mp.organization_code) = &apos;Y&apos;
)</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Ingredient Item Catalog</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>15</SORT_ORDER>
    <DISPLAY_SEQUENCE>130</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;lp_ingred_item_dff</ANCHOR>
    <SQL_TEXT>select xxen_util.dff_columns(p_table_name=&gt;&apos;mtl_system_items_b&apos;,p_table_alias=&gt;&apos;msiv2&apos;, p_row_id=&gt;&apos;row_id&apos;,p_column_name_prefix=&gt;&apos;Ing: &apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show Ingredient Item DFF</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.formula_class</FLEX_BIND>
    <PARAMETER_NAME>Formula Class</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Batch</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.formula_class</FLEX_BIND>
    <PARAMETER_NAME>Formula Class</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Product</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.from_date</FLEX_BIND>
    <PARAMETER_NAME>From Date</PARAMETER_NAME>
    <IS_DATE>Y</IS_DATE>
    <DEPENDENT_PARAMETER_NAME>Batch</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.from_date</FLEX_BIND>
    <PARAMETER_NAME>From Date</PARAMETER_NAME>
    <IS_DATE>Y</IS_DATE>
    <DEPENDENT_PARAMETER_NAME>Product</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.organization_code</FLEX_BIND>
    <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Batch</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.organization_code</FLEX_BIND>
    <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Cost Type</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.organization_code</FLEX_BIND>
    <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Ingredient Category Set</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.organization_code</FLEX_BIND>
    <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Ingredient Item Catalog</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.organization_code</FLEX_BIND>
    <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Product</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.organization_code</FLEX_BIND>
    <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Product Category Set</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.organization_code</FLEX_BIND>
    <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Product Item Catalog</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.product</FLEX_BIND>
    <PARAMETER_NAME>Product</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Batch</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.to_date</FLEX_BIND>
    <PARAMETER_NAME>To Date</PARAMETER_NAME>
    <IS_DATE>Y</IS_DATE>
    <DEPENDENT_PARAMETER_NAME>Batch</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.to_date</FLEX_BIND>
    <PARAMETER_NAME>To Date</PARAMETER_NAME>
    <IS_DATE>Y</IS_DATE>
    <DEPENDENT_PARAMETER_NAME>Product</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
    <OWNER>ERIC.CLEGG</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_ACTUAL_OUTPUT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_COMPLETION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>33</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_ID</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_LOT_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_NO</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_SIZE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_UNIT_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_UOM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_YIELD</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CURRENCY_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>29</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DETAIL_UOM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_DESC</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>26</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_EXTENDED_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_QUANTITY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>28</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_SOURCE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Level</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>34</DISPLAY_SEQUENCE>
      <COLUMN_NAME>MATERIAL_DETAIL_ID</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>MATERIAL_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>27</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PCT_OF_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRIMARY_UOM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRODUCT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRODUCT_DESC</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRODUCT_ITEM_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>31</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SORT_ORDER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>32</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TOP_BATCH_ID</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TOP_BATCH_NO</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
      <COLUMN_NAME>UOM_CONV_ERROR</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
    </TEMPLATE_PIVOT>
    <FILE_NAME>OPM Batch Lot Cost Details Template 20250804.xlsx</FILE_NAME>
    <FILE_LANGUAGE>US</FILE_LANGUAGE>
    <FILE_DATA>UEsDBBQAAAAIAFlhllyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAFlhlly1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAFlhllwPZyHAoQEAAGYDAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TwW7bMAyG7wP2DoLujdxmKIZAVjEkG3rosGBxuzMn07FQWTIkxkj29JNtxHHWnnYj+f+iPomSfDg2lnUYovEu57eLjDN02pfG7XP+XHy7+cxZJHAlWO8w5yeM/EF9/CC3wbcYyGBkqYWLOa+J2pUQUdfYQFwk2SWl8qEBSmnYC19VRuPG60ODjsRdlt0LPBK6EsubdmrIx46rjv63ael1zxdfilObgJUsPIEtTIMqk+KSyC9ta40GSqdX340OPvqK2NejRivFXJSJeof6EAyd+h7zVO40WFynDVUFNqIUl4J8ROgvcwsmRCU7WnWoyQcWzZ90nXec/YaIPWbOOwgGHCXc3jYmQ2zbSEH98uE11ogUpZiKQzj3zmPzSS0HQwqujcOqASQJ14iFIYvxR7WFQO8QL+fEA9jIOzLu/CFoZBsgmENO+pMntvaR2AYJjI3sJ7Y+0LveBAANUnqbb857Jv+H9cm41/jcFj7tj+dZXBflroaAZRrfNKupIB/TGILtm6xrcHssz563Qv9yXsZvo27vF9kyS49iVpPi8kHUX1BLAwQUAAAACABZYZZcOskcmjcBAABRAgAAEQAAAGRvY1Byb3BzL2NvcmUueG1sjZJfS8MwFMXfBb9DyXubdHUioe1AZU8OBCuKbyG524LNH5Jot29v2m7dBnsQ8nLvOfeXk0vKxU61yS84L42uUJ4RlIDmRki9qdB7s0wfUOID04K1RkOF9uDRor69Kbml3Dh4dcaCCxJ8EknaU24rtA3BUow934JiPosOHcW1cYqFWLoNtox/sw3gGSH3WEFgggWGe2BqJyI6IAWfkPbHtQNAcAwtKNDB4zzL8ckbwCl/dWBQzpxKhr2NbzrEPWcLPoqTe+flZOy6LuuKIUbMn+PP1cvb8NRU6n5XHFBdCk65AxaMq8uY9lTExbXMh1Xc8VqCeNxH/UpP8CHuOAciiQHoGPeofBRPz80S1TMym6fkISV5Q3IaT1F89VdezPeBxoY6XPwf4l1DCjrvzxnxCBhzX36C+g9QSwMEFAAAAAgAWWGWXE1B1tIaAQAAewQAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72UwUrEMBCG74LvEOZu03Z1Fdl0Dy7CXnV9gNBO27BtEjJxtW9vrNBaWOoeipfAzCT//zHMZLP9bBt2QkfKaAFJFANDnZtC6UrA2+H55gEYeakL2RiNAjok2GbXV5sXbKQPj6hWllhQ0SSg9t4+ck55ja2kyFjUoVIa10ofQldxK/OjrJCncbzm7rcGZBNNti8EuH2xAnbobHD+W9uUpcpxZ/L3FrU/Y8E/jDtSjeiDqHQVegFDinhfWUWBGPh5mPslYaiWDotX70KvaQSapOdg0iVhLuhMOgeT/DNMMgezXhKGfNeEoR8G5iees79b0t6HVcLRvQ95f8624HZJBqtOxj/JsNU7LJVW33s/Io1Vfu7igMknX0b2BVBLAwQUAAAACABZYZZc4it/e7sAAAAzAQAAMgAAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzhY/BasMwEETvhf6D2HstO4dQiuUcEgK5BucDFmlti9haoVVC/PfRMaGFHodh3sy0u8cyqzsl8RwMNFUNioJl58No4NIfv75BScbgcOZABlYS2HWfH+2ZZswlJJOPogoliIEp5/ijtdiJFpSKI4XiDJwWzEWmUUe0VxxJb+p6q9MrA7o3pjo5A+nkGlD9Gkvz/2weBm/pwPa2UMh/VOjo75z3WOadyXJyUuCYRsoGfllNVaaD7lr9drV7AlBLAwQUAAAACABZYZZcz6VOcXsEAADIGAAAJwAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbN1ZbW/iOBD+ftL9ByvfUxIIrwJWvOqQ2tJbYKX76CYGrMY2chwO9rT//cZ2oLB0C9k7er0iBMS2ZuaZeTweD81PGxajNZEJFbzl+DeegwgPRUT5ouXMpkO35qBEYR7hWHDScrYkcT61f/2luaJroXo4XJI+mVNOFQhAIIwnLWep1KpRKCQwyXByI1aEw8xcSIYVPMpFIVlJgqNkSYhicaHoeZUCw5Q7VkJDXiJDzOc0JH0RpoxwZYVIEmNtSbKkq2QnjYWXiGNYPqUrNxRsBSIeaUzV1gh1EAsbowUXEj/G4IKN3AnenNrJaChFIubqBgQVrIknaP0ADF1T7XMHyQaNWo4cRT78JnNJkuWY3woMg88jJOpuW04nVUsB2rNlJOpjBQYF5Vq1dFOp+LVStezBqwQm0ySBGI4UYcktZVS1HAhtCF5XJPqyizcEdy/rcJBR/tmaoiHvZ0CuJKGQUU+kHCQWwRGykWr7/yqXh16v0i25/bJfc4NKt+rW+72eOygNy9XycNjpV6rfnHYz1JSZiFSGBKntCsz/U8gnwwSY3f/OVnDMYIV9ALDYKbSbhQMRmbwhJXGUoNCaVQp2esw4skLGcoE5/Wro4SCesiFTI7Dcg8WAU5LIOGsnxNfDaN1y7jtG6cGSnQlG+qEFmaapWKEuVuES3YvXNXEFpE8mhNE7uiHRFPwB20cHSmRTSpqdeDB0n7JHAsQDcuxWjbgii2wMQvcFxykAhgUMb54fMu9oYFwD8/Piem+YgH4ZpuIRJoOu+HPodAguidm94HbzvR6sboz5UxYrw03tfZaTT9bvPUhMMTFpVms+NNKvaMYfk/gstV5CYCEdMGvyzD8gVjZdq9ddv+iW/KnnNczbMC2brXue6/nwfp7db9of7ZheKiUcO1sAGZ1x/96LZnPOJv28cX6QIkpDdd0UkClBfZKEb6NJJy90LfaeDaCl6K1QyKan62K22ib063e7oJx/FxwQfJdNL06wlvZZgjV5YE9Ok4K8vNS0uDqhSnGMxqlapUc09SsfA+Af+tw8ZEhwegafTV//JHB+lrF2Z6N+PDkdYfAn83TyIaM2gxof8vMHBSdYnpQ1yF0TPkgKF4wtmo3vrqvolqxJfEkF8xZV579bod1BdSIppMbzx9xxlTDiCyjvKdwS825pfarmiVf+y4I5t69fJvy35cFbFQZaz8dLURrV7ynmCjoSx2X//70e0MgGG0V4RKJ3F7izRe9DqNB4fmL3W1cz35WhZ83WTrcdlTyZ7eHzuD/rTUfje9TtTHu/5c2kfQK9jhjNrn3QggKICF+jgZS6V/Zao8cWmXmv8mcdPBESiCGji65BunVhrrK6ced5UJqaL+3e0+HcTY3nVtToqOJ+64L7uBV11oP2IvR+TLZ+N33HH7Uw9sVJRvT3bPwBkqTdJBt1myjzjVJJoZdbLZY7g2Jn4NaDuu8GtUfidovdwA0G3Xo1GPZKXi34tm+C+8FJe/2iLrhXL9Rt17/d3PhB46V/FLTbwS77aawsvLSs/TdQSwMEFAAAAAgAWWGWXMaqmY9CAQAAVAQAACQAAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWzNlEFqwzAQRfeF3kHM3pHtlpIa21m0FLot6QEUWY5FLY2QFOPcvrJDEtqYOtkVtBgxozf//4XyVa9a0gnrJOoCkkUMRGiOldTbAj7Xb9ESiPNMV6xFLQrYCwer8v4uN7JD/8J4Iz4ER1s5EkjaFdB4bzJKXego5hZohA6dGq1iPlztljpjBatcI4RXLU3j+IkqJjUcCJm9hoF1Lbl4Rb5TQvsDxIqW+eDDNdK4I03xa3CK2a+diTgqExAb2Uq/H6FAFM/etxot27TBf2+P4P5Sp5LcosPaLwKIHiReuE0eg9BODoED4bjTvoAUytyWeU+6AmKgc1U1zCXL5+coSaOHZB3H2XjmX6pZ9rUabp+b361P/s/V1J6fpHE2GbxPVTTk+le048Pzkn8Y7S+F84FMTdwc7VSg6SnksRqipRf/QPkNUEsDBBQAAAAIAFlhllwKQQzqvQAAAEcBAAApAAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHOFj8EKwjAMhu+C71Byt908iMg6D4rgVfQBQpdtxS0tbRV9e+ttA8FjyJ/vz1ftX+MgnhSidayhlAUIYuMay52G2/W02oKICbnBwTFpeFOEfb1cVBcaMOWj2FsfRaZw1NCn5HdKRdPTiFE6T5w3rQsjpjyGTnk0d+xIrYtio8KUAfWMKc6NhnBuShDXt8/N/9muba2hozOPkTj9qFDePl06YH7vSK1l+xXIfAwdJQ1STgI/s6XMOqDqSs306w9QSwMEFAAAAAgAWWGWXCgvTAumBQAArh0AAB4AAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWztWVtvm0gUfl9p/wPinWIwOLEVuyJ22EbKbqI2233GMMSjDgwahtRW1f++5wwYM9itkjRW0u0+xGEOw7l8c+b2nbO364wZ90SUlOdT03kzMA2Sxzyh+d3U/Ps2tE5No5RRnkSM52Rqbkhpvp39/ttZQe+5vI2WjCxISnMqQYEByvJyaq6kLCa2XcYrkkXlG16QHN6kXGSRhKa4s8tCkCgpV4TIjNnuYDCys4jmZq1hksUPUZJF4lNVWDHPikjSJWVUbpQu08jiyeVdzgX6NzXXYqt4LfYUZzQWvOSpfAOKbJ6mNCZ7/jmeLcg9RZRAlZhUNJmaX/xwHATz+cI6d/1zywsvQis4P3Et13V9Z+AswpHnfTWNPMrAiZsWMPAvjgCbS9DhAr5RUbDNX1W2JCKsMZqaMA5KfM5FckAc8lzu9b2JpCQi35MHjN7lGTnwxT80kat3hN6tdtoc00giGc2jAod0an6MWAWDblQFiEnycZsr4HhG8/ckFaRcIc7tmyGkzIp/XgjKmIqkKklQSV47JlVqgRXBP/8hILNuuYxYHXLMWV9EJcluBM3lLZWMQDf4Mobk6blC8wQCbJRAPsTa8wICUu+yiklaMBJSwpKQMsBLWZ6dMR5DEkEOC5JOzWA4CYKxaaRUlPIdpCoR7/lnpUKJUKESgDetYM4hXNc37Vk9O5SREoKq0LOhB1Z2ciNaUzCNv6AIQ995zSvJKM42MIdIBg2OCUkjCOBDtZSIWe04AtQacRqBscaX4IitXsP/neUf9YLmJRHynEX5py0Er9WxHjrDPjoIDkLlIFSqAQPVBHMk9I4AVTd18ioLM4krizPyTOMRmaRl7c+bnUfA93XM1CcuEE8b1maFueXFCy9C3Xz2H5XPR1wZX7lTHmwbj5j4vy5QzqifUq8m71/H+P3sXrjf3fCPcDb6z+4+v+Ae+GIH71e+veyvmsdFCm+j6ipV3/0696SnA6Wfih5i4ZGb6tOOXccF8v85/P3L84/tFs9yPn9hJR2WADgDIGh0CgO4jdlZilOx5RfalrpC71onWtPVWkPFTLR9R1pL/3Csa9U/dHo2dSvOUP/W05uKptn5qzuhf9rreqp/qbvo6i4Cvdc14+ouuj2UdBdd5YXdjoIakMsu2zPC483sbA3djv1ngx3aZUcMYFKRT0HD7cslkkLA7PVfgQAn19q4b7iWg0/PHMa3XW7d+JbjWgccAQX77Az4SX1GIN/WJpGlRtduO6n+2oCpFaaLGUU8usCgR6ihMdjuTC3DhypaaUMtG8YVl8bFWhJgQRNjzksJtCRumDBjjWVU1nynuspjC5Wrhr6BgvN7mm9iaVynmkqgrx+kEnZMhGMXAkBV09tbShQZ0VpkJOsUSauTLUcaAMWreOjrnG2Ur927iIL8hpeq6lDToEDbEgGlC6Jxoa0UWFqFgIsnCMXHgsq907paUIDp36ra8qboDTzXvvZ9xlmo2NV9n1m0JKyOAI4uzxOB54698egEfttQ2rmlEN/NrV0kj48Kl/pdVFv0wKbcFMBMLyspsRaiDdG3w+0dPXrj16x0h+FtaXMF79YRqDEcwxG1Arfj3DzAxN9Vuz7IDSOXecq7ZR0l/JMktMqgaICUPTDjddmgrligCMoDfRH0+iAFLbCu0XD90KsvuopKCeIqwwodOkjW8qqEPIT/RiVgDfkyHrkXob9wLH8euJYXj4fW6UXoWYvz0J8PfG84XrhQiaqra2vHe1oVbDC2x3WdDrLM8SYHa4ArmpC6ZrStDjRWYcnpFQYPlt7IOibdkiAOCATajfbEOwlGwG9bzqkfWN5gMbdOg8C3woHjO1h6W/hYd2vsFglUSh5iuV+UdEb1eahZJli0gRmMoYPGg7E7I+Mix1JYsi3RlFAcxZKNGt5WeJ0Dsdp504aIgaqRrQ33yquzfwFQSwMEFAAAAAgAWWGWXKBh8uEFBAAA4Q0AAA0AAAB4bC9zdHlsZXMueG1szVddj+I2FH2v1P9gZV4b8kFCCSWsBphIK21XVWcqVer0wSQOWGvHyDHTsFX/e6+dkIRZZoDRVCoP4M/jc++599pMP1ScoSciSyqK2PIGroVIkYqMFuvY+u0hsccWKhUuMsxEQWJrT0rrw+z776al2jNyvyFEIYAoytjaKLWdOE6ZbgjH5UBsSQEzuZAcK+jKtVNuJcFZqTdx5viuO3I4poVVI0x4egkIx/LLbmungm+xoivKqNobLAvxdPJxXQiJVwyoVl6AU1R5I+mjSh4OMaPfnMNpKkUpcjUAXEfkOU3Jt3QjJ3Jw2iEB8tuQvNBx/SPbK/lGpMCR5Ilq+azZtNjxhKsSpWJXqNjy2yFUz3zMQONRYKFalYXIwE/Zo805f7T3+0e02Uw4n5Sl5RzAjnaGxztvfri5cQeu6/70x68k+/PRbgf0fqdhM5vmouiTAk1Ag8mXQvxVJHoKSAFTvWo2Lb+iJ8xgxNUYqWBCIgURBUQ9wwpzUq9YYEZXkurBHHPK9vWwrwdMEDbrOIWQMITqE+rvlV71n59ljizhTMpYK0ugjYWB2RQiWBFZJNBBTfthvwVTC0i2mrJZd2b1WuK954eXbygFo5lmsV4YB8v1KraS5O72LkkMzKqZoEVGKgJRA0Gj6fQIX0ru+VmNmBCEiuogdQdhBJ/hOBr50dhzg/HVDIyXwMsrITMoZYfw10FVD82mjOQKDJB0vdG/Smy1lUIpSPfZNKN4LQrMtImHHU0DYFPC2L0ud7/nR9hV3ksOKJxaa51hugmEmmaNV3c0fh+txu7Das7X46Iqbw94abfXsfIt1GfV7kZ4u2V7nZI62ZoeWNKk3hFyU0bOWfwM+/OOr4hMTPU5jWpKzDujBheJcyXVKzG39Emo+Q4CTt+zOhIukHn4ulAvSnPaia+jPZfmdflfcOl7HnGlg03s3jK6LjipA3g2hRui7qKNkPQrxJW+IUwRMLlY5RfJAExO58szUWuXXcRB16OWgqkJUAV6peao0LQlA+nbL7Y+6/xh8A5psh6tdpRBNT1RZAAzq7qyNQanQP/sjXIo2od74MKiffJ+cMyB5uucHudWtl77Hy/soqsjeeb+fn9va5+D9Eq/hM3V1cYTxHJGcrxj6qGdjK2u/TPJ6I7DDdGs+kXXLQMRW127XhXpCCaV+lTCgwp+0U7S2Pr7bv5jtLxLfHvszsd2MCShHYXzpR0Gi/lymUSu7y7+6b3H3/bydfVr3Px9gBz2gknJ4M0uG2Mb8vfdWGz1Op90BTBF2AHafe6RP3JvQ8+1k6Hr2cEIj+3xaBjaSej5y1EwvwuTsMc9fBt3z3U8ryMfThTlhNHioNVBof4oiATdV4zQphglnO6/2exfUEsDBBQAAAAIAFlhllzCh9vyUQYAANcbAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1ZT2/bNhS/D9h3IHRvYye2Ewd1itixm61NGyRuhx5pmZbYUKJA0kl9G9rjgAHDumGXAbvtMGwr0AK7dJ8mW4etA/oV9khKthgzjdOm2L/mEIvUj+//e3ykrly9nzB0SISkPG0F1cuVAJE05EOaRq3gdr93aS1AUuF0iBlPSSuYEBlc3Xj/vSt4XcUkIQjWp3Idt4JYqWx9aUmGMI3lZZ6RFN6NuEiwgqGIloYCHwHdhC0tVyqNpQTTNEApToDsrdGIhgT1DUl4u4ouwU+1EmwUjLoMXqVK6omQiX3NhrirT64bHlQ1Wk5khwl0iFkrAP5DftQn91WAGJYKXrSCivkLljauLOH1fBFTp6wtreuZv3xdvmB4sGx4imgwZVrt1ZqrW1P6BsDUPK7b7Xa61Sk9A8BhCFpbWco0a721arugWQLZx3nanUq9UnPxJforc/Sb7Xa73sxlsUQNyD7W5vBrlUZtc9nBG5DF1+flb292Og0Hb0AW35jD91abjZqLN6CY0fRgDq39OfXMFDLibNsLXwP4WhEAMxREwzTSNIsRT9UicZfge1z0AGwcjRVNkZpkZIRDiPQOTgaCYq05Xie49MZOhXJuSvNFMhQ0U63gwwxD1szovXz2/ctnT9DLZ4+PHzw9fvDT8cOHxw9+tLSchds4jcoLX3z72Z9ff4z+ePLNi0df+PGyjP/1h09++flzPxCyaSbR8y8f//b08fOvPv39u0ce+KbAgzK8TxMi0U1yhPZ4Arp5JCcDcb4V/RhTZwWOgbaHdFfFDvDmBDMfrk1c490RUEh8wGvje46s+7EYK+rhfD1OHOAO56zNhdcA1zWvkoX74zTyMxfjMm4P40Mf7w5OHdd2xxlU0yIonajpxMQRc5fhVOGIpEQh/Y4fEOLR7i6ljl13aCi45COF7lLUxtRrkj4dOIE0W7RNE/DLxKczuNqxzc4d1ObMp/UWOXSRkBCYeYTvE+aY8RoeK5z4SPZxwsoGv4FV7BNyfyLCMq4rFXg6Ioyj7pBI6VtzS4C+Jadfx1C7vG7fYZPERQpFD3w0b2DOy8gtftCJcZJ5ZaZpXMZ+IA8gRDHa5coH3+Fuhugx+AGnp7r7DiWOu88uBLdp5Ig0CxD9Ziw8vrxGuJuPEzbCxFQZKO9OpU5o+qqyzSjU7Xdlu9jHNmET8yXP9olifRruX1iit/A43SWQFfNb1LsK/a5CB//5Cn1aLl98XZ6VYqjSs77bNLXJQk34iDK2ryaM3JCmD5ewGQ17MGkG5vQ4PaBlMTzmW4KDiwQ2a5Dg6iOq4v0YZ9DDV82xNJI56UiijEs4R5ppL21zjKXQxptTaL04bwIaqx0+tNMr5XPolIzZqCJz7i0YrWgCizJbWc0Pt6/JrGqlWlC1qhHNFEhHtanKoMy8akbD3JrQ5SDojcDKDTjQa2pw9sGMDLXd7bZduMXY5CJdJGM8JLmPtN7zilSNk4pYKcLI4yN9pjzDaiVuTU32Dbgt4qQyu9op7ArvvYmXCuvMvKRz+EQ6srScnCxFR62gWV+uByjEWSsYwbEZHpMMvC51Y4lZBPdToRI2EM9MZoOaebPpD8sq3Iqc4k2HRSak2sIytqFhXhXXNKk55Bv5l+tg1otSwEb6a0ixsgbB8LdJATK7riWjEQlV2dmlGXMHYgB58vOxImI/Hh6hARuLPQzu16EK+gyphNsPUxH0AK7ttLXNyC3OedKVL8sMzs5jlsU4L7c6RYtMtnBj86kMZlQSbzoy2sxkPzFcVBWT8hekSjmM/2eq6P0EriNWhub2DG6TBUY6X1sBFyrmUIWymIY9AZdoJgIgWuDqF16D8eFO2/wKcqh/bc5ZGiat4VSp9miEBIX9SMWCkF0oSyb6ziBWzfcuS7IgZHN6Jq7MrNgDckhYX9eQht7bAxQX1SQvAwZ3Mv7ccR52g0g3LP/Uzscm83nbg1nnY9cv2IvUSkW/tBU030yEc261tmLNabxcX3irzeBSCel/sP9RETJi9Ncbap/vQelE044SQVRfso0H0gXSPg2gcbKTNpg0qbfbRs063Snft9h8lrb5aXPmsnNy8dXd5/mMnVvYsXW50/WYGhxwMkV1e1QcaoxjzJe18gcvPrgHjt6CTwhjpqT9dHAfrhBhy7IfJCD5rXPN0o2/AFBLAwQUAAAACABZYZZco0DrwxMDAAD8BgAADwAAAHhsL3dvcmtib29rLnhtbKVVXU/bMBR9n7T/4FlIG9LaxG4aIGqKgLYCiUE1CjwiN3GpRRJHttMPIf77rhNSUrpJiKVtUvva5557fOz0jldpghZcaSGzEJO2ixHPIhmL7DHEt5NR6xAjbVgWs0RmPMRrrvFx/+uX3lKqp6mUTwgAMh3iuTF54Dg6mvOU6bbMeQaRmVQpM9BUj47OFWexnnNu0sShrus7KRMZrhAC9REMOZuJiA9kVKQ8MxWI4gkzQF/PRa5rtDT6CFzK1FORtyKZ5gAxFYkw6xIUozQKLh4zqdg0gbJXpItWCr4+/IgLN1pngtBOqlRESmo5M22AdirSO/UT1yFkS4LVrgYfQ/JAhIWwa7hhpfxPsrKCVligQrU0tuT/RiNgrRqOfhKtu+FGcb83Ewm/q6yLWJ5fsdSuVIJRwrQZxsLwOMQH0JRL/tbhYaSK/LQQCUTpkUuPsNPf2HmsEMAarsZKLFi0hj2B0VzEfCwW0owET+JLoU3ZHfMZKxIzAcfXPKCfepT6FnKlglrJsVEI/l8MLoHZDVsAT1AjfrXxBRAhnYcsUgF5eO50Dv0jl7gt3+8etLzhgdc67VDSooQMT7tnwyN/1H0BKZUfRJIVZv4qgYUOsQf17oR+sVUdIW5QiPiNxrP7erXs892tjr3YcuxmvxN8qd/Esk20uhdZLJchbhEKRa23m8syeC9iMw8xVObBkKrvnIvHOTCmoBh0ssiIBZ+waSkt7C/LM8Rb/AYVvxFc5W2Ln9MgWB4yQLR8oqw0xo0sVMTRgBkGR5oNlLqDGwKbSF3ExJbZnHIpDTqT2qABN0wkGv3muVSmMb3TmE7fTx8zBZnBS3AqbRLCubFJ2LEznJos2ElkPLY2BuqN1msBD6skS9sPo9Ketowp09y6O2LJTV0PKAlujbk9zHH/e6Po79/2TvZIsHdyvkd6TgP+b7mqeaVW/evR6GY4+bGL9dOFz9n17dXkZCcKefb/EQMOZH//HYUmIageSopgK9pHuUqUgv2tWrndhmcM3jIw6q0BI6HLDqXwwtoI7JUCb81x6hdX/w9QSwMEFAAAAAgAWWGWXMihuPq4AAAANAEAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc4WPwQrCMBBE74L/EPZu0noQkaa9iOBV6ges6bYNtknIRtG/N8cKgrfZHfbNTtW85kk8KbL1TkMpCxDkjO+sGzRc29NmD4ITug4n70jDmxiaer2qLjRhykc82sAiUxxrGFMKB6XYjDQjSx/IZaf3ccaUxziogOaOA6ltUexUXDKg/mKKc6chnrsSRPsOOfk/2/e9NXT05jGTSz8iVLBPn1q8TZSpGAdKGqRcrHmhS5l/B1VX6qtr/QFQSwMEFAAAAAgAWWGWXIHctdzzAwAAjg4AABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWydl1tvpDYUx98r9TsgHvoWwGbIXDozq21GUVbaVaOml2cPeGasAKa2J7dVv3uPDQeI0kp4ogk+YPj7+Phn+3j96aUqgyeutJD1JiRREga8zmUh6uMm/OP326tFGGjD6oKVsuab8JXr8NP2xx/Wz1I96hPnJgCFWm/CkzHNKo51fuIV05FseA01B6kqZuBWHWPdKM4K91FVxjRJruOKiTpsFVZqioY8HETOdzI/V7w2rYjiJTPgvz6JRqNalU+Rq5h6PDdXuawakNiLUphXJxoGVb76cqylYvsS+v1CZiwPXhT8KPyn2Ix7/qGlSuRKankwESjHrc8fu7+MlzHLe6WP/Z8kQ2YQgCdhB3CQope5RLJeiw5i6YVidmRax2y41Oosik34Pen+rqAk9pIMF6z7J9yuCwEjbD8OFD9sws9k9fkuDePt2gH0p+DPemQHlse9lI+24gu0k4BEw2oevD40MKrAdhgY2XzlB3PDyxIEoYcsN+KJ38Nrm3AvjZGVrXfEG3h0UPKN165NXnJ4F5yxmu9fbkUGUf136zC1H8a9t2MbPb91s+NeBQU/sHNpbmT5lyjMCbwl0Yxm8wWhWYi1v8nnOy6OJ9sZGs2hwtG3Kl53XOcwHaDXkWs1lyU0AdegEnZaA83sxZXPnXwa0UVGsmsrv+fa3HYhys8aooBOdFqtCsTLqUA5qMxJskytKxNFgAQnAiWKgM++rsw6FShRhUSLLJtdLzx8Aa+dL1B2KpREvh2yK4UVgRJdmXmLzDsRKDuRpX9QYKV2nkDZiaSpf1CWnQqU2J+5vwqBfaRFDoxBJ5snqSN6Ii2kJ3eELonILPEBlyC51kBnLggwQXitgTogObUzSC15h613TBBbMnBLstFqMdUdJJeM0L1gFhGE1xr9FJgeFcSWDNzOvUcYqSUjbGe+KhShtUbXk2t/9ilCa41OZrbwHyDaL7gjbL3hpwitNXpoI1/qKMJrjX6NGraoidDZud9uIiN4wbGpnyOzdMTs3L8ziCwdIXsB+hTZtQaO9AULC0V8rTGMkecylyK+1kCVzHsvShFfa+C+SH3nUorwWqNPFyYPdNrnCQO1S+9xThFaawy70LS4xm0S5fK3HTMM87fWZmcjb0VpuBqlpxCw/0xzl/+b5kKu1rAj/8bUUdQ6KCH7tEkcYKnaRM/ZkLc6y26cLkvFuxOcpzicG5IIwnSQEtxpbzrdB27ODaSsDVcP4g3yVuBLKgGpojswbcISTnY6h/owOEHFm4SactcImz/bY6EReX8Pmm17t66h7VoWxZ17sP2JVc3PN7/efwt+YSY/BV+lCW6kNsGOGyZKvY6Hd9fxe5W4P0lu/wVQSwMEFAAAAAgAWWGWXOcpNPiDBQAAqRgAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWylWVlzskgUfZ+q+Q8U74qNu6V+RVyiSUxM4pL4htgq9Yk4QLaamv8+t2kb4Up6MFOVBDz39OnuuzWY5q9PZ6e8U8+33X1LJfmCqtC95a7s/aalTif9XE1V/MDcr8ydu6ct9Yv66q/2n380P1zvt7+lNFBAYe+31G0QHBqa5ltb6ph+3j3QPVjWrueYAXz0Npp/8Ki5Cgc5O00vFCqaY9p7lSs0vCwa7nptW7TrWm8O3QdcxKM7M4D1+1v74As1x8oi55je77dDznKdA0gs7Z0dfIWiquJYjeFm73rmcgf7/iQl01I+PfjR4bcopgnxs5kc2/Jc310HeVDW+JrPt1/X6pppRUrn+88kQ0rggHebBfAkpf9sSaQcaeknseIPxVhk+MKYu7zGm71qqX9f6Z1+rVIzckan08+VqoTkruqdQo6U9Z6u1wr9crH3j9purmyIMBuseHTdUo1iwzDqqtZuhgk0s+mHH7tXAnP5THfUCihMQlSF5efSdX8z4hCgAkj6IYFJmnB5px2624FyCVL8Lz5JiU2gRTPE78Vs/TCjx56yomvzbRc8uR8Dam+2AUyr56tl2CrLicbqq0t9C5IU5s7rTNdydyACfxXHZsUGOWZ+8sXaq2Abjq+Vy6VKjaksqR/0baaqKtabH7jO/Mg6anEViFOoAlehUszrtTIpV/TsKhCgUAWuR5VqnpQKocTWXq0oX69kHeDEUAGuYh3QSzJuAmYJB8NVDC5fOD+rWCYBVyFRiyQk664ex8H15D+x9YzLhx4Zzg1XoVHNl/RytUYuiEFd5AP47bSFixOCRHkVSyySL1cLxUtWQ0RikVNOkNLl+UlEYpBYcIuXL0fEl8QCVbrcyUTEit2cAl4lhXrxgqojUbDgJsr3/KUyOoSaV28s5uRyGRFyPdFLLg25HvWSWDOpXt5MdNFN2E1UEJmbgS4yht38n84ougqrwVNbiWIka6oi2/RYO6n8wBOiu+ixrP3PtqjxgyI8hbpmYLabnvuhwOMBuNM/mOxhizSYYupBAycM4xqMHHZUOEJ8OPze24Wm9g4nmnVkXJ0zSJLROWfoSUb3nFFMMnrnjFKS0T9nlJOM63NGJckYnDOqScbwnFFLMm7OGfUk4zbFY8ipdykU5NVRCgW59T6Fgvz6kEJBjh2nUJBnH1MoyLVPKRTk2+cUCnLuJIWCvDtNyTbk3VkKBXl3nkJB3n3hFAKFGNWGjtz7msZB/l1wDpwAJxnkX+NYhgnOycEaFHZU3ewxNHN1A/k0KQrHVSksd1zMqWg3Fe0l5FEo+7K5r2XGgcw4ZPtnPS6lVd1IbLfcdtxHAdejZORIYrtPLBVl6oPMOI4bi2g5jwkjitBTwoiS9lnmu4nMOJWtdiYbOU8sCFXIi8R7rxLbQmIzwncxEcyT7xJ1Akda5jrpMnL4UhBVSxFVcU9Q2BsaOzn7GLjGwAADQwzcYOAWA3cYGGHgHgMPGBhj4BEDTxh4xsAEA1MMzDAwx8ALBl4xsOBANa24DYMba8iYCDpEMHPQF4zMOomIqGFwhL/dx3suPERllu3w1eMnoFS0B8KnjEOHQj9u1FHzvpYZBzLjkG3muwYqsd1y23cNVDJyJLHdJ5aKG6jMOE74DjfQhBE30IQRN1CZ7yYy41S22pls5DyxINxAJd57ldgWEpthxIP5TQNlX+lmfdDoMjJqoOgBsScoUQPFwDUGBhgYYuAGA7cYuMPACAP3GHjAwBgDjxh4wsAzBiYYmGJghoE5Bl4w8IqBBQe+aaDcKG2g8ASaOegLRk42UI7EGij/kpS/nh7MDR2Z3sbe+8qOrsNvPCEPPf6taHgfuIfwDlr90g3gy0zxaQv/EqBw6hby8DS9dt1AfGCtOvonQ/tfUEsBAhQAFAAAAAgAWWGWXJDvHNaaAQAAbQcAABMAAAAAAAAAAAAgALaBAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECFAAUAAAACABZYZZctVUwI+4AAABMAgAACwAAAAAAAAAAACAAtoHLAQAAX3JlbHMvLnJlbHNQSwECFAAUAAAACABZYZZcD2chwKEBAABmAwAAEAAAAAAAAAAAACAAtoHiAgAAZG9jUHJvcHMvYXBwLnhtbFBLAQIUABQAAAAIAFlhllw6yRyaNwEAAFECAAARAAAAAAAAAAAAIAC2gbEEAABkb2NQcm9wcy9jb3JlLnhtbFBLAQIUABQAAAAIAFlhllxNQdbSGgEAAHsEAAAaAAAAAAAAAAAAIAC2gRcGAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQIUABQAAAAIAFlhllziK397uwAAADMBAAAyAAAAAAAAAAAAIAC2gWkHAAB4bC9waXZvdENhY2hlL19yZWxzL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWwucmVsc1BLAQIUABQAAAAIAFlhllzPpU5xewQAAMgYAAAnAAAAAAAAAAAAIAC2gXQIAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWxQSwECFAAUAAAACABZYZZcxqqZj0IBAABUBAAAJAAAAAAAAAAAACAAtoE0DQAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1sUEsBAhQAFAAAAAgAWWGWXApBDOq9AAAARwEAACkAAAAAAAAAAAAgALaBuA4AAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzUEsBAhQAFAAAAAgAWWGWXCgvTAumBQAArh0AAB4AAAAAAAAAAAAgALaBvA8AAHhsL3Bpdm90VGFibGVzL3Bpdm90VGFibGUxLnhtbFBLAQIUABQAAAAIAFlhllygYfLhBQQAAOENAAANAAAAAAAAAAAAIAC2gZ4VAAB4bC9zdHlsZXMueG1sUEsBAhQAFAAAAAgAWWGWXMKH2/JRBgAA1xsAABMAAAAAAAAAAAAgALaBzhkAAHhsL3RoZW1lL3RoZW1lMS54bWxQSwECFAAUAAAACABZYZZco0DrwxMDAAD8BgAADwAAAAAAAAAAACAAtoFQIAAAeGwvd29ya2Jvb2sueG1sUEsBAhQAFAAAAAgAWWGWXMihuPq4AAAANAEAACMAAAAAAAAAAAAgALaBkCMAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzUEsBAhQAFAAAAAgAWWGWXIHctdzzAwAAjg4AABgAAAAAAAAAAAAgALaBiSQAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLAQIUABQAAAAIAFlhllznKTT4gwUAAKkYAAAYAAAAAAAAAAAAIAC2gbIoAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWxQSwUGAAAAABAAEAB/BAAAay4AAAAA
</FILE_DATA>
    <DATA_SHEET_FILE_NAME>xl/worksheets/sheet1.xml</DATA_SHEET_FILE_NAME>
    <PARAMETER_SHEET_FILE_NAME>xl/worksheets/sheet3.xml</PARAMETER_SHEET_FILE_NAME>
    <COLUMN_HEADER_ROW_NUM>1</COLUMN_HEADER_ROW_NUM>
    <TEMPLATE_SHARED_STRINGS>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>0</STRING_ID>
      <STRING>Organization</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>1</STRING_ID>
      <STRING>Top Batch No</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>2</STRING_ID>
      <STRING>Level</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>3</STRING_ID>
      <STRING>Batch No</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>4</STRING_ID>
      <STRING>Sort Order</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>5</STRING_ID>
      <STRING>Product</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>6</STRING_ID>
      <STRING>Product Desc</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>7</STRING_ID>
      <STRING>Batch Lot Number</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>8</STRING_ID>
      <STRING>Batch Size</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>9</STRING_ID>
      <STRING>Batch Actual Output</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>10</STRING_ID>
      <STRING>Batch Yield</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>11</STRING_ID>
      <STRING>Batch Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>12</STRING_ID>
      <STRING>Batch Unit Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>13</STRING_ID>
      <STRING>Batch Uom</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>14</STRING_ID>
      <STRING>Primary UOM</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>15</STRING_ID>
      <STRING>Batch Type</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>16</STRING_ID>
      <STRING>Currency Code</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>17</STRING_ID>
      <STRING>Material Type</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>18</STRING_ID>
      <STRING>Item</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>19</STRING_ID>
      <STRING>Item Desc</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>20</STRING_ID>
      <STRING>Detail Uom</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>21</STRING_ID>
      <STRING>Lot Number</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>22</STRING_ID>
      <STRING>Lot Source</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>23</STRING_ID>
      <STRING>Lot Quantity</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>24</STRING_ID>
      <STRING>Lot Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>25</STRING_ID>
      <STRING>  Lot Extended Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>26</STRING_ID>
      <STRING> Pct Of Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>27</STRING_ID>
      <STRING>NA</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>28</STRING_ID>
      <STRING>00000010000001</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>29</STRING_ID>
      <STRING>EA</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>30</STRING_ID>
      <STRING>(blank)</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>31</STRING_ID>
      <STRING>USD</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>32</STRING_ID>
      <STRING>Ingredient</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>33</STRING_ID>
      <STRING>PRODUCTION BATCH</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>34</STRING_ID>
      <STRING>1 Total</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>35</STRING_ID>
      <STRING>00000010000002</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>36</STRING_ID>
      <STRING>2 Total</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>A1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AA</CELL_IDENTIFIER>
      <STYLE_ID>4</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AA1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AB1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AC1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AD1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AE1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AF1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AG1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AH1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>B1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>C1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>D1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>E</CELL_IDENTIFIER>
      <STYLE_ID>2</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>E1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>F1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>G1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>H1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>I1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>J1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>K</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>K1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>L</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>L1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>M</CELL_IDENTIFIER>
      <STYLE_ID>4</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>M1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>N</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>N1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>O</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>O1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>P1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Q1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>R1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>S1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>T1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>U1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>V1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>W1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>X</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>X1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Y</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Y1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Z</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Z1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A11</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A12</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A13</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A14</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A15</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A2</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A3</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A4</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A5</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A6</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A7</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A8</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A9</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>B3</CELL_IDENTIFIER>
      <STYLE_ID>2</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
    </TEMPLATE_STYLES>
    <TEMPLATE_SHARING>
     <TEMPLATE_SHARING_ROW>
      <SHARING_LEVEL>S</SHARING_LEVEL>
      <LEVEL_VALUE>Site</LEVEL_VALUE>
     </TEMPLATE_SHARING_ROW>
    </TEMPLATE_SHARING>
    <PARAMETER_EXCLUSION>
    </PARAMETER_EXCLUSION>
   </TEMPLATES_ROW>
   <TEMPLATES_ROW>
    <TEMPLATE_NAME>Detail Pivot</TEMPLATE_NAME>
    <OWNER>ERIC.CLEGG</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_ACTUAL_OUTPUT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_COMPLETION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>33</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_ID</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_LOT_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_NO</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_SIZE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_UNIT_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_UOM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>BATCH_YIELD</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CURRENCY_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>29</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DETAIL_UOM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_DESC</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>26</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_EXTENDED_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_QUANTITY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>28</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_SOURCE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Level</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>34</DISPLAY_SEQUENCE>
      <COLUMN_NAME>MATERIAL_DETAIL_ID</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>MATERIAL_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>27</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PCT_OF_COST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRIMARY_UOM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRODUCT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRODUCT_DESC</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRODUCT_ITEM_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>31</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SORT_ORDER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>32</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TOP_BATCH_ID</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TOP_BATCH_NO</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
      <COLUMN_NAME>UOM_CONV_ERROR</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
    </TEMPLATE_PIVOT>
    <FILE_NAME>OPM Batch Lot Cost Details Template 20250804.xlsx</FILE_NAME>
    <FILE_LANGUAGE>US</FILE_LANGUAGE>
    <FILE_DATA>UEsDBBQAAAAIAFlhllyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAFlhlly1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAFlhllwPZyHAoQEAAGYDAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TwW7bMAyG7wP2DoLujdxmKIZAVjEkG3rosGBxuzMn07FQWTIkxkj29JNtxHHWnnYj+f+iPomSfDg2lnUYovEu57eLjDN02pfG7XP+XHy7+cxZJHAlWO8w5yeM/EF9/CC3wbcYyGBkqYWLOa+J2pUQUdfYQFwk2SWl8qEBSmnYC19VRuPG60ODjsRdlt0LPBK6EsubdmrIx46rjv63ael1zxdfilObgJUsPIEtTIMqk+KSyC9ta40GSqdX340OPvqK2NejRivFXJSJeof6EAyd+h7zVO40WFynDVUFNqIUl4J8ROgvcwsmRCU7WnWoyQcWzZ90nXec/YaIPWbOOwgGHCXc3jYmQ2zbSEH98uE11ogUpZiKQzj3zmPzSS0HQwqujcOqASQJ14iFIYvxR7WFQO8QL+fEA9jIOzLu/CFoZBsgmENO+pMntvaR2AYJjI3sJ7Y+0LveBAANUnqbb857Jv+H9cm41/jcFj7tj+dZXBflroaAZRrfNKupIB/TGILtm6xrcHssz563Qv9yXsZvo27vF9kyS49iVpPi8kHUX1BLAwQUAAAACABZYZZcL49i6ToBAABRAgAAEQAAAGRvY1Byb3BzL2NvcmUueG1sjZJRS8MwFIXfBf9DyXubpNUxQ9uByp4cCFYU30JytxWbNCTRbv/etN26DfYg5OXec+6Xk0vyxU410S9YV7e6QDQhKAItWlnrTYHeq2U8R5HzXEvetBoKtAeHFuXtTS4ME62FV9sasL4GFwWSdkyYAm29NwxjJ7aguEuCQwdx3VrFfSjtBhsuvvkGcErIDCvwXHLPcQ+MzUREB6QUE9L82GYASIGhAQXaO0wTik9eD1a5qwODcuZUtd+b8KZD3HO2FKM4uXeunoxd1yVdNsQI+Sn+XL28DU+Na93vSgAqcymYsMB9a8s8pD0VYXENd34VdryuQT7ug36lJ8UQd5wDGYUAbIx7VD6yp+dqicqUpPcxmceEVoSycLLsq7/yYr4PNDbU4eJ/EOlDlVJ2N2MpOSMeAWPuy09Q/gFQSwMEFAAAAAgAWWGWXE1B1tIaAQAAewQAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72UwUrEMBCG74LvEOZu03Z1Fdl0Dy7CXnV9gNBO27BtEjJxtW9vrNBaWOoeipfAzCT//zHMZLP9bBt2QkfKaAFJFANDnZtC6UrA2+H55gEYeakL2RiNAjok2GbXV5sXbKQPj6hWllhQ0SSg9t4+ck55ja2kyFjUoVIa10ofQldxK/OjrJCncbzm7rcGZBNNti8EuH2xAnbobHD+W9uUpcpxZ/L3FrU/Y8E/jDtSjeiDqHQVegFDinhfWUWBGPh5mPslYaiWDotX70KvaQSapOdg0iVhLuhMOgeT/DNMMgezXhKGfNeEoR8G5iees79b0t6HVcLRvQ95f8624HZJBqtOxj/JsNU7LJVW33s/Io1Vfu7igMknX0b2BVBLAwQUAAAACABZYZZc4it/e7sAAAAzAQAAMgAAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzhY/BasMwEETvhf6D2HstO4dQiuUcEgK5BucDFmlti9haoVVC/PfRMaGFHodh3sy0u8cyqzsl8RwMNFUNioJl58No4NIfv75BScbgcOZABlYS2HWfH+2ZZswlJJOPogoliIEp5/ijtdiJFpSKI4XiDJwWzEWmUUe0VxxJb+p6q9MrA7o3pjo5A+nkGlD9Gkvz/2weBm/pwPa2UMh/VOjo75z3WOadyXJyUuCYRsoGfllNVaaD7lr9drV7AlBLAwQUAAAACABZYZZc7e0eb3kEAADHGAAAJwAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbN1ZbY/iNhD+Xqn/wcr3LAmElyDgxKuKxC7bA07qR29iwNrYRo5D4ar77x07gYVjbyHXQreLEBDbmpln5vF4PDQ+bViE1kTGVPCm5d45FiI8ECHli6Y1mw7smoVihXmII8FJ09qS2PrU+vWXxoquheriYEl6ZE45VSAAgTAeN62lUqt6oRDDJMPxnVgRDjNzIRlW8CgXhXglCQ7jJSGKRYWi41QKDFNupRLq8hIZYj6nAemJIGGEq1SIJBHWlsRLuop30lhwiTiG5XOysgPBViDiiUZUbY1QC7GgPlxwIfFTBC7YyJ3gzamdjAZSxGKu7kBQITXxBK3rgaFrqn1uIVmnYdOSw9CF32QuSbwc85HAMPgyQsLOtmm1E7UUoD1bRsIeVmCQV67V/DvP8Wrlsu8UqxAyRuMYQjhUhMUjyqhqWhDZAJyuSPhlF25YuBd1OMgo/5xaohHvZ0p6eSBk2BUJB4lF8IOsJ9r8v8rlgdOtdEp2r+zWbK/Sqdp+r9u1+6VBuVoeDNq9SvWb1WoEmjETkciAILVdgfV/CvlsiACz+9/ZCo4ZrEgfACu2Cq1G4UBEJm9ASRTGKEjNKnk7PWYcpULGcoE5/WrYYSGesAFTQ7DcgcWAU5LQOGsnxNXDaN20HtpG6cGSnQlG+qEFmaapWKEOVsESPYi3NXEFnI8nhNF7uiHhFPwBu0cHSmRTSpqNeDD0kLAnArwDbuxWDbkii2wMQvcFRwkAhgUMb14eMu9oYFwDc/Piem+YgH4ZpuIRJoOu+HPodAguidmD4OneeztYnQjz5yxWhpva+ywnn1K/dyEvRcRkWa350Ei3ohl/TOKz1HoNQQrpgFmTF/4BsbLpmu/bbtEuuVPHqZu3YVo26zuO7bjwfpndb9of7ZhuIiWcOlsAGZ5x/96LZnPOJr28cX6UIkwCdd0UkClBPRIHt9Gkkxe6FnvPBjCl6EgolKan62JOtU3o1+92QTn/Ljgg+C6bXpxgU9pnCdbkgT05TQpy8lIzxdUOVIIjNE7UKjmiqVv5GAD/0OfmIUO80zP4bPr6J4Fzs4y1Oxv148npCIM/mafjDxm1GZT4kJ8/KDjB8qSsfu6a8FFSuF9s0Wx8f11FI7Im0SUVzC2qzn+3QruH6kRSSI3nj7njKmHIF1DeU7gk5t3S+lTNE6/8lwVzbl+/TPhvy4NbFQZaz8dLURrV7wnmChoSx2X//70e0Mj6G0V4SMJ3F7izRe9joNB4fmL3rauZ78rQs2Zrp6cdlTyZ7fHzuDfrTofjB9RpT7u/5c2kPQK9jgjNrn3QggKICF+jvpS6VfZWoyctMvNe5c86eCIkEEOGF12DdOvCXGUd84LS1Hxp954O525qvLSihkcV960L7uNW1FkPpheh92Ny6nfTd/xRC2NfnGREf8/GHyCJWw2yUaNYmW+USAq93Gqx3O4X233b93zX9mpPxO4UO57t9Tt+1Rt0S07N+7bvgbveSXf9oia44xf8tOnfamxcr/7aHwra7WBX+mmsLLy2rPU3UEsDBBQAAAAIAFlhllzGqpmPQgEAAFQEAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1szZRBasMwEEX3hd5BzN6R7ZaSGttZtBS6LekBFFmORS2NkBTj3L6yQxLamDrZFbQYMaM3//+F8lWvWtIJ6yTqApJFDERojpXU2wI+12/REojzTFesRS0K2AsHq/L+LjeyQ//CeCM+BEdbORJI2hXQeG8ySl3oKOYWaIQOnRqtYj5c7ZY6YwWrXCOEVy1N4/iJKiY1HAiZvYaBdS25eEW+U0L7A8SKlvngwzXSuCNN8WtwitmvnYk4KhMQG9lKvx+hQBTP3rcaLdu0wX9vj+D+UqeS3KLD2i8CiB4kXrhNHoPQTg6BA+G4076AFMrclnlPugJioHNVNcwly+fnKEmjh2Qdx9l45l+qWfa1Gm6fm9+tT/7P1dSen6RxNhm8T1U05PpXtOPD85J/GO0vhfOBTE3cHO1UoOkp5LEaoqUX/0D5DVBLAwQUAAAACABZYZZcCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIAFlhllzQXsRRnwUAALAdAAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Vlbb5tIFH5faf8D4p1iMDh2FLsidthGym6iJtt9xjDEow4MGobUVtX/vucMGDPYqZK0VtPtPsRhDsO5fHPm9p2zt+uMGQ9ElJTnU9N5MzANksc8ofn91Pz7LrTGplHKKE8ixnMyNTekNN/Ofv/trKAPXN5FS0YWJKU5laDAAGV5OTVXUhantl3GK5JF5RtekBzepFxkkYSmuLfLQpAoKVeEyIzZ7mAwsrOI5mat4TSLn6Iki8THqrBinhWRpEvKqNwoXaaRxaeX9zkX6N/UXIut4rXYU5zRWPCSp/INKLJ5mtKY7PnneLYgDxRRAlXitKLJ1Pzsh5MgmM8X1rnrn1teeBFawfmJa7mu6zsDZxGOPO+LaeRRBk7ctICBf3EE2FyCjsmJaURFwTZ/VdmSiLDGaGrCOCjxORfJAXHIc7nX9yaSkoh8Tx4wep9n5MAX/9BErt4Rer/aaXNMI4lkNI8KHNKp+SFiFQy6URUgJsmHba5AYmQ0f09SQcoV4ty+GULKrPinhaCMqUiqkgSV5LVjUqUWWBH80x8CMuuOy4jVIcec9UVUkuxG0FzeUckIdIMvY0ienis0TyDARgnkQ6w9LyAg9S6rmKQFIyElLAkpA7yU5dkZ4zEkEeSwIOnUDIanQTAxjZSKUr6DVCXiPf+kVCgRKlQC8KYVzDmE6/qmPatnhzJSQlAVejb0wMpObkRrCqbxFxRh6DuveSUZxdkG5hDJoMExIWkEAdxWS4mY1Y4jQK0RpxEYa3wJjtjqNfzfWf5WL2heEiHPWZR/3ELwWh3roTPso4PgIFQOQqUaMFBNMEdC7whQdVMnr7Iwk7iyOCPPNJ6RSVrW/rzZeQR8X8dMfeEC8bJhbVaYO1784EWom8/+s/L5iCvjK3fKg23jGRP/1wXKGfVT6tXk/esYv5/dC/erG/4Rzkb/2d3nF9wDf9jB+5VvL/ur5nGRwtuoukrVd7/OPenlQOmnoqdYeOam+rJj13GB/H8Of/3y/G27xXc5n/9gJR2WADgDIGh0CgO4jdlZilOx5RfalrpC71onWtPVWkPFTLR9R1prorV0NY7+odOzqVtxhrpHnt5UNM3OX90J/dNe17H+pe6wq7vo6p1d3UW3h5Luoqu8sNtRUANy2WV7Rni8mZ2todux/2ywQ7vsiAFMKvIpaLh9uURSCJi9/isQ4ORaGw8N13Lw6TuH8bjLrRuPOa51wBFQsM/OgJ/UZwTybW0SWWp07baT6q8NmFphuphRxKMLDHqEGhqD7c7UMnyoopU21LJhXHFpXKwlARY0Mea8lEBL4oYJM9ZYRmXNd6qrPLZQuWroGyg4v6f5JpbGdaqpBPr6SSphx0Q4diEAVDW9vaVEkRGtRUayThVphWgoqjIAjlcR0dc52yhnu5cRhfkNL1XZoeZBgbclAmoXRCNDWynQtAoCF48QipAFlXvHdbWiANW/VbUlTtEbeK6d3XMazT/iNIuWhNUhwOHl+4TguRNvMjqB3zaWdnYpzHezaxfK88OaaFFt4QObclMAN72spMRqiDZGj4fbO3z0BrBZ6w7jOz7oCFQZjuGIWoPbgW4eYOrv6l23csPIZZ7ybmFHCf8kCa0yKBsgaQ/ceF04qGsWKIICQV8EvW6loAVWNhq2H3r1RVdRKUFcZVijQwfJWl6VkIjw36gErCKfJyP3IvQXjuXPA9fy4snQGl+EnrU4D/35wPeGk4ULtai6vrZ2vJfVwQYTe1JX6iDLHO/0YBVwRRNSV4229YHGKiw6vdLgweIbWcekWxTEAYFAu9GeeCfBCBhuyxn7geUNFnNrHAS+FQ4c38Hi28LHyltjt0igVvIUy/2ypDOqT0TNOsGiDcxgDB00HozdGRkXORbDkm2RpoTyKBZt1PC2wuscqNXOmzZEDFSNbG24V2Cd/QtQSwMEFAAAAAgAWWGWXJer4F0PBAAA1A4AAA0AAAB4bC9zdHlsZXMueG1s3VfbbuM2EH0v0H8glNfKulhyLdfyIr4IWGC7KJoUKND0gZYom1hSFCg6lbfov3dIybacdeJLt31oHhxyRB6emTMzlMbvas7QM5EVFUVseT3XQqRIRUaLVWz98pjYQwtVChcZZqIgsbUllfVu8u0340ptGXlYE6IQQBRVbK2VKkeOU6VrwnHVEyUp4EkuJMcKpnLlVKUkOKv0Js4c33UHDse0sBqEEU8vAeFYftqUdip4iRVdUkbV1mBZiKej96tCSLxkQLX2Apyi2htIH9Vyd4ixfnEOp6kUlchVD3Adkec0JV/SjZzIwekBCZBvQ/JCx/WPfK/ljUiBI8kz1fJZk3Gx4QlXFUrFplCx5e9NqHnyPgONB4GFGlVmIoM4ZU825/zJ3m6f0Ho94nxUVZazAzvaGR7vvPvu7s7tua77w28/k+z3J3tv0Pudls1knIuiSwo0AQ1GnwrxR5HoR0AKmOpVk3H1GT1jBhZXY6SCCYkUZBQQ9QwrzEmzYoYZXUqqjTnmlG0bs68NJgnbdZxCShhCzQnN71Kv+tfPMkdWcCZlbC9LoJ0Fw2QMGayILBKYoHb8uC3B1QKKraFs1p1ZvZJ46/nh5RsqwWimWaxmJsBytYytJFncL5LEwCzbB7TISE0gayBpNJ0O4UvJvTyrFROSUFGdpG4vjOCvP4wGfjT03GB4NQMTJYjyUsgMWtku/XVSNabJmJFcgQOSrtb6vxKl9lIoBeU+GWcUr0SBmXZxt6MdAGxKGHvQ7e7X/Ai7zjvFAY1Ta60rTA+BUDts8JqJxu+iNdhdWM35elxU5/sDXtvtHVj5Fuqy2u9GuCzZVpekLrZ2Bp60pXeE3LaRcx6/wP644UsiE9N9TqOaFvOVUYOLxLmS6pWYJX0WarqBhNP3rM6EC2Tuvy3Uq9KcDuLbaC+leVv+V0L6NY+4MsAmd+8ZXRWcNAk8GcMN0UzRWkj6GfJK3xCmCZharPOLZAAmp+vlhahNyC7ioPvRnoLpCdAFOq3mqNHsWwbSt19sfdT1w+A9pK16tNxQBt30RJMBzKzutC39SgCGs1fKrmvvLoILu/bJC8IxB5qfc4KcW7kP2w0Lz1yi/0OPT0f7n8Twcv3+82jrLINsV/rl39zW+xKC8s1IjjdMPe4fxtZh/CPJ6IbDpdiu+km3agMRW4dxsyrSRUtq9aGCd0j4jzaSxtafi+n30XyR+PbQnQ7toE9COwqnczsMZtP5PIlc35391fkEue1l39UfIOaLCdqWF4wqBp8psnW2Jf9wsMVWZ/JBNz1z7zhAu8s98gfufei5dtJ3PTsY4KE9HPRDOwk9fz4IposwCTvcw9u4e67jeQfy4UhRThgtdlrtFOpaQSSYvuGEdsUo4Rw+Ryd/A1BLAwQUAAAACABZYZZcwofb8lEGAADXGwAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWztWU9v2zYUvw/YdyB0b2MnthMHdYrYsZutTRskboceaZmW2FCiQNJJfRva44ABw7phlwG77TBsK9ACu3SfJluHrQP6FfZISrYYM43Tpti/5hCL1I/v/3t8pK5cvZ8wdEiEpDxtBdXLlQCRNORDmkat4Ha/d2ktQFLhdIgZT0krmBAZXN14/70reF3FJCEI1qdyHbeCWKlsfWlJhjCN5WWekRTejbhIsIKhiJaGAh8B3YQtLVcqjaUE0zRAKU6A7K3RiIYE9Q1JeLuKLsFPtRJsFIy6DF6lSuqJkIl9zYa4q0+uGx5UNVpOZIcJdIhZKwD+Q37UJ/dVgBiWCl60gor5C5Y2rizh9XwRU6esLa3rmb98Xb5geLBseIpoMGVa7dWaq1tT+gbA1Dyu2+12utUpPQPAYQhaW1nKNGu9tWq7oFkC2cd52p1KvVJz8SX6K3P0m+12u97MZbFEDcg+1ubwa5VGbXPZwRuQxdfn5W9vdjoNB29AFt+Yw/dWm42aizegmNH0YA6t/Tn1zBQy4mzbC18D+FoRADMURMM00jSLEU/VInGX4Htc9ABsHI0VTZGaZGSEQ4j0Dk4GgmKtOV4nuPTGToVybkrzRTIUNFOt4MMMQ9bM6L189v3LZ0/Qy2ePjx88PX7w0/HDh8cPfrS0nIXbOI3KC198+9mfX3+M/njyzYtHX/jxsoz/9YdPfvn5cz8Qsmkm0fMvH//29PHzrz79/btHHvimwIMyvE8TItFNcoT2eAK6eSQnA3G+Ff0YU2cFjoG2h3RXxQ7w5gQzH65NXOPdEVBIfMBr43uOrPuxGCvq4Xw9ThzgDueszYXXANc1r5KF++M08jMX4zJuD+NDH+8OTh3XdscZVNMiKJ2o6cTEEXOX4VThiKREIf2OHxDi0e4upY5dd2gouOQjhe5S1MbUa5I+HTiBNFu0TRPwy8SnM7jasc3OHdTmzKf1Fjl0kZAQmHmE7xPmmPEaHiuc+Ej2ccLKBr+BVewTcn8iwjKuKxV4OiKMo+6QSOlbc0uAviWnX8dQu7xu32GTxEUKRQ98NG9gzsvILX7QiXGSeWWmaVzGfiAPIEQx2uXKB9/hboboMfgBp6e6+w4ljrvPLgS3aeSINAsQ/WYsPL68RribjxM2wsRUGSjvTqVOaPqqss0o1O13ZbvYxzZhE/Mlz/aJYn0a7l9YorfwON0lkBXzW9S7Cv2uQgf/+Qp9Wi5ffF2elWKo0rO+2zS1yUJN+Igytq8mjNyQpg+XsBkNezBpBub0OD2gZTE85luCg4sENmuQ4OojquL9GGfQw1fNsTSSOelIooxLOEeaaS9tc4yl0MabU2i9OG8CGqsdPrTTK+Vz6JSM2agic+4tGK1oAosyW1nND7evyaxqpVpQtaoRzRRIR7WpyqDMvGpGw9ya0OUg6I3Ayg040GtqcPbBjAy13e22XbjF2OQiXSRjPCS5j7Te84pUjZOKWCnCyOMjfaY8w2olbk1N9g24LeKkMrvaKewK772JlwrrzLykc/hEOrK0nJwsRUetoFlfrgcoxFkrGMGxGR6TDLwudWOJWQT3U6ESNhDPTGaDmnmz6Q/LKtyKnOJNh0UmpNrCMrahYV4V1zSpOeQb+ZfrYNaLUsBG+mtIsbIGwfC3SQEyu64loxEJVdnZpRlzB2IAefLzsSJiPx4eoQEbiz0M7tehCvoMqYTbD1MR9ACu7bS1zcgtznnSlS/LDM7OY5bFOC+3OkWLTLZwY/OpDGZUEm86MtrMZD8xXFQVk/IXpEo5jP9nquj9BK4jVobm9gxukwVGOl9bARcq5lCFspiGPQGXaCYCIFrg6hdeg/HhTtv8CnKof23OWRomreFUqfZohASF/UjFgpBdKEsm+s4gVs33LkuyIGRzeiauzKzYA3JIWF/XkIbe2wMUF9UkLwMGdzL+3HEedoNINyz/1M7HJvN524NZ52PXL9iL1EpFv7QVNN9MhHNutbZizWm8XF94q83gUgnpf7D/UREyYvTXG2qf70HpRNOOEkFUX7KNB9IF0j4NoHGykzaYNKm320bNOt0p37fYfJa2+Wlz5rJzcvHV3ef5jJ1b2LF1udP1mBoccDJFdXtUHGqMY8yXtfIHLz64B47egk8IY6ak/XRwH64QYcuyHyQg+a1zzdKNvwBQSwMEFAAAAAgAWWGWXDv94C4UAwAA/QYAAA8AAAB4bC93b3JrYm9vay54bWylVW1v2jAQ/j5p/8GzkLZKC4kDDRARKgpFRepaNGj7EZnEgNUkjmzzpqr/fedAeCmbVHUBEs7ne+65x2enebVOYrRkUnGRBpiUHYxYGoqIp7MAP456Vh0jpWka0VikLMAbpvBV6+uX5krIl4kQLwgAUhXgudaZb9sqnLOEqrLIWAqeqZAJ1WDKma0yyWik5ozpJLZdx/HshPIUbxF8+REMMZ3ykHVFuEhYqrcgksVUA30155kq0JLwI3AJlS+LzApFkgHEhMdcb3JQjJLQ789SIekkhrLX5BKtJXw9+BEHbm6RCVxnqRIeSqHEVJcB2t6SPqufODYhJxKszzX4GFIVRFhys4Z7VtL7JCsj6BYLVNgujSn5v9EItFYB534S7XLPzcWt5pTH7Gnbuohm2T1NzErFGMVU6ZuIaxYFuAamWLHDQBUjuciuFzwGr9tw3Aa2W/t2HkgEsJrJgeRLGm5gT2A05xEb8KXQPc7i6I4rnQ9HbEoXsR5Bxxc8YNytuq5nINfSL5QcaIngf797B8yGdAk8QY1o18Z9IEIq4zSUPhm/unWHdOrEsZy2d2lVnS6xGpVazSIdr35d865Jp11/Ayml54eCLvR8J4GBDnAV6j1z/aLrwkMcf8GjA41XZ3dZ5vnuVvjeTDlmsz9xtlIHsYyJ1s88jcQqwJU6UMdoU9gWccFc5d5nHum5meJV92O3jM/mQNkFyWCQhpov2YhOcm1hgxmiAT4h2N0S7MGV304I2kcM81MGmOZPlOadMRQLGTLUpZrCmWYcufDQDr5JJPsRMXUeh9wJjTpCadRlmvJYod8sE1IfhVeOwt334QMqITM0ExxL+4RwcOwTVkyEXZCFfuIpi0wfA/Uja1fAeB2nSXncy/vTlDGhipn2Dmk8LOoBJaFdI2ZOc9z6flT092+ldon4pfZtiTTtI/i/5drG5Vq1Hnq94c3oxznWTwc+nYfH+1H7zAt5Lv7hAw7k4uIdhWNCUD2UFMJeNI98lVzXJfnyZGYfdii8ZmDWwYCZMGSmNmAH7AWu5gKfxNjFm6v1B1BLAwQUAAAACABZYZZcyKG4+rgAAAA0AQAAIwAAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzhY/BCsIwEETvgv8Q9m7SehCRpr2I4FXqB6zptg22SchG0b83xwqCt9kd9s1O1bzmSTwpsvVOQykLEOSM76wbNFzb02YPghO6DifvSMObGJp6vaouNGHKRzzawCJTHGsYUwoHpdiMNCNLH8hlp/dxxpTHOKiA5o4DqW1R7FRcMqD+YopzpyGeuxJE+w45+T/b9701dPTmMZNLPyJUsE+fWrxNlKkYB0oapFyseaFLmX8HVVfqq2v9AVBLAwQUAAAACABZYZZcgdy13PMDAACODgAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJ2XW2+kNhTH3yv1OyAe+hbAZshcOjOrbUZRVtpVo6aXZw94ZqwAprYnt1W/e48NB4jSSniiCT5g+Pv4+Gf7eP3ppSqDJ660kPUmJFESBrzOZSHq4yb84/fbq0UYaMPqgpWy5pvwlevw0/bHH9bPUj3qE+cmAIVab8KTMc0qjnV+4hXTkWx4DTUHqSpm4FYdY90ozgr3UVXGNEmu44qJOmwVVmqKhjwcRM53Mj9XvDatiOIlM+C/PolGo1qVT5GrmHo8N1e5rBqQ2ItSmFcnGgZVvvpyrKVi+xL6/UJmLA9eFPwo/KfYjHv+oaVK5EpqeTARKMetzx+7v4yXMct7pY/9nyRDZhCAJ2EHcJCil7lEsl6LDmLphWJ2ZFrHbLjU6iyKTfg96f6uoCT2kgwXrPsn3K4LASNsPw4UP2zCz2T1+S4N4+3aAfSn4M96ZAeWx72Uj7biC7STgETDah68PjQwqsB2GBjZfOUHc8PLEgShhyw34onfw2ubcC+NkZWtd8QbeHRQ8o3Xrk1ecngXnLGa719uRQZR/XfrMLUfxr23Yxs9v3Wz414FBT+wc2luZPmXKMwJvCXRjGbzBaFZiLW/yec7Lo4n2xkazaHC0bcqXndc5zAdoNeRazWXJTQB16ASdloDzezFlc+dfBrRRUayayu/59rcdiHKzxqigE50Wq0KxMupQDmozEmyTK0rE0WABCcCJYqAz76uzDoVKFGFRIssm10vPHwBr50vUHYqlES+HbIrhRWBEl2ZeYvMOxEoO5Glf1BgpXaeQNmJpKl/UJadCpTYn7m/CoF9pEUOjEEnmyepI3oiLaQnd4Quicgs8QGXILnWQGcuCDBBeK2BOiA5tTNILXmHrXdMEFsycEuy0Wox1R0kl4zQvWAWEYTXGv0UmB4VxJYM3M69RxipJSNsZ74qFKG1RteTa3/2KUJrjU5mtvAfINovuCNsveGnCK01emgjX+oowmuNfo0atqiJ0Nm5324iI3jBsamfI7N0xOzcvzOILB0hewH6FNm1Bo70BQsLRXytMYyR5zKXIr7WQJXMey9KEV9r4L5IfedSivBao08XJg902ucJA7VL73FOEVprDLvQtLjGbRLl8rcdMwzzt9ZmZyNvRWm4GqWnELD/THOX/5vmQq7WsCP/xtRR1DooIfu0SRxgqdpEz9mQtzrLbpwuS8W7E5ynOJwbkgjCdJAS3GlvOt0Hbs4NpKwNVw/iDfJW4EsqAamiOzBtwhJOdjqH+jA4QcWbhJpy1wibP9tjoRF5fw+abXu3rqHtWhbFnXuw/YlVzc83v95/C35hJj8FX6UJbqQ2wY4bJkq9jod31/F7lbg/SW7/BVBLAwQUAAAACABZYZZclYNJGdQFAABKGQAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbKVZ2XLqOBB9n6r5B5ffwchAWCrklsMSyEpWEt6MEeAKtrm2s83U/Pu0LGSsxtHgTNXNxTl9dNTqVreEc/zr01tr7zSM3MDv6KRc0TXqO8Hc9Zcd/fFhUGrqWhTb/txeBz7t6F800n+d/PnH8UcQvkYrSmMNFPyoo6/ieNM2jMhZUc+OysGG+mBZBKFnx/BruDSiTUjteTLIWxtmpXJkeLbr61yhHR6iESwWrkN7gfPmUT/mIiFd2zH4H63cTSTUPOcQOc8OX982JSfwNiAxc9du/JWI6prntEdLPwjt2RrW/UlqtqN9hvDPhJ+qmCbB92byXCcMomARl0HZ4D7vL79ltAzbSZX213+QDKlBAN5dlsCdlPkzl0g91TJ3YtUfirHMcMdYuML2mzvv6H+fmt1B86hplaxud1CqNQgpnba6lRKpm33TbFYG9Wr/H/3keO5ChtlgLaSLjm5V25bV0o2T42QDPbn0I8o8a7E9u6dr6sQUJiG6xvbnLAheGXEEUAUkN7ZPtc/7DWS5ozd07Wv7CO7FweaSLuIuXa87+rCma7YTu+90DCM6+iyI48C7c5erOKmGGLBFGPxF/cSfZFrmKNPv6CC1pXKNrSb4FP1OljIkecP4JMwJMTkfaIEz24HwmDOf5J005W4krAhGGmnoss8ijIOkVMehNqcL+20d3wUfQ8rWDPE0y4065JBt9vb8q0cjB6oPglo2ma4TrEEE/tc8l3URKB77k2fBncerZHyzXq8dNZnKjEbxgGUA7M5bBIuebFlbLa4CGzBRgU+hUi2bzTqpH5mHq0BqExX43Ko0yqRWSSRW7nxOub8KPyCIiQJ8Cj+gSR64CJglGQyfYnC94PysFTEJ+BQSzVRC4Tfs72QcNHAxrlGumfVGkxSIX0vkEta8m75wMkm6JzKbgpTrjUq1iDdEbAqyyyepFd9bRCSVZBJTLe6OyA2BYIvo1IoHmUCOeMVkklUtN0ilVS1QMSRNFjyke7WwjAmp5pWXyTkpLiNSbkp9oGjKzbQPZBpBo3gjMEUnYA9pQRxcyKbYMezh/3Q10RFYDW51WsV3jCl2HnsQ7hz9ICqiS5iZHfyf7c3gDT85TXp2bJ8ch8GHBvcXCG0EhyDcBkmbKeYeGHBSMK7FyElnhKMggtP5/aRybLzDyeRsGaf7DCIzuvsMU2b09hlVmdHfZ9RkxmCfUZcZZ/uMI5kx3Gc0ZMZon9GUGef7jJbMuMiJGArqZQ4FRfUqh4LCep1DQXG9yaGgwI5zKCiytzkUFNq7HAqK7X0OBQX3IYeCovuYs9tQdJ9yKCi6kxwKiu4zpxAoxLQ2TBTelzwOiu+Uc+A02Mmg+FrbMpQ4uwAbUNhpdbPr5MHVDeTdpCgdp7Wk3HEx56K9XLQvyaNUDlRzn6mM7OL/rdcjtn7W43Ja1bnCdsFt23VUcD0qRl4pbNeSq2in3qiM46yxity5lYwoQ3eSEW3ae1XsHlTGR5W3T6qRE8khVCHPiui9KGxThc1Kvo2JZO5iJ9UJHGkH10mPkZPLfbrvqqiK+4LCvmmxk3OAgTMMDDEwwsA5Bi4wcImBKwxcY+AGA2MM3GLgDgP3GHjAwCMGnjAwwcAzBl4wMOVAI6+4LYsbm8goJR0yeHDSp4zMOonIqGVxhH9Lz/ZcuEQdLNvl3uMbUC7aB+HdjkOHwiBrNFHzPlMZhyrjiC3muwaqsF1w23cNVDHySmG7llzFDVRlHEuxww1UMuIGKhlxA1XF7kFlfFR5+6QaOZEcwg1UEb0XhW2qsFlWNpnfNFD2zvnQi0aPkVEDRRfEvqCkDRQDZxgYYmCEgXMMXGDgEgNXGLjGwA0Gxhi4xcAdBu4x8ICBRww8YWCCgWcMvGBgyoFvGig3Khso3EAPTvqUkeUGypFMA+UvO/nX0429pFd2uHT9SFvDG1b25hL2YcjfbibP8NY2eYJWz1+oit9W8DcLCqdupQy36UUQxOIX1qrTv4Kc/AtQSwECFAAUAAAACABZYZZckO8c1poBAABtBwAAEwAAAAAAAAAAACAAtoEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAFlhlly1VTAj7gAAAEwCAAALAAAAAAAAAAAAIAC2gcsBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAFlhllwPZyHAoQEAAGYDAAAQAAAAAAAAAAAAIAC2geICAABkb2NQcm9wcy9hcHAueG1sUEsBAhQAFAAAAAgAWWGWXC+PYuk6AQAAUQIAABEAAAAAAAAAAAAgALaBsQQAAGRvY1Byb3BzL2NvcmUueG1sUEsBAhQAFAAAAAgAWWGWXE1B1tIaAQAAewQAABoAAAAAAAAAAAAgALaBGgYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQAFAAAAAgAWWGWXOIrf3u7AAAAMwEAADIAAAAAAAAAAAAgALaBbAcAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzUEsBAhQAFAAAAAgAWWGWXO3tHm95BAAAxxgAACcAAAAAAAAAAAAgALaBdwgAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbFBLAQIUABQAAAAIAFlhllzGqpmPQgEAAFQEAAAkAAAAAAAAAAAAIAC2gTUNAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWxQSwECFAAUAAAACABZYZZcCkEM6r0AAABHAQAAKQAAAAAAAAAAACAAtoG5DgAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHNQSwECFAAUAAAACABZYZZc0F7EUZ8FAACwHQAAHgAAAAAAAAAAACAAtoG9DwAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1sUEsBAhQAFAAAAAgAWWGWXJer4F0PBAAA1A4AAA0AAAAAAAAAAAAgALaBmBUAAHhsL3N0eWxlcy54bWxQSwECFAAUAAAACABZYZZcwofb8lEGAADXGwAAEwAAAAAAAAAAACAAtoHSGQAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIAFlhllw7/eAuFAMAAP0GAAAPAAAAAAAAAAAAIAC2gVQgAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACABZYZZcyKG4+rgAAAA0AQAAIwAAAAAAAAAAACAAtoGVIwAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHNQSwECFAAUAAAACABZYZZcgdy13PMDAACODgAAGAAAAAAAAAAAACAAtoGOJAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAAAAgAWWGWXJWDSRnUBQAAShkAABgAAAAAAAAAAAAgALaBtygAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLBQYAAAAAEAAQAH8EAADBLgAAAAA=
</FILE_DATA>
    <DATA_SHEET_FILE_NAME>xl/worksheets/sheet1.xml</DATA_SHEET_FILE_NAME>
    <PARAMETER_SHEET_FILE_NAME>xl/worksheets/sheet3.xml</PARAMETER_SHEET_FILE_NAME>
    <COLUMN_HEADER_ROW_NUM>1</COLUMN_HEADER_ROW_NUM>
    <TEMPLATE_SHARED_STRINGS>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>0</STRING_ID>
      <STRING>Organization</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>1</STRING_ID>
      <STRING>Top Batch No</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>2</STRING_ID>
      <STRING>Level</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>3</STRING_ID>
      <STRING>Batch No</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>4</STRING_ID>
      <STRING>Sort Order</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>5</STRING_ID>
      <STRING>Product</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>6</STRING_ID>
      <STRING>Batch Lot Number</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>7</STRING_ID>
      <STRING>Product Desc</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>8</STRING_ID>
      <STRING>Batch Size</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>9</STRING_ID>
      <STRING>Batch Actual Output</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>10</STRING_ID>
      <STRING>Batch Yield</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>11</STRING_ID>
      <STRING>Batch Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>12</STRING_ID>
      <STRING>Batch Unit Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>13</STRING_ID>
      <STRING>Batch Uom</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>14</STRING_ID>
      <STRING>Primary UOM</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>15</STRING_ID>
      <STRING>Batch Type</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>16</STRING_ID>
      <STRING>Currency Code</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>17</STRING_ID>
      <STRING>Material Type</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>18</STRING_ID>
      <STRING>Item</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>19</STRING_ID>
      <STRING>Item Desc</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>20</STRING_ID>
      <STRING>Detail Uom</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>21</STRING_ID>
      <STRING>Lot Number</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>22</STRING_ID>
      <STRING>Lot Source</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>23</STRING_ID>
      <STRING>Lot Quantity</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>24</STRING_ID>
      <STRING>Lot Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>25</STRING_ID>
      <STRING>  Lot Extended Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>26</STRING_ID>
      <STRING> Pct Of Cost</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>27</STRING_ID>
      <STRING>NA</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>28</STRING_ID>
      <STRING>00000010000001</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>29</STRING_ID>
      <STRING>EA</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>30</STRING_ID>
      <STRING>(blank)</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>31</STRING_ID>
      <STRING>USD</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>32</STRING_ID>
      <STRING>Ingredient</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>33</STRING_ID>
      <STRING>PRODUCTION BATCH</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>34</STRING_ID>
      <STRING>1 Total</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>35</STRING_ID>
      <STRING>00000010000002</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
     <TEMPLATE_SHARED_STRINGS_ROW>
      <STRING_ID>36</STRING_ID>
      <STRING>2 Total</STRING>
     </TEMPLATE_SHARED_STRINGS_ROW>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>A1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AA</CELL_IDENTIFIER>
      <STYLE_ID>4</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AA1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AB1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AC1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AD1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AE1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AF1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AG1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>AH1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>B1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>C1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>D1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>E</CELL_IDENTIFIER>
      <STYLE_ID>2</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>E1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>F1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>G1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>H1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>I1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>J1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>K</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>K1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>L</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>L1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>M</CELL_IDENTIFIER>
      <STYLE_ID>4</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>M1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>N</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>N1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>O</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>O1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>P1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Q1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>R1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>S1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>T1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>U1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>V1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>W1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>X</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>X1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Y</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Y1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Z</CELL_IDENTIFIER>
      <STYLE_ID>3</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>data</SHEET_TYPE>
      <CELL_IDENTIFIER>Z1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A1</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A11</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A12</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A13</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A14</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A15</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A2</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A3</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A4</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A5</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A6</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A7</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A8</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>A9</CELL_IDENTIFIER>
      <STYLE_ID>1</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
     <TEMPLATE_STYLES_ROW>
      <SHEET_TYPE>parameter</SHEET_TYPE>
      <CELL_IDENTIFIER>B3</CELL_IDENTIFIER>
      <STYLE_ID>2</STYLE_ID>
     </TEMPLATE_STYLES_ROW>
    </TEMPLATE_STYLES>
    <TEMPLATE_SHARING>
     <TEMPLATE_SHARING_ROW>
      <SHARING_LEVEL>S</SHARING_LEVEL>
      <LEVEL_VALUE>Site</LEVEL_VALUE>
     </TEMPLATE_SHARING_ROW>
    </TEMPLATE_SHARING>
    <PARAMETER_EXCLUSION>
    </PARAMETER_EXCLUSION>
   </TEMPLATES_ROW>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
   <DEFAULT_TEMPLATES_ROW>
    <USER_NAME>ERIC.CLEGG</USER_NAME>
    <TEMPLATE_NAME>Detail Pivot</TEMPLATE_NAME>
   </DEFAULT_TEMPLATES_ROW>
   <DEFAULT_TEMPLATES_ROW>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
   </DEFAULT_TEMPLATES_ROW>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
