<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: ONT Unbooked Orders Detail -->
 <REPORTS_ROW>
  <GUID>C6E085D4710451A9E05362FB09050512</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
h.order_number,
            h.ordered_date,
            ot.name order_type,
            UPPER(REPLACE(SUBSTR(ppf_mgr.email_address, 1,
                      DECODE(INSTR(ppf_mgr.email_address, &apos;.&apos;),
	        0, LENGTH(ppf_mgr.email_address),
	       INSTR(ppf_mgr.email_address, &apos;.&apos;) -1)), &apos;@&apos;, &apos;_&apos;)) manager,
            fu.user_name,
            l.item_identifier_type,
            decode (l.item_identifier_type, &apos;INT&apos;, &amp;rp_item_flex_all_seg, &apos;CUST&apos;, ci.customer_item_number, l.ordered_item)
Item,
            msi.description Internal_Item_Desc,
DECODE(l.line_category_code,&apos;RETURN&apos;, nvl(l.unit_selling_price,0) * nvl(l.ordered_quantity,0)  * -1,
               nvl(l.unit_selling_price,0) * nvl(l.ordered_quantity,0))  line_amt ,
            h.transactional_curr_code,
            h.conversion_rate        Conversion_rate ,
            h.conversion_type_code Conversion_Type_Code ,
	    substrb(bill_to_PARTY.PARTY_NAME,1,50) bill_to,
	    substrb(sold_to_PARTY.PARTY_NAME,1,50) sold_to,
            h.cust_po_number,
            l.charge_periodicity_code,
	ONT_OEXOEUBD_XMLP_PKG.c_precisionformula(h.transactional_curr_code) C_precision,
	ONT_OEXOEUBD_XMLP_PKG.c_recur_chargesformula(l.charge_periodicity_code) C_recur_charge_periodicity,
	ONT_OEXOEUBD_XMLP_PKG.c_line_amtformula(h.transactional_curr_code, DECODE ( l.line_category_code , &apos;RETURN&apos; , nvl ( l.unit_selling_price , 0 ) * nvl ( l.ordered_quantity , 0 ) * - 1 , nvl ( l.unit_selling_price , 0 ) * nvl ( l.ordered_quantity , 0 ) ), h.conversion_type_code, h.ordered_date, h.conversion_rate) C_line_amt
	--,	&amp;Item_dsp Item_Dsp
from        fnd_user fu,
            mtl_system_items_vl msi,
            oe_order_lines_all l,
            oe_order_headers_all h,
            oe_order_types_v ot,
            mtl_customer_items ci,
	   hz_cust_site_uses_all  bill_site,
	   hz_cust_acct_sites_all acct_site,
	   hz_party_sites party_site,
           -- hz_loc_assignments loc_assign, --bug 10050232
           hz_locations loc,
	   hz_parties bill_to_party,
           hz_cust_accounts bill_to_cust_acct ,
	   hz_parties sold_to_party,
           hz_cust_accounts sold_to_cust_acct ,
            per_all_people_f ppf_mgr,
            per_all_assignments_f paf,
            per_all_people_f ppf
where     h.header_id = l.header_id
   AND bill_to_CUST_ACCT.PARTY_ID = bill_to_PARTY.PARTY_ID (+)
   AND sold_to_CUST_ACCT.PARTY_ID = sold_to_PARTY.PARTY_ID (+)
   AND acct_site.party_site_id = party_site.party_site_id(+)
   AND party_site.location_id  = loc.location_id (+)
   -- AND loc.location_id = loc_assign.location_id  (+) --bug 10050232 
   -- AND NVL (acct_site.org_id, -99) = NVL (loc_assign.org_id, -99) --bug 10050232 
and       l.inventory_item_id = msi.inventory_item_id
and       h.order_type_id(+) = ot.order_type_id
and       h.created_by = fu.user_id
AND 	  SYSDATE BETWEEN NVL(PPF.EFFECTIVE_START_DATE(+) , SYSDATE) AND
                          NVL(PPF.EFFECTIVE_END_DATE(+) , SYSDATE+1)
and       fu.employee_id = ppf.person_id(+)
and       ppf.person_id = paf.person_id(+)
AND 	  SYSDATE BETWEEN NVL(PAF.EFFECTIVE_START_DATE(+) , SYSDATE) AND
                          NVL(PAF.EFFECTIVE_END_DATE(+) , SYSDATE+1)
and       paf.supervisor_id = ppf_mgr.person_id(+)
AND 	  SYSDATE BETWEEN NVL(PPF_MGR.EFFECTIVE_START_DATE(+) , SYSDATE) AND
                          NVL(PPF_MGR.EFFECTIVE_END_DATE(+) , SYSDATE+1)
and       nvl(l.booked_flag, &apos;N&apos;) =&apos;N&apos;
and       (l.cancelled_flag =&apos;N&apos; or l.cancelled_flag is null)
and       nvl(msi.organization_id,0) = nvl(oe_sys_parameters.value(&apos;MASTER_ORGANIZATION_ID&apos;,mo_global.get_current_org_id()),0)
and       l.ordered_item_id = ci.customer_item_id(+)
and       l.open_flag =&apos;Y&apos;
--and       nvl(l.org_id,0) = nvl(:p_organization_id,0)
and       nvl(l.org_id,0) = nvl(:p_organization_id_v,0)
--and       nvl(h.org_id,0) = nvl(:p_organization_id,0)
and       nvl(h.org_id,0) = nvl(:p_organization_id_v,0)
and       l.sold_to_org_id = sold_to_CUST_ACCT.CUST_ACCOUNT_ID(+)
and       bill_site.CUST_ACCT_SITE_ID = acct_site.cust_acct_site_id(+)
and       acct_site.cust_account_id =  bill_to_CUST_ACCT.CUST_ACCOUNT_ID(+)
and       l.invoice_to_org_id= bill_site.site_use_id(+)
&amp;lp_created_by
&amp;lp_order_date
&amp;lp_order_type
&amp;lp_manager
UNION ALL
select
  h.order_number,
             h.ordered_date,
             ot.name order_type,
             UPPER(REPLACE(SUBSTR(ppf_mgr.email_address, 1,
	   DECODE(INSTR(ppf_mgr.email_address, &apos;.&apos;),
	   0, LENGTH(ppf_mgr.email_address),
	   INSTR(ppf_mgr.email_address, &apos;.&apos;) -1)), &apos;@&apos;, &apos;_&apos;)) manager,
              fu.user_name,
              NULL  item_identifier_type,
              &apos;    &apos;item,
              &apos;     &apos;Internal_Item_Desc,
              0 line_amt,
              h.transactional_curr_code,
              h.conversion_rate        Conversion_rate ,
              h.conversion_type_code Conversion_Type_Code ,
              substrb(bill_to_PARTY.PARTY_NAME,1,50) bill_to,
              substrb(sold_to_PARTY.PARTY_NAME,1,50) sold_to,
              h.cust_po_number,
              NULL charge_periodicity_code,
	ONT_OEXOEUBD_XMLP_PKG.c_precisionformula(h.transactional_curr_code) C_precision,
	ONT_OEXOEUBD_XMLP_PKG.c_recur_chargesformula(NULL) C_recur_charge_periodicity,
	--ONT_OEXOEUBD_XMLP_PKG.c_line_amtformula(h.transactional_curr_code, DECODE ( l.line_category_code , &apos;RETURN&apos; , nvl ( l.unit_selling_price , 0 ) * nvl ( l.ordered_quantity , 0 ) * - 1 , nvl ( l.unit_selling_price , 0 ) * nvl ( l.ordered_quantity , 0 ) ), h.conversion_type_code, h.ordered_date, h.conversion_rate) C_line_amt
	ONT_OEXOEUBD_XMLP_PKG.c_line_amtformula(h.transactional_curr_code, 0,h.conversion_type_code,h.ordered_date,h.conversion_rate) C_line_amt
	--, &amp;Item_dsp Item_Dsp
from      oe_order_headers_all h,
          oe_order_types_v ot,
	  hz_cust_site_uses_all bill_site,
	  hz_party_sites party_site,
          -- hz_loc_assignments loc_assign, -- bug 10050232 
          hz_locations loc,
          hz_cust_acct_sites_all acct_site,
	  hz_parties bill_to_party,
          hz_cust_accounts bill_to_cust_acct ,
	  hz_parties sold_to_party,
          hz_cust_accounts sold_to_cust_acct ,
	  per_all_people_f ppf_mgr,
          per_all_assignments_f paf,
          per_all_people_f ppf,
          fnd_user fu
where    h.created_by = fu.user_id
       AND acct_site.party_site_id = party_site.party_site_id (+)
       AND party_site.location_id = loc.location_id (+)
       -- AND loc.location_id = loc_assign.location_id (+) --bug 10050232 
       -- AND NVL (acct_site.org_id, -99) = NVL (loc_assign.org_id, -99) --bug 10050232 
       AND bill_to_cust_acct.party_id = bill_to_party.party_id (+)
       AND sold_to_cust_acct.party_id = sold_to_party.party_id (+)
and        h.booked_flag  =&apos;N&apos;
and        (h.cancelled_flag =&apos;N&apos; or h.cancelled_flag is null)
and        h.open_flag = &apos;Y&apos;
and        h.order_type_id(+) = ot.order_type_id
and        fu.employee_id = ppf.person_id(+)
AND 	  SYSDATE BETWEEN NVL(PPF.EFFECTIVE_START_DATE(+) , SYSDATE) AND
                          NVL(PPF.EFFECTIVE_END_DATE(+) , SYSDATE+1)
and        ppf.person_id = paf.person_id(+)
AND 	  SYSDATE BETWEEN NVL(PAF.EFFECTIVE_START_DATE(+) , SYSDATE) AND
                          NVL(PAF.EFFECTIVE_END_DATE(+) , SYSDATE+1)
and        paf.supervisor_id = ppf_mgr.person_id(+)
AND 	  SYSDATE BETWEEN NVL(PPF_MGR.EFFECTIVE_START_DATE(+) , SYSDATE) AND
                          NVL(PPF_MGR.EFFECTIVE_END_DATE(+) , SYSDATE+1)
and        h.sold_to_org_id = sold_to_CUST_ACCT.CUST_ACCOUNT_ID (+)
and        bill_site. CUST_ACCT_SITE_ID = acct_site.cust_acct_site_id (+)
and       acct_site.cust_account_id =  bill_to_CUST_ACCT.CUST_ACCOUNT_ID(+)
and        h.invoice_to_org_id= bill_site.site_use_id(+)
--and        nvl(h.org_id,0) = nvl(:p_organization_id,0)
and        nvl(h.org_id,0) = nvl(:p_organization_id_v,0)
and        not exists
              (select &apos;X&apos; from oe_order_lines_all  b
                where  h.header_id = b.header_id
	        --and nvl(b.org_id,0) = nvl(:p_organization_id,0) )
	        and nvl(b.org_id,0) = nvl(:p_organization_id_v,0) )
&amp;lp_created_by
&amp;lp_order_date
&amp;lp_order_type
&amp;lp_manager
&amp;lp_order_by
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>ONT</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>OEXOEUBD_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>ONT تقرير تفاصيل الطلبات غير المحجوزة</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: تقرير تفاصيل الطلبات غير المحجوزة
Application: إدارة الطلبات
Source: تقرير تفاصيل الطلبات غير المحجوزة (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>ONT Nicht gebuchte Aufträge - Details</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Auswertung &quot;Nicht gebuchte Aufträge - Details&quot;
Application: Order Management
Source: Nicht gebuchte Aufträge - Details (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>ONT Informe Detalle de Pedidos Sin Registrar</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Informe Detalle de Pedidos Sin Registrar
Application: Order Management
Source: Informe Detalle de Pedidos Sin Registrar (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>ONT Etat détaillé des commandes non validées</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Etat détaillé des commandes non validées
Application: Order Management
Source: Etat détaillé des commandes non validées (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>ONT Rapporto Dettagli ordini non registrati</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Rapporto Dettagli ordini non registrati
Application: Order Management
Source: Rapporto Dettagli ordini non registrati (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>ONT 未記帳受注詳細レポート</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 未記帳受注詳細レポート
Application: Order Management
Source: 未記帳受注詳細レポート(XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>ONT 확정되지 않은 주문 상세 보고서</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 예약되지 않은 주문 상세내역 보고서
Application: Order Management
Source: 확정되지 않은 주문 상세 보고서(XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>ONT Relatório Detalhado de Ordens Não Registradas</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Relatório Detalhado de Ordens Não Registradas
Application: Gerenciamento de Ordens
Source: Relatório Detalhado de Ordens Não Registradas (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>ONT Подробный отчет о неразмещенных заказах</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Подробный отчет о неразмещенных заказах
Application: Управление заказами
Source: Подробный отчет о неразмещенных заказах (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>ONT Obokade order - detaljrapport</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Obokade order - detaljrapport
Application: Order Management
Source: Obokade order - detaljrapport (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>ONT Kaydedilmemiş Siparişler Detay Raporu</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Kaydedilmemiş Siparişler Detay Raporu
Application: Sipariş Yönetimi(1)
Source: Kaydedilmemiş Siparişler Detay Raporu (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>ONT Unbooked Orders Detail</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Unbooked Orders Detail Report
Application: Order Management
Source: Unbooked Orders Detail Report (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>ONT 未登记订单详细信息报表</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 撤消登记订单详细资料报表
Application: 订单管理
Source: 未登记订单详细信息报表 (XML)
Short Name: OEXOEUBD_XML
DB package: ONT_OEXOEUBD_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;item_dsp</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_created_by</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_manager</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_order_by</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_order_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;lp_order_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;rp_item_flex_all_seg</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:f_periodicity</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:l_order_type_high</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:l_order_type_low</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:l_use_functional_currency</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_created_by</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_created_by_range</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_line_category</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_manager</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_manager_range</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_order_by</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_order_by_mean</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_order_category</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_order_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_order_date_range</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_order_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:lp_order_type_range</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_created_by_high</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_created_by_low</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_item_flex_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_item_structure_num</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_line_category</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_manager_high</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_manager_low</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_one_time</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_by</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_category</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_date_high</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_date_high_v</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_date_low</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_date_low_v</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_type_high</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_order_type_low</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_organization_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_organization_id_v</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_print_description</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_sob_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_use_functional_currency</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_c_ext_total_rounded</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_c_recur_charge_rounded</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_functional_currency</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_item_flex_all_seg</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_print_description</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_report_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_sub_title</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>-30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_sob_id</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select to_number(oe_sys_parameters.value (&apos;SET_OF_BOOKS_ID&apos;)) from dual</DEFAULT_VALUE>
    <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>Buchkennung</PARAMETER_NAME>
      <DESCRIPTION>Buchkennung</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Id Libro Mayor</PARAMETER_NAME>
      <DESCRIPTION>Identificador de libro mayor</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>ID livre</PARAMETER_NAME>
      <DESCRIPTION>ID livre</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Id libro contabile</PARAMETER_NAME>
      <DESCRIPTION>Id del libro contabile</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>元帳ID</PARAMETER_NAME>
      <DESCRIPTION>元帳ID</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>원장 ID</PARAMETER_NAME>
      <DESCRIPTION>원장 ID</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Id do Razão</PARAMETER_NAME>
      <DESCRIPTION>Id do 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>Huvudboks-id</PARAMETER_NAME>
      <DESCRIPTION>Huvudboks-id</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Defter No</PARAMETER_NAME>
      <DESCRIPTION>Defter No</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Ledger Id</PARAMETER_NAME>
      <DESCRIPTION>Ledger Id</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>-20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_item_flex_code</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>fnd_profile.value(&apos;OE_ID_FLEX_CODE&apos;)</DEFAULT_VALUE>
    <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>Artikel-FlexFeld-Schlüssel</PARAMETER_NAME>
      <DESCRIPTION>Artikel-FlexFeld-Schlüssel</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Código de Estructura de Artículo</PARAMETER_NAME>
      <DESCRIPTION>Código de Estructura de Artículo</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Code clé article</PARAMETER_NAME>
      <DESCRIPTION>Code clé article</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Codice flexfield Articolo</PARAMETER_NAME>
      <DESCRIPTION>Codice flexfield Articolo</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>Código Flex. do Item</PARAMETER_NAME>
      <DESCRIPTION>Código Flex. do Item</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>Artikelflexkod</PARAMETER_NAME>
      <DESCRIPTION>Artikelflexkod</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Kalem Esnek Kodu</PARAMETER_NAME>
      <DESCRIPTION>Kalem Esnek Kodu</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Item Flex Code</PARAMETER_NAME>
      <DESCRIPTION>Item Flex Code</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>3</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>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_order_by</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>ONT_SRS_OEXOEUBD_SORTBY</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
oe_lookups
where lookup_type=&apos;OEXOEUBD SORT BY&apos;
order by meaning</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select meaning from oe_lookups where lookup_type=&apos;OEXOEUBD SORT BY&apos; AND lookup_code=&apos;ORDER_NUMBER&apos;</DEFAULT_VALUE>
    <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>Sortieren nach</PARAMETER_NAME>
      <DESCRIPTION>Sortieroptionen</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Ordenar por</PARAMETER_NAME>
      <DESCRIPTION>Opciones de Ordenación</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Tri par</PARAMETER_NAME>
      <DESCRIPTION>Options de tri</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Ordina per</PARAMETER_NAME>
      <DESCRIPTION>Opzioni di ordinamento</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>Classificar por</PARAMETER_NAME>
      <DESCRIPTION>Classificar por Opções</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>Sortera efter</PARAMETER_NAME>
      <DESCRIPTION>Sorteringsalternativ</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Sıralama Ölçütü</PARAMETER_NAME>
      <DESCRIPTION>Sıralama Bazı seçenekleri</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Sort By</PARAMETER_NAME>
      <DESCRIPTION>Sort By options</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>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_created_by_low</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>ONT_SRS_AOL_USER</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
user_name id,
user_name value,
null description
from
fnd_user
order by user_name</LOV_QUERY_DSP>
    <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 Erstellt von</PARAMETER_NAME>
      <DESCRIPTION>Von Erstellt von</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Creado por (De)</PARAMETER_NAME>
      <DESCRIPTION>Creado por (De)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Créé par (De)</PARAMETER_NAME>
      <DESCRIPTION>Créé par (De)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Creato da - Da</PARAMETER_NAME>
      <DESCRIPTION>Creato da - 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>Criado Por (De)</PARAMETER_NAME>
      <DESCRIPTION>Criado Por (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>Skapad av (från)</PARAMETER_NAME>
      <DESCRIPTION>Skapad av (från)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Oluşturan (İlk)</PARAMETER_NAME>
      <DESCRIPTION>Oluşturan (İlk)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Created By (From)</PARAMETER_NAME>
      <DESCRIPTION>Created By (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>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_created_by_high</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>ONT_SRS_AOL_USER</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
user_name id,
user_name value,
null description
from
fnd_user
order by user_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select :$flex$.created_by_from from sys.dual</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>Bis Erstellt von</PARAMETER_NAME>
      <DESCRIPTION>Bis Erstellt von</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Creado por (A)</PARAMETER_NAME>
      <DESCRIPTION>Creado por (A)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Créé par (A)</PARAMETER_NAME>
      <DESCRIPTION>Créé par (A)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Creato da - A</PARAMETER_NAME>
      <DESCRIPTION>Creato da - 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>Criado por (Até)</PARAMETER_NAME>
      <DESCRIPTION>Criado por (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>Skapad av (till)</PARAMETER_NAME>
      <DESCRIPTION>Skapad av (till)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Oluşturan (Son)</PARAMETER_NAME>
      <DESCRIPTION>Oluşturan (Son)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Created By (To)</PARAMETER_NAME>
      <DESCRIPTION>Created By (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_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>:p_order_date_low</ANCHOR>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <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 Auftragsdatum</PARAMETER_NAME>
      <DESCRIPTION>Von Auftragsdatum</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Fecha de Pedido (De)</PARAMETER_NAME>
      <DESCRIPTION>Fecha de Pedido (De)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Date commande (Du)</PARAMETER_NAME>
      <DESCRIPTION>Date commande (Du)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Data ordine - Da</PARAMETER_NAME>
      <DESCRIPTION>Data ordine - 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>Data da Ordem (De)</PARAMETER_NAME>
      <DESCRIPTION>Data da Ordem (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>Orderdatum (från)</PARAMETER_NAME>
      <DESCRIPTION>Orderdatum (från)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Sipariş Tarihi (İlk)</PARAMETER_NAME>
      <DESCRIPTION>Sipariş Tarihi (İlk)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Order Date (From)</PARAMETER_NAME>
      <DESCRIPTION>Order Date (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>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>:p_order_date_high</ANCHOR>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.order_date_from)) from sys.dual</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>Bis Auftragsdatum</PARAMETER_NAME>
      <DESCRIPTION>Bis Auftragsdatum</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Fecha de Pedido (A)</PARAMETER_NAME>
      <DESCRIPTION>Fecha de Pedido (A)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Date commande (Au)</PARAMETER_NAME>
      <DESCRIPTION>Date commande (Au)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Data ordine - A</PARAMETER_NAME>
      <DESCRIPTION>Data ordine - 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>Data da Ordem (Até)</PARAMETER_NAME>
      <DESCRIPTION>Data da Ordem (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>Orderdatum (till)</PARAMETER_NAME>
      <DESCRIPTION>Orderdatum (till)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Sipariş Tarihi (Son)</PARAMETER_NAME>
      <DESCRIPTION>Sipariş Tarihi (Son)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Order Date (To)</PARAMETER_NAME>
      <DESCRIPTION>Order Date (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_ROW>
    <SORT_ORDER>9</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>:p_order_type_low</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>ONT_MOAC_SRS_ORDER_TYPES</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
ot.order_type_id id,
ot.name value,
null description
from
oe_order_types_v ot,hr_operating_units ou
where ot.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=ot.org_id) order by ot.name</LOV_QUERY_DSP>
    <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 Auftragsart</PARAMETER_NAME>
      <DESCRIPTION>Von Auftragsart</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Tipo de Pedido (De)</PARAMETER_NAME>
      <DESCRIPTION>Tipo de Pedido (De)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Type commande (De)</PARAMETER_NAME>
      <DESCRIPTION>Type commande (De)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Tipo di ordine - Da</PARAMETER_NAME>
      <DESCRIPTION>Tipo di ordine - 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>Tipo da Ordem (De)</PARAMETER_NAME>
      <DESCRIPTION>Tipo da Ordem (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>Ordertyp (från)</PARAMETER_NAME>
      <DESCRIPTION>Ordertyp (från)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Sipariş Tipi (İlk)</PARAMETER_NAME>
      <DESCRIPTION>Sipariş Tipi (İlk)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Order Type (From)</PARAMETER_NAME>
      <DESCRIPTION>Order Type (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>10</SORT_ORDER>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <ANCHOR>:p_order_type_high</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>ONT_MOAC_SRS_ORDER_TYPES</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
ot.order_type_id id,
ot.name value,
null description
from
oe_order_types_v ot,hr_operating_units ou
where ot.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=ot.org_id) order by ot.name</LOV_QUERY_DSP>
    <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 Auftragsart</PARAMETER_NAME>
      <DESCRIPTION>Bis Auftragsart</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Tipo de Pedido (A)</PARAMETER_NAME>
      <DESCRIPTION>Tipo de Pedido (A)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Type commande (A)</PARAMETER_NAME>
      <DESCRIPTION>Type commande (A)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Tipo di ordine - A</PARAMETER_NAME>
      <DESCRIPTION>Tipo di ordine - 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>Tipo da Ordem (Até)</PARAMETER_NAME>
      <DESCRIPTION>Tipo da Ordem (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>Ordertyp (till)</PARAMETER_NAME>
      <DESCRIPTION>Ordertyp (till)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Sipariş Tipi (Son)</PARAMETER_NAME>
      <DESCRIPTION>Sipariş Tipi (Son)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Order Type (To)</PARAMETER_NAME>
      <DESCRIPTION>Order Type (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_ROW>
    <SORT_ORDER>11</SORT_ORDER>
    <DISPLAY_SEQUENCE>80</DISPLAY_SEQUENCE>
    <ANCHOR>:p_manager_low</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>ONT_SRS_MANAGER</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
email_address id,
email_address value,
null description
from
per_all_people_f
order by email_address</LOV_QUERY_DSP>
    <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 Manager</PARAMETER_NAME>
      <DESCRIPTION>Von Manager</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Director (De)</PARAMETER_NAME>
      <DESCRIPTION>Director (De)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Manager (De)</PARAMETER_NAME>
      <DESCRIPTION>Manager (De)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Manager (Da)</PARAMETER_NAME>
      <DESCRIPTION>Manager (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>Gerenciador (De)</PARAMETER_NAME>
      <DESCRIPTION>Gerenciador (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>Hanterare (från)</PARAMETER_NAME>
      <DESCRIPTION>Hanterare (från)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Yönetici (İlk)</PARAMETER_NAME>
      <DESCRIPTION>Yönetici (İlk)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Manager (From)</PARAMETER_NAME>
      <DESCRIPTION>Manager (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>12</SORT_ORDER>
    <DISPLAY_SEQUENCE>90</DISPLAY_SEQUENCE>
    <ANCHOR>:p_manager_high</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>ONT_SRS_MANAGER</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
email_address id,
email_address value,
null description
from
per_all_people_f
order by email_address</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select :$flex$.manager_from from sys.dual</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>Bis Manager</PARAMETER_NAME>
      <DESCRIPTION>Bis Manager</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Director (A)</PARAMETER_NAME>
      <DESCRIPTION>Director (A)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Manager (A)</PARAMETER_NAME>
      <DESCRIPTION>Manager (A)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Manager (A)</PARAMETER_NAME>
      <DESCRIPTION>Manager (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>Gerenciador (Até)</PARAMETER_NAME>
      <DESCRIPTION>Gerenciador (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>Hanterare (till)</PARAMETER_NAME>
      <DESCRIPTION>Hanterare (till)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Yönetici (Son)</PARAMETER_NAME>
      <DESCRIPTION>Yönetici (Son)</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Manager (To)</PARAMETER_NAME>
      <DESCRIPTION>Manager (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_ROW>
    <SORT_ORDER>13</SORT_ORDER>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <ANCHOR>:p_use_functional_currency</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>OM: Yes or No</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
fnd_lookups
where lookup_type=&apos;YES_NO&apos;
order by meaning</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select meaning from fnd_lookups where lookup_code = &apos;N&apos; and lookup_type = &apos;YES_NO&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>Buchwährung verwenden</PARAMETER_NAME>
      <DESCRIPTION>Buchwährung verwenden</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Utilizar Divisa de Libro Mayor</PARAMETER_NAME>
      <DESCRIPTION>Utilizar divisa del libro mayor</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Utiliser la devise comptable</PARAMETER_NAME>
      <DESCRIPTION>Utiliser la devise comptable</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Usa divisa libro contabile</PARAMETER_NAME>
      <DESCRIPTION>Usa la divisa del 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>Usar Moeda do Razão</PARAMETER_NAME>
      <DESCRIPTION>Usar Moeda do 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>Använd reskontravaluta</PARAMETER_NAME>
      <DESCRIPTION>Använd reskontravaluta</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Defter Para Birimini Kullan</PARAMETER_NAME>
      <DESCRIPTION>Defter Para Birimini Kullan</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Use Ledger Currency</PARAMETER_NAME>
      <DESCRIPTION>Use Ledger Currency</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>
