<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: FA Mass Additions Invoice Split - draft -->
 <REPORTS_ROW>
  <GUID>82288223F1E73869E053B46B63588994</GUID>
  <SQL_TEXT>SELECT  ad.asset_number				Asset_Number,
	ai.description				Description,
	ve.segment1||&apos; - &apos;||ve.vendor_name	Vendor,
	ai.invoice_number			Invoice_Number,
	ai.invoice_line_number||&apos; - &apos;||ai.ap_distribution_line_number		Line,
	&amp;ACCT_FLEX_ACCT_SEG                     Payable_Account,
	cb.asset_cost_acct			Assets_Account,
	ai.payables_cost			Payable_Cost,
	books.cost				Assets_Cost,
	--ADDED
	fnd_flex_xml_publisher_apis.process_kff_combination_1(&apos;d_payable_account&apos;, &apos;SQLGL&apos;, &apos;GL#&apos;, glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, &apos;GL_ACCOUNT&apos;, &apos;Y&apos;, &apos;VALUE&apos;) D_PAYABLE_ACCOUNT
FROM	
	fa_system_controls			sc,
	fa_transaction_headers			th,
	fa_asset_invoices			ai,
	fa_additions				ad,
	fa_books				books,
	fa_asset_history			ah,
	fa_category_books			cb,
	po_vendors				ve,
	gl_code_combinations			glcc
WHERE 	
	th.date_effective &gt;= :PERIOD1_POD AND
	th.date_effective &lt;= :PERIOD1_PCD AND
	th.book_type_code = :P_BOOK AND
	th.transaction_type_code  in (&apos;ADDITION&apos;, &apos;CIP ADDITION&apos;)
AND
	ai.asset_id = th.asset_id				AND
	ai.split_code = &apos;SC&apos;
AND
	ad.asset_id = ai.asset_id
AND
	books.transaction_header_id_in = th.transaction_header_id
AND
	ve.vendor_id = ai.po_vendor_id
AND
	ah.asset_id		  = ai.asset_id			AND
	ah.date_effective &lt;= :PERIOD1_PCD AND
	nvl(ah.date_ineffective, sysdate) &gt;= :PERIOD1_PCD
	AND
	cb.category_id		  = ah.category_id		AND
	cb.book_type_code	  = th.book_type_code
AND
	ai.payables_code_combination_id = glcc.code_combination_id
ORDER BY 
	ad.asset_number,
	ai.invoice_number,
	ai.invoice_Line_number||&apos; - &apos;||ai.ap_distribution_line_number
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>OFA</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>FASMAISP_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>FA تقرير تجزئة فاتورة الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل</REPORT_NAME>
    <DESCRIPTION>Application: الأصول
Source: تقرير تجزئة فاتورة الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل
Short Name: FASMAISP_XML
DB package: FA_FASMAISP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>FA Globale Zugänge, Rechnungen aufteilen- Nicht unterstützt: Reserviert für zukünftige Verwendung</REPORT_NAME>
    <DESCRIPTION>Application: Anlagen
Source: Globale Zugänge, Rechnungen aufteilen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung
Short Name: FASMAISP_XML
DB package: FA_FASMAISP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>FA Etat des acquisitions en haut volume issues de l&apos;éclatement de lignes de facture- Non pris en charge : réservé pour une utilisation ultérieure</REPORT_NAME>
    <DESCRIPTION>Application: Assets
Source: Etat des acquisitions en haut volume issues de l&apos;éclatement de lignes de facture (XML) - Non pris en charge : réservé pour une utilisation ultérieure
Short Name: FASMAISP_XML
DB package: FA_FASMAISP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>FA Mass Additions Invoice Split - draft</REPORT_NAME>
    <DESCRIPTION>Application: Assets
Source: Mass Additions Invoice Split Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASMAISP_XML
DB package: FA_FASMAISP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>FA 成批增加发票分解报表- 不支持：已保留供将来使用</REPORT_NAME>
    <DESCRIPTION>Application: 资产
Source: 成批增加发票分解报表 (XML) - 不支持：已保留供将来使用
Short Name: FASMAISP_XML
DB package: FA_FASMAISP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>&amp;acct_flex_acct_seg</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:accounting_flex_structure</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:currency_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_book</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_min_precision</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_period1</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:period1_fy</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:period1_pc</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:period1_pcd</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:period1_pod</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_company_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_data_found</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_report_name</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_book</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>FA_CORP_BOOK</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
book_type_code id,
book_type_code value,
book_type_name description
from
fa_book_controls_sec
where book_class=&apos;CORPORATE&apos;
order by book_type_code
</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>الدفتر</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>AfA-Buch</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Livre</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Book</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>帐簿</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_period1</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>FA_PERIOD_NAME_CORP</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
period_name id,
period_name value,
null description
from
fa_deprn_periods
where book_type_code=:$flex$.fa_corp_book
and period_counter&gt;(select min(dp2.period_counter)
from fa_deprn_periods dp2
where dp2.book_type_code=:$flex$.fa_corp_book)
order by period_counter
</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>الفترة</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Periode</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Période</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Period</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>期间</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.fa_corp_book</FLEX_BIND>
    <PARAMETER_NAME>Book</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Period</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
