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）限制的操作单元。 C6E085D470F551A9E05362FB09050512Y select l.line_number || decode(l.shipment_number, null, null, '.'||l.shipment_number) || decode(l.option_number, null, null, '.'||l.option_number) line_number, l.line_number l_number, l.shipment_number l_ship_number, l.option_number l_option_number, l.ordered_quantity , l.pricing_quantity, l.item_identifier_type, --&rp_item_flex_all_seg item_flex, l.inventory_item_id, l.ordered_item_id, l.ordered_item, --Removed trunc function on the below three date fields for bug 17768119 l.request_date Request_Date, l.promise_date Promise_Date, l.schedule_ship_date Schedule_Date, --Changes for Bug 1776 complete nvl(&lp_unit_of_measure, uom.unit_of_measure) Unit, l.unit_selling_price Selling_Price, NVL(l.tax_value,0) Tax_On_Line, ship_party.party_name||decode(ship_loc.address4,null,decode(ship_loc.address3,null,decode(ship_loc.address2,null,decode(ship_loc.address1,null,null,','||ship_loc.address1),','||ship_loc.address1||','||ship_loc.address2),','||ship_loc.address1||','||ship_loc.address2||','||ship_loc.address3),','||ship_loc.address1||','||ship_loc.address2||','||ship_loc.address3||','||ship_loc.address4)||','||ship_loc.city||decode(ship_loc.city,null,null,decode(ship_loc.state,null,null,','||ship_loc.state))||decode(ship_loc.province,null,null,','||ship_loc.province)||' '||ship_loc.postal_code line_s_city_st_zip, bill_party.party_name||decode(bill_loc.address4,null,decode(bill_loc.address3,null,decode(bill_loc.address2,null,decode(bill_loc.address1,null,null,','||bill_loc.address1),','||bill_loc.address1||','||bill_loc.address2),','||bill_loc.address1||','||bill_loc.address2||','||bill_loc.address3),','||bill_loc.address1||','||bill_loc.address2||','||bill_loc.address3||','||bill_loc.address4)||','||bill_loc.city||decode(bill_loc.city,null,null,decode(bill_loc.state,null,null,','||bill_loc.state))||decode(bill_loc.province,null,null,','||bill_loc.province)||' '||bill_loc.postal_code line_b_city_st_zip, del_party.party_name||decode(del_loc.address4,null,decode(del_loc.address3,null,decode(del_loc.address2,null,decode(del_loc.address1,null,null,','||del_loc.address1),','||del_loc.address1||','||del_loc.address2),','||del_loc.address1||','||del_loc.address2||','||del_loc.address3),','||del_loc.address1||','||del_loc.address2||','||del_loc.address3||','||del_loc.address4)||','||del_loc.city||decode(del_loc.city,null,null,decode(del_loc.state,null,null,','||del_loc.state))||decode(del_loc.province,null,null,','||del_loc.province)||' '||del_loc.postal_code line_d_city_st_zip, l.ship_to_org_id line_ship_to_org_id, l.invoice_to_org_id line_bill_to_org_id, l.deliver_to_org_id line_del_to_org_id, l.header_id line_header_id, l.line_id line_id_q_lines, To_Char(l.Line_Id) char_line_Id, l.line_type_id, a.name line_agreement, l.cust_po_number line_po, terms.name line_term, sr.name line_salesrep, lk1.meaning Line_Freight_Terms, lk2.meaning Line_FOB, f.carrier_name Line_Carrier, ol.name Line_Type, l.line_category_code, l.user_item_description, l.charge_periodicity_code, l.contingency_id, ONT_OEXOEACK_XMLP_PKG.c_charge_periodicityformula(l.charge_periodicity_code) C_CHARGE_PERIODICITY, ONT_OEXOEACK_XMLP_PKG.g_grand_totalformula(l.charge_periodicity_code, fnd_number.canonical_to_number(:C_TAX_TOTAL), fnd_number.canonical_to_number(:C_LINE_RECUR_CHARGE), fnd_number.canonical_to_number(:CF_EXTENDED_PRICE), fnd_number.canonical_to_number(:C_svc_extended_price), fnd_number.canonical_to_number(:c_header_charge_periodicity), :C_precision) C_GRAND_TOTAL, ONT_OEXOEACK_XMLP_PKG.g_precisionformula(:CURRENCY) CF_PRECISION, ONT_OEXOEACK_XMLP_PKG.c_header_charge_periodicityfor(l.charge_periodicity_code, fnd_number.canonical_to_number(:c_header_charge), :C_precision) c_header_charge_periodicity, --&Item_dsp Item_dsp, ONT_OEXOEACK_XMLP_PKG.ITEM_DSPFORMULA(l.user_item_description,l.item_identifier_type, l.inventory_item_id, :c_master_org, l.ORDERED_ITEM_ID, l.ORDERED_ITEM, si.organization_id, si.inventory_item_id) Item_dsp, ONT_OEXOEACK_XMLP_PKG.c_accept_requiredformula(l.contingency_id) C_ACCEPT_REQUIRED, ONT_OEXOEACK_XMLP_PKG.c_line_ship_to_custformula(l.ship_to_org_id, :HDR_SHIP_TO_ORG_ID, ship_party.party_name || decode ( ship_loc.address4 , null , decode ( ship_loc.address3 , null , decode ( ship_loc.address2 , null , decode ( ship_loc.address1 , null , null , ',' || ship_loc.address1 ) , ',' || ship_loc.address1 || ',' || ship_loc.address2 ) , ',' || ship_loc.address1 || ',' || ship_loc.address2 || ',' || ship_loc.address3 ) , ',' || ship_loc.address1 || ',' || ship_loc.address2 || ',' || ship_loc.address3 || ',' || ship_loc.address4 ) || ',' || ship_loc.city || decode ( ship_loc.city , null , null , decode ( ship_loc.state , null , null , ',' || ship_loc.state ) ) || decode ( ship_loc.province , null , null , ',' || ship_loc.province ) || ' ' || ship_loc.postal_code) C_LINE_SHIP_TO_CUST, ONT_OEXOEACK_XMLP_PKG.c_extended_priceformula(l.unit_selling_price, :C_precision, l.pricing_quantity, l.line_category_code, l.ordered_quantity) C_EXTENDED_PRICE, ONT_OEXOEACK_XMLP_PKG.c_line_del_to_custformula(l.deliver_to_org_id, :HDR_DEL_TO_ORG_ID, del_party.party_name || decode ( del_loc.address4 , null , decode ( del_loc.address3 , null , decode ( del_loc.address2 , null , decode ( del_loc.address1 , null , null , ',' || del_loc.address1 ) , ',' || del_loc.address1 || ',' || del_loc.address2 ) , ',' || del_loc.address1 || ',' || del_loc.address2 || ',' || del_loc.address3 ) , ',' || del_loc.address1 || ',' || del_loc.address2 || ',' || del_loc.address3 || ',' || del_loc.address4 ) || ',' || del_loc.city || decode ( del_loc.city , null , null , decode ( del_loc.state , null , null , ',' || del_loc.state ) ) || decode ( del_loc.province , null , null , ',' || del_loc.province ) || ' ' || del_loc.postal_code) C_Line_Del_To_Cust, ONT_OEXOEACK_XMLP_PKG.c_line_bill_to_custformula(l.invoice_to_org_id, :HDR_BILL_TO_ORG_ID, bill_party.party_name || decode ( bill_loc.address4 , null , decode ( bill_loc.address3 , null , decode ( bill_loc.address2 , null , decode ( bill_loc.address1 , null , null , ',' || bill_loc.address1 ) , ',' || bill_loc.address1 || ',' || bill_loc.address2 ) , ',' || bill_loc.address1 || ',' || bill_loc.address2 || ',' || bill_loc.address3 ) , ',' || bill_loc.address1 || ',' || bill_loc.address2 || ',' || bill_loc.address3 || ',' || bill_loc.address4 ) || ',' || bill_loc.city || decode ( bill_loc.city , null , null , decode ( bill_loc.state , null , null , ',' || bill_loc.state ) ) || decode ( bill_loc.province , null , null , ',' || bill_loc.province ) || ' ' || bill_loc.postal_code) C_Line_Bill_To_Cust, ONT_OEXOEACK_XMLP_PKG.c_line_salesrepformula(sr.name, :SALES_PERSON) C_Line_Salesrep, ONT_OEXOEACK_XMLP_PKG.c_line_freight_termsformula(lk1.meaning, :FREIGHT_TERMS) C_Line_Freight_Terms, ONT_OEXOEACK_XMLP_PKG.c_line_carrierformula(f.carrier_name, :CARRIER) C_Line_Carrier, ONT_OEXOEACK_XMLP_PKG.c_line_fobformula(lk2.meaning, :FOB) C_Line_FOB, ONT_OEXOEACK_XMLP_PKG.c_line_typeformula(l.line_type_id, ol.name) C_Line_Type, ONT_OEXOEACK_XMLP_PKG.c_line_poformula(l.cust_po_number, :PURCHASE_ORDER) C_Line_PO, ONT_OEXOEACK_XMLP_PKG.c_line_agreementformula(a.name, :AGREEMENT) C_Line_Agreement, ONT_OEXOEACK_XMLP_PKG.c_line_termsformula(terms.name, :PAYMENT_TERMS) C_Line_Terms, ONT_OEXOEACK_XMLP_PKG.c_fmt_tax_on_lineformula(l.line_category_code, fnd_number.canonical_to_number(:C_total_Line_tax), :C_precision) C_fmt_Tax_On_Line, ONT_OEXOEACK_XMLP_PKG.c_line_categoryformula(l.line_category_code) C_Line_Category, ONT_OEXOEACK_XMLP_PKG.c_tax_on_lineformula(l.line_category_code, fnd_number.canonical_to_number(:C_total_Line_tax), :C_precision) C_tax_on_line, ONT_OEXOEACK_XMLP_PKG.c_ordered_quantity(l.line_category_code, l.ordered_quantity) C_ordered_Quantity, ONT_OEXOEACK_XMLP_PKG.c_total_line_taxformula(l.tax_value, fnd_number.canonical_to_number(:S_Total_svc_tax)) C_total_Line_tax, ONT_OEXOEACK_XMLP_PKG.RP_dummy_item_p RP_dummy_item from oe_order_lines_all l, oe_line_types_v ol, mtl_units_of_measure uom, mtl_system_items si, HZ_CUST_SITE_USES_ALL ship_su, HZ_CUST_SITE_USES_ALL bill_su, HZ_CUST_SITE_USES_ALL del_su, wsh_carriers_v f, WSH_CARRIER_SHIP_METHODS_V CSM, oe_agreements_v a, oe_lookups lk1, ar_lookups lk2, ra_salesreps sr, ra_terms terms, hz_party_sites bill_party_site, -- hz_loc_assignments bill_loc_assign, --bug 9744274 hz_locations bill_loc, hz_cust_acct_sites_all bill_acct_site, hz_parties bill_party, hz_cust_accounts bill_cust_acct, hz_party_sites ship_party_site, -- hz_loc_assignments ship_loc_assign, --bug 9744274 hz_locations ship_loc, hz_cust_acct_sites_all ship_acct_site, hz_parties ship_party, hz_cust_accounts ship_cust_acct, hz_party_sites del_party_site, -- hz_loc_assignments del_loc_assign, --bug 9744274 hz_locations del_loc, hz_cust_acct_sites_all del_acct_site, hz_parties del_party, hz_cust_accounts del_cust_acct where l.line_type_id = ol.line_type_id(+) and (l.service_reference_line_id is null or l.service_reference_type_code <> 'ORDER' or ( l.service_reference_type_code = 'ORDER' and not exists (select header_id from oe_order_lines_all where line_id = l.service_reference_line_id and header_id = l.header_id) )) and l.order_quantity_uom = uom.uom_code(+) and l.inventory_item_id = si.inventory_item_id and nvl(si.organization_id,0) = :c_master_org and l.ship_to_org_id = ship_su.site_use_id(+) and ship_su.CUST_ACCT_SITE_ID = ship_acct_site.cust_acct_site_id(+) and ship_acct_site.party_site_id = ship_party_site.party_site_id(+) and ship_acct_site.cust_account_id = ship_cust_acct.cust_account_id(+) and ship_loc.location_id(+) = ship_party_site.location_id -- and ship_loc.location_id = ship_loc_assign.location_id(+) --bug 9744274 -- and NVL ( ship_acct_site.org_id , - 99 ) = nvl ( ship_loc_assign.org_id , - 99 ) --bug 9744274 and ship_cust_acct.party_id = ship_party.party_id and l.invoice_to_org_id = bill_su.site_use_id(+) and bill_su.CUST_ACCT_SITE_ID = bill_acct_site.cust_acct_site_id(+) and bill_acct_site.party_site_id = bill_party_site.party_site_id(+) and bill_acct_site.cust_account_id = bill_cust_acct.cust_account_id(+) and bill_loc.location_id(+) = bill_party_site.location_id -- and bill_loc.location_id = bill_loc_assign.location_id(+) --bug 9744274 -- and NVL ( bill_acct_site.org_id , - 99 ) = nvl ( bill_loc_assign.org_id , - 99 ) --bug 9744274 and bill_cust_acct.party_id = bill_party.party_id and l.deliver_to_org_id = del_su.site_use_id(+) and del_su.CUST_ACCT_SITE_ID = del_acct_site.cust_acct_site_id(+) and del_acct_site.party_site_id = del_party_site.party_site_id(+) and del_acct_site.cust_account_id = del_cust_acct.cust_account_id(+) and del_loc.location_id(+) = del_party_site.location_id -- and del_loc.location_id = del_loc_assign.location_id(+) --bug 9744274 -- and NVL ( del_acct_site.org_id , - 99 ) = nvl ( del_loc_assign.org_id , - 99 ) --bug 9744274 and del_cust_acct.party_id = del_party.party_id(+) and terms.term_id(+) = l.payment_term_id and sr.salesrep_id(+) = l.salesrep_id and a.agreement_id(+) = l.agreement_id and lk1.lookup_code(+) = l.freight_terms_code and lk1.lookup_type(+) = 'FREIGHT_TERMS' and lk2.lookup_code(+) = l.fob_point_code and lk2.lookup_type(+) = 'FOB' and CSM.ship_method_code(+) = l.shipping_method_code and nvl(CSM.organization_id(+),0) = :c_master_org and f.freight_code(+) = CSM.freight_code &lp_line_category &lp_schedule_date and l.header_id=:header_id_orders ORDER BY l.line_number, l.shipment_number, nvl(l.option_number,0), nvl(l.component_number,0) ONT OEXOEACK_XML AR ONT إشعار استلام أمر المبيعات Imported from BI Publisher Description: إشعار استلام أمر المبيعات Application: إدارة الطلبات Source: إشعار استلام أمر المبيعات (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG D ONT Auftragsbestätigung Imported from BI Publisher Description: Auftragsbestätigung Application: Order Management Source: Auftragsbestätigung (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG E ONT Reconocimiento de Pedidos de Venta Imported from BI Publisher Description: Reconocimiento de Pedidos de Venta Application: Order Management Source: Reconocimiento de Pedidos de Venta (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG F ONT Accusé de réception de commande Imported from BI Publisher Description: Accusé de réception de commande Application: Order Management Source: Accusé de réception de commande (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG I ONT Conferma ordine di vendita Imported from BI Publisher Description: Conferma ordine di vendita Application: Order Management Source: Conferma ordine di vendita (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG JA ONT 受注通知 Imported from BI Publisher Description: 受注通知 Application: Order Management Source: 受注通知(XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG KO ONT 판매 주문 확인 Imported from BI Publisher Description: 판매 주문 확인 Application: Order Management Source: 판매 주문 확인(XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG PTB ONT Confirmação da Ordem de Venda Imported from BI Publisher Description: Confirmação da Ordem de Venda Application: Gerenciamento de Ordens Source: Confirmação da Ordem de Venda (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG RU ONT Подтверждение заказа на продажу Imported from BI Publisher Description: Подтверждение заказа на продажу Application: Управление заказами Source: Подтверждение заказа на продажу (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG S ONT Kundordererkännande Imported from BI Publisher Description: Kundordererkännande Application: Order Management Source: Kundordererkännande (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG TR ONT Satış Siparişi Onayı Imported from BI Publisher Description: Satış Siparişi Onayı Application: Sipariş Yönetimi(1) Source: Satış Siparişi Onayı (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG US ONT Sales Order Acknowledgement Imported from BI Publisher Description: Sales Order Acknowledgement Application: Order Management Source: Sales Order Acknowledgement (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG ZHS ONT 销售订单确认 Imported from BI Publisher Description: 销售订单确认 Application: 订单管理 Source: 销售订单确认 (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG BI Publisher &item_dsp &lp_line_category &lp_schedule_date &lp_unit_of_measure &rp_item_flex_all_seg :agreement :att_column_name :c_header_charge :c_header_charge_periodicity :c_line_recur_charge :c_master_org :c_precision :c_svc_extended_price :c_tax_total :c_total_line_tax :carrier :cf_extended_price :currency :fob :freight_terms :hdr_bill_to_org_id :hdr_del_to_org_id :hdr_ship_to_org_id :header_id_orders :lp_bill_to_customer_name :lp_booked_status :lp_created_by :lp_del_to_customer_name :lp_language_where :lp_line_category :lp_open_orders :lp_order_category :lp_order_date :lp_order_num :lp_order_type :lp_promise_date :lp_request_date :lp_salesrep :lp_schedule_date :lp_ship_to_customer_name :lp_unit_of_measure :mls_flag :operating_unit :p_bill_to_customer_name_hi :p_bill_to_customer_name_lo :p_booked_status :p_charge_periodicity :p_conc_request_id :p_created_by :p_del_to_customer_name_hi :p_del_to_customer_name_lo :p_enable_trace :p_functional_currency :p_item_flex_code :p_item_structure_num :p_line_category :p_master_org_id :p_open_orders :p_order_category :p_order_date_high :p_order_date_low :p_order_num_high :p_order_num_low :p_order_type :p_org_id :p_print_description :p_profile_name :p_promise_date_high :p_promise_date_low :p_request_date_high :p_request_date_low :p_salesrep :p_schedule_date_high :p_schedule_date_low :p_ship_to_customer_name_hi :p_ship_to_customer_name_lo :p_show_body_attach :p_show_ftr_attach :p_show_hdr_attach :p_sob_id :p_user_lang :payment_terms :purchase_order :rp_company_name :rp_curr_profile :rp_data_found :rp_dummy_item :rp_functional_currency :rp_hdr_charge_total :rp_hdr_charge_total_rounded :rp_item_flex_all_seg :rp_item_flex_seg_val :rp_line_charge_total_rounded :rp_print_description :rp_report_name :rp_sub_title :rp_tax_total_rounded :s_total_svc_tax :sales_person 1 -30 :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 -20 :p_item_flex_code Char fnd_profile.value('OE_ID_FLEX_CODE') Y AR رمز الصنف المرن الرمز المرن للصنف D Artikel-FlexFeld-Schlüssel Artikel-FlexFeld-Schlüssel E Código de Estructura de Artículo Código de Estructura de Artículo F Code clé article Code clé article I Codice flexfield Articolo Codice flexfield Articolo JA 品目フレックス・コード 品目フレックス・コード KO 품목 가변 코드 품목 가변 코드 PTB Código Flex. do Item Código Flex. do Item RU Код ГП позиции Код ГП позиции S Artikelflexkod Artikelflexkod TR Kalem Esnek Kodu Kalem esnek kodu US Item Flex Code Item Flex code ZHS 项目弹性域代码 项目弹性域代码 3 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 4 10 :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' Y 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 项目显示 项目显示 5 20 :p_booked_status 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 AR الموقف محجوز الموقف محجوز D Buchungsstatus Buchungsstatus E Estado de Registrado Estado de Registrado F Statut enregistré Statut enregistré I Stato registrato Stato registrato JA 記帳済ステータス 記帳済ステータス KO Booked 상태 Booked 상태 PTB Status de Registro Status de Registro RU Статус: размещено Статус: размещено S Status Bokad Status Bokad TR Kayıtlı Statü Kayıtlı Statü US Booked Status Booked Status ZHS 登记状态 登记状态 6 30 :p_order_type 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 Auftragsart Auftragsart E Tipo de Pedido Tipo de Pedido F Type de commande Type de commande I Tipo di ordine Tipo di ordine JA 受注タイプ 受注タイプ KO 주문 유형 주문 유형 PTB Tipo de Ordem Tipo de Ordem RU Тип заказа Тип заказа S Ordertyp Ordertyp TR Sipariş Tipi Sipariş Tipi US Order Type Order Type ZHS 订单类型 订单类型 7 40 :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 订单编号（自） 订单编号（自） 8 50 :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 订单编号（至） 订单编号（至） 9 60 :p_order_date_low Date AR تاريخ الطلب (من) تاريخ الطلب (من) D Von Auftragsdatum Von Auftragsdatum E Número de Pedido (De) 2 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 Sipariş Tarihi (İlk) US Order Date ( From) Order Date (From) ZHS 订单日期（自） 订单日期（自） 10 70 :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) 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 订单日期（至） 订单日期（至） 11 80 :p_bill_to_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 Rechnung/Kunde Von Rechnung/Kunde E Nombre del Cliente de Facturación (De) Nombre de Cliente de Facturación (De) F Nom client à facturer (De) Nom client à facturer (De) I Fattura a Nome cliente - Da Fattura a Nome cliente - Da JA 請求先顧客名 (自) 請求先顧客名 (自) KO 송장 발행처 고객명(부터) 청구처 고객명(부터) PTB Nome do Cliente para Emissão de NFF ( De) Nome do Cliente para Faturamento (De) RU Имя получателя счета с Имя получателя счета с S Faktureringsadress - kundnamn från Från kund, fakt.adress TR Faturalanacak Müşteri Adı (İlk) Faturalama Müşterisi Adı (İlk) US Invoice To Customer Name ( From) Bill To Customer Name (From) ZHS 收票客户名称（自） 收单客户名称（自） 12 90 :p_bill_to_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$.invoice_to_customer_name_from from sys.dual AR فاتورة إلى اسم العميل (إلى) تحرير فاتورة إلى اسم عميل (إلى) D Bis Rechnung/Kunde Bis Rechnung/Kunde E Nombre del Cliente de Facturación (A) Nombre de Cliente de Facturación (A) F Nom client à facturer (A) Nom client à facturer (A) I Fattura a Nome cliente - A Nome cliente per fatturazione - A JA 請求先顧客名 (至) 請求先顧客名 (至) KO 송장 발행처 고객명(까지) 청구처 고객명(까지) PTB Nome do Cliente para Emissão de NFF (Até) Nome do Cliente para Faturamento (Até) RU Имя получателя счета по Имя получателя счета по S Faktureringsadress - kundnamn till Till kund, fakt.adress TR Faturalanacak Müşteri Adı (Son) Faturalanacak Müşteri Adı (Son) US Invoice To Customer Name (To) Bill To Customer Name (To) ZHS 收票客户名称（至） 收单客户名称（至） 13 100 :p_ship_to_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 Lieferadresse Von Lieferadresse E Nombre del Cliente de Envío (De) Nombre del Cliente de Envío (De) F Nom client à livrer (De) Nom client à livrer (De) I Nome cliente per spedizione - Da Spedisci a Nome cliente - Da JA 出荷先顧客名 (自) 出荷先顧客名 (自) KO 납품처 고객명(부터) 납품처 고객명(부터) PTB Nome do Cliente para Entrega (De) Nome do Cliente para Entrega (De) RU Имя получателя товара с Имя получателя товара с S Leveransadress - kundnamn (från) Leveransadress - kundnamn från TR Sevkedilen Müşteri Adı (İlk) Sevkedilen Müşteri Adı (İlk) US Ship To Customer Name ( From) Ship To Customer Name (From) ZHS 收货客户名称（自） 收货客户名称（自） 14 110 :p_ship_to_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$.ship_to_customer_name_from from sys.dual AR شحن إلى اسم العميل (إلى) شحن إلى اسم العميل (إلى) D Bis Lieferadresse Bis Lieferadresse E Nombre del Cliente de Envío (A) Nombre del Cliente de Envío (A) F Nom client à livrer (A) Nom client à livrer (A) I Nome cliente per spedizione - A Nome cliente per spedizione - A JA 出荷先顧客名 (至) 出荷先顧客名 (至) KO 납품처 고객명(까지) 납품처 고객명(까지) PTB Nome do Cliente para Entrega (Até) Nome do Cliente para Entrega (Até) RU Имя получателя товара по Имя получателя товара по S Leveransadress - kundnamn (till) Leveransadress - kundnamn (till) TR Sevkedilen Müşteri Adı (Son) Sevkedilen Müşteri Adı (Son) US Ship To Customer Name (To) Ship To Customer Name (To) ZHS 收货客户名称（至） 收货客户名称（至） 15 120 :p_schedule_date_low Date AR تاريخ الجدول (من) تاريخ الجدول (من) D Von Plandatum Von Plandatum E Fecha Programada (De) Fecha Programada (De) F Date programmée (Du) Date programmée (Du) I Data programma - Da Data programma - Da JA 予定日 (自) 予定日 (自) KO 계획 일자(부터) 계획 일자(부터) PTB Data de Programação (De) Data de Programação (De) RU Плановая дата с Плановая дата с S Planeringsdatum (från) Planeringsdatum (från) TR Çizelge Tarihi (İlk) Çizelge Tarihi (İlk) US Schedule Date (From) Schedule Date (From) ZHS 计划日期（自） 计划日期（自） 16 130 :p_schedule_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.schedule_date_from)) from sys.dual AR تاريخ الجدول (إلى) تاريخ الجدول (إلى) D Bis Plandatum Bis Plandatum E Fecha Programada (A) Fecha Programada (A) F Date programmée (Au) Date programmée (Au) I Data programma - A Data programma - A JA 予定日 (至) 予定日 (至) KO 계획 일자(까지) 계획 일자(까지) PTB Data de Programação (Até) Data de Programação (Até) RU Плановая дата по Плановая дата по S Planeringsdatum (till) Planeringsdatum (till) TR Çizelge Tarihi (Son) Çizelge Tarihi (Son) US Schedule Date (To) Schedule Date (To) ZHS 计划日期（至） 计划日期（至） 17 140 :p_request_date_low Date AR تاريخ الطلب (من) 2 تاريخ الطلب (من) D Von Anforderungsdatum Von Anforderungsdatum E Fecha de Solicitud (De) Fecha de Solicitud (De) F Date de besoin (Du) Date de besoin (Du) I Data richiesta di acquisto - Da Data richiesta di acquisto - Da JA 要求日 (自) 要求日 (自) KO 요청 일자(부터) 요청 일자(부터) PTB Data da Solicitação (De) Data da Solicitação (De) RU Дата запроса с Дата запроса с S Önskat datum (från) Önskat datum (från) TR Talep Tarihi (İlk) Talep Tarihi (İlk) US Request Date (From) Request Date (From) ZHS 请求日期（自） 请求日期（自） 18 150 :p_request_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.request_date_from)) from sys.dual AR تاريخ الطلب (إلى) 2 تاريخ الطلب (إلى) D Bis Anforderungsdatum Bis Anforderungsdatum E Fecha de Solicitud (A) Fecha de Solicitud (A) F Date de besoin (Au) Date de besoin (Au) I Data richiesta di acquisto - A Data richiesta di acquisto - A JA 要求日 (至) 要求日 (至) KO 요청 일자(까지) 요청 일자(까지) PTB Data da Solicitação (Até) Data da Solicitação (Até) RU Дата запроса по Дата запроса по S Önskat datum (till) Önskat datum (till) TR Talep Tarihi (Son) Talep Tarihi (Son) US Request Date (To) Request Date (To) ZHS 请求日期（至） 请求日期（至） 19 160 :p_promise_date_low Date AR تاريخ الوعد (من) تاريخ الوعد (من) D Von Zusagedatum Von Zusagedatum E Fecha Prometida (De) Fecha Prometida (De) F Date promise (Du) Date promise (Du) I Data promessa - Da Data promessa - Da JA 確約日 (自) 確約日 (自) KO 약속 일자(부터) 약속 일자(부터) PTB Data da Promessa (De) Data da Promessa (De) RU Ожидаемая дата с Ожидаемая дата с S Utlovat datum från Utlovat datum från TR Taahhüt Tarihi (İlk) Taahhüt Tarihi (İlk) US Promise Date (From) Promise Date (From) ZHS 承诺日期（自） 承诺日期（自） 20 170 :p_promise_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.promise_date_from)) from sys.dual AR تاريخ الوعد (إلى) تاريخ الوعد (إلى) D Bis Zusagedatum Bis Zusagedatum E Fecha Prometida (A) Fecha Prometida (A) F Date promise (Au) Date promise (Au) I Data promessa - A Data promessa - A JA 確約日 (至) 確約日 (至) KO 약속 일자(까지) 약속 일자(까지) PTB Data da Promessa (Até) Data da Promessa (Até) RU Ожидаемая дата по Ожидаемая дата по S Utlovat datum till Utlovat datum till TR Taahhüt Tarihi (Son) Taahhüt Tarihi (Son) US Promise Date (To) Promise Date (To) ZHS 承诺日期（至） 承诺日期（至） 21 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 订单类别 订单类别 22 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 行类别 行类别 23 200 :p_salesrep 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 Vertriebsmitarbeiter Vertriebsmitarbeiter E Vendedor Vendedor F Vendeur Vendeur I Rappresentante commerciale Rappresentante commerciale JA 営業担当 営業担当 KO 영업사원 영업사원 PTB Vendedor Vendedor RU Продавец Продавец S Säljare Säljare TR Satış Elemanı Satış Elemanı US Salesperson Salesperson ZHS 销售人员 销售人员 24 210 :p_created_by 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 Erstellt von Erstellt von E Creado por Creado por F Créé par Créé par I Creato da Creato da JA 作成者 作成者 KO 생성자 생성자 PTB Criado por Criado por RU Создано Создано S Skapad av Skapad av TR Oluşturan Oluşturan US Created By Created By ZHS 创建者 创建者 25 220 :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' 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 仅限于未完成订单 仅限于未完成订单 26 230 :p_del_to_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 Auslieferung Von Kunde Auslieferung E Nombre del Cliente de Entrega (De) Nombre del Cliente de Entrega (De) F Nom du client de mise à disposition (De) Nom du client de mise à disposition (De) I Nome cliente per consegna - Da Consegna a Nome cliente - Da JA 搬送先顧客名 (自) 搬送先顧客名 (自) KO 수령처 고객명(부터) 수령처 고객명(부터) PTB Nome do Cliente para Distribuição (De) Nome do Cliente para Distribuição (De) RU Имя конечного получателя с Имя конечного получателя с S Mottagningsplats, kund (från) Mottagningsplats, kund (från) TR Teslim Edilecek Müşteri Adı (İlk) Teslim Edilen Müşteri Adı (İlk) US Deliver To Customer Name(From) Deliver To Customer Name (From) ZHS 最终收货客户名称（自） 最终收货客户名称（自） 27 240 :p_del_to_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$.deliver_to_customer_name_from from sys.dual AR تسليم إلى اسم العميل (إلى) تسليم إلى اسم العميل (إلى) D Bis Kunde Auslieferung Bis Kunde Auslieferung E Nombre del Cliente de Entrega (A) Nombre del Cliente de Entrega (A) F Nom du client de mise à disposition (A) Nom du client de mise à disposition (A) I Nome cliente per consegna - A Nome cliente per consegna - A JA 搬送先顧客名 (至) 搬送先顧客名 (至) KO 수령처 고객명(까지) 수령처 고객명(까지) PTB Nome do Cliente para Distribuição (Até) Nome do Cliente para Distribuição (Até) RU Имя конечного получателя по Имя конечного получателя по S Mottagningsplats, kund (till) Mottagningsplats, kund (till) TR Teslim Edilecek Müşteri Adı (Son) Teslim Edilecek Müşteri Adı (Son) US Deliver To Customer Name (To) Deliver To Customer Name (To) ZHS 最终收货客户名称（至） 最终收货客户名称（至） 28 250 :p_show_hdr_attach 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 Kopfdatenanhänge anzeigen Kopfdatenanhänge anzeigen E Mostrar Anexos de Cabecera Mostrar Anexos de Cabecera F Afficher les documents joints au niveau en-tête Afficher les documents joints au niveau en-tête I Mostra allegati intestazione Mostra allegati intestazione JA ヘッダー添付の表示 ヘッダー添付の表示 KO 헤더 첨부 표시 헤더 첨부 표시 PTB Exibir Anexos do Cabeçalho Exibir Anexos do Cabeçalho RU Показать приложение к заголовку Показать приложение к заголовку S Visa bilagor till huvud Visa bilagor till huvud TR Başlık Eklerini Göster Başlık Eklerini Göster US Show Header Attachments Show Header Attachments ZHS 显示题头附件 显示题头附件 29 260 :p_show_body_attach 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 Textanhänge anzeigen Textanhänge anzeigen E Mostrar Anexos de Cuerpo Mostrar Anexos de Cuerpo F Afficher les documents joints au niveau corps Afficher les documents joints au niveau corps I Mostra allegati corpo Mostra allegati corpo JA 本文添付の表示 本文添付の表示 KO 본문 첨부 표시 본문 첨부 표시 PTB Exibir Anexos do Corpo Exibir Anexos do Corpo RU Показать приложения к тексту Показать приложения к тексту S Visa bilagor till brödtext Visa bilagor till brödtext TR Gövde Eklerini Göster Gövde Eklerini Göster US Show Body Attachments Show Body Attachments ZHS 显示正文附件 显示正文附件 30 270 :p_show_ftr_attach 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 Fußnotenanhänge anzeigen Fußnotenanhänge anzeigen E Mostrar Anexos de Pie de Página Mostrar Anexos de Pie de Página F Afficher les documents joints au niveau bas de page Afficher les documents joints au niveau bas de page I Mostra allegati nota Mostra allegati nota JA フッター添付の表示 フッター添付の表示 KO 꼬리말 첨부 표시 꼬리말 첨부 표시 PTB Exibir Anexos do Rodapé Exibir Anexos do Rodapé RU Показать приложения к колонтитулу Показать приложения к колонтитулу S Visa bilagor till sidfot Visa bilagor till sidfot TR Dipnot Eklerini Göster Dipnot Eklerini Göster US Show Footer Attachments Show Footer Attachments ZHS 显示页脚附件 显示页脚附件