<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: ECC Discrete Completions, Assembly Completion Transactions -->
 <REPORTS_ROW>
  <GUID>EEE75CEB4B016AD8E05362FB09051F8B</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
x.*
from
(
 SELECT * FROM (SELECT /*+ leading(mmt) index(mmt MTL_MATERIAL_TRANSACTIONS_N5) cardinality(mmt10) */
                                            mmt.transaction_id          ecc_spec_id,
                                            we.wip_entity_id,
                                            we.wip_entity_name          job_name,
                                            mp.organization_id,
                                            mp.organization_code,
                                            org_name_lkp.name organization_name,
                                            org_name_lkp.language language,
                                            entity_source_lkp.meaning entity_source,
                                            entity_name_lkp.meaning job_type,
                                            transaction_lkp.meaning transaction_meaning,
                                           &apos;fwkhp_sswafunc.gif&apos; as ITEM_LINK, /* view_item_lkp.meaning */
                                           &apos;fwkhp_sswafunc.gif&apos; as QUALITY_LINK, /* view_quality_lkp.meaning  quality_link */
                                            status_lkp.meaning    job_status,
                                            wdj.status_type job_status_flag,
                                            mmt.transaction_date    completion_date,
                                            mmt.inventory_item_id,
                                            msi.concatenated_segments   assembly,
                                            msi.description             assembly_description,
                                            msi.primary_uom_code        primary_uom_code,
                                            msi.fixed_lead_time         fixed_lead_time,
                                            msi.variable_lead_time      variable_lead_time,
                                            msi.planner_code            planner,
                                            CASE
                                                    WHEN mmt.transaction_type_id = 44 THEN
                                                        mmt.primary_quantity
                                                    ELSE
                                                        0
                                            END completed_quantity,
                                            CASE
                                                    WHEN mmt.transaction_type_id = 90 THEN
                                                        mmt.primary_quantity
                                                    ELSE
                                                        0
                                            END scrap_quantity,
                                            CASE
                                                    WHEN mmt.transaction_type_id = 17 THEN
                                                        ABS(mmt.primary_quantity)
                                                    ELSE
                                                        0
                                            END return_quantity,
                                            decode(msi.base_item_id, NULL, NULL, WIP_ECC_WC_PVT.get_concatenated_segments(msi.organization_id, msi.base_item_id)) base_model
                                            ,
                                            (
                                                SELECT
                                                    acat.concatenated_segments
                                                FROM
                                                    mtl_item_catalog_groups_b_kfv acat
                                                WHERE
                                                    acat.item_catalog_group_id = msi.item_catalog_group_id
                                            ) assembly_catalog_category,
                                            we.entity_type,
                                            abs(mmt.primary_quantity) primary_quantity,
                                            abs(mmt.transaction_quantity) transaction_quantity,
                                            mmt.transaction_uom,
                                            mmt.transaction_action_id,
                                            mmt.transaction_type_id,
                                            mmt.transaction_date,
                                            mmt.subinventory_code,
                                            decode(mp.project_reference_enabled, NULL, milk.concatenated_segments, 2, milk.concatenated_segments,
                                                   1, inv_project.get_pjm_locsegs(milk.concatenated_segments)) completion_locator,
                                            mtr.description             transaction_reason_desc,
                                            mtr.reason_name             transaction_reason,
                                            (
                                                SELECT
                                                    mtt.transaction_type_name
                                                FROM
                                                    mtl_transaction_types mtt
                                                WHERE
                                                    mtt.transaction_type_id = mmt.transaction_type_id
                                            ) transaction_type_name,
                                            (
                                                SELECT
                                                    schedule_group_name
                                                FROM
                                                    wip_schedule_groups
                                                WHERE
                                                    schedule_group_id = decode(we.entity_type, 4, wfs.schedule_group_id, wdj.schedule_group_id)
                                            ) schedule_group,
                                            decode(we.entity_type, 4, wfs.build_sequence, wdj.build_sequence) build_sequence,
                                            decode(we.entity_type, 4, wfs.alternate_bom_designator, wdj.alternate_bom_designator) alternate_bom_designator,
                                            decode(we.entity_type, 4, wfs.bom_revision, wdj.bom_revision) bom_revision,
                                            decode(we.entity_type, 4, wfs.bom_revision_date, wdj.bom_revision_date) bom_revision_date,
                                            decode(we.entity_type, 4, wfs.alternate_routing_designator, wdj.alternate_routing_designator) alternate_routing_designator,
                                            decode(we.entity_type, 4, wfs.routing_revision, wdj.routing_revision) routing_revision,
                                            decode(we.entity_type, 4, wfs.routing_revision_date, wdj.routing_revision_date) routing_revision_date,
                                            nvl(ppa.name, psn.project_name) project_name,
                                            nvl(ppa.segment1, psn.project_number) project_number,
                                            decode(we.entity_type, 4, wfs.end_item_unit_number, wdj.end_item_unit_number) end_item_unit_number,
                                            pat.task_name               task_name,
                                            pat.task_number             task_number,
                                            decode(we.entity_type, 4, wfs.demand_class, wdj.demand_class) demand_class
                                        FROM
                                            mtl_material_transactions   mmt,
                                            wip_entities                we,
                                            wip_discrete_jobs           wdj,
                                            mtl_transaction_reasons     mtr,
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    wip_flow_schedules
                                                WHERE
                                                    scheduled_flag = 2
                                            ) wfs,
                                            mtl_parameters              mp,
                                            pa_projects_all             ppa,
                                            pjm_seiban_numbers          psn,
                                            pa_tasks                    pat,
                                            mtl_system_items_vl         msi,
                                            mtl_item_locations_kfv      milk ,
                                            (
                                                SELECT
                                                    haout.name ,haout.language , haout.organization_id
                                                FROM
                                                    hr_all_organization_units_tl haout
                                            ) org_name_lkp,
                                            (
                                                SELECT
                                                    meaning ,language,lookup_code
                                                FROM
                                                    fnd_lookup_values
                                                WHERE
                                                    lookup_type = &apos;WIP_ENTITY&apos;
                                                    AND view_application_id = 700
                                                    AND security_group_id = 0
                                            ) entity_source_lkp,
                                           (
                                                SELECT
                                                    meaning ,lookup_code
                                                FROM
                                                    fnd_lookup_values
                                                WHERE
                                                    lookup_type = &apos;WIP_ENTITY&apos;
                                                    AND view_application_id = 700
                                                    AND security_group_id = 0
                                                    AND language = &apos;US&apos;
                                            ) entity_name_lkp,
                                           (
                                                SELECT
                                                    ml1.meaning,
                                                    ml1.lookup_code,
                                                    ml1.language
                                                FROM
                                                    fnd_lookup_values ml1
                                                WHERE
                                                    ml1.lookup_type = &apos;WIP_JOB_STATUS&apos;
                                                    AND ml1.view_application_id = 700
                                                    AND ml1.security_group_id = 0
                                            ) status_lkp ,
                                           (
                                                SELECT
                                                    ml1.meaning,
                                                    ml1.lookup_code,
                                                    ml1.language
                                                FROM
                                                    fnd_lookup_values ml1
                                                WHERE
                                                    ml1.lookup_type = &apos;WIP_COMP_ECC_TXN_TYPE&apos;
                                                    AND ml1.view_application_id = 700
                                                    AND ml1.security_group_id = 0
                                            ) transaction_lkp
                                           /* (
                                                SELECT
                                                    ml1.meaning,
                                                    ml1.lookup_code,
                                                    ml1.language
                                                  FROM fnd_lookup_values ml1
                                                  WHERE ml1.lookup_type       = &apos;WIP_VIEW_QUALITY_NC&apos;
                                                  AND ml1.view_application_id = 700
                                                  AND ml1.security_group_id   = 0
                                                  AND ml1.lookup_code         = 2
                                             ) view_quality_lkp,*/
                                           /*  (
                                                  SELECT
                                                    ml1.meaning,
                                                    ml1.lookup_code,
                                                    ml1.language
                                                  FROM fnd_lookup_values ml1
                                                  WHERE ml1.lookup_type       = &apos;WIP_VIEW_ITEM&apos;
                                                  AND ml1.view_application_id = 700
                                                  AND ml1.security_group_id   = 0
                                                  AND ml1.lookup_code         = 1
                                              ) view_item_lkp */

                                        WHERE
                                            mmt.transaction_source_type_id = 5
                                            AND mmt.transaction_action_id IN (
                                                31,
                                                32
                                            )
                                            AND mmt.transaction_source_id = we.wip_entity_id
                                            AND mmt.organization_id = msi.organization_id
                                            AND mmt.inventory_item_id = msi.inventory_item_id
                                            AND we.entity_type IN (
                                                1,
                                                3,
                                                4
                                            )
                                            AND mp.organization_id = mmt.organization_id
                                            AND we.wip_entity_id = wdj.wip_entity_id (+)
                                            AND mmt.locator_id = milk.inventory_location_id (+)
                                            AND we.wip_entity_id = wfs.wip_entity_id (+)
                                            AND mmt.transaction_date &gt; TO_DATE(&apos;12-NOV-22 10:13:51&apos;,&apos;DD-MON-RR HH24:MI:SS&apos;)
                                            AND mmt.transaction_date &lt;= TO_DATE(&apos;12-DEC-22 10:13:51&apos;,&apos;DD-MON-RR HH24:MI:SS&apos;)
                                            AND mmt.reason_id = mtr.reason_id (+)
                                            AND mmt.source_project_id = ppa.project_id (+)
                                            AND mmt.source_project_id = psn.project_id (+)
                                            AND mmt.source_task_id = pat.task_id (+)
                                            AND mmt.transaction_type_id = transaction_lkp.lookup_code
                                            AND entity_name_lkp.lookup_code = to_char(we.entity_type)
                                            AND entity_source_lkp.lookup_code = to_char(we.entity_type)
                                            AND entity_source_lkp.language = org_name_lkp.language
                                            AND org_name_lkp.organization_id = mp.organization_id
                                            AND status_lkp.language = org_name_lkp.language
                                            AND status_lkp.lookup_code = to_char(decode(we.entity_type,4,12,wdj.status_type))
                                          /*  AND view_item_lkp.language = org_name_lkp.language
                                            AND view_quality_lkp.language = org_name_lkp.language */


                                    AND org_name_lkp.language IN (&apos;US&apos;)) PIVOT (
                                MAX ( organization_name )
                            AS organization_name, MAX ( entity_source ) AS entity_source ,/* MAX( item_link ) AS item_link,MAX( quality_link) AS quality_link,*/ MAX( job_status ) AS job_status FOR language  IN (&apos;US&apos; &quot;US&quot;))
) x
where
2=2</SQL_TEXT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>ECC عمليات الإتمام المنفصلة, حركات إتمام المنتج</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>ECC Diskrete Fertigmeldungen, Fertigmeldungen für Baugruppen</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>ECC Discrete Completions, Transacciones de Finalización de Conjuntos</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>ECC Fab. discrète - Fins prod., Déclarations de fin de production</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>ECC Completamenti discreti, Transazioni completamento assieme</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>ECC ショップ型完了, 組立完了取引</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>ECC 단속 완료, 조립품 완료 트랜잭션</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>ECC Завершения сборок, Транзакции завершения сборки</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>ECC Diskret tillv.: Färdigställ., Transaktioner för produktfärdigställande</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>ECC Kesikli Tamamlamalar, Ürün Tamamlama İşlemleri</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>ECC Discrete Completions, Assembly Completion Transactions</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>ECC 离散完成, 装配件完成事务处理</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: wip-com-completiontxns
Query Procedure: WIP_ECC_WC_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: wip_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enterprise Command Center</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
  </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>