ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y 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)='Y')) 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 Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4710951A9E05362FB09050512 SELECT h.transactional_curr_code Currency2, ot.name Order_Type, DECODE(SUBSTR(UPPER(:P_ORDER_BY),1,1),'C',CUST_ACCT.CUST_ACCOUNT_ID,NULL) CUSTOMER_ID, DECODE(SUBSTR(UPPER(:P_ORDER_BY),1,1),'C',PARTY.PARTY_NAME,NULL) CUSTOMER_NAME_2, h.order_number Order_Number, PARTY.PARTY_NAME CUSTOMER_NAME_1, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, h.ordered_date Order_Date, ag.name Agreement, sr.name Sales_Person, sum(nvl(l.ordered_quantity,0)* DECODE(L.LINE_CATEGORY_CODE,'RETURN', -1*nvl(l.unit_list_price,0),nvl(l.unit_list_price,0))) Order_List, sum(nvl(l.ordered_quantity,0)* DECODE(L.LINE_CATEGORY_CODE,'RETURN',-1*nvl(l.unit_selling_price,0),nvl(l.unit_selling_price,0))) Order_Amount , curr.precision c_pre, l.charge_periodicity_code --added ,ONT_OEXPRPRS_XMLP_PKG.C_DATA_NOT_FOUNDFORMULA(h.transactional_curr_code) C_DATA_NOT_FOUND, ONT_OEXPRPRS_XMLP_PKG.CF_1FORMULA(l.charge_periodicity_code) C_CHARGE_PERIODICITY, ONT_OEXPRPRS_XMLP_PKG.C_DISCOUNT_PRICEFormula(sum(nvl(l.ordered_quantity,0)* DECODE(L.LINE_CATEGORY_CODE,'RETURN',-1*nvl(l.unit_selling_price,0),nvl(l.unit_selling_price,0))), sum(nvl(l.ordered_quantity,0)* DECODE(L.LINE_CATEGORY_CODE,'RETURN', -1*nvl(l.unit_list_price,0),nvl(l.unit_list_price,0))) ) C_DISCOUNT_PRICE, ONT_OEXPRPRS_XMLP_PKG.C_ORDER_AMOUNTFormula(sum(nvl(l.ordered_quantity,0)* DECODE(L.LINE_CATEGORY_CODE,'RETURN',-1*nvl(l.unit_selling_price,0),nvl(l.unit_selling_price,0))),curr.precision ) C_ORDER_AMOUNT, ONT_OEXPRPRS_XMLP_PKG.C_ORDER_LISTFORMULA(sum(nvl(l.ordered_quantity,0)* DECODE(L.LINE_CATEGORY_CODE,'RETURN', -1*nvl(l.unit_list_price,0),nvl(l.unit_list_price,0))),curr.precision) C_ORDER_LIST FROM oe_order_headers_all h, oe_order_lines_all l, OE_TRANSACTION_TYPES_TL OT, ra_salesreps sr, HZ_CUST_ACCOUNTS CUST_ACCT, HZ_PARTIES PARTY, oe_agreements ag , fnd_currencies curr WHERE OT.TRANSACTION_TYPE_ID = h.order_type_id AND h.sold_to_org_id = CUST_ACCT.CUST_ACCOUNT_ID AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID AND h.salesrep_id=sr.salesrep_id (+) AND h.agreement_id = ag.agreement_id(+) AND l.header_id=h.header_id AND l.service_reference_line_id is null AND NVL(h.cancelled_flag, 'N') = 'N' and nvl(h.org_id,0) = nvl(:p_organization_id,0) and nvl(l.org_id,0) = nvl(:p_organization_id,0) and nvl(sr.org_id,0) = nvl(:p_organization_id,0) and ot.LANGUAGE = SYS_CONTEXT('USERENV','LANG') and h.transactional_curr_code = curr.currency_code &lp_customer_name &lp_customer_number &lp_salesrep &lp_agreement &lp_order_type &lp_open_orders_only &lp_order_num &lp_order_date &lp_order_category &lp_line_category GROUP BY h.transactional_curr_code, ot.name, DECODE(SUBSTR(UPPER(:P_ORDER_BY),1,1),'C',CUST_ACCT.CUST_ACCOUNT_ID,NULL), DECODE(SUBSTR(UPPER(:P_ORDER_BY),1,1),'C',PARTY.PARTY_NAME,NULL), h.order_number, PARTY.PARTY_NAME, CUST_ACCT.ACCOUNT_NUMBER, h.ordered_date, ag.name, sr.name, curr.precision, l.charge_periodicity_code &lp_having ORDER BY h.transactional_curr_code, ot.name &lp_sort_by Y ONT OEXPRPRS_XML AR ONT تقرير إجمالي خصومات الطلب Imported from BI Publisher Description: تقرير إجمالي خصومات الطلب Application: إدارة الطلبات Source: تقرير إجمالي خصومات الطلب (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG D ONT Auftragsrabatte - Übersicht Imported from BI Publisher Description: Auftragsrabatte - Übersicht Application: Order Management Source: Auftragsrabatte - Übersicht (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG E ONT Informe Resumen de Descuentos de Pedidos Imported from BI Publisher Description: Informe Resumen de Descuentos de Pedidos Application: Order Management Source: Informe Resumen de Descuentos de Pedidos (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG F ONT Etat Synthèse des remises sur commande Imported from BI Publisher Description: Etat Synthèse des remises sur commande Application: Order Management Source: Etat Synthèse des remises sur commande (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG I ONT Rapporto Sintetico sconti ordine Imported from BI Publisher Description: Rapporto Sintetico sconti ordine Application: Order Management Source: Rapporto Sintetico sconti ordine (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG JA ONT 受注値引要約レポート Imported from BI Publisher Description: 受注値引要約レポート Application: Order Management Source: 受注値引要約レポート(XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG KO ONT 주문 할인 요약 보고서 Imported from BI Publisher Description: 주문 할인 요약 보고서 Application: Order Management Source: 주문 할인 요약 보고서(XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG PTB ONT Relatório Sumariado de Desconto da Ordem Imported from BI Publisher Description: Relatório Sumariado de Desconto da Ordem Application: Gerenciamento de Ordens Source: Relatório Sumariado de Desconto da Ordem (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG RU ONT Сводный отчет о скидках для заказов Imported from BI Publisher Description: Сводный отчет о скидках для заказов Application: Управление заказами Source: Сводный отчет о скидках для заказов (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG S ONT Orderrabatt - översiktsrapport Imported from BI Publisher Description: Orderrabatt - översiktsrapport Application: Order Management Source: Orderrabatt - översiktsrapport (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG TR ONT Sipariş İndirimi Özet Raporu Imported from BI Publisher Description: Sipariş İndirimi Özeti Raporu Application: Sipariş Yönetimi(1) Source: Sipariş İndirimi Özet Raporu (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG US ONT Order Discount Summary Imported from BI Publisher Description: Order Discount Summary Report Application: Order Management Source: Order Discount Summary Report (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG ZHS ONT 订单折扣汇总报表 Imported from BI Publisher Description: 订单折扣汇总报表 Application: 订单管理 Source: 订单折扣汇总报表 (XML) Short Name: OEXPRPRS_XML DB package: ONT_OEXPRPRS_XMLP_PKG BI Publisher &lp_agreement &lp_customer_name &lp_customer_number &lp_having &lp_line_category &lp_open_orders_only &lp_order_category &lp_order_date &lp_order_num &lp_order_type &lp_salesrep &lp_sort_by :f1 :l_order_type_high :l_order_type_low :lp_agreement :lp_customer_name :lp_customer_number :lp_having :lp_line_category :lp_open_orders_only :lp_order_amount :lp_order_category :lp_order_date :lp_order_list :lp_order_num :lp_order_type :lp_salesrep :lp_sort_by :operating_unit :p_agreement :p_conc_request_id :p_customer_name_hi :p_customer_name_lo :p_customer_number_hi :p_customer_number_lo :p_line_category :p_one_time :p_open_orders_only :p_order_amount_high :p_order_amount_low :p_order_by :p_order_category :p_order_date_high :p_order_date_low :p_order_list_high :p_order_list_low :p_order_num_high :p_order_num_low :p_order_type_hi :p_order_type_lo :p_organization_id :p_salesrep_hi :p_salesrep_lo :p_sob_id :rp_agreement_name :rp_company_name :rp_customer_name_range :rp_customer_number_range :rp_data_found :rp_functional_currency :rp_line_category :rp_open_orders_only :rp_order_amount_range :rp_order_category :rp_order_date_range :rp_order_list_range :rp_order_number_range :rp_order_type_range :rp_report_name :rp_salesrep_range :rp_sub_title 1 -20 :p_sob_id Number select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) from dual Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y 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)='Y')) 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 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('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_order_by LOV Oracle ONT_SRS_OEXPRPRS_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXPRPRS ORDER BY' order by meaning select meaning from oe_lookups where lookup_type = 'OEXPRPRS ORDER BY' and lookup_code = 'ORDER_NUMBER' Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Ölçütü Sıralama Ölçütü US Sort By Sort By ZHS 排序依据 排序依据 4 20 :p_open_orders_only LOV Oracle OM: Yes or No Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR الطلبات المفتوحة فقط إظهار الطلبات المفتوحة فقط D Nur offene Aufträge Nur offene Aufträge E Sólo Pedidos Abiertos Mostrar Sólo Pedidos Abiertos F Commandes en cours uniquement Afficher commandes en cours uniquement I Solo ordini aperti Mostra solo ordini aperti JA オープン受注のみ オープン受注のみ表示 KO 개설 주문만 개설 주문만 표시 PTB Somente Ordens em Aberto Mostrar Apenas Ordens em Aberto RU Только открытые заказы Показывать только открытые заказы S Endast uteliggande order Visa endast öppna order TR Sadece Açık Siparişler Sadece Açık Siparişleri Göster US Open Orders Only Show Open Orders Only ZHS 仅限于未完成订单 仅显示打开的订单 5 30 :p_customer_name_lo LOV Oracle ONT_SRS_CUSTOMER_NAME Y Y select party_name id, party_name value, null description from hz_parties where exists (select null from hz_cust_accounts ha where ha.party_id=hz_parties.party_id) order by party_name AR اسم العميل (من) اسم العميل (من) D Von Kunde Von Kunde E Nombre del Cliente (De) De Nombre de Cliente F Nom client (De) Nom client (De) I Nome cliente - Da Nome cliente (min) JA 顧客名 (自) 顧客名 (自) KO 고객명(부터) 고객명 (하한) PTB Nome do Cliente (De) Nome do Cliente (Inferior) RU Имя заказчика с Имя заказчика с S Kundnamn (från) Kundnamn (från) TR Müşteri Adı (İlk) Müşteri Adı (Alt Değer) US Customer Name (From) Customer Name (Low) ZHS 客户名称（自） 客户名称（下限） 6 40 :p_customer_name_hi LOV Oracle ONT_SRS_CUSTOMER_NAME Y Y select party_name id, party_name value, null description from hz_parties where exists (select null from hz_cust_accounts ha where ha.party_id=hz_parties.party_id) order by party_name select :$flex$.customer_name_from from sys.dual AR اسم العميل (إلى) اسم العميل (إلى) D Bis Kunde Bis Kunde E Nombre del Cliente (A) A Nombre de Cliente F Nom client (A) Nom client (Au) I Nome cliente - A Nome cliente (max) JA 顧客名 (至) 顧客名 (至) KO 고객명(까지) 고객명 (상한) PTB Nome do Cliente (Até) Nome do Cliente (Superior) RU Имя заказчика по Имя заказчика по S Kundnamn (till) Kundnamn (till) TR Müşteri Adı (Son) Müşteri Adı (Üst Değer) US Customer Name (To) Customer Name (High) ZHS 客户名称（至） 客户名称（上限） 7 50 :p_customer_number_lo LOV Oracle ONT_SRS_CUSTOMER_NUMBER Y select customer_number id, customer_number value, null description from oe_sold_to_orgs_v order by customer_number AR رقم العميل (من) رقم العميل (من) D Von Kundennummer Von Kundennummer E Número de Cliente (De) De Número de Cliente F Numéro client (De) Numéro client (De) I Numero cliente - Da Numero cliente - Minimo JA 顧客番号 (自) 顧客番号 (自) KO 고객 번호(부터) 고객 번호(하한) PTB Número do Cliente (De) Número do Cliente (Inferior) RU Номер заказчика с Номер заказчика с S Kundnummer (från) Kundnummer (från) TR Müşteri Numarası (İlk) Müşteri Numarası (İlk) US Customer Number (From) Customer Number (Low) ZHS 客户编号（自） 客户编号（下限） 8 60 :p_customer_number_hi LOV Oracle ONT_SRS_CUSTOMER_NUMBER Y select customer_number id, customer_number value, null description from oe_sold_to_orgs_v order by customer_number select :$flex$.customer_number_from from sys.dual AR رقم العميل (إلى) رقم العميل (إلى) D Bis Kundennummer Bis Kundennummer E Número de Cliente (A) A Número de Cliente F Numéro client (A) Numéro client (Au) I Numero cliente - A Numero cliente - Massimo JA 顧客番号 (至) 顧客番号 (至) KO 고객 번호(까지) 고객 번호(상한) PTB Número do Cliente (Até) Número do Cliente (Superior) RU Номер заказчика по Номер заказчика по S Kundnummer (till) Kundnummer (till) TR Müşteri Numarası (Son) Müşteri Numarası (İlk) US Customer Number (To) Customer Number (High) ZHS 客户编号（至） 客户编号（上限） 9 70 :p_salesrep_lo LOV Oracle ONT_MOAC_SRS_SALESREPS Y select rs.name id, rs.name value, null description from ra_salesreps rs,hr_operating_units ou where rs.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=rs.org_id) order by rs.name AR مندوب المبيعات (من) فرد المبيعات (من) D Von Vertriebsmitarbeiter Von Vertriebsmitarbeiter E Vendedor (De) De Vendedor F Vendeur (De) Vendeur (De) I Rappresentante commerciale - Da Venditore (minimo) JA 営業担当 (自) 営業担当 (自) KO 영업사원(부터) 영업 사원명(하위) PTB Vendedor (De) Vendedor (Inferior) RU Продавец с Продавец с S Säljare (från) Från säljare TR Satış Elemanı (İlk) Satış Elemanı (Alt) US Sales Person (From) Salesperson (Low) ZHS 销售人员（自） 销售人员（下限） 10 80 :p_salesrep_hi LOV Oracle ONT_MOAC_SRS_SALESREPS Y select rs.name id, rs.name value, null description from ra_salesreps rs,hr_operating_units ou where rs.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=rs.org_id) order by rs.name AR مندوب مبيعات (إلى) فرد المبيعات (إلى) D Bis Vertriebsmitarbeiter Bis Vertriebsmitarbeiter E Vendedor (A) A Vendedor F Vendeur (A) Vendeur (Au) I Rappresentante commerciale - A Venditore (massimo) JA 営業担当 (至) 営業担当 (至) KO 영업사원(까지) 영업 사원명(상위) PTB Vendedor (Até) Vendedor (Superior) RU Продавец по Продавец по S Säljare (till) Till säljare TR Satış Elemanı (Son) Satış Elemanı (Üst) US Salesperson (To) Salesperson (High) ZHS 销售人员（至） 销售人员（上限） 11 90 :p_agreement LOV Oracle ONT_SRS_AGREEMENT Y select agreement_id id, name value, null description from oe_agreements order by name AR الاتفاقية الاتفاقية D Vereinbarung Vereinbarung E Acuerdo Acuerdo F Accord-cadre Accord-cadre I Accordo Accordo JA 基本契約 基本契約 KO 계약 계약 PTB Acordo Acordo RU Соглашен. Соглашен. S Avtal Avtal TR Anlaşma Anlaşma US Agreement Agreement ZHS 协议 协议 12 100 :p_order_type_lo LOV Oracle ONT_MOAC_SRS_ORDER_TYPES Y 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 AR نوع الطلب (من) نوع الطلب (من) D Von Auftragsart Von Auftragsart E Tipo de Pedido (De) De Tipo de Pedido F Type commande (De) Type commande (De) I Tipo di ordine - Da Tipo di ordine (minimo) JA 受注タイプ (自) 受注タイプ (自) KO 주문 유형(부터) 주문유형(하한) PTB Tipo da Ordem (De) Tipo de Ordem (Inferior) RU Тип заказа с Тип заказа с S Ordertyp (från) Ordertyp (från) TR Sipariş Tipi (İlk) Sipariş Tipi (Alt Değer) US Order Type (From) Order Type (Low) ZHS 订单类型（自） 订单类型（下限） 13 110 :p_order_type_hi LOV Oracle ONT_MOAC_SRS_ORDER_TYPES Y 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 AR نوع الطلب (إلى) نوع الطلب (إلى) D Bis Auftragsart Bis Auftragsart E Tipo de Pedido (A) A Tipo de Pedido F Type commande (A) Type commande (Au) I Tipo di ordine - A Tipo di ordine (massimo) JA 受注タイプ (至) 受注タイプ (至) KO 주문 유형(까지) 주문유형(상한) PTB Tipo da Ordem (Até) Tipo de Ordem (Superior) RU Тип заказа по Тип заказа по S Ordertyp (till) Ordertyp (till) TR Sipariş Tipi (Son) Sipariş Tipi (Üst Değer) US Order Type (To) Order Type (High) ZHS 订单类型（至） 订单类型（上限） 14 120 :p_order_num_low Number AR رقم الطلب (من) رقم الطلب من D Von Auftragsnummer Von Auftragsnummer E Número de Pedido (De) De Número de Pedido F Numéro commande (De) Numéro de commande - De I Numero ordine - Da Numero ordine (minimo) JA 受注番号 (自) 受注番号:自 KO 주문 번호(부터) 주문 번호 하한 PTB Número de Ordem (De) Nº da Ordem - Inferior RU Номер заказа с Номер заказа с S Ordernummer (från) Från ordernummer TR Sipariş Numarası (İlk) Sipariş Numarası Alt Değeri US Order Number (From) Order Number Low ZHS 订单编号（自） 订单编号下限 15 130 :p_order_num_high Number select :$flex$.order_number_from from sys.dual AR رقم الطلب (إلى) رقم الطلب إلى D Bis Auftragsnummer Bis Auftragsnummer E Número de Pedido (A) A Número de Pedido F Numéro commande (A) Numéro de commande - A I Numero ordine - A Numero ordine - Massimo JA 受注番号 (至) 受注番号:至 KO 주문 번호(까지) 주문 번호 상한 PTB Número de Ordem (Até) Nº da Ordem - Superior RU Номер заказа по Номер заказа по S Ordernummer (till) Till ordernummer TR Sipariş Numarası (Son) Sipariş Numarası Üst Değeri US Order Number (To) Order Number High ZHS 订单编号（至） 订单编号上限 16 140 :p_order_date_low Date AR تاريخ الطلب (من) تاريخ الطلب من D Von Auftragsdatum Von Auftragsdatum E Fecha de Pedido (De) De Fecha de Pedido F Date commande (Du) Date commande - Du I Data ordine - Da Data ordine (minimo) JA 受注日 (自) 受注日:自 KO 주문 일자(부터) 주문일자 하한 PTB Data da Ordem (De) Data da Ordem - Inferior RU Дата заказа с Дата заказа с S Orderdatum (från) Från orderdatum TR Sipariş Tarihi (İlk) Sipariş Tarihi Alt Değeri US Order Date (From) Order Date Low ZHS 订单日期（自） 订单日期下限 17 150 :p_order_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.order_date_from)) from sys.dual AR تاريخ الطلب (إلى) تاريخ الطلب إلى D Bis Auftragsdatum Bis Auftragsdatum E Fecha de Pedido (A) A Fecha de Pedido F Date commande (Au) Date commande - Au I Data ordine - A Data ordine (massimo) JA 受注日 (至) 受注日:至 KO 주문 일자(까지) 주문일자 상한 PTB Data da Ordem (Até) Data da Ordem - Superior RU Дата заказа по Дата заказа по S Orderdatum (till) Till orderdatum TR Sipariş Tarihi (Son) Sipariş Tarihi Üst Değeri US Order Date (To) Order Date High ZHS 订单日期（至） 订单日期上限 18 160 :p_order_amount_low Number AR مبلغ الطلب (من) مبلغ الطلب (من) D Von Auftragswert Von Auftragswert E Importe del Pedido (De) De Importe del Pedido F Montant commande (De) Montant commande (De) I Importo ordine - Da Importo ordine (minimo) JA 受注金額 (自) 受注金額 (自) KO 주문 금액(부터) 주문금액(하한) PTB Quantia da Ordem (De) Quantia da Ordem (Inferior) RU Сумма заказа с Сумма заказа с S Orderbelopp (från) Orderbelopp (från) TR Sipariş Tutarı (İlk) Sipariş Tutarı (Alt Değer) US Order Amount (From) Order Amount (Low) ZHS 订单数额（自） 订单金额（下限） 19 170 :p_order_amount_high Number AR مبلغ الطلب (إلى) مبلغ الطلب (إلى) D Bis Auftragswert Bis Auftragswert E Importe del Pedido (A) A Importe del Pedido F Montant commande (A) Montant commande (Au) I Importo ordine - A Importo ordine (massimo) JA 受注金額 (至) 受注金額 (至) KO 주문 금액(까지) 주문금액(상한) PTB Quantia da Ordem (Até) Quantia da Ordem (Superior) RU Сумма заказа по Сумма заказа по S Orderbelopp (till) Orderbelopp (till) TR Sipariş Tutarı (Son) Sipariş Tutarı (Üst Değer) US Order Amount (To) Order Amount (High) ZHS 订单数额（至） 订单金额（上限） 20 180 :p_order_list_low Number AR قائمة الطلب (من) قائمة الطلب (من) D Von Auftragsliste Von Auftragsliste E Lista de Pedidos (De) De Lista de Pedidos F Tarif commande (De) Tarif commande (De) I Ordine a listino - Da Elenco ordini (minimo) JA 受注リスト (自) 受注リスト (自) KO 주문 목록(부터) 주문목록(하한) PTB Lista da Ordem (De) Lista de Ordens (Inferior) RU Список заказов с Список заказов с S Orderlista (från) Orderlista (från) TR Sipariş Listesi Sipariş Listesi (Alt Değer) US Order List (From) Order List (Low) ZHS 订货单（自） 订货单（下限） 21 190 :p_order_list_high Number AR قائمة الطلب (إلى) قائمة الطلب (إلى) D Bis Auftragsliste Bis Auftragsliste E Lista de Pedidos (A) A Lista de Pedidos F Tarif commande (A) Tarif commande (Au) I Ordine a listino - A Elenco ordini (massimo) JA 受注リスト (至) 受注リスト (至) KO 주문 목록(까지) 주문목록(상한) PTB Lista da Ordem (Até) Lista de Ordens (Superior) RU Список заказов по Список заказов по S Orderlista (till) Orderlista (till) TR Sipariş Listesi (Son) Sipariş Listesi (Üst Değer) US Order List (To) Order List (High) ZHS 订货单（至） 订货单（上限） 22 200 :p_order_category LOV Oracle ONT_SRS_ORDER_CATEGORY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='REPORT_ORDER_CATEGORY' order by meaning AR فئة الطلب فئة الطلب D Auftragskategorie Auftragskategorie E Categoría de Pedido Categoría de Pedido F Catégorie de commande Catégorie de commande I Categoria ordine Categoria ordine JA 受注カテゴリ 受注カテゴリ KO 주문 범주 주문 범주 PTB Categoria da Ordem Categoria da Ordem RU Категория заказа Категория заказа S Orderkategori Orderkategori TR Sipariş Kategorisi Sipariş Kategorisi US Order Category Order Category ZHS 订单类别 订单类别 23 210 :p_line_category LOV Oracle ONT_SRS_LINE_CATEGORY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='REPORT_LINE_DISPLAY' order by meaning AR فئة السطر فئة السطر D Positionskategorie Positionskategorie E Categoría de Línea Categoría de Línea F Catégorie de ligne Catégorie de ligne I Categoria linea Categoria linea JA 明細カテゴリ 明細カテゴリ KO 라인 범주 라인 범주 PTB Categoria da Linha Categoria da Linha RU Категория строки Категория строки S Radkategori Radkategori TR Satır Kategorisi Satır Kategorisi US Line Category Line Category ZHS 行类别 行类别 :$flex$.customer_name_from Customer Name (From) Customer Name (To) :$flex$.customer_number_from Customer Number (From) Customer Number (To) :$flex$.order_date_from Order Date (From) Y Order Date (To) :$flex$.order_number_from Order Number (From) Order Number (To)