<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 Lease Shipping Instructions -->
 <REPORTS_ROW>
  <GUID>82288223F22D3869E053B46B63588994</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>  SELECT    AR.KLE_ID                           KLE_ID,
            AR.DATE_RETURN_DUE                  DATE_RETURN_DUE,
            CP.CONTACT_PARTY_ID                 PAC_ID, 
            CONTACT_PARTY_NAME                  CONTACT_PARTY_NAME,
            CDL.NAME                            ASSET_NUMBER,
            CDL.ITEM_DESCRIPTION               ASSET_DESCRIPTION, 
            CHR.CUST_ACCT_ID                    CUST_ACCOUNT_ID,
            CHR.AUTHORING_ORG_ID                ORG_ID,
            CHR.CONTRACT_NUMBER                CONTRACT_NUMBER,
            OALV.SERIAL_NUMBER SERIAL_NUMBER, 
            OALV.MODEL_NUMBER MODEL_NUMBER,
            OALV.ORIGINAL_COST ASSET_COST
    FROM    OKL_ASSET_RETURNS_B       AR,
            OKL_RELOCATE_ASSETS_B     RA,
            OKL_AM_CONTACT_POINTS_UV  CP,
            OKL_AM_CONTACTS_UV        C,
            OKL_K_LINES_FULL_V CDL ,
            OKC_LINE_STYLES_B LSTY,
            OKC_K_HEADERS_B CHR,
            OKX_ASSET_LINES_V OALV
    WHERE    AR.ID               = :P_ART_ID
    AND      AR.ID               = RA.ART_ID
    AND      PAC_ID              = CP.CONTACT_CONTACT_POINT_ID
    AND      CP.CONTACT_PARTY_ID = C.CONTACT_PARTY_ID
    AND      CDL.LSE_ID          = LSTY.ID 
    AND      LSTY.LTY_CODE       =&apos;FREE_FORM1&apos;
    AND    CDL.DNZ_CHR_ID = CHR.ID
    AND      AR.KLE_ID           = CDL.ID
    AND      CDL.ID = OALV.PARENT_LINE_ID 
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>OKL</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>OKLSHIPINSTR</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>OKL إرشادات الشحن بعقد الإيجار</REPORT_NAME>
    <DESCRIPTION>Application: إدارة الإيجار
Source: 
Short Name: OKLSHIPINSTR
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>OKL Leasing - Versandanweisungen</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLSHIPINSTR
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>OKL Crédit-bail - Instructions de livraison</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLSHIPINSTR
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>OKL Lease Shipping Instructions</REPORT_NAME>
    <DESCRIPTION>Application: Lease and Finance Management
Source: 
Short Name: OKLSHIPINSTR
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: OKLSHIPINSTR
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_art_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>
