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）限制的操作单元。 C6E085D4710251A9E05362FB09050512Y SELECT h.transactional_curr_code Currency, h.conversion_rate Conversion_rate , h.conversion_type_code Conversion_Type_Code , h.transactional_curr_code use_currency, decode (substr(upper(:p_order_by),1,1), 'S',sr.name,NULL) Sales_Person, decode(substr(upper(:p_order_by),1,1),'O', h.ordered_date,NULL) dummy_order_date, decode(substr(upper(:p_order_by),1,1),'A', agree.name,NULL) dummy_agreement, decode(substr(upper(:p_order_by),1,1),'P', h.cust_po_number,NULL) dummy_po_num, ot.name Order_Type, decode (substr(upper(:p_order_by),1,1), 'C',party.party_name,NULL) Customer_Name1, h.order_number Order_Number, h.cust_po_number PO_Number, h.ordered_date Order_Date, party.party_name Customer_Name3, h.header_id Header_id, u.user_name created_by, h.flow_status_code, fl.meaning Order_Status, -- 8925328 agree.name Agreement, sr.name Salesrep, nvl(sum(DECODE(l.line_category_code,'RETURN', (nvl(l.unit_list_price,0) * (nvl(l.ordered_quantity,0)) * (-1)), (nvl(l.unit_list_price,0) * (nvl(l.ordered_quantity,0))))),0) List_Value, nvl(sum(DECODE(l.line_category_code,'RETURN', (nvl(l.unit_selling_price,0) * (nvl(l.ordered_quantity,0)) * (-1)), (nvl(l.unit_selling_price,0) *(nvl(l.ordered_quantity,0))))),0) Order_Amount, nvl(sum(DECODE(l.line_category_code,'RETURN', (nvl(l.unit_selling_price,0) * (nvl(l.shipped_quantity,0)) * (-1)), (nvl(l.unit_selling_price,0) * (nvl(l.shipped_quantity,0))))),0) Ship_Value, l.charge_periodicity_code --added as fix ,ONT_OEXOEOSR_XMLP_PKG.C_CURRENCYFORMULA(h.transactional_curr_code) C_CURRENCY ,ONT_OEXOEOSR_XMLP_PKG.C_LIST_AMOUNTFORMULA(h.transactional_curr_code,nvl(sum(DECODE(l.line_category_code,'RETURN', (nvl(l.unit_list_price,0) * (nvl(l.ordered_quantity,0)) * (-1)), (nvl(l.unit_list_price,0) * (nvl(l.ordered_quantity,0))))),0),h.conversion_type_code,h.ordered_date,h.conversion_rate) C_LIST_AMOUNT ,ONT_OEXOEOSR_XMLP_PKG.C_ORDER_AMOUNTFORMULA(h.transactional_curr_code,nvl(sum(DECODE(l.line_category_code,'RETURN', (nvl(l.unit_selling_price,0) * (nvl(l.ordered_quantity,0)) * (-1)), (nvl(l.unit_selling_price,0) *(nvl(l.ordered_quantity,0))))),0),h.conversion_type_code,h.ordered_date,h.conversion_rate) C_ORDER_AMOUNT ,ONT_OEXOEOSR_XMLP_PKG.C_SHIPPED_AMOUNTFORMULA(h.transactional_curr_code,nvl(sum(DECODE(l.line_category_code,'RETURN', (nvl(l.unit_selling_price,0) * (nvl(l.shipped_quantity,0)) * (-1)), (nvl(l.unit_selling_price,0) * (nvl(l.shipped_quantity,0))))),0),h.conversion_type_code,h.ordered_date,h.conversion_rate) C_SHIPPED_AMOUNT ,ONT_OEXOEOSR_XMLP_PKG.C_ORDER_COUNTFORMULA() C_ORDER_COUNT ,ONT_OEXOEOSR_XMLP_PKG.C_LINE_COUNTFORMULA(h.header_id) C_LINE_COUNT ,ONT_OEXOEOSR_XMLP_PKG.C_DATA_NOT_FOUNDFORMULA(h.transactional_curr_code) C_DATA_NOT_FOUND FROM oe_order_headers_all h, oe_order_lines_all l, oe_transaction_types_tl ot, fnd_user u, fnd_lookup_values fl, -- 8925328 oe_agreements_tl agree, HZ_CUST_SITE_USES_ALL su, hz_party_sites party_site, -- hz_loc_assignments loc_assign, --bug 9796318 hz_locations loc, hz_cust_acct_sites_all acct_site, ra_salesreps sr, fnd_territories_vl terr , hz_parties party, hz_cust_accounts cust_acct WHERE h.sold_to_org_id = cust_acct.cust_account_id AND cust_acct.party_id = party.party_id AND h.header_id = l.header_id(+) AND nvl(h.org_id,0) = nvl(:p_org_id_v,0) AND h.order_type_id = ot.transaction_type_id AND ot.language = userenv('LANG') AND sr.salesrep_id(+)= h.salesrep_id AND nvl(sr.org_id(+),nvl(:p_org_id_v,0)) =nvl(:p_org_id_v,0) AND h.agreement_id=agree.agreement_id (+) AND agree.language(+) = userenv('LANG') AND h.created_by =u.user_id AND h.ship_to_org_id = su.site_use_id(+) AND acct_site.party_site_id = party_site.party_site_id(+) AND loc.location_id(+) = party_site.location_id -- AND loc.location_id = loc_assign.location_id(+) --bug 9796318 -- AND NVL(acct_site.org_id,-99) = NVL(loc_assign.org_id,-99) --bug 9796318 AND su.CUST_ACCT_SITE_ID = acct_site.cust_acct_site_id(+) AND loc.country = terr.territory_code(+) -- Begin 8925328 AND fl.lookup_type = 'FLOW_STATUS' AND fl.lookup_code = h.flow_status_code AND fl.language = Userenv('LANG') -- End 8925328 &lp_order_num &lp_salesrep &lp_order_type &lp_country &lp_customer_name &lp_order_date &lp_po_num &lp_agreement &lp_order_source &lp_created_by &lp_open_orders_only GROUP BY h.transactional_curr_code, h.conversion_rate , h.conversion_type_code , decode (:p_use_functional_currency,'N', h.transactional_curr_code, :rp_functional_currency) , sr.name , cust_acct.cust_account_id, h.order_number, h.cust_po_number, h.ordered_date , party.party_name, ot.name, h.header_id, h.flow_status_code, fl.meaning, -- 8925328 agree.name, u.user_name, l.charge_periodicity_code /*ORDER BY 1 ,decode(substr(upper(:p_order_by),1,1), 'S', sr.name ,'O', h.ordered_date,h.order_number), decode(substr(upper(:p_order_by),1,1), 'S', party.party_name ,'O', party.party_name), h.order_number*/ -- bug 9796318 - removed the space between ":" and "p_order_by" in below clause ORDER BY 1 ASC,9 ASC,5 ASC,23 ASC,10 ASC,8 ASC,7 ASC,6 ASC , 1 , decode ( substr ( upper ( :p_order_by ) , 1 , 1 ) , 'S' , sr.name , 'O' , h.ordered_date , h.order_number ) , decode ( substr ( upper ( :p_order_by ) , 1 , 1 ) , 'S' , party.party_name , 'O' , party.party_name ) , h.order_number ONT OEXOEOSR_XML AR ONT تقرير إجمالي الطلبات Imported from BI Publisher Description: تقرير إجمالي الطلبات Application: إدارة الطلبات Source: تقرير إجمالي الطلبات (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG D ONT Auftragsübersicht Imported from BI Publisher Description: Auswertung "Auftragsübersicht" Application: Order Management Source: Auftragsübersicht (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG E ONT Informe Resumen de Pedidos Imported from BI Publisher Description: Informe Resumen de Pedidos Application: Order Management Source: Informe Resumen de Pedidos (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG F ONT Etat de synthèse des commandes Imported from BI Publisher Description: Etat de synthèse des commandes Application: Order Management Source: Etat de synthèse des commandes (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG I ONT Rapporto Sintetico ordini Imported from BI Publisher Description: Rapporto sintetico ordini Application: Order Management Source: Rapporto Sintetico ordini (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG JA ONT 受注要約レポート Imported from BI Publisher Description: 受注要約レポート Application: Order Management Source: 受注要約レポート(XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG KO ONT 주문 요약 보고서 Imported from BI Publisher Description: 주문 요약 보고서 Application: Order Management Source: 주문 요약 보고서(XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG PTB ONT Relatório Sumariado de Ordens Imported from BI Publisher Description: Relatório Sumariado de Ordens Application: Gerenciamento de Ordens Source: Relatório Sumariado de Ordens (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG RU ONT Сводный отчет о заказах Imported from BI Publisher Description: Сводка заказов Application: Управление заказами Source: Сводный отчет о заказах (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG S ONT Order - översiktsrapport Imported from BI Publisher Description: Order - översiktsrapport Application: Order Management Source: Order - översiktsrapport (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG TR ONT Sipariş Özet Raporu Imported from BI Publisher Description: Sipariş Özet Raporu Application: Sipariş Yönetimi(1) Source: Sipariş Özet Raporu (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG US ONT Orders Summary Imported from BI Publisher Description: Orders Summary Report Application: Order Management Source: Orders Summary Report (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG ZHS ONT 订单汇总报表 Imported from BI Publisher Description: 订单汇总报表 Application: 订单管理 Source: 订单汇总报表 (XML) Short Name: OEXOEOSR_XML DB package: ONT_OEXOEOSR_XMLP_PKG BI Publisher &lp_agreement &lp_country &lp_created_by &lp_customer_name &lp_open_orders_only &lp_order_date &lp_order_num &lp_order_source &lp_order_type &lp_po_num &lp_salesrep :f1 :l_order_type_high :l_order_type_low :lp_agreement :lp_country :lp_created_by :lp_customer_name :lp_open_orders_only :lp_order_date :lp_order_num :lp_order_source :lp_order_source_name :lp_order_status :lp_order_type :lp_po_num :lp_salesrep :operating_unit :p_agreement :p_conc_request_id :p_country_high :p_country_low :p_created_by_high :p_created_by_low :p_customer_name_high :p_customer_name_low :p_enable_trace :p_invoice_line_context :p_one_time :p_open_orders_only :p_order_by :p_order_date_high :p_order_date_high_v :p_order_date_low :p_order_date_low_v :p_order_num_high :p_order_num_low :p_order_source :p_order_status_high :p_order_status_low :p_order_type_high :p_order_type_low :p_org_id :p_org_id_v :p_po_num_high :p_po_num_low :p_salesrep_high :p_salesrep_low :p_sob_id :p_use_functional_currency :rp_agreement :rp_company_name :rp_country_range :rp_created_by_range :rp_customer_name_range :rp_data_found :rp_functional_currency :rp_open_orders_only :rp_order_by :rp_order_date_range :rp_order_number_range :rp_order_status_range :rp_order_type_range :rp_po_number_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_OEXOEOSR_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXOEOSR SORT BY' order by meaning select meaning from oe_lookups where lookup_type = 'OEXOEOSR SORT BY' and lookup_code = 'ORDER_DATE' 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_customer_name_low 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) Nombre del Cliente (De) F Nom client (De) Nom client (De) I Nome cliente - Da Nome cliente - Da JA 顧客名 (自) 顧客名 (自) KO 고객명(부터) 고객명(부터) PTB Nome do Cliente (De) Nome do Cliente (De) RU Имя заказчика с Имя заказчика с S Kundnamn (från) Kundnamn (från) TR Müşteri Adı (İlk) Müşteri Adı (İlk) US Customer Name (From) Customer Name (From) ZHS 客户名称（自） 客户名称（自） 5 30 :p_customer_name_high 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) Nombre del Cliente (A) F Nom client (A) Nom client (A) I Nome cliente - A Nome cliente - A JA 顧客名 (至) 顧客名 (至) KO 고객명(까지) 고객명(까지) PTB Nome do Cliente (Até) Nome do Cliente (Até) RU Имя заказчика по Имя заказчика по S Kundnamn (till) Kundnamn (till) TR Müşteri Adı (Son) Müşteri Adı (Son) US Customer Name (To) Customer Name (To) ZHS 客户名称（至） 客户名称（至） 6 40 :p_salesrep_low 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) Vendedor (De) F Vendeur (De) Vendeur (De) I Rappresentante commerciale - Da Rappresentante commerciale - Da JA 営業担当 (自) 営業担当 (自) KO 영업사원(부터) 영업사원(부터) PTB Vendedor (De) Vendedor (De) RU Продавец с Продавец с S Säljare (från) Säljare (från) TR Satış Elemanı (İlk) Satış Elemanı (İlk) US Salesperson (From) Salesperson (From) ZHS 销售人员（自） 销售人员（自） 7 50 :p_salesrep_high 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) Vendedor (A) F Vendeur (A) Vendeur (A) I Rappresentante commerciale - A Rappresentante commerciale - A JA 営業担当 (至) 営業担当 (至) KO 영업사원(까지) 영업사원(까지) PTB Vendedor (Até) Vendedor (Até) RU Продавец по Продавец по S Säljare (till) Säljare (till) TR Satış Elemanı (Son) Satış Elemanı (Son) US Salesperson (To) Salesperson (To) ZHS 销售人员（至） 销售人员（至） 8 60 :p_order_date_low Date AR تاريخ الطلب (من) تاريخ الطلب (من) D Von Auftragsdatum Von Auftragsdatum E Fecha de Pedido (De) Fecha de Pedido (De) F Date commande (Du) Date commande (Du) I Data ordine - Da Data ordine - Da JA 受注日 (自) 受注日 (自) KO 주문 일자(부터) 주문 일자(부터) PTB Data da Ordem (De) Data da Ordem (De) RU Дата заказа с Дата заказа с S Orderdatum (från) Orderdatum (från) TR Sipariş Tarihi (İlk) Sipariş Tarihi (İlk) US Order Date (From) Order Date (From) ZHS 订单日期（自） 订单日期（自） 9 70 :p_order_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.order_date_from)) from DUAL AR تاريخ الطلب (إلى) تاريخ الطلب (إلى) D Bis Auftragsdatum Bis Auftragsdatum E Fecha de Pedido (A) Fecha de Pedido (A) F Date commande (Au) Date commande (Au) I Data ordine - A Data ordine - A JA 受注日 (至) 受注日 (至) KO 주문 일자(까지) 주문 일자(까지) PTB Data da Ordem (Até) Data da Ordem (Até) RU Дата заказа по Дата заказа по S Orderdatum (till) Orderdatum (till) TR Sipariş Tarihi (Son) Sipariş Tarihi (Son) US Order Date (To) Order Date (To) ZHS 订单日期（至） 订单日期（至） 10 80 :p_order_num_low Number AR رقم الطلب (من) رقم الطلب (من) D Von Auftragsnummer Von Auftragsnummer E Número de Pedido (De) Número de Pedido (De) F Numéro commande (De) Numéro commande (De) I Numero ordine - Da Numero ordine - Da JA 受注番号 (自) 受注番号 (自) KO 주문 번호(부터) 주문 번호(부터) PTB Número de Ordem (De) Número de Ordem (De) RU Номер заказа с Номер заказа с S Ordernummer (från) Ordernummer (från) TR Sipariş Numarası (İlk) Sipariş Numarası (İlk) US Order Number (From) Order Number (From) ZHS 订单编号（自） 订单编号（自） 11 90 :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) Número de Pedido (A) F Numéro commande (A) Numéro commande (A) I Numero ordine - A Numero ordine - A JA 受注番号 (至) 受注番号 (至) KO 주문 번호(까지) 주문 번호(까지) PTB Número de Ordem (Até) Número de Ordem (Até) RU Номер заказа по Номер заказа по S Ordernummer (till) Ordernummer (till) TR Sipariş Numarası (Son) Sipariş Numarası (Son) US Order Number (To) Order Number (To) ZHS 订单编号（至） 订单编号（至） 12 100 :p_country_low LOV Oracle ONT_SRS_COUNTRY Y select territory_short_name id, territory_short_name value, null description from fnd_territories_vl order by territory_short_name AR شحن إلى الدولة (من) شحن إلى الدولة (من) D (Von) Zu belieferndes Land (Von) Zu belieferndes Land E País de Envío (De) País de Envío (De) F Pays de livraison (De) Pays de livraison (De) I Paese di spedizione (Da) Paese di spedizione (Da) JA 出荷先国 (自) 出荷先国 (自) KO 납품처 국가(부터) 납품처 국가(부터) PTB País para Entrega (De) País para Entrega (De) RU Страна получателя товара с Страна получателя товара с S Inleveransadress - land (från) Inleveransadress - land (från) TR Sevk Varış Ülkesi (İlk) Sevk Varış Ülkesi (İlk) US Ship to Country (From) Ship to Country (From) ZHS 收货地点所在国家（地区）（自） 收货地点所在国家（地区）（自） 13 110 :p_country_high LOV Oracle ONT_SRS_COUNTRY Y select territory_short_name id, territory_short_name value, null description from fnd_territories_vl order by territory_short_name select :$flex$.ship_to_country_from from sys.dual AR شحن إلى الدولة (إلى) شحن إلى الدولة (إلى) D (Bis) Zu belieferndes Land (Bis) Zu belieferndes Land E País de Envío (A) País de Envío (A) F Pays de livraison (A) Pays de livraison (A) I Paese di spedizione (A) Paese di spedizione (A) JA 出荷先国 (至) 出荷先国 (至) KO 납품처 국가(까지) 납품처 국가(까지) PTB País para Entrega (Até) País para Entrega (Até) RU Страна получателя товара по Страна получателя товара по S Leveransadress - land (till) Leveransadress - land (till) TR Sevk Varış Ülkesi (Son) Sevk Varış Ülkesi (Son) US Ship to Country (To) Ship to Country (To) ZHS 收货地点所在国家（地区）（至） 收货地点所在国家（地区）（至） 14 120 :p_order_type_low 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) Tipo de Pedido (De) F Type commande (De) Type commande (De) I Tipo di ordine - Da Tipo di ordine - Da JA 受注タイプ (自) 受注タイプ (自) KO 주문 유형(부터) 주문 유형(부터) PTB Tipo da Ordem (De) Tipo da Ordem (De) RU Тип заказа с Тип заказа с S Ordertyp (från) Ordertyp (från) TR Sipariş Tipi (İlk) Sipariş Tipi (İlk) US Order Type (From) Order Type (From) ZHS 订单类型（自） 订单类型（自） 15 130 :p_order_type_high 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) Tipo de Pedido (A) F Type commande (A) Type commande (A) I Tipo di ordine - A Tipo di ordine - A JA 受注タイプ (至) 受注タイプ (至) KO 주문 유형(까지) 주문 유형(까지) PTB Tipo da Ordem (Até) Tipo da Ordem (Até) RU Тип заказа по Тип заказа по S Ordertyp (till) Ordertyp (till) TR Sipariş Tipi (Son) Sipariş Tipi (Son) US Order Type (To) Order Type (To) ZHS 订单类型（至） 订单类型（至） 16 140 :p_po_num_low Char AR رقم أمر شراء العميل (من) رقم أمر شراء العميل (من) D Von Kundenbestellnummer Von Kundenbestellnummer E Número de Pedido de Compra del Cliente (De) Número de Pedido de Compra del Cliente (De) F Numéro d'ordre d'achat client (De) Numéro d'ordre d'achat client (De) I Numero OA cliente - Da Numero OA cliente - Da JA 顧客発注番号 (自) 顧客発注番号 (自) KO 고객 PO 번호(부터) 고객 PO 번호(부터) PTB Nº da OC do Cliente (De) Nº da OC do Cliente (De) RU Номер ЗП заказчика с Номер ЗП заказчика с S Kundens ink.ordernr (från) Kundens ink.ordernr (från) TR Müşteri SS Numarası (İlk) Müşteri SS Numarası (İlk) US Customer PO Number (From) Customer PO Number (From) ZHS 客户 PO 编号（自） 客户 PO 编号（自） 17 150 :p_po_num_high Char select :$flex$.customer_po_number_from from sys.dual AR رقم أمر شراء العميل (إلى) رقم أمر شراء العميل (إلى) D Bis Kundenbestellnummer Bis Kundenbestellnummer E Número de Pedido de Compra del Cliente (A) Número de Pedido de Compra del Cliente (A) F Numéro d'ordre d'achat client (A) Numéro d'ordre d'achat client (A) I Numero OA cliente - A Numero OA cliente - A JA 顧客発注番号 (至) 顧客発注番号 (至) KO 고객 PO 번호(까지) 고객 PO 번호(까지) PTB Nº da OC do Cliente (Até) Nº da OC do Cliente (Até) RU Номер ЗП заказчика по Номер ЗП заказчика по S Kundens ink.ordernr (till) Kundens ink.ordernr (till) TR Müşteri SS Numarası (Son) Müşteri SS Numarası (Son) US Customer PO Number (To) Customer PO Number (To) ZHS 客户 PO 编号（至） 客户 PO 编号（至） 18 160 :p_created_by_low LOV Oracle ONT_SRS_AOL_USER Y select user_name id, user_name value, null description from fnd_user order by user_name AR مكون بواسطة (من) مكون بواسطة (من) D Von Erstellt von Von Erstellt von E Creado por (De) Creado por (De) F Créé par (De) Créé par (De) I Creato da - Da Creato da - Da JA 作成者 (自) 作成者 (自) KO 생성자(부터) 생성자(부터) PTB Criado Por (De) Criado Por (De) RU Создано с Создано с S Skapad av (från) Skapad av (från) TR Oluşturan (İlk) Oluşturan (İlk) US Created By (From) Created By (From) ZHS 创建者（自） 创建者（自） 19 170 :p_created_by_high LOV Oracle ONT_SRS_AOL_USER Y select user_name id, user_name value, null description from fnd_user order by user_name select :$flex$.created_by_from from sys.dual AR مكون بواسطة (إلى) مكون بواسطة (إلى) D Bis Erstellt von Bis Erstellt von E Creado por (A) Creado por (A) F Créé par (A) Créé par (A) I Creato da - A Creato da - A JA 作成者 (至) 作成者 (至) KO 생성자(까지) 생성자(까지) PTB Criado por (Até) Criado por (Até) RU Создано по Создано по S Skapad av (till) Skapad av (till) TR Oluşturan (Son) Oluşturan (Son) US Created By (To) Created By (To) ZHS 创建者（至） 创建者（至） 20 180 :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 Vereinbarungsbezeichnung E Acuerdo Nombre de Acuerdo F Accord-cadre Nom de l'accord-cadre I Accordo Nome contratto JA 基本契約 基本契約名 KO 계약 계약명 PTB Acordo Nome do Acordo RU Соглашен. Соглашение S Avtal Avtal TR Anlaşma Anlaşma Adı US Agreement Agreement Name ZHS 协议 协议名称 21 190 :p_order_source LOV Oracle ONT_SRS_ORDER_SOURCES Y select order_source_id id, name value, null description from oe_order_sources order by name AR مصدر الطلب مصدر الطلب D Auftragsherkunft Auftragsherkunft E Origen del Pedido Origen del Pedido F Origine de commande Origine de commande I Orig. ordine Orig. ordine JA 受注ソース 受注ソース KO 주문 출처 주문 출처 PTB Origem da Ordem Origem da Ordem RU Источник заказа Источник заказа S Orderkälla Orderkälla TR Sipariş Kaynağı Sipariş Kaynağı US Order Source Order Source ZHS 订单来源 订单来源 22 200 :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 Sólo Pedidos Abiertos F Commandes en cours uniquement Commandes en cours uniquement I Solo ordini aperti Solo ordini aperti JA オープン受注のみ オープン受注のみ KO 개설 주문만 개설 주문만 PTB Somente Ordens em Aberto Somente Ordens em Aberto RU Только открытые заказы Только открытые заказы S Endast uteliggande order Endast uteliggande order TR Sadece Açık Siparişler Sadece Açık Siparişler US Open Orders Only Open Orders Only ZHS 仅限于未完成订单 仅限于未完成订单 23 210 :p_use_functional_currency 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_code = 'N' and lookup_type = 'YES_NO' AR استخدام عملة دفتر الأستاذ استخدام عملة دفتر الأستاذ D Buchwährung verwenden Buchwährung verwenden E Utilizar Divisa de Libro Mayor Utilizar divisa del libro mayor F Utiliser la devise comptable Utiliser la devise comptable I Usa divisa libro contabile Usa la divisa del libro contabile JA 元帳通貨の使用 元帳通貨の使用 KO 원장 통화 사용 원장 통화 사용 PTB Usar Moeda do Razão Usar Moeda do Razão RU Использовать валюту книги Использовать валюту книги S Använd reskontravaluta Använd reskontravaluta TR Defter Para Birimini Kullan Defter Para Birimini Kullan US Use Ledger Currency Use Ledger Currency ZHS 使用分类帐币种 使用分类帐币种