<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 Notify Title Filing Authority -->
 <REPORTS_ROW>
  <GUID>82288223F2343869E053B46B63588994</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>SELECT TO_CHAR(sysdate, &apos;MM-DD-YYYY&apos;)  SYSTEM_DATE,
	 OADT.CONTRACT_NUMBER CONTRACT_NUMBER ,
	 OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME(&apos;OKX_VENDOR&apos;,OPRV.OBJECT1_ID1, OPRV.OBJECT1_ID2) TITLE_FILING_AUTHORITY,
	 OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME(&apos;OKX_PARTY&apos;,OPPV.OBJECT1_ID1, OPPV.OBJECT1_ID2) LESSEE,
	 OADT.SERIAL_NUMBER SERIAL_NUMBER,
	 OADT.MODEL_NUMBER MODEL_NUMBER,
	 OADT.NAME ASSET_NUMBER,
	 OADT.ITEM_DESCRIPTION ASSET_DESCRIPTION,
	 OTQV.COMMENTS COMMENTS
FROM  OKL_AM_ASSET_DETAILS_UV OADT,
	OKL_TRX_QUOTES_V        OTQV,
	OKC_K_PARTY_ROLES_V     OPPV,
	OKC_K_PARTY_ROLES_V     OPRV
WHERE	OADT.CHR_ID = OTQV.KHR_ID
AND OPPV.chr_id = OTQV.khr_id
AND OPPV.jtot_object1_code = &apos;OKX_PARTY&apos;
AND  OPPV.RLE_CODE = &apos;LESSEE&apos;
AND OPRV.chr_id = OTQV.khr_id
AND OPRV.jtot_object1_code = &apos;OKX_VENDOR&apos;
and OTQV.id = : P_QUOTE_ID 
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>OKL</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>OKLTITLEFILING</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>OKL تبليغ جهة الحفظ/الملكية</REPORT_NAME>
    <DESCRIPTION>Application: إدارة الإيجار
Source: 
Short Name: OKLTITLEFILING
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>OKL Behörde für Eigentumsrecht und Eintragungen benachrichtigen</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLTITLEFILING
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>OKL Aviser l&apos;administration d&apos;enregistrement des titres</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLTITLEFILING
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>OKL Notify Title Filing Authority</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLTITLEFILING
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: OKLTITLEFILING
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</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>
