<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: OKL Principal Paydown Statement -->
 <REPORTS_ROW>
  <GUID>82288223F2293869E053B46B63588994</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>  SELECT RECEIVABLE_APPLICATION_ID,
         TRANSACTION_TYPE, 
         INVOICE_NUMBER, 
         INVOICE_DATE, 
         TRANSACTION_AMOUNT,
         AMOUNT_APPLIED,
         AMOUNT_REMAINING,
         PAYMENT_METHOD,
         RECEIPT_NUMBER, 
         RECEIPT_AMOUNT,
         RECEIPT_DATE,
         CONTRACT_NUMBER,
         DUE_DATE,
         PAYMENT_APPLICATION_DATE, 
         APPLICATION_STATUS,
         LINE_IDENTIFIER,
         RECEIPT_CURRENCY_CODE,
         INVOICE_CURRENCY_CODE, 
         RECEIPT_METHOD_ID,
         CASH_RECEIPT_ID,
         INVOICE_ID,
         KHR_ID,
         CUST_ACCOUNT_ID, 
         RECEIPT_TYPE_CODE,
         ORG_ID,
         CUSTOMER_ID,
         RECEIPT_STATUS_CODE,
         RECEIPT_STATUS, 
         INVOICE_LINE_ID,
         ADVANCED_YN,
         CUSTOMER_ACCOUNT_NUMBER
FROM OKL_CS_TRX_PAYMENTS_UV
WHERE KHR_ID = :P_CONTRACT_ID
AND TRANSACTION_TYPE IN
(SELECT CODE
 FROM OKL_STRM_TYPE_B
 WHERE STREAM_TYPE_PURPOSE = &apos;UNSCHEDULED_PRINCIPAL_PAYMENT&apos;)
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>OKL</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>OKLPRINPAYDOWN</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>OKL كشف حساب سداد الجزء الرئيسي من القرض</REPORT_NAME>
    <DESCRIPTION>Application: إدارة الإيجار
Source: 
Short Name: OKLPRINPAYDOWN
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>OKL Auszug Tilgung für Kapitalsumme</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLPRINPAYDOWN
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>OKL Relevé de règlement en réduction du principal</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLPRINPAYDOWN
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>OKL Principal Paydown Statement</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLPRINPAYDOWN
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>OKL 本金即时支付对帐单</REPORT_NAME>
    <DESCRIPTION>Application: Oracle Lease and Finance Management
Source: 
Short Name: OKLPRINPAYDOWN
DB package: </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_contract_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>
