<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 Sales Credit Details -->
 <REPORTS_ROW>
  <GUID>EEE75CEB4AA66AD8E05362FB09051F8B</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
x.*
from
(
select * from (SELECT    ecc_spec_id,
  language_code,
  linesalescreditid,
  linesalesperson,
  linesalesgroup,
  linesalescredittype,
  linequotapercent,
  linenonquota,
  contract_id,
  contract_line_id,
  contract_number,
  contract_modifier,
  line_number  ,
  CONTRACT_STATUS_GROUP,
  CONTRACT_END_DATE,
  CONTRACT_TERMINATION_DATE
 FROM oks_k_sales_credit_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(lineSALESGROUP)	as	lineSALESGROUP
  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-salescredit
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 - Umsatzgutschriftsdetails</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
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 Crédito de Ventas Contrato de Servicio</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
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 commissions</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
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 base provvigioni contratto di assistenza</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
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-salescredit
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-salescredit
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-salescredit
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, detaljer om säljprovision</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
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 Satış Kredisi Detayları</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
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 Sales Credit Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-contract-salescredit
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-salescredit
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>
