<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 Mass Return Components for Serialized Assembly -->
 <REPORTS_ROW>
  <GUID>82288223F50D3869E053B46B63588994</GUID>
  <SQL_TEXT>select  
mp.organization_code,
wtr.program_source,
wtr.last_updated_by,
msik.concatenated_segments item_name,
we.wip_entity_name job_name, 
wtr.attribute1 parent_serial,
wtr.attribute2 component_serial,
wtr.attribute3 lot_number,
wtr.attribute4 revision,
wtr.attribute5 error_explanation,
wtr.attribute6 subinventory,
milk.concatenated_segments locator,
wtr.key1 request_id,
wtr.key2 quantity,
wtr.key3 op_seq_num,
wtr.key4 process_flag,
wtr.key5 transaction_id,
wtr.date1 creation_date,
msik.description description
from wip_temp_reports wtr,
wip_entities we,
mtl_system_items_kfv msik,
mtl_parameters mp,
mtl_item_locations_kfv milk
where wtr.program_source = &apos;WIPDEKIT&apos;
and we.wip_entity_id = wtr.wip_entity_id
and we.organization_id = wtr.organization_id
and msik.inventory_item_id = wtr.inventory_item_id
and msik.organization_id = wtr.organization_id
and mp.organization_id = wtr.organization_id
and wtr.organization_id = milk.organization_id (+)
and wtr.key6 = milk.inventory_location_id (+)
and wtr.organization_id = :P_ORG_ID
and wtr.wip_entity_id = :P_WIP_ENTITY_ID
and wtr.attribute1 = :P_SERIAL_NUM
and wtr.key1 = :P_CONC_REQUEST_ID
and wtr.key4 = 3
order by item_name
</SQL_TEXT>
  <DISABLED>Y</DISABLED>
  <XDO_APPLICATION_SHORT_NAME>WIP</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>WIPDEKIT_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>WIP تقرير مكونات المرتجعات المجمعة للمنتج المسلسل</REPORT_NAME>
    <DESCRIPTION>Application: العمل في الإنجاز
Source: تقرير مكونات المرتجعات المجمعة للمنتج المسلسل
Short Name: WIPDEKIT_XML
DB package: WIP_WIPDEKIT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>WIP Globale Rücksendung von Komponenten für Baugruppen mit Seriennummern</REPORT_NAME>
    <DESCRIPTION>Application: Fertigung
Source: Globale Rücksendung von Komponenten für Baugruppen mit Seriennummern
Short Name: WIPDEKIT_XML
DB package: WIP_WIPDEKIT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>WIP Etat Retour en masse de composants pour produits suivis par numéros de série</REPORT_NAME>
    <DESCRIPTION>Application: Work In Process
Source: Etat Retour en masse de composants pour produits suivis par numéros de série
Short Name: WIPDEKIT_XML
DB package: WIP_WIPDEKIT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>WIP Mass Return Components for Serialized Assembly</REPORT_NAME>
    <DESCRIPTION>Application: Work in Process
Source: Mass Return Components for Serialized Assembly Report
Short Name: WIPDEKIT_XML
DB package: WIP_WIPDEKIT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>WIP 序列化装配件报表对应的成批退回组件</REPORT_NAME>
    <DESCRIPTION>Application: 在制品管理系统
Source: 序列化装配件报表对应的成批退回组件
Short Name: WIPDEKIT_XML
DB package: WIP_WIPDEKIT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>:p_assembly</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_clean_up</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_job</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_locator</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_org_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_org_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_reason_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_reason_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_reference</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_serial_num</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_subinventory</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_wip_entity_id</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
