<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>
<LOVS>
<!-- loader xml for Enginatics Blitz Report lov: HR Operating Unit -->
 <LOVS_ROW>
  <GUID>8E2FF36EDEB979D2E0530100007F1FF2</GUID>
  <LOV_NAME>HR Operating Unit</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select
hou.name value,
null description
from
hr_operating_units hou
where
sysdate between hou.date_from and nvl(hou.date_to,sysdate) and
(:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)=&apos;Y&apos;)) and
hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)
order by
hou.name</LOV_QUERY>
  <VERSION_COMMENTS>Fixed where clause duplication</VERSION_COMMENTS>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <DESCRIPTION>وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <DESCRIPTION>Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <DESCRIPTION>Unidad operativa restringida por el control de acceso multiorgánico (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <DESCRIPTION>Unité opérationnelle restreinte par un contrôle d&apos;accès multi-organismes (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <DESCRIPTION>Unità operativa limitata dal controllo di accesso multiorgano (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <DESCRIPTION>多機関アクセス制御(MOAC)で制限された操作ユニット</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <DESCRIPTION>다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <DESCRIPTION>Unidade operacional restrita por controle de acesso multi org (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <DESCRIPTION>Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <DESCRIPTION>Styrenhet begränsad av multi-org access control (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <DESCRIPTION>Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <DESCRIPTION>Operating unit restricted by multi org access control (MOAC)</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <DESCRIPTION>受多机构访问控制（MOAC）限制的操作单元。</DESCRIPTION>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
</LOVS>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: AP Invoice Audit by Voucher Number- Not Supported: Reserved For Future Use -->
 <REPORTS_ROW>
  <GUID>C6E085D4722D51A9E05362FB09050512</GUID>
  <SQL_TEXT>select a.*,
AP_APXINVAD_XMLP_PKG.c_new_recordsformula(a.doc_sequence_value) C_new_records,
	AP_APXINVAD_XMLP_PKG.C_last_value_p C_last_value from
(select aud.doc_sequence_value,
           aud.doc_sequence_id,
           aud.creation_date,
decode(i.doc_sequence_value,null,:C_deleted,:C_entered) status,
            dsc.name category,
            v.segment1 vendor_num,
            hp.party_name,
            i.invoice_num,
            i.invoice_currency_code,
            i.invoice_amount,
            l.displayed_field paid
from    ap_lookup_codes l,
            ap_doc_sequence_audit aud,
            fnd_doc_sequence_assignments dsa,
            fnd_doc_sequence_categories dsc,
            hz_parties hp,
            ap_suppliers v,
            ap_invoices i
where aud.doc_sequence_id = :C_sequence_id
and     aud.doc_sequence_id = i.doc_sequence_id(+)
and     aud.doc_sequence_value =                 i.doc_sequence_value(+)
and     aud.doc_sequence_value between :P_sequence_from and :P_sequence_to
and     aud.doc_sequence_assignment_id = dsa.doc_sequence_assignment_id
and     dsa.category_code = dsc.code
and     dsa.application_id = dsc.application_id
and     i.party_id = hp.party_id (+)
and     hp.party_id = v.party_id(+)
and     l.lookup_type(+) = &apos;INVOICE PAYMENT STATUS&apos;
and     l.lookup_code(+) = i.payment_status_flag
order by aud.doc_sequence_value) a
</SQL_TEXT>
  <DISABLED>Y</DISABLED>
  <XDO_APPLICATION_SHORT_NAME>SQLAP</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>APXINVAD_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>AP مراجعة الفاتورة حسب رقم الإيصال (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: تدقيق الفاتورة بواسطة رقم الإيصال
Application: المدفوعات
Source: مراجعة الفاتورة حسب رقم الإيصال (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>AP Rechnungsprotokoll nach Belegnummer- Nicht unterstützt: Reserviert für zukünftige Verwendung</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Rechnungsprotokoll nach Belegnummer
Application: Kreditoren
Source: Rechnungsprotokoll nach Belegnummer (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>AP Auditoría de Facturas por Número de Justificante: No Admitido, Reservado para Uso Futuro</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Auditoría de Facturas por Número de Justificante
Application: Payables
Source: Auditoría de Facturas por Número de Justificante (XML): No Admitido, Reservado para Uso Futuro
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>AP Contrôle des factures par pièce justificative- Non pris en charge : réservé pour une utilisation future</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Contrôle des factures par pièce justificative
Application: Payables
Source: Contrôle des factures par pièce justificative (XML) - Non pris en charge : réservé pour une utilisation future
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>AP Audit fatture per numero giustificativo- non supportato: riservato per usi futuri</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Audit fatture per numero giustificativo
Application: Payables
Source: Audit fatture per numero giustificativo (XML) - non supportato: riservato per usi futuri
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>AP 証憑番号に基づく請求書監査- 未サポート: 将来の使用のために予約</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 証憑番号に基づく請求書監査
Application: Payables
Source: 証憑番号に基づく請求書監査(XML) - 未サポート: 将来の使用のために予約
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>AP 증빙 번호별 송장 감사- 지원되지 않음: 추후 사용을 위해 예약됨</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 증빙 번호별 송장 감사
Application: Payables
Source: 증빙 번호별 송장 감사(XML) - 지원되지 않음: 추후 사용을 위해 예약됨
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>AP Auditoria de NFF por Número do Voucher- Não Suportado: Reservado Para Uso Futuro</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Auditoria de NFF por Nr. do Voucher
Application: Payables
Source: Auditoria de NFF por Número do Voucher (XML) - Não Suportado: Reservado Para Uso Futuro
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>AP Аудит счетов-фактур по номерам квитанций- не поддерживается: зарезервировано для будущего использования</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Аудит счетов-фактур по номерам квитанций
Application: Кредиторы
Source: Аудит счетов-фактур по номерам квитанций (XML) - не поддерживается: зарезервировано для будущего использования
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>AP Fakturakontroll per ver.nr- Stöds inte: Reserverad för framtida bruk</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Fakturakontroll per ver.nr
Application: Payables
Source: Fakturakontroll per ver.nr (XML) - Stöds inte: Reserverad för framtida bruk
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>AP Makbuz Numarasına Göre Fatura Denetimi- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Makbuz Numarasına Göre Fatura Denetimi
Application: Borçlar Muhasebesi
Source: Makbuz Numarasına Göre Fatura Denetimi (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>AP Invoice Audit by Voucher Number- Not Supported: Reserved For Future Use</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Invoice Audit by Voucher Number
Application: Payables
Source: Invoice Audit by Voucher Number (XML) - Not Supported: Reserved For Future Use
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>AP 按凭证编号审核发票- 不支持：已保留供将来使用</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 按凭证编号审核发票
Application: 应付帐款
Source: 按凭证编号审核发票 (XML) - 不支持：已保留供将来使用
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_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>:c_base_currency_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_base_description</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_base_min_acct_unit</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_base_precision</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_chart_of_accounts_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_company_name_header</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_deleted</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_entered</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_last_value</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_nls_all</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_nls_end_of_report</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_nls_no</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_nls_no_data_exists</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_nls_yes</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_report_start_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_sequence_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:operating_unit</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_debug_switch</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_min_precision</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_sequence_from</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_sequence_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_sequence_to</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_set_of_books_id</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>-20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_set_of_books_id</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>fnd_profile.value(&apos;GL_SET_OF_BKS_ID&apos;)</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>دفتر الأستاذ</PARAMETER_NAME>
      <DESCRIPTION>دفتر الأستاذ</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Buch</PARAMETER_NAME>
      <DESCRIPTION>Buch</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Libro Mayor</PARAMETER_NAME>
      <DESCRIPTION>Libro mayor</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Livre</PARAMETER_NAME>
      <DESCRIPTION>Livre</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Libro contabile</PARAMETER_NAME>
      <DESCRIPTION>Libro contabile</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>元帳</PARAMETER_NAME>
      <DESCRIPTION>元帳</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>원장</PARAMETER_NAME>
      <DESCRIPTION>원장</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Razão</PARAMETER_NAME>
      <DESCRIPTION>Razão</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Книга</PARAMETER_NAME>
      <DESCRIPTION>Книга</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Huvudbok</PARAMETER_NAME>
      <DESCRIPTION>Huvudbok </DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Defter</PARAMETER_NAME>
      <DESCRIPTION>Defter</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Ledger</PARAMETER_NAME>
      <DESCRIPTION>Ledger</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>分类帐</PARAMETER_NAME>
      <DESCRIPTION>分类帐</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>0</DISPLAY_SEQUENCE>
    <ANCHOR>:operating_unit</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>HR Operating Unit</LOV_NAME>
    <LOV_GUID>8E2FF36EDEB979D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
hou.name value,
null description
from
hr_operating_units hou
where
sysdate between hou.date_from and nvl(hou.date_to,sysdate) and
(:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)=&apos;Y&apos;)) and
hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)
order by
hou.name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
haouv.name
from
hr_all_organization_units_vl haouv
where
haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value(&apos;DEFAULT_ORG_ID&apos;),mgoat.organization_id) and rownum=1),fnd_global.org_id)</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Operating Unit</PARAMETER_NAME>
      <DESCRIPTION>Required Operating Unit restriction for reports working in single operating unit mode only</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_sequence_name</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>AP_SRS_INV_SEQUENCES</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
name id,
name value,
null description
from
fnd_document_sequences fds
where application_id=200
and (table_name=&apos;AP_INVOICES&apos;
or table_name=&apos;AP_INVOICES_ALL&apos;)
and exists
(select &apos;CURRENT SOB&apos;
from fnd_doc_sequence_assignments fdsa,
ap_system_parameters asp
where fdsa.doc_sequence_id=fds.doc_sequence_id
and (fdsa.set_of_books_id is null or
fdsa.set_of_books_id=asp.set_of_books_id))
order by value,description</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>اسم المسلسل</PARAMETER_NAME>
      <DESCRIPTION>اسم المسلسل</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Folge</PARAMETER_NAME>
      <DESCRIPTION>Folge</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Nombre de Secuencia</PARAMETER_NAME>
      <DESCRIPTION>Nombre de Secuencia</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Code journal</PARAMETER_NAME>
      <DESCRIPTION>Code journal</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Nome sequenza</PARAMETER_NAME>
      <DESCRIPTION>Nome della sequenza</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>連番名</PARAMETER_NAME>
      <DESCRIPTION>連番名</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>순서명</PARAMETER_NAME>
      <DESCRIPTION>순서명</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Nome da Sequência</PARAMETER_NAME>
      <DESCRIPTION>Nome da Sequência</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Имя последовательности</PARAMETER_NAME>
      <DESCRIPTION>Имя последовательности</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Sekvensnamn</PARAMETER_NAME>
      <DESCRIPTION>Sekvensnamn</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Sıra Adı</PARAMETER_NAME>
      <DESCRIPTION>Sıra Adı</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Sequence Name</PARAMETER_NAME>
      <DESCRIPTION>Sequence Name</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>序列名</PARAMETER_NAME>
      <DESCRIPTION>序列名</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_sequence_from</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>رقم الإيصال من</PARAMETER_NAME>
      <DESCRIPTION>رقم الإيصال من</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Von Belegnummer</PARAMETER_NAME>
      <DESCRIPTION>Von Belegnummer</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>De Número de Justificante</PARAMETER_NAME>
      <DESCRIPTION>De Número de Justificante</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Numéro de pièce - De</PARAMETER_NAME>
      <DESCRIPTION>Numéro de pièce - De</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Numero giustificativo - Da</PARAMETER_NAME>
      <DESCRIPTION>Numero giustificativo - Da</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>証憑番号:自</PARAMETER_NAME>
      <DESCRIPTION>証憑番号:自</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>증빙 번호: 부터</PARAMETER_NAME>
      <DESCRIPTION>증빙 번호: 부터</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Nr. do Voucher De</PARAMETER_NAME>
      <DESCRIPTION>Nr. do Voucher De</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>№ квитанции с</PARAMETER_NAME>
      <DESCRIPTION>№ квитанции с</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Från verifikatnummer</PARAMETER_NAME>
      <DESCRIPTION>Från verifikatnummer</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>İlk Makbuz Numarası</PARAMETER_NAME>
      <DESCRIPTION>İlk Makbuz Numarası</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Voucher Number From</PARAMETER_NAME>
      <DESCRIPTION>Voucher Number From</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>凭证编号自</PARAMETER_NAME>
      <DESCRIPTION>凭证编号自</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_sequence_to</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>رقم الإيصال إلى</PARAMETER_NAME>
      <DESCRIPTION>رقم الإيصال إلى</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Bis Belegnummer</PARAMETER_NAME>
      <DESCRIPTION>Bis Belegnummer</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>A Número de Justificante</PARAMETER_NAME>
      <DESCRIPTION>A Número de Justificante</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Numéro de pièce - A</PARAMETER_NAME>
      <DESCRIPTION>Numéro de pièce - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Numero giustificativo - A</PARAMETER_NAME>
      <DESCRIPTION>Numero giustificativo - A</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>証憑番号:至</PARAMETER_NAME>
      <DESCRIPTION>証憑番号:至</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>증빙 번호: 까지</PARAMETER_NAME>
      <DESCRIPTION>증빙 번호: 까지</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Número do Voucher - Até</PARAMETER_NAME>
      <DESCRIPTION>Número do Voucher - Até</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Конечный номер квитанции</PARAMETER_NAME>
      <DESCRIPTION>Конечный номер квитанции</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Till verifikatnummer</PARAMETER_NAME>
      <DESCRIPTION>Till verifikatnummer</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Son Makbuz Numarası</PARAMETER_NAME>
      <DESCRIPTION>Son Makbuz Numarası</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Voucher Number To</PARAMETER_NAME>
      <DESCRIPTION>Voucher Number To</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>凭证编号至</PARAMETER_NAME>
      <DESCRIPTION>凭证编号至</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
