<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 Service Contracts, Service Contract Contact Details -->
 <REPORTS_ROW>
  <GUID>EEE75CEB4AA36AD8E05362FB09051F8B</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
x.*
from
(
select * from (SELECT     ecc_spec_id,
  language_code,
  contract_id,
  contract_number,
  contract_modifier,
  contact_role,
  contact_name,
  contact_status,
  contact_email_address,
  contact_start_date,
  contact_end_date ,
  contract_status_group,
  contract_end_date,
  contract_termination_date
 FROM oks_k_contact_ecc_v WHERE (
    (contract_end_date &gt;=  NVL(fnd_date.canonical_to_date(fnd_profile.value(&apos;OKS_ECC_CONTARCT_FROM_DATE&apos;)),sysdate))
     and language_code in (&apos;US&apos;) ))
pivot
(
max(contact_role)	as	contact_role
  for language_code 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: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>ECC Service Contracts, Servicevertrag - Kontaktdetails</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>ECC Service Contracts, Detalles de Contacto de Contrato de Servicio</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>ECC Service Contracts, Contrat de service - Détails contacts</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>ECC Contratti di assistenza, Dettagli contatto contratto di assistenza</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>ECC Service Contracts, サービス契約担当者詳細</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>ECC Service Contracts, 서비스 계약 담당자 상세내역</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_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: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>ECC Servicekontrakt, Servicekontrakt, kontaktdetaljer</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>ECC Servis Sözleşmeleri, Servis Sözleşmesi Sözleşme Detayları</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>ECC Service Contracts, Service Contract Contact Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_ecc_datasecurity_pkg_pub.GetFilterAttributeValues</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>ECC Service Contracts, 服务合同联系人详细信息</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-contact
Query Procedure: oks_ecc_util_pvt.get_ecc_data_load_info
Security Procedure: oks_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>
