<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>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: WIP Value -->
 <REPORTS_ROW>
  <GUID>CCB2939CA7CB0D94E0530100007FA761</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>with wip_detail_q as
( select /*+ inline */
   wdq.job_type,
   wdq.discrete_job_type,
   wdq.class_type_code,
   wdq.class_type,
   wdq.class_code,
   wdq.wip_entity,
   xxen_util.meaning(wdq.status_type,&apos;WIP_JOB_STATUS&apos;,700) status,
   wdq.date_closed,
   wdq.release_date,
   wdq.complete_date,
   wdq.period,
   wdq.period_close_date,
   wdq.scheduled_start_date,
   wdq.assembly,
   wdq.item_id,
   wdq.start_quantity,
   wdq.completed_quantity,
   wdq.scrap_quantity,
   wdq.open_quantity,
   wdq.element,
   wdq.gl_account,
   -- PTD
   case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.costs_incurred,:p_precision) end ptd_costs_incurred,
   case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.costs_relieved,:p_precision) end ptd_costs_relieved,
   case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.elemental_variances_relieved,:p_precision) end ptd_elemental_var_relieved,
   case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.single_variances_relieved,:p_precision) end ptd_single_var_relieved,
   case when wdq.acct_period_id = :p_acct_period_id then
     round(:p_exchange_rate * nvl(wdq.costs_incurred,0),:p_precision) -
     round(:p_exchange_rate * nvl(wdq.costs_relieved,0),:p_precision) -
     round(:p_exchange_rate * nvl(wdq.elemental_variances_relieved,0),:p_precision)
   end ptd_net_activity,
   -- CTD
   round(:p_exchange_rate * wdq.costs_incurred,:p_precision) ctd_costs_incurred,
   round(:p_exchange_rate * wdq.costs_relieved,:p_precision) ctd_costs_relieved,
   round(:p_exchange_rate * wdq.elemental_variances_relieved,:p_precision) ctd_elemental_var_relieved,
   round(:p_exchange_rate * wdq.single_variances_relieved,:p_precision) ctd_single_var_relieved,
   round(:p_exchange_rate * nvl(wdq.costs_incurred,0),:p_precision) -
   round(:p_exchange_rate * nvl(wdq.costs_relieved,0),:p_precision) -
   round(:p_exchange_rate * nvl(wdq.elemental_variances_relieved,0),:p_precision) ctd_net_activity,
   --
   wdq.organization_id,
   wdq.wip_entity_id,
   wdq.repetitive_schedule_id,
   wdq.acct_period_id,
   wdq.element_code,
   wdq.costs_incurred,
   wdq.costs_relieved,
   wdq.elemental_variances_relieved,
   wdq.single_variances_relieved
  from
   (
     select /*+ LEADING(WDJ WPB OAP WE) USE_NL(WDJ WPB OAP WE ML2) */ -- Discrete Jobs
      &apos;Discrete&apos;                  job_type,
      xxen_util.meaning(wdj.job_type,&apos;WIP_DISCRETE_JOB&apos;,700) discrete_job_type,
      wpb.class_type              class_type_code,
      ml.meaning                  class_type,
      wdj.class_code              class_code,
      we.wip_entity_name          wip_entity,
      wdj.status_type,
      wdj.date_closed,
      wdj.date_released           release_date,
      wdj.date_completed          complete_date,
      oap.period_name             period,
      oap.schedule_close_date     period_close_date,
      wdj.scheduled_start_date    scheduled_start_date,
      wdj.primary_item_id         item_id,
      msik.concatenated_segments  assembly,
      wdj.start_quantity,
      wdj.quantity_completed      completed_quantity,
      wdj.quantity_scrapped       scrap_quantity,
      wdj.start_quantity-wdj.quantity_completed-wdj.quantity_scrapped open_quantity,
      --
      ml2.meaning                 element,
      decode(:p_display_level,&apos;Job&apos;,null,nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1(&apos;acct_flex_bal_seg&apos;, &apos;SQLGL&apos;, &apos;GL#&apos;, gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, &apos;ALL&apos;, &apos;Y&apos;, &apos;VALUE&apos;),null))
                                  gl_account,
      --
      decode( ml2.lookup_code,
              1  , nvl(wpb.pl_material_in,0),
              2  , nvl(wpb.pl_material_overhead_in,0),
              3  , nvl(wpb.tl_resource_in,0) + nvl(wpb.pl_resource_in,0),
              4  , nvl(wpb.tl_outside_processing_in,0) + nvl(wpb.pl_outside_processing_in,0),
              5  , nvl(wpb.tl_overhead_in,0) + nvl(wpb.pl_overhead_in,0),
              12 , nvl(wpb.tl_scrap_in,0),
                   0)             costs_incurred,
      decode(ml2.lookup_code,
             1  , nvl(wpb.tl_material_out,0) + nvl(wpb.pl_material_out,0),
             2  , nvl(wpb.pl_material_overhead_out,0)+nvl(wpb.tl_material_overhead_out,0),
             3  , nvl(wpb.tl_resource_out,0) + nvl(wpb.pl_resource_out,0),
             4  , nvl(wpb.tl_outside_processing_out,0) + nvl(wpb.pl_outside_processing_out, 0),
             5  , nvl(wpb.tl_overhead_out,0) + nvl(wpb.pl_overhead_out,0),
             12 , nvl(wpb.tl_scrap_out,0),
                  0)              costs_relieved,
      decode(ml2.lookup_code,
             1  , nvl(wpb.tl_material_var,0) + nvl(wpb.pl_material_var,0),
             2  , nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.tl_material_overhead_var,0),
             3  , nvl(wpb.tl_resource_var,0) + nvl(wpb.pl_resource_var,0),
             4  , nvl(wpb.tl_outside_processing_var,0) + nvl(wpb.pl_outside_processing_var, 0),
             5  , nvl(wpb.tl_overhead_var,0) + nvl(wpb.pl_overhead_var,0),
             12 , nvl(wpb.tl_scrap_var,0),
                  0)              elemental_variances_relieved,
      decode(ml2.lookup_code,
             6  , nvl(wpb.tl_material_var,0) +
                  nvl(wpb.pl_material_var,0) +
                  nvl(wpb.pl_material_overhead_var,0) +
                  nvl(wpb.pl_resource_var,0) +
                  nvl(wpb.pl_overhead_var,0) +
                  nvl(wpb.pl_outside_processing_var,0) +
                  nvl(wpb.tl_material_overhead_var,0),
             7  , nvl(wpb.tl_resource_var,0),
             8  , nvl(wpb.tl_outside_processing_var,0),
             9  , nvl(wpb.tl_overhead_var,0),
             13 , nvl(wpb.tl_scrap_var,0),
                  0)             single_variances_relieved,
      --
      wpb.organization_id,
      wpb.wip_entity_id,
      wpb.repetitive_schedule_id,
      wpb.acct_period_id,
      ml2.lookup_code element_code
     from
      wip_discrete_jobs    wdj,
      wip_period_balances  wpb,
      org_acct_periods     oap,
      mfg_lookups          ml,
      wip_entities         we,
      mtl_system_items_b_kfv msik,
      mfg_lookups          ml2,
      gl_code_combinations gcc
     where
      wpb.wip_entity_id          = wdj.wip_entity_id and
      wpb.organization_id        = wdj.organization_id and
      oap.organization_id        = wpb.organization_id and
      oap.acct_period_id         = wpb.acct_period_id and
      ml.lookup_type             = &apos;WIP_CLASS_TYPE&apos; and
      ml.lookup_code             = wpb.class_type and
      we.wip_entity_id           = wdj.wip_entity_id and
      we.organization_id         = wdj.organization_id and
      msik.inventory_item_id (+) = wdj.primary_item_id and
      msik.organization_id (+)   = wdj.organization_id and
      ml2.lookup_type            = &apos;WIP_ELEMENT_VAR_TYPE&apos; and
      ml2.lookup_code           in (1,2,3,4,5,6,7,8,9,12,13) and
      gcc.code_combination_id    = decode(ml2.lookup_code,
                                    1 , wdj.material_account,
                                    2 , wdj.material_overhead_account,
                                    3 , wdj.resource_account,
                                    4 , wdj.outside_processing_account,
                                    5 , wdj.overhead_account,
                                    6 , wdj.material_variance_account,
                                    7 , wdj.resource_variance_account,
                                    8 , wdj.outside_proc_variance_account,
                                    9 , wdj.overhead_variance_account,
                                    12, wdj.est_scrap_account,
                                    13, wdj.est_scrap_var_account,
                                        0) and
      wdj.organization_id        = :p_organization_id and
      wdj.date_released         is not null and
      trunc(wdj.date_released)  &lt;= :p_period_close_date and
      wpb.organization_id        = :p_organization_id and
      wpb.acct_period_id        &lt;= :p_acct_period_id and
      2=2
     union
     select /*+ LEADING(WRS) */ -- Repetitive Schedules
      &apos;Repetitive&apos;               job_type,
      null                       discrete_job_type,
      wpb.class_type              class_type_code,
      ml.meaning                  class_type,
      wri.class_code              class_code,
      wl.line_code                wip_entity,
      wrs.status_type,
      wrs.date_closed,
      wrs.date_released           release_date,
      to_date(null)               complete_date,
      oap.period_name             period,
      oap.schedule_close_date     period_close_date,
      wrs.first_unit_start_date   scheduled_start_date,
      wri.primary_item_id         item_id,
      msik.concatenated_segments  assembly,
      to_number(null)             start_quantity,
      to_number(null)             completed_quantity,
      to_number(null)             scrap_quantity,
      to_number(null)             open_quantity,
      --
      ml2.meaning                 element,
      decode(:p_display_level,&apos;Job&apos;,null,nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1(&apos;acct_flex_bal_seg&apos;, &apos;SQLGL&apos;, &apos;GL#&apos;, gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, &apos;ALL&apos;, &apos;Y&apos;, &apos;VALUE&apos;),null))
                                  gl_account,
      --
      decode( ml2.lookup_code,
              1  , nvl(wpb.pl_material_in,0),
              2  , nvl(wpb.pl_material_overhead_in,0),
              3  , nvl(wpb.tl_resource_in,0) + nvl(wpb.pl_resource_in,0),
              4  , nvl(wpb.tl_outside_processing_in,0) + nvl(wpb.pl_outside_processing_in,0),
              5  , nvl(wpb.tl_overhead_in,0) + nvl(wpb.pl_overhead_in,0),
                   0)             costs_incurred,
      decode(ml2.lookup_code,
             1  , nvl(wpb.tl_material_out,0) + nvl(wpb.pl_material_out,0),
             2  , nvl(wpb.pl_material_overhead_out,0) + nvl(wpb.tl_material_overhead_out,0),
             3  , nvl(wpb.tl_resource_out,0) + nvl(wpb.pl_resource_out,0),
             4  , nvl(wpb.tl_outside_processing_out,0) + nvl(wpb.pl_outside_processing_out, 0),
             5  , nvl(wpb.tl_overhead_out,0) + nvl(wpb.pl_overhead_out,0),
                  0)              costs_relieved,
      decode(ml2.lookup_code,
             1  , nvl(wpb.tl_material_var,0) + nvl(wpb.pl_material_var,0),
             2  , nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.tl_material_overhead_var,0),
             3  , nvl(wpb.tl_resource_var,0) + nvl(wpb.pl_resource_var,0),
             4  , nvl(wpb.tl_outside_processing_var,0) + nvl(wpb.pl_outside_processing_var, 0),
             5  , nvl(wpb.tl_overhead_var,0) + nvl(wpb.pl_overhead_var,0),
                  0)              elemental_variances_relieved,
      decode(ml2.lookup_code,
             6  , nvl(wpb.tl_material_var,0) +
                  nvl(wpb.pl_material_var,0) +
                  nvl(wpb.pl_material_overhead_var,0) +
                  nvl(wpb.pl_resource_var,0) +
                  nvl(wpb.pl_overhead_var,0) +
                  nvl(wpb.pl_outside_processing_var,0) +
                  nvl(wpb.tl_material_overhead_var,0),
             7  , nvl(wpb.tl_resource_var,0),
             8  , nvl(wpb.tl_outside_processing_var,0),
             9  , nvl(wpb.tl_overhead_var,0),
                  0)             single_variances_relieved,
      --
      wpb.organization_id,
      wpb.wip_entity_id,
      wpb.repetitive_schedule_id,
      wpb.acct_period_id,
      ml2.lookup_code element_code
     from
      wip_repetitive_schedules wrs,
      wip_period_balances      wpb,
      org_acct_periods         oap,
      mfg_lookups              ml,
      wip_entities             we,
      wip_lines                wl,
      wip_repetitive_items     wri,
      mtl_system_items_b_kfv     msik,
      mfg_lookups              ml2,
      gl_code_combinations     gcc
     where
      wpb.wip_entity_id          = wrs.wip_entity_id and
      wpb.organization_id        = wrs.organization_id and
      wpb.repetitive_schedule_id = wrs.repetitive_schedule_id and
      oap.organization_id        = wpb.organization_id and
      oap.acct_period_id         = wpb.acct_period_id and
      ml.lookup_type             = &apos;WIP_CLASS_TYPE&apos; and
      ml.lookup_code             = wpb.class_type and
      we.wip_entity_id           = wrs.wip_entity_id and
      we.organization_id         = wrs.organization_id and
      wl.line_id                 = wrs.line_id and
      wl.organization_id         = wrs.organization_id and
      wri.wip_entity_id          = wrs.wip_entity_id and
      wri.line_id                = wrs.line_id and
      wri.organization_id        = wrs.organization_id and
      msik.inventory_item_id     = wri.primary_item_id and
      msik.organization_id       = wri.organization_id and
      ml2.lookup_type            = &apos;WIP_ELEMENT_VAR_TYPE&apos; and
      ml2.lookup_code           in (1,2,3,4,5,6,7,8,9) and
      gcc.code_combination_id    = decode(ml2.lookup_code,
                                    1 , wrs.material_account,
                                    2 , wrs.material_overhead_account,
                                    3 , wrs.resource_account,
                                    4 , wrs.outside_processing_account,
                                    5 , wrs.overhead_account,
                                    6 , wrs.material_variance_account,
                                    7 , wrs.resource_variance_account,
                                    8 , wrs.outside_proc_variance_account,
                                    9 , wrs.overhead_variance_account,
                                        0) and
      wrs.organization_id        = :p_organization_id and
      wrs.date_released         is not null and
      trunc(wrs.date_released)  &lt;= :p_period_close_date and
      ( wrs.date_closed         is null or
        wrs.date_closed         &gt;= :p_period_start_date
      ) and
      wpb.organization_id        = :p_organization_id and
      wpb.acct_period_id        &lt;= :p_acct_period_id and
      3=3
   ) wdq
)
--
-- Main Query Starts Here
--
select
 :p_organization_code organization,
 wdq.job_type,
 wdq.discrete_job_type,
 wdq.class_type,
 wdq.class_code class,
 wdq.wip_entity &quot;Job/Line&quot;,
 wdq.status &quot;Job Status&quot;,
 wdq.date_closed job_closed_date,
 wdq.release_date,
 wdq.complete_date,
 wdq.period,
 wdq.period_close_date,
 wdq.scheduled_start_date start_date,
 wdq.assembly,
 &amp;category_columns
 wdq.start_quantity,
 wdq.completed_quantity,
 wdq.scrap_quantity,
 wdq.open_quantity,
 wdq.element &quot;Element/Variance&quot;,
 wdq.gl_account,
 :p_currency_code currency,
 :p_exchange_rate exchange_rate,
 -- PTD
 wdq.ptd_costs_incurred,
 wdq.ptd_costs_relieved,
 wdq.ptd_elemental_var_relieved ptd_variances_relieved,
 wdq.ptd_single_var_relieved ptd_single_level_var_relieved,
 wdq.ptd_net_activity,
 -- CTD
 wdq.ctd_costs_incurred,
 wdq.ctd_costs_relieved,
 wdq.ctd_elemental_var_relieved ctd_variances_relieved,
 wdq.ctd_single_var_relieved ctd_single_level_var_relieved,
 wdq.ctd_net_activity,
 --
 wdq.class_type_code,
 wdq.class_type_code || &apos; &apos; || wdq.class_type class_type_pivot_label,
 wdq.element_code,
 lpad(wdq.element_code,2) || &apos; &apos; || wdq.element || &apos; - &apos; || wdq.gl_account &quot;Element/Variance Pivot Label&quot;
from
 (
 select
  wdq.job_type,
  wdq.discrete_job_type,
  wdq.class_type_code,
  wdq.class_type,
  wdq.class_code,
  wdq.wip_entity,
  wdq.status,
  wdq.date_closed,
  wdq.release_date,
  wdq.complete_date,
  wdq.period,
  wdq.period_close_date,
  wdq.scheduled_start_date,
  wdq.assembly,
  wdq.item_id,
  wdq.start_quantity,
  wdq.completed_quantity,
  wdq.scrap_quantity,
  wdq.open_quantity,
  wdq.element,
  wdq.gl_account,
  wdq.ptd_costs_incurred,
  wdq.ptd_costs_relieved,
  wdq.ptd_elemental_var_relieved,
  wdq.ptd_single_var_relieved,
  wdq.ptd_net_activity,
  wdq.ctd_costs_incurred,
  wdq.ctd_costs_relieved,
  wdq.ctd_elemental_var_relieved,
  wdq.ctd_single_var_relieved,
  wdq.ctd_net_activity,
  wdq.element_code,
  wdq.organization_id
 from
  wip_detail_q wdq
 where
  lnnvl(:p_display_level=&apos;Job&apos;)
 union all
 select
  y.job_type,
  y.discrete_job_type,
  y.class_type_code,
  y.class_type,
  y.class_code,
  y.wip_entity,
  y.status,
  y.date_closed,
  y.release_date,
  y.complete_date,
  null period,
  to_date(null) period_close_date,
  min(y.scheduled_start_date) scheduled_start_date,
  y.assembly,
  y.item_id,
  y.start_quantity,
  y.completed_quantity,
  y.scrap_quantity,
  y.open_quantity,
  null element,
  null gl_account,
  sum(case when y.acct_period_id=:p_acct_period_id then round(:p_exchange_rate*y.costs_incurred,:p_precision) end) ptd_costs_incurred,
  sum(case when y.acct_period_id=:p_acct_period_id then round(:p_exchange_rate*y.costs_relieved,:p_precision) end) ptd_costs_relieved,
  sum(case when y.acct_period_id=:p_acct_period_id then round(:p_exchange_rate*y.elemental_variances_relieved,:p_precision) end) ptd_elemental_var_relieved,
  sum(case when y.acct_period_id=:p_acct_period_id then round(:p_exchange_rate*y.single_variances_relieved,:p_precision) end) ptd_single_var_relieved,
  sum(case when y.acct_period_id=:p_acct_period_id then round(:p_exchange_rate*y.costs_incurred,:p_precision)-round(:p_exchange_rate*y.costs_relieved,:p_precision)-round(:p_exchange_rate*y.elemental_variances_relieved,:p_precision) end) ptd_net_activity,
  sum(round(:p_exchange_rate*y.costs_incurred,:p_precision)) ctd_costs_incurred,
  sum(round(:p_exchange_rate*y.costs_relieved,:p_precision)) ctd_costs_relieved,
  sum(round(:p_exchange_rate*y.elemental_variances_relieved,:p_precision)) ctd_elemental_var_relieved,
  sum(round(:p_exchange_rate*y.single_variances_relieved,:p_precision)) ctd_single_var_relieved,
  sum(round(:p_exchange_rate*y.costs_incurred,:p_precision)-round(:p_exchange_rate*y.costs_relieved,:p_precision)-round(:p_exchange_rate*y.elemental_variances_relieved,:p_precision)) ctd_net_activity,
  to_number(null) element_code,
  y.organization_id
 from
  (
  select
   wdq.job_type,
   wdq.discrete_job_type,
   wdq.class_type_code,
   wdq.class_type,
   wdq.class_code,
   wdq.wip_entity,
   wdq.status,
   wdq.date_closed,
   wdq.release_date,
   wdq.complete_date,
   wdq.assembly,
   wdq.item_id,
   wdq.start_quantity,
   wdq.completed_quantity,
   wdq.scrap_quantity,
   wdq.open_quantity,
   wdq.organization_id,
   min(wdq.scheduled_start_date) scheduled_start_date,
   wdq.repetitive_schedule_id,
   wdq.acct_period_id,
   sum(nvl(wdq.costs_incurred,0)) costs_incurred,
   sum(nvl(wdq.costs_relieved,0)) costs_relieved,
   sum(nvl(wdq.elemental_variances_relieved,0)) elemental_variances_relieved,
   sum(nvl(wdq.single_variances_relieved,0)) single_variances_relieved
  from
   wip_detail_q wdq
  where
   :p_display_level=&apos;Job&apos;
  group by
   wdq.job_type,
   wdq.discrete_job_type,
   wdq.class_type_code,
   wdq.class_type,
   wdq.class_code,
   wdq.wip_entity,
   wdq.status,
   wdq.date_closed,
   wdq.release_date,
   wdq.complete_date,
   wdq.assembly,
   wdq.item_id,
   wdq.start_quantity,
   wdq.completed_quantity,
   wdq.scrap_quantity,
   wdq.open_quantity,
   wdq.organization_id,
   wdq.repetitive_schedule_id,
   wdq.acct_period_id
  ) y
 group by
  y.job_type,
  y.discrete_job_type,
  y.class_type_code,
  y.class_type,
  y.class_code,
  y.wip_entity,
  y.status,
  y.date_closed,
  y.release_date,
  y.complete_date,
  y.assembly,
  y.item_id,
  y.start_quantity,
  y.completed_quantity,
  y.scrap_quantity,
  y.open_quantity,
  y.organization_id
 ) wdq
where
 1=1
order by
 wdq.job_type,
 wdq.class_type_code,
 wdq.class_code,
 wdq.wip_entity,
 wdq.period_close_date,
 wdq.scheduled_start_date</SQL_TEXT>
  <VERSION_COMMENTS>Added discrete job type, release and completion dates, start, completed, scrap and open quantities, item category columns (Category Set 1 to 3), a Job Status filter and Display Level Job for one row per job</VERSION_COMMENTS>
  <XDO_APPLICATION_SHORT_NAME>WIP</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>WIPUTVAL_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>WIP تقرير قيم ما تحت التنفيذ (بتنسيق XML)</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: تقرير قيمة ما تحت التنفيذ
Application: العمل في الإنجاز
Source: تقرير قيم ما تحت التنفيذ (بتنسيق XML)
Short Name: WIPUTVAL_XML
DB package: WIP_WIPUTVAL_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>WIP Fertigung - Auftragswerte</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Fertigung - Auftragswerte
Application: Fertigung
Source: Fertigung - Auftragswerte (XML)
Short Name: WIPUTVAL_XML
DB package: WIP_WIPUTVAL_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>WIP Etat Valeurs des en-cours</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Etat Valeurs des en-cours
Application: Work In Process
Source: Etat Valeurs des en-cours (XML)
Short Name: WIPUTVAL_XML
DB package: WIP_WIPUTVAL_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>WIP Rapporto Valori WIP</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Rapporto Valori WIP
Application: Work in Process
Source: Rapporto Valori WIP (XML)
Short Name: WIPUTVAL_XML
DB package: WIP_WIPUTVAL_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>WIP Value</REPORT_NAME>
    <DESCRIPTION>Application: Work in Process
Description: WIP Value Report

This report will display Period To Date (PTD) and Cumulative To Date (CTD) WIP costs/variances for the selected period. 

The raw data (without template) provides a breakdown of these values by WIP Cost Type, Class, Discrete Job/Repetitive Schedule, Assembly, Element/Variance GL Account, and Period in which the cost is incurred/relieved.

Display Level Job returns one row per discrete job (per repetitive line and assembly), with the amounts summed over the elements and periods and rounded per period as the Oracle report summary does. Job Status restricts the jobs and schedules, and Category Set 1 to 3 add the assembly&apos;s item category segments as columns. The job type, release and completion dates and the start, completed, scrap and open quantities are shown for discrete jobs.

Templates are provided to detail or summarize the costs as followed:

Applicable Templates:
Pivot: WIP Value by Cost Type, Class - WIP Value Summary by Cost Type, Class with Drill Down to WIP Job Details
Pivot: WIP Value by Cost Type, Class, Element/Variance GL Account - WIP Value by Cost Type, Class, Element/Variance GL Account
Pivot: WIP Value by Element/Variance GL Account - WIP Value Account Summary by Element/Variance GL Account with Drill Down to WIP Job Details
Detail: WIP value detail by WIP Job/Repetitive Schedule - Detail: WIP value detail by WIP Job/Repetitive Schedule
Detail: WIP value detail by Element/Variance GL Account - WIP value detail breakdown at the  Element/Variance GL Account level

Provides equivalent functionality to the following standard Oracle Forms/Reports
- WIP Value Report

Source: WIP Value Report (XML)
Short Name: WIPUTVAL_XML
DB package: WIP_WIPUTVAL_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>WIP 值报表</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: WIP 值报表
Application: 在制品管理系统
Source: WIP 值报表 (XML)
Short Name: WIPUTVAL_XML
DB package: WIP_WIPUTVAL_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>&amp;category_columns</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>2=2</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>3=3</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_struct_num</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_acct_flex</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_acct_period_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_assy_flex</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_class_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_closed_jobs</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_currency_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_debug</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_display_level</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_exchange_rate</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_exchange_rate_char</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_flexwhere</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_flexwhere1</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_flexwhere2</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_flexwhere3</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_from_assembly</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_from_class</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_from_job</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_inverse_rate</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_organization_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_organization_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_outer</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_period_close_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_period_start_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_precision</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_project_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_project_where</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_rate_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_report_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_struct_num</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_to_assembly</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_to_class</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_to_job</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>-50</DISPLAY_SEQUENCE>
    <ANCHOR>:p_precision</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select 
 fc.precision
from 
 fnd_currencies fc
where
 fc.currency_code = :$flex$.Currency_Code</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Précision</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Precision</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>-40</DISPLAY_SEQUENCE>
    <ANCHOR>:p_organization_id</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select
mp.organization_id value
from
mtl_parameters mp
where mp.organization_code=:$flex$.Organization_Code</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>ID de l&apos;organisation</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Organization Id</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>-30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_acct_period_id</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select
acct_period_id
from
org_acct_periods
where organization_id=:$flex$.Organization_ID
and period_name=:$flex$.Period</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>ID de la période</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Period Id</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>-20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_period_start_date</ANCHOR>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select 
 oap.period_start_date
from 
 org_acct_periods oap
where
 oap.acct_period_id = :$flex$.Period_ID and
 oap.organization_id = :$flex$.Organization_ID</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Date de début de la période</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Period Start Date</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>-10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_period_close_date</ANCHOR>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select 
 oap.schedule_close_date
from 
 org_acct_periods oap
where
 oap.acct_period_id = :$flex$.Period_ID and
 oap.organization_id = :$flex$.Organization_ID
</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Date de clôture de la période</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Period Close Date</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_organization_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Organization Code</LOV_NAME>
    <LOV_GUID>8E2FF36EDEB279D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
ood.organization_code value,
ood.organization_name||&apos; (&apos;||ftv.territory_short_name||&apos;, &apos;||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,&apos;, &apos;||mp0.organization_code)||&apos;)&apos; description
from
org_organization_definitions ood,
mtl_parameters mp,
mtl_parameters mp0,
hr_all_organization_units haou,
hr_locations_all hla,
fnd_territories_vl ftv
where
ood.organization_id=mp.organization_id and
mp.organization_id&lt;&gt;mp.master_organization_id and
(
ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) or
not exists (select null from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) and
ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;)
) and
(:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)=&apos;Y&apos;)) and
(:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)=&apos;Y&apos;)) and
nvl(ood.disable_date,sysdate)&gt;=sysdate and
mp.master_organization_id=mp0.organization_id and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+)
order by
ood.organization_code</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>AR</LANGUAGE>
      <PARAMETER_NAME>Org_id</PARAMETER_NAME>
      <DESCRIPTION>معرف التنظيم</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Org_id</PARAMETER_NAME>
      <DESCRIPTION>Organisationskennung</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Code de l&apos;organisation</PARAMETER_NAME>
      <DESCRIPTION>ID organisation</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Org_id</PARAMETER_NAME>
      <DESCRIPTION>Id dell&apos;organizzazione</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
      <DESCRIPTION>Organization Id</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>Org_id</PARAMETER_NAME>
      <DESCRIPTION>组织标识</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_period_name</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
period_name value,
null description
from
org_acct_periods
where organization_id=:$flex$.Organization_ID
order by schedule_close_date desc</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>الفترة</PARAMETER_NAME>
      <DESCRIPTION>الفترة</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Periode</PARAMETER_NAME>
      <DESCRIPTION>Periode</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Période</PARAMETER_NAME>
      <DESCRIPTION>Période</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Periodo</PARAMETER_NAME>
      <DESCRIPTION>Periodo</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Period</PARAMETER_NAME>
      <DESCRIPTION>period</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>期间</PARAMETER_NAME>
      <DESCRIPTION>期间</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_closed_jobs</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>WIP_SRS_YES_NO_MAND</LOV_NAME>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
mfg_lookups
where lookup_type=&apos;SYS_YES_NO&apos;
order by meaning</LOV_QUERY_DSP>
    <DEFAULT_VALUE>1</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>يتضمن أوامر شغل مقفلة</PARAMETER_NAME>
      <DESCRIPTION>أوامر شغل مقفلة</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Mit geschlossenen diskreten Aufträgen</PARAMETER_NAME>
      <DESCRIPTION>Geschlossene diskrete Aufträge</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Inclure les emplois fermés</PARAMETER_NAME>
      <DESCRIPTION>Ordres de fabrication clôturés</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Includi OdL chiusi</PARAMETER_NAME>
      <DESCRIPTION>OdL chiusi</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Include Closed Jobs</PARAMETER_NAME>
      <DESCRIPTION>closed jobs</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>包括已关闭的任务</PARAMETER_NAME>
      <DESCRIPTION>已关闭的任务</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>9</SORT_ORDER>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>:p_closed_jobs=1 and nvl(trunc(wdj.date_closed),:p_period_start_date)&gt;=:p_period_start_date</SQL_TEXT>
    <MATCHING_VALUE>1</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Inclure les emplois fermés</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Include Closed Jobs</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>10</SORT_ORDER>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>:p_closed_jobs=2 and nvl(trunc(wdj.date_closed),:p_period_close_date+1)&gt;:p_period_close_date</SQL_TEXT>
    <MATCHING_VALUE>2</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Inclure les emplois fermés</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Include Closed Jobs</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>11</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>wpb.class_type=:p_class_type_code</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>WIP_SRS_CLASS_TYPE_OPT</LOV_NAME>
    <LOV_QUERY_DSP>select
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where lookup_type=&apos;WIP_CLASS_TYPE&apos;
order by meaning</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>نوع الطبقة</PARAMETER_NAME>
      <DESCRIPTION>نوع الطبقة</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Klassenart</PARAMETER_NAME>
      <DESCRIPTION>Klassenart</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Type de classe</PARAMETER_NAME>
      <DESCRIPTION>Type classe</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Tipo classe</PARAMETER_NAME>
      <DESCRIPTION>Tipo di classe</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Class Type</PARAMETER_NAME>
      <DESCRIPTION>class type</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>分类类型</PARAMETER_NAME>
      <DESCRIPTION>分类类型</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>12</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>wpb.class_type=:p_class_type_code</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Type de classe</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Class Type</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>13</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>wdj.class_code&gt;=:p_class_code_from</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
class_code value,
null description
from
wip_accounting_classes
where organization_id=:$flex$.Organization_ID
and class_type=nvl(:$flex$.Class_Type,
class_type) order by class_code</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>الطبقات من</PARAMETER_NAME>
      <DESCRIPTION>الطبقات من</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Von Klasse</PARAMETER_NAME>
      <DESCRIPTION>Von Klasse</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Classes de</PARAMETER_NAME>
      <DESCRIPTION>Classes - De</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Classi - Da</PARAMETER_NAME>
      <DESCRIPTION>Classi - Da</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Classes From</PARAMETER_NAME>
      <DESCRIPTION>classes from</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>分类自</PARAMETER_NAME>
      <DESCRIPTION>分类自</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>14</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>wri.class_code&gt;=:p_class_code_from</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Classes de</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Classes From</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>15</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>wdj.class_code&lt;=:p_class_code_to</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
class_code value,
null description
from
wip_accounting_classes
where organization_id=:$flex$.Organization_ID
and class_type=nvl(:$flex$.Class_Type,
class_type) order by class_code</LOV_QUERY_DSP>
    <DEFAULT_VALUE>:$flex$.Classes_From</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>إلى</PARAMETER_NAME>
      <DESCRIPTION>الطبقات إلى</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Bis</PARAMETER_NAME>
      <DESCRIPTION>Bis Klasse</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Classes à</PARAMETER_NAME>
      <DESCRIPTION>Classes - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>A</PARAMETER_NAME>
      <DESCRIPTION>Classi - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Classes To</PARAMETER_NAME>
      <DESCRIPTION>classes to</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>至</PARAMETER_NAME>
      <DESCRIPTION>分类至</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>16</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>wri.class_code&lt;=:p_class_code_to</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Classes à</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Classes To</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>17</SORT_ORDER>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>we.wip_entity_name&gt;=:p_job_sch_from</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
wip_entity_name value,
null description
from
wip_entities
where organization_id=:$flex$.Organization_ID
order by wip_entity_name
</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>أوامر الشغل/الجداول من</PARAMETER_NAME>
      <DESCRIPTION>أوامر شغل/جداول من</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Von Fertigungsauftrag</PARAMETER_NAME>
      <DESCRIPTION>Von Fertigungsauftrag</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Travail/horaire de</PARAMETER_NAME>
      <DESCRIPTION>OF/Programmes - De</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>OdL/Programmi da</PARAMETER_NAME>
      <DESCRIPTION>OdL/Programmi - Da</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Job/Schedules From</PARAMETER_NAME>
      <DESCRIPTION>job/schedules from</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>任务/计划自</PARAMETER_NAME>
      <DESCRIPTION>任务/计划自</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>18</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>we.wip_entity_name&gt;=:p_job_sch_from</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Travail/horaire de</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Job/Schedules From</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>19</SORT_ORDER>
    <DISPLAY_SEQUENCE>80</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>we.wip_entity_name&lt;=:p_job_sch_to</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
wip_entity_name value,
null description
from
wip_entities
where organization_id=:$flex$.Organization_ID
order by wip_entity_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>:$flex$.Job_Schedules_From</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>إلى 2</PARAMETER_NAME>
      <DESCRIPTION>أوامر شغل/جداول إلى</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Bis 2</PARAMETER_NAME>
      <DESCRIPTION>Bis Fertigungsauftrag</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Travail/horaire à</PARAMETER_NAME>
      <DESCRIPTION>OF/Programmes - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>A 2</PARAMETER_NAME>
      <DESCRIPTION>OdL/Programmi - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Job/Schedules To</PARAMETER_NAME>
      <DESCRIPTION>job/schedules to</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>至 2</PARAMETER_NAME>
      <DESCRIPTION>任务/计划至</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>20</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>we.wip_entity_name&lt;=:p_job_sch_to</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Travail/horaire à</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Job/Schedules To</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>21</SORT_ORDER>
    <DISPLAY_SEQUENCE>85</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>wdj.status_type=xxen_util.lookup_code(:p_job_status,&apos;WIP_JOB_STATUS&apos;,700)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>WIP Job Status</LOV_NAME>
    <LOV_GUID>8E2FF36EDE9579D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type=&apos;WIP_JOB_STATUS&apos;
order by
ml.meaning</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Job Status</PARAMETER_NAME>
      <DESCRIPTION>Status of the discrete jobs and repetitive schedules</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>22</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>wrs.status_type=xxen_util.lookup_code(:p_job_status,&apos;WIP_JOB_STATUS&apos;,700)</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Job Status</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>23</SORT_ORDER>
    <DISPLAY_SEQUENCE>90</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>msik.concatenated_segments&gt;=:p_assembly_from</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Item</LOV_NAME>
    <LOV_GUID>8E2FF36EDEF179D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
msiv.concatenated_segments value,
msiv.description||&apos; (&apos;||mp.organization_code||&apos;)&apos; description
from
mtl_system_items_vl msiv,
mtl_parameters mp
where
(
:$flex$.organization_code is null and (
fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;) is null and msiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) or
msiv.organization_id=fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;)
) or
xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos;
) and
msiv.organization_id=mp.organization_id
order by
mp.organization_code,
msiv.concatenated_segments</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>المنتجات من</PARAMETER_NAME>
      <DESCRIPTION>المنتجات من</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Von Baugruppe</PARAMETER_NAME>
      <DESCRIPTION>Von Baugruppe</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Assemblages de</PARAMETER_NAME>
      <DESCRIPTION>Produits - De</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Assiemi - Da</PARAMETER_NAME>
      <DESCRIPTION>Assiemi - Da</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Assemblies From</PARAMETER_NAME>
      <DESCRIPTION>assemblies from</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>装配件自</PARAMETER_NAME>
      <DESCRIPTION>装配件自</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>24</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>msik.concatenated_segments&gt;=:p_assembly_from</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Assemblages de</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Assemblies From</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>25</SORT_ORDER>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>msik.concatenated_segments&lt;=:p_assembly_to</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Item</LOV_NAME>
    <LOV_GUID>8E2FF36EDEF179D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
msiv.concatenated_segments value,
msiv.description||&apos; (&apos;||mp.organization_code||&apos;)&apos; description
from
mtl_system_items_vl msiv,
mtl_parameters mp
where
(
:$flex$.organization_code is null and (
fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;) is null and msiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) or
msiv.organization_id=fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;)
) or
xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos;
) and
msiv.organization_id=mp.organization_id
order by
mp.organization_code,
msiv.concatenated_segments</LOV_QUERY_DSP>
    <DEFAULT_VALUE>:$flex$.Assemblies_From</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>إلى 3</PARAMETER_NAME>
      <DESCRIPTION>المنتجات إلى</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Bis 3</PARAMETER_NAME>
      <DESCRIPTION>Bis Baugruppe</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Assemblages à</PARAMETER_NAME>
      <DESCRIPTION>Produits - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>A 3</PARAMETER_NAME>
      <DESCRIPTION>Assiemi - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Assemblies To</PARAMETER_NAME>
      <DESCRIPTION>assemblies to</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>至 3</PARAMETER_NAME>
      <DESCRIPTION>装配件至</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>26</SORT_ORDER>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>msik.concatenated_segments&lt;=:p_assembly_to</SQL_TEXT>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Assemblages à</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Assemblies To</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>27</SORT_ORDER>
    <DISPLAY_SEQUENCE>110</DISPLAY_SEQUENCE>
    <ANCHOR>:p_currency_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>CST_SRS_CURRENCY_CODE</LOV_NAME>
    <LOV_QUERY_DSP>select
currency_code id,
currency_code value,
description description
from
fnd_currencies_vl
where trunc(nvl(start_date_active,sysdate-1))&lt;sysdate and trunc(nvl(end_date_active,sysdate+1))&gt;sysdate
order by value,description</LOV_QUERY_DSP>
    <DEFAULT_VALUE>SELECT GL.CURRENCY_CODE FROM ORG_ORGANIZATION_DEFINITIONS OOD, GL_SETS_OF_BOOKS GL WHERE OOD.ORGANIZATION_ID = fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;) AND GL.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>رمز العملة</PARAMETER_NAME>
      <DESCRIPTION>رمز العملة</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Währungsschlüssel</PARAMETER_NAME>
      <DESCRIPTION>Währung</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Code devise</PARAMETER_NAME>
      <DESCRIPTION>Code devise</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Codice divisa</PARAMETER_NAME>
      <DESCRIPTION>Codice divisa</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Currency Code</PARAMETER_NAME>
      <DESCRIPTION>currency code</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>币种代码</PARAMETER_NAME>
      <DESCRIPTION>币种代码</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>28</SORT_ORDER>
    <DISPLAY_SEQUENCE>120</DISPLAY_SEQUENCE>
    <ANCHOR>:p_exchange_rate_char</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
actual_rate value,
period description
from
cst_gl_translation_view
where org_id=:$flex$.Organization_ID
and code=:$flex$.Currency_Code
and inverse=fnd_profile.value(&apos;DISPLAY_INVERSE_RATE&apos;)
and rate_type=2
order by period_year desc,period_num desc</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>سعر الصرف</PARAMETER_NAME>
      <DESCRIPTION>سعر الصرف</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Wechselkurs</PARAMETER_NAME>
      <DESCRIPTION>Kurs</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Taux de change</PARAMETER_NAME>
      <DESCRIPTION>Taux de change</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Tasso di cambio</PARAMETER_NAME>
      <DESCRIPTION>Tasso di cambio</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Exchange Rate</PARAMETER_NAME>
      <DESCRIPTION>exchange rate</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>汇率</PARAMETER_NAME>
      <DESCRIPTION>汇率</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>29</SORT_ORDER>
    <DISPLAY_SEQUENCE>130</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>wdj.project_id=:p_project_id</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
project_id id,
name value,
segment1 description
from
pa_projects_all
where project_id in(
select ppp.project_id
from pjm_project_parameters ppp
where ppp.organization_id=
   (select organization_id 
    from mtl_parameters 
    where organization_id=:$flex$.Organization_ID and 
              project_reference_enabled=1 and 
              cost_group_accounting=1
   )
)
order by value,description</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>معرف المشروع</PARAMETER_NAME>
      <DESCRIPTION>معرف المشروع</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Projektkennung</PARAMETER_NAME>
      <DESCRIPTION>Projektkennung</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Id. du projet</PARAMETER_NAME>
      <DESCRIPTION>ID projet</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Id progetto</PARAMETER_NAME>
      <DESCRIPTION>Id progetto</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Project</PARAMETER_NAME>
      <DESCRIPTION>Project Id</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>项目标识</PARAMETER_NAME>
      <DESCRIPTION>项目标识</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>30</SORT_ORDER>
    <DISPLAY_SEQUENCE>140</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;category_columns</ANCHOR>
    <SQL_TEXT>select xxen_util.item_category_columns(p_category_set_name=&gt;&apos;&lt;parameter_value&gt;&apos;,p_table_alias=&gt;&apos;wdq&apos;,p_item_id_column=&gt;&apos;item_id&apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <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>Category Set 1</PARAMETER_NAME>
      <DESCRIPTION>Item category set whose segments and description are shown as columns for the assembly</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>31</SORT_ORDER>
    <DISPLAY_SEQUENCE>145</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;category_columns</ANCHOR>
    <SQL_TEXT>select xxen_util.item_category_columns(p_category_set_name=&gt;&apos;&lt;parameter_value&gt;&apos;,p_table_alias=&gt;&apos;wdq&apos;,p_item_id_column=&gt;&apos;item_id&apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <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>Category Set 2</PARAMETER_NAME>
      <DESCRIPTION>Item category set whose segments and description are shown as columns for the assembly</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>32</SORT_ORDER>
    <DISPLAY_SEQUENCE>150</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;category_columns</ANCHOR>
    <SQL_TEXT>select xxen_util.item_category_columns(p_category_set_name=&gt;&apos;&lt;parameter_value&gt;&apos;,p_table_alias=&gt;&apos;wdq&apos;,p_item_id_column=&gt;&apos;item_id&apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <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>Category Set 3</PARAMETER_NAME>
      <DESCRIPTION>Item category set whose segments and description are shown as columns for the assembly</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>33</SORT_ORDER>
    <DISPLAY_SEQUENCE>155</DISPLAY_SEQUENCE>
    <ANCHOR>:p_display_level</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select &apos;Element/Variance&apos; value, &apos;One row per job or schedule, period and element or variance&apos; description from dual union all
select &apos;Job&apos; value, &apos;One row per job or repetitive line and assembly, amounts summed over the periods and elements&apos; description from dual</LOV_QUERY_DSP>
    <DEFAULT_VALUE>Element/Variance</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Display Level</PARAMETER_NAME>
      <DESCRIPTION>Element/Variance: one row per period and element or variance. Job: one row per job, amounts rounded per period as the Oracle WIP Value Report summary</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>BA099B4C731D5EFB1CAAA56ED8EFA8B3</GUID>
    <TEMPLATE_NAME>Detail: WIP value detail by Element/Variance GL Account</TEMPLATE_NAME>
    <DESCRIPTION>WIP value detail breakdown at the  Element/Variance GL Account level</DESCRIPTION>
    <OWNER>SYSADMIN</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSEMBLY</COLUMN_NAME>
      <SORT_ORDER>6</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS</COLUMN_NAME>
      <SORT_ORDER>4</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_CODE</COLUMN_NAME>
      <SORT_ORDER>3</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CURRENCY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ELEMENT_CODE</COLUMN_NAME>
      <SORT_ORDER>8</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>EXCHANGE_RATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Element/Variance</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>GL_ACCOUNT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
      <COLUMN_NAME>JOB_TYPE</COLUMN_NAME>
      <SORT_ORDER>2</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Job/Line</COLUMN_NAME>
      <SORT_ORDER>5</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION</COLUMN_NAME>
      <SORT_ORDER>1</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>START_DATE</COLUMN_NAME>
      <SORT_ORDER>7</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
    </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>
    <TEMPLATE_CONDITIONS>
    </TEMPLATE_CONDITIONS>
   </TEMPLATES_ROW>
   <TEMPLATES_ROW>
    <GUID>67A8BA5DE5D32C446F0246C2FBACE075</GUID>
    <TEMPLATE_NAME>Detail: WIP value detail by WIP Job/Repetitive Schedule</TEMPLATE_NAME>
    <DESCRIPTION>WIP value detail by WIP Job/Repetitive Schedule</DESCRIPTION>
    <OWNER>SYSADMIN</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSEMBLY</COLUMN_NAME>
      <SORT_ORDER>6</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS</COLUMN_NAME>
      <SORT_ORDER>4</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_CODE</COLUMN_NAME>
      <SORT_ORDER>3</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CURRENCY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>EXCHANGE_RATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>JOB_TYPE</COLUMN_NAME>
      <SORT_ORDER>2</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Job/Line</COLUMN_NAME>
      <SORT_ORDER>5</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION</COLUMN_NAME>
      <SORT_ORDER>1</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>START_DATE</COLUMN_NAME>
      <SORT_ORDER>7</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
    </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>
    <TEMPLATE_CONDITIONS>
    </TEMPLATE_CONDITIONS>
   </TEMPLATES_ROW>
   <TEMPLATES_ROW>
    <GUID>6E9398567AECB5159A9E36FEB5BE0F59</GUID>
    <TEMPLATE_NAME>Pivot: WIP Value by Cost Type, Class</TEMPLATE_NAME>
    <DESCRIPTION>WIP Value Summary by Cost Type, Class with Drill Down to WIP Job Details</DESCRIPTION>
    <OWNER>SYSADMIN</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSEMBLY</COLUMN_NAME>
      <SORT_ORDER>5</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS</COLUMN_NAME>
      <SORT_ORDER>3</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_CODE</COLUMN_NAME>
      <SORT_ORDER>2</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_PIVOT_LABEL</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CURRENCY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>EXCHANGE_RATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>JOB_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Job/Line</COLUMN_NAME>
      <SORT_ORDER>4</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION</COLUMN_NAME>
      <SORT_ORDER>1</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>START_DATE</COLUMN_NAME>
      <SORT_ORDER>6</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CLASS</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CLASS_TYPE_PIVOT_LABEL</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>JOB_TYPE</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
    </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>
    <TEMPLATE_CONDITIONS>
    </TEMPLATE_CONDITIONS>
   </TEMPLATES_ROW>
   <TEMPLATES_ROW>
    <GUID>B61D0EC9FA74D9602A2F9CE5A32973F5</GUID>
    <TEMPLATE_NAME>Pivot: WIP Value by Cost Type, Class, Element/Variance GL Account</TEMPLATE_NAME>
    <DESCRIPTION>WIP Value Summary by Cost Type, Class, Element/Variance with Drill Down to WIP Job Details</DESCRIPTION>
    <OWNER>SYSADMIN</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSEMBLY</COLUMN_NAME>
      <SORT_ORDER>6</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS</COLUMN_NAME>
      <SORT_ORDER>4</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_PIVOT_LABEL</COLUMN_NAME>
      <SORT_ORDER>3</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CURRENCY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ELEMENT_CODE</COLUMN_NAME>
      <SORT_ORDER>8</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>EXCHANGE_RATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Element/Variance</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Element/Variance Pivot Label</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>GL_ACCOUNT</COLUMN_NAME>
      <SORT_ORDER>9</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
      <COLUMN_NAME>JOB_TYPE</COLUMN_NAME>
      <SORT_ORDER>2</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Job/Line</COLUMN_NAME>
      <SORT_ORDER>5</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION</COLUMN_NAME>
      <SORT_ORDER>1</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>START_DATE</COLUMN_NAME>
      <SORT_ORDER>7</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CLASS</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CLASS_TYPE_PIVOT_LABEL</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>Element/Variance Pivot Label</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>JOB_TYPE</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
    </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>
    <TEMPLATE_CONDITIONS>
    </TEMPLATE_CONDITIONS>
   </TEMPLATES_ROW>
   <TEMPLATES_ROW>
    <GUID>76B79105137BA330B968C0DFBAC240A1</GUID>
    <TEMPLATE_NAME>Pivot: WIP Value by Element/Variance GL Account</TEMPLATE_NAME>
    <DESCRIPTION>WIP Value Account Summary by Element/Variance GL Account with Drill Down to WIP Job Details</DESCRIPTION>
    <OWNER>SYSADMIN</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSEMBLY</COLUMN_NAME>
      <SORT_ORDER>7</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS</COLUMN_NAME>
      <SORT_ORDER>6</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_CODE</COLUMN_NAME>
      <SORT_ORDER>5</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CLASS_TYPE_PIVOT_LABEL</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CURRENCY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ELEMENT_CODE</COLUMN_NAME>
      <SORT_ORDER>2</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>EXCHANGE_RATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Element/Variance</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Element/Variance Pivot Label</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>GL_ACCOUNT</COLUMN_NAME>
      <SORT_ORDER>3</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
      <COLUMN_NAME>JOB_TYPE</COLUMN_NAME>
      <SORT_ORDER>4</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>Job/Line</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION</COLUMN_NAME>
      <SORT_ORDER>1</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
      <COLUMN_NAME>START_DATE</COLUMN_NAME>
      <SORT_ORDER>8</SORT_ORDER>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_COSTS_INCURRED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_COSTS_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_NET_ACTIVITY</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>CTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>Element/Variance Pivot Label</COLUMN_NAME>
      <FIELD_TYPE>ROW</FIELD_TYPE>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_COSTS_INCURRED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_COSTS_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_NET_ACTIVITY</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_SINGLE_LEVEL_VAR_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
     <TEMPLATE_PIVOT_ROW>
      <COLUMN_NAME>PTD_VARIANCES_RELIEVED</COLUMN_NAME>
      <FIELD_TYPE>VALUE</FIELD_TYPE>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <AGGREGATION>SUM</AGGREGATION>
     </TEMPLATE_PIVOT_ROW>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
    </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>
    <TEMPLATE_CONDITIONS>
    </TEMPLATE_CONDITIONS>
   </TEMPLATES_ROW>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
   <DEFAULT_TEMPLATES_ROW>
    <USER_NAME>SYSADMIN</USER_NAME>
    <TEMPLATE_GUID>B61D0EC9FA74D9602A2F9CE5A32973F5</TEMPLATE_GUID>
   </DEFAULT_TEMPLATES_ROW>
   <DEFAULT_TEMPLATES_ROW>
    <TEMPLATE_GUID>6E9398567AECB5159A9E36FEB5BE0F59</TEMPLATE_GUID>
   </DEFAULT_TEMPLATES_ROW>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
