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）限制的操作单元。 C6E085D470F951A9E05362FB09050512Y select distinct h.header_id header_id10, h.order_number, ot.name Order_Type, sold_to_org.name customer_name, sold_to_org.customer_number, h.cust_po_number purchase_order, sold_party.PERSON_LAST_NAME || DECODE(sold_party.PERSON_FIRST_NAME, NULL, NULL, ', '|| sold_party.PERSON_FIRST_NAME) || DECODE(sold_arl.meaning,NULL, NULL, ' ' ||sold_arl.meaning) CONTACT, h.sold_to_contact_id contact_id, h.creation_date, h.ordered_date order_date, h.booked_date booked_date, 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))) order_value, 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))) order_list, h.transactional_curr_code currency1, h.conversion_rate, h.conversion_type_code, h.request_date hdr_request_date, h.flow_status_code order_status, h.tax_exempt_reason_code tax_exempt_reason, h.tax_exempt_number tax_exempt_number, ar_lk.meaning tax_type, lk.meaning open_order, u.user_name entered_by, qp.name price_list, t.name terms, acc_rule.name accounting_rule, h.accounting_rule_duration, inv_rule.name invoicing_rule, sr.name salesrep, agree.name agreement, party_s.party_name ship_customer, loc.address1 s_address1, loc.address2 s_address2, loc.address3 s_address3, loc.city || ' , '||loc.state || ' , '||loc.postal_code || ' , '||loc.country s_address4, party_b.party_name bill_customer, billorg.address_line_1 b_address1, billorg.address_line_2 b_address2, billorg.address_line_3 b_address3, billorg.town_or_city || ', '||billorg.state || ', '||billorg.postal_code || ', '||billorg.country b_address4, h.ship_to_org_id hdr_ship_site_use_id, h.invoice_to_org_id, loc.country, ONT_OEXOECOD_XMLP_PKG.contact_phone(h.sold_to_contact_id) C_contact_phone, ONT_OEXOECOD_XMLP_PKG.c_use_currencyformula(:C_base_currency, h.transactional_curr_code) C_USE_CURRENCY, ONT_OEXOECOD_XMLP_PKG.c_gl_conv_rateformula(h.transactional_curr_code, :C_base_currency, h.conversion_rate, h.ordered_date, h.conversion_type_code) C_gl_conv_rate, ONT_OEXOECOD_XMLP_PKG.c_fc_order_valueformula(ONT_OEXOECOD_XMLP_PKG.c_gl_conv_rateformula(h.transactional_curr_code, :C_base_currency, h.conversion_rate, h.ordered_date, h.conversion_type_code), h.header_id) C_fc_order_value, ONT_OEXOECOD_XMLP_PKG.c_ship_hdr_address4formula(loc.city || ' , ' || loc.state || ' , ' || loc.postal_code || ' , ' || loc.country, h.ship_to_org_id) C_ship_hdr_address4, ONT_OEXOECOD_XMLP_PKG.c_bill_hdr_address4formula(billorg.town_or_city || ', ' || billorg.state || ', ' || billorg.postal_code || ', ' || billorg.country, h.invoice_to_org_id) C_Bill_hdr_address4, ONT_OEXOECOD_XMLP_PKG.cf_initial_due_totalformula(h.header_id) CF_INITIAL_DUE_TOTAL, /*ONT_OEXOECOD_XMLP_PKG.cf_initial_due_balanceformula(:CF_INITIAL_DUE_TOTAL, :CS_PREPAID_AMOUNT) CF_INITIAL_DUE_BALANCE,*/ ONT_OEXOECOD_XMLP_PKG.cf_authorized_amountformula(h.header_id) CF_AUTHORIZED_AMOUNT, ONT_OEXOECOD_XMLP_PKG.CP_STD_PRECISION_p CP_STD_PRECISION, ONT_OEXOECOD_XMLP_PKG.CP_EXT_PRECISION_p CP_EXT_PRECISION, ONT_OEXOECOD_XMLP_PKG.CP_MIN_ACCT_UNIT_p CP_MIN_ACCT_UNIT, ONT_OEXOECOD_XMLP_PKG.CP_COMMITMENT_p CP_COMMITMENT from oe_order_headers_all h, oe_order_lines_all l, oe_transaction_types_tl ot, oe_transaction_types_tl ol, oe_sold_to_orgs_v sold_to_org, hz_party_sites party_site, hz_locations loc, hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all acct_site_uses, oe_invoice_to_orgs_v billorg, hz_cust_account_roles sold_roles, hz_parties sold_party, hz_cust_accounts sold_acct, hz_relationships sold_rel, ar_lookups sold_arl, qp_price_lists_v qp, ra_terms_tl t, ra_rules acc_rule, ra_rules inv_rule, hz_parties party_s, hz_cust_accounts cust_acct_s, hz_parties party_b, hz_cust_accounts cust_acct_b, ra_salesreps_all sr, oe_agreements agree, fnd_user u, ar_lookups ar_lk, oe_lookups lk where (h.cancelled_flag='N' or h.cancelled_flag is null ) and l.line_type_id=ol.transaction_type_id and cust_acct_s.party_id = party_s.party_id(+) and cust_acct_s.cust_account_id(+) = acct_site.cust_account_id and cust_acct_b.party_id = party_b.party_id(+) and cust_acct_b.cust_account_id(+) = billorg.customer_id and h.order_type_id = ot.transaction_type_id and ot.language = userenv('LANG') and h.sold_to_org_id = sold_to_org.organization_id(+) and h.invoice_to_org_id = billorg.organization_id(+) and acct_site.party_site_id = party_site.party_site_id(+) and loc.location_id(+) = party_site.location_id and acct_site_uses.cust_acct_site_id = acct_site.cust_acct_site_id(+) and acct_site_uses.site_use_code(+) = 'SHIP_TO' and h.ship_to_org_id = acct_site_uses.site_use_id(+) AND h.sold_to_contact_id = sold_roles.cust_account_role_id(+) AND sold_roles.party_id = sold_rel.party_id(+) AND sold_roles.role_type(+) = 'CONTACT' AND sold_roles.cust_account_id = sold_acct.cust_account_id(+) AND nvl(sold_rel.object_id,-1) = nvl(sold_acct.party_id,-1) AND sold_rel.subject_id = sold_party.party_id(+) AND sold_arl.lookup_type(+) = 'CONTACT_TITLE' AND sold_arl.lookup_code(+) = sold_party.person_pre_name_adjunct and h.salesrep_id = sr.salesrep_id (+) and sr.org_id(+) = :lp_organization_id and ar_lk.lookup_code(+) = h.tax_exempt_flag and ar_lk.lookup_type(+) = 'TAX_CONTROL_FLAG' and lk.lookup_code(+) = h.open_flag and lk.lookup_type(+) = 'YES_NO' and u.user_id(+) = h.created_by and h.header_id = l.header_id and l.item_type_code != 'INCLUDED' and nvl(l.org_id,0) = nvl(:lp_organization_id,0) and nvl(h.org_id,0) = nvl(:lp_organization_id,0) and h.price_list_id = qp.price_list_id(+) and t.language(+) = userenv('LANG') and h.payment_term_id = t.term_id(+) and h.accounting_rule_id = acc_rule.rule_id(+) and h.invoicing_rule_id = inv_rule.rule_id(+) and h.agreement_id = agree.agreement_id(+) &C_open_orders_where &lp_order_num &lp_customer_number &lp_order_type &lp_order_date &lp_customer_name &lp_salesrep_name &lp_entered_by &lp_order_category &lp_line_type &lp_line_category group by h.header_id, h.order_number, ot.name, Sold_To_org.name, sold_to_org.customer_number, h.cust_po_number, sold_party.PERSON_LAST_NAME || DECODE(sold_party.PERSON_FIRST_NAME, NULL, NULL, ', '|| sold_party.PERSON_FIRST_NAME) ||DECODE(sold_arl.meaning,NULL, NULL, ' '||sold_arl.meaning) , h.sold_to_contact_id, h.creation_date, h.ordered_date, h.booked_date, h.transactional_curr_code, h.conversion_rate, h.conversion_type_code, h.request_date, h.flow_status_code, h.tax_exempt_reason_code, h.tax_exempt_number, ar_lk.meaning, lk.meaning, u.user_name, qp.name, t.name, acc_rule.name, h.accounting_rule_duration, Inv_Rule.name, sr.name, Agree.name, party_b.party_name, billorg.address_line_1 , billorg.address_line_2 , billorg.address_line_3 , billorg.town_or_city || ', '||billorg.state || ', '||billorg.postal_code || ', '||billorg.country , party_s.party_name , loc.address1, loc.address2 , loc.address3 , loc.city || ' , '||loc.state || ' , '||loc.postal_code || ' , '||loc.country , h.ship_to_org_id, h.invoice_to_org_id, loc.country order by &lp_order_by ot.name, h.order_number ONT OEXOECOD_XML AR ONT تقرير تفاصيل الطلب الشامل Imported from BI Publisher Description: تقرير تفاصيل الطلب الشامل Application: إدارة الطلبات Source: تقرير تفاصيل الطلب الشامل (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG D ONT Aufträge - Details Imported from BI Publisher Description: Aufträge - Details Application: Order Management Source: Aufträge - Details (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG E ONT Informe Detalle Exhaustivo de Pedidos Imported from BI Publisher Description: Informe Detalle Exhaustivo de Pedidos Application: Order Management Source: Informe Detalle Exhaustivo de Pedidos (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG F ONT Etat Analyse complète de commande Imported from BI Publisher Description: Etat Analyse complète de commande Application: Order Management Source: Etat Analyse complète de commande (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG I ONT Rapporto completo Dettagli ordini Imported from BI Publisher Description: Rapporto completo Dettagli ordini Application: Order Management Source: Rapporto completo Dettagli ordini (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG JA ONT 包括受注詳細レポート Imported from BI Publisher Description: 包括受注詳細レポート Application: Order Management Source: 包括受注詳細レポート(XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG KO ONT 종합적인 주문 상세 보고서 Imported from BI Publisher Description: 종합적인 주문 상세내역 보고서 Application: Order Management Source: 종합적인 주문 상세 보고서(XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG PTB ONT Relatório Detalhado da Ordem Abrangente Imported from BI Publisher Description: Relatório Detalhado da Ordem Abrangente Application: Gerenciamento de Ordens Source: Relatório Detalhado da Ordem Abrangente (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG RU ONT Полный отчет о заказах Imported from BI Publisher Description: Полный отчет о заказах Application: Управление заказами Source: Полный отчет о заказах (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG S ONT Omfattande rapport om orderdetaljer Imported from BI Publisher Description: Omfattande rapport om orderdetaljer Application: Order Management Source: Omfattande rapport om orderdetaljer (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG TR ONT Kapsamlı Sipariş Detay Raporu Imported from BI Publisher Description: Kapsamlı Sipariş Detay Raporu Application: Sipariş Yönetimi(1) Source: Kapsamlı Sipariş Detay Raporu (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG US ONT Comprehensive Order Detail Imported from BI Publisher Description: Comprehensive Order Detail Report Application: Order Management Source: Comprehensive Order Detail Report (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG ZHS ONT 综合订单详细信息报表 Imported from BI Publisher Description: 综合订单明细报表 Application: 订单管理 Source: 综合订单详细信息报表 (XML) Short Name: OEXOECOD_XML DB package: ONT_OEXOECOD_XMLP_PKG BI Publisher &c_open_orders_where &lp_customer_name &lp_customer_number &lp_entered_by &lp_line_category &lp_line_type &lp_order_by &lp_order_category &lp_order_date &lp_order_num &lp_order_type &lp_salesrep_name :c_base_currency :cp_commitment :cp_ext_precision :cp_line_commitment :cp_min_acct_unit :cp_std_precision :l_line_type_high :l_line_type_low :l_order_type_high :l_order_type_low :lp_customer_name :lp_customer_number :lp_entered_by :lp_line_category :lp_line_type :lp_line_type_where :lp_order_by :lp_order_category :lp_order_date :lp_order_num :lp_order_type :lp_organization_id :lp_salesrep_name :operating_unit :p_adjustments :p_charge_periodicity :p_conc_request_id :p_cust_num_hi :p_cust_num_lo :p_customer_hi :p_customer_lo :p_enable_trace :p_end_cust :p_entered_by_hi :p_entered_by_lo :p_functional_currency :p_item_flex_code :p_item_structure_num :p_line_category :p_line_type_hi :p_line_type_lo :p_open_orders :p_order_by :p_order_category :p_order_date_hi :p_order_date_hi_t :p_order_date_lo :p_order_date_lo_t :p_order_num_hi :p_order_num_lo :p_order_type_hi :p_order_type_lo :p_organization_id :p_print_description :p_sales_credits :p_salesrep_hi :p_salesrep_lo :p_sob_id :rp_curr_profile :rp_item_flex_all_seg :rp_item_flex_seg_val 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_OEXOECOD_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXOAPOA ORDER BY' order by meaning select meaning from oe_lookups where lookup_type='OEXOAPOA ORDER BY' and lookup_code='ORDER_TYPE' 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_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) Från ordertyp TR Sipariş Tipi (İlk) Sipariş Tipi Alt Değeri US Order Type (From) Order Type Low ZHS 订单类型（自） 订单类型下限 5 30 :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 - A I Tipo di ordine - A Tipo di ordine (massimo) JA 受注タイプ (至) 受注タイプ:至 KO 주문 유형(까지) 주문 유형 상한 PTB Tipo da Ordem (Até) Tipo de Ordem - Superior RU Тип заказа по Тип заказа по S Ordertyp (till) Till ordertyp TR Sipariş Tipi (Son) Sipariş Tipi Üst Değeri US Order Type (To) Order Type High ZHS 订单类型（至） 订单类型上限 6 40 :p_line_type_lo LOV Oracle ONT_MOAC_SRS_LINE_TYPES Y select lt.line_type_id id, lt.name value, null description from oe_line_types_v lt,hr_operating_units ou where lt.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=lt.org_id) order by lt.name AR سطر الطلب (من) سطر الطلب من D Von Positionsart Von Positionsart E Tipo de Línea (De) De Tipo de Línea F Type de ligne (De) Type de ligne - De I Tipo di linea - Da Tipo di linea - Minimo JA 明細タイプ (自) 明細タイプ:自 KO 라인 유형(부터) 라인 유형 하한 PTB Tipo de Linha (De) Tipo de Linha - Inferior RU Тип строки с Тип строки с S Radtyp (från) Från radtyp TR Satır Tipi (İlk) Satır Tipi Alt Değeri US Line Type (From) Line Type Low ZHS 行类型（自） 行类型下限 7 50 :p_line_type_hi LOV Oracle ONT_MOAC_SRS_LINE_TYPES Y select lt.line_type_id id, lt.name value, null description from oe_line_types_v lt,hr_operating_units ou where lt.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=lt.org_id) order by lt.name AR نوع السطر (إلى) نوع السطر إلى D Bis Positionsart Bis Positionsart E Tipo de Línea (A) A Tipo de Línea F Type de ligne (A) Type de ligne - A I Tipo di linea - A Tipo di linea - Massimo JA 明細タイプ (至) 明細タイプ:至 KO 라인 유형(까지) 라인 유형 상한 PTB Tipo de Linha (Até) Tipo de Linha - Superior RU Тип строки по Тип строки по S Radtyp (till) Till radtyp TR Satır Tipi (Son) Satır Tipi Üst Değeri US Line Type (To) Line Type High ZHS 行类型（至） 行类型上限 8 60 :p_order_num_lo 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 订单编号（自） 订单编号下限 9 70 :p_order_num_hi 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 订单编号（至） 订单编号上限 10 80 :p_order_date_lo 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 订单日期（自） 订单日期下限 11 90 :p_order_date_hi 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 订单日期（至） 订单日期上限 12 100 :p_customer_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 du 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) Från kundnamn TR Müşteri Adı (İlk) Müşteri Adı Alt Değeri US Customer Name (From) Customer Name Low ZHS 客户名称（自） 客户名称下限 13 110 :p_customer_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 DUAL AR اسم العميل (إلى) اسم العميل إلى D Bis Kunde Bis Kundenname E Nombre del Cliente (A) A Nombre de Cliente F Nom client (A) Nom du client - A I Nome cliente - A Nome cliente (max) JA 顧客名 (至) 顧客名:至 KO 고객명(까지) 고객명 상한 PTB Nome do Cliente (Até) Nome do Cliente - Superior RU Имя заказчика по Имя заказчика по S Kundnamn (till) Till kundnamn TR Müşteri Adı (Son) Müşteri Adı Üst Değeri US Customer Name (To) Customer Name High ZHS 客户名称（至） 客户名称上限 14 120 :p_cust_num_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 de client - De I Numero cliente - Da Numero cliente (min) JA 顧客番号 (自) 顧客番号:自 KO 고객 번호(부터) 고객 번호 하한 PTB Número do Cliente (De) Número do Cliente - Inferior RU Номер заказчика с Номер заказчика с S Kundnummer (från) Från kundnummer TR Müşteri Numarası (İlk) Müşteri Numarası Alt Değeri US Customer Number (From) Customer Number Low ZHS 客户编号（自） 客户编号下限 15 130 :p_cust_num_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 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 de client - A I Numero cliente - A Numero cliente (max) JA 顧客番号 (至) 顧客番号:至 KO 고객 번호(까지) 고객 번호 상한 PTB Número do Cliente (Até) Número do Cliente - Superior RU Номер заказчика по Номер заказчика по S Kundnummer (till) Till kundnummer TR Müşteri Numarası (Son) Müşteri Numarası Üst Değeri US Customer Number (To) Customer Number High ZHS 客户编号（至） 客户编号上限 16 140 :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 De Nombre del Vendedor De Vendedor F Nom vendeur (De) Vendeur - De I Nome venditore (Da) Nome venditore (minimo) JA 営業担当名 (自) 営業担当:自 KO 영업사원명(부터) 영업사원 하한 PTB Nome do Vendedor (De) Rep. de Vendas - Inferior RU Имя продавца с Продавец с S Namn på säljare från Från säljare TR Satış Elemanı Adı (İlk) Satış Temsilcisi Alt Değeri US Salesperson Name (From) Salesrep Low ZHS 销售人员姓名（自） 销售代表下限 17 150 :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 A Nombre del Vendedor A Vendedor F Nom vendeur (A) Vendeur - A I Nome rappresentante commerciale - A Nome venditore (massimo) JA 営業担当名 (至) 営業担当:至 KO 영업사원명(까지) 영업사원 상한 PTB Nome do Vendedor (Até) Rep. de Venda - Superior RU Имя продавца по Продавец по S Namn på säljare (till) Till säljare TR Satış Elemanı Adı (Son) Satış Temsilcisi Üst Değeri US Salesperson Name (To) Salesrep High ZHS 销售人员姓名（至） 销售代表上限 18 160 :p_entered_by_lo 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 Eingegeben von Von Eingegeben von E Introducido por (De) De Introducido por F Saisi par (De) Saisi par - De I Inserito da - Da Inserito da (minimo) JA 入力担当 (自) 入力担当:自 KO 입력자(부터) 입력자 하한 PTB Informado Por (De) Informado por - Inferior RU Введено с Введено с S Registrerad av (från) Från registrerad av TR Giren (İlk) Giriş Yapan Alt Değeri US Entered By (From) Entered By Low ZHS 输入者（自） 输入者下限 19 170 :p_entered_by_hi 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$.entered_by_from from DUAL AR مدخل بواسطة (إلى) مدخل بواسطة إلى D Bis Eingegeben von Bis Eingegeben von E Introducido por (A) A Introducido por F Saisi par (A) Saisi par - A I Inserito da - A Inserito da (massimo) JA 入力担当 (至) 入力担当:至 KO 입력자(까지) 입력자 상한 PTB Informado por (Até) Informado por - Superior RU Введено по Введено по S Registrerad av (till) Till registrerad av TR Giren (Son) Giriş Yapan Üst Değeri US Entered By (To) Entered By High ZHS 输入者（至） 输入者上限 20 180 :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 select meaning from oe_lookups where lookup_type='REPORT_ORDER_CATEGORY' and lookup_code='SALES' 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 订单类别 订单类别 21 190 :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 select meaning from oe_lookups where lookup_type='REPORT_LINE_DISPLAY' and lookup_code='ALL' 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 行类别 行类别 22 200 :p_open_orders 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 Mostrar Sólo Pedidos Abiertos Sólo Pedidos Abiertos F Afficher commandes en cours uniquement Commandes en cours uniquement I Mostra solo ordini aperti Solo ordini aperti JA オープン受注のみ表示 オープン受注のみ KO 개설 주문만 표시 개설 주문만 PTB Mostrar Apenas Ordens em Aberto Somente Ordens em Aberto RU Показывать только открытые заказы Только открытые заказы S Visa endast öppna order Endast uteliggande order TR Sadece Açık Siparişleri Göster Sadece Açık Siparişler US Show Open Orders Only Open Orders Only ZHS 仅显示打开的订单 仅限于未完成订单 23 210 :p_sales_credits 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' AR إظهار البيع بالآجل المبيعات بالآجل D Umsatzgutschriften anzeigen Umsatzgutschriften E Mostrar Créditos de Ventas Créditos de Ventas F Voir commissions Commissions I Mostra basi provvigioni Basi provvigioni JA 販売実績の表示 販売実績 KO 판매 실적 표시 판매 실적 PTB Mostrar Créditos de Vendas Créditos de Venda RU Показывать торговые кредиты Торговые кредиты S Visa provisionsunderlag Provisionsunderlag TR Satış Kredilerini Göster Satış Kredileri US Show Sales Credits Sales Credits ZHS 显示销售业绩 销售业绩 24 220 :p_adjustments 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' AR إظهار تعديلات السعر تعديلات السعر D Preisanpassungen anzeigen Preisanpassungen E Mostrar Ajustes en Precio Ajustes en Precio F Voir ajust. prix Ajustements de prix I Mostra adeguamenti prezzo Adeguamenti prezzo JA 値引情報の表示 価格調整 KO 가격 조정 표시 가격 조정 PTB Mostrar Ajustes de Preço Ajustes de Preço RU Показывать корректировки цены Корректировки цены S Visa prisjusteringar Prisjusteringar TR Fiyat Düzeltmelerini Göster Fiyat Düzeltmeleri US Show Price Adjustments Price Adjustments ZHS 显示价格调整 价格调整 25 230 :p_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_type='YES_NO' and lookup_code='N' AR إظهار بعملة دفتر الأستاذ عملة دفتر الأستاذ D In Buchwährung anzeigen Buchwährung E Mostrar en Divisa del Libro Mayor Divisa de Libro Mayor F Afficher en devise comptable Devise comptable I Mostra nella divisa del libro contabile Divisa del libro contabile JA 元帳通貨で表示 元帳通貨 KO 원장 통화 표시 원장 통화 PTB Mostrar na Moeda Razão Moeda do Razão RU Вывод в валюте книги Валюта книги S Visa i reskontravaluta Huvudboksvaluta TR Defter Para Biriminde Göster Defter Para Birimi US Show in Ledger Currency Ledger Currency ZHS 以分类帐币种显示 分类帐币种 26 240 :p_print_description LOV Oracle ONT_SRS_ITEM_DISPLAY_CODE Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='ITEM_DISPLAY_CODE' order by value,description select meaning from oe_lookups where lookup_type = 'ITEM_DISPLAY_CODE' and lookup_code = 'D' AR عرض الصنف عرض الصنف D Artikelanzeige Artikelanzeige E Presentación de Artículo Presentación de Artículo F Affichage article Affichage article I Visualizzazione articolo Visualizzazione articolo JA 品目表示 品目表示 KO 품목 표시 품목 표시 PTB Exibição do Item Exibição do Item RU Вывод позиции Вывод позиции S Artikelvisning Artikelvisning TR Kalem Görüntüleme Kalem Görüntüleme US Item Display Item Display ZHS 项目显示 项目显示 27 250 :p_end_cust 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='N' AR إظهار تفاصيل عميل نهائي وقاعدة التركيبات إظهار تفاصيل العميل النهائي D Details für Endkunden und Installierte Basis anzeigen Endkundendetails anzeigen E Mostrar Detalles de Cliente Final y de la Base Instalada Mostrar Detalles de Cliente Final F Afficher les détails du client final et de la base installée Afficher les détails du client final I Mostra cliente finale e dettagli base installata Mostra dettagli cliente finale JA 最終顧客および導入ベース詳細の表示 最終顧客詳細の表示 KO 최종 고객 및 Installed Base 상세내역 표시 최종 고객 상세내역 표시 PTB Mostrar Detalhes do Cliente Final e da Base Instalada Mostrar Detalhes do Cliente Final RU Показ. свед. о конеч. заказ. и базе установок Показать сведения о конечном заказчике S Visa detaljer för slutkund och installerad bas Visa detaljer för slutkund TR Son Müşteri ve Müşteri Ürünleri Detaylarını Göster Son Müşteri Detaylarını Göster US Show End Customer and Installed Base Details Show End Customer Details ZHS 显示最终客户和产品安装信息库详细信息 显示最终客户详细资料