<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 Billing Details -->
 <REPORTS_ROW>
  <GUID>EEE75CEB4AA16AD8E05362FB09051F8B</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
x.*
from
(
select * from (select
okbs.id ECC_SPEC_ID,
amount AMOUNT,
okcl.dnz_chr_id CONTRACT_ID ,
date_billed_from BILL_DATE
from oks_bill_sub_lines  okbs,
okc_k_lines_b okcl
where okcl.id=okbs.cle_id
 and okcl.cle_id is not null
 and okcl.lse_id=13
 and okcl.end_date &gt;=  NVL(fnd_date.canonical_to_date(fnd_profile.value(&apos;OKS_ECC_CONTARCT_FROM_DATE&apos;)),sysdate))
) x
where
2=2</SQL_TEXT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>ECC عقود الخدمة, Service Contract Billing Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-bill-details
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, Service Contract Billing Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-bill-details
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 Контракты на обслуживание, Service Contract Billing Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-bill-details
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, Service Contract Billing Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-bill-details
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, Service Contract Billing Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-bill-details
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 Billing Details</REPORT_NAME>
    <DESCRIPTION>Imported from Enterprise Command Center
Dataset Key: oks-bill-details
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>
