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）限制的操作单元。 C6E085D470FD51A9E05362FB09050512Y SELECT decode(upper(:p_order_by) , 'SALESREP', sr.name, 'CANCEL_REASON',lu.meaning, NULL) dummy_salesrep_reason, decode(upper(:p_order_by), 'ORDER_DATE', h.ordered_date, 'CANCEL_DATE', to_date(lh.hist_creation_date,'DD-MON-YYYY'), NULL) dummy_order_cancel_date, decode(upper(:p_order_by) , 'ORDER_NUMBER', h.order_number, NULL) dummy_order_number, decode(upper(:p_order_by) , 'CANCEL_BY', fnd_user.user_name, NULL) dummy_cancelled_by, lh.line_id hist_line_id, lh.last_update_date, org.name cust, org.customer_number cust_no, h.order_number ordnum, h.ordered_date ord_date, nvl(lh.cancelled_quantity,0)*nvl(lh.unit_selling_price,0) amount, lh.line_id lineid, SI.description Internal_Item_Desc, lh.inventory_item_id iid, DECODE(l.ITEM_TYPE_CODE,'SERVICE',L.LINE_NUMBER ||'.'|| L.SHIPMENT_NUMBER||'.'|| L.OPTION_NUMBER ||'.'||L.COMPONENT_NUMBER || decode(L.SERVICE_NUMBER,null,null,'.'||L.SERVICE_NUMBER), 'INCLUDED',L.LINE_NUMBER ||'.'|| L.SHIPMENT_NUMBER||'.'|| L.OPTION_NUMBER ||'.'||L.COMPONENT_NUMBER ||decode(L.SERVICE_NUMBER,null,null,'.'||L.SERVICE_NUMBER), L.LINE_NUMBER || '.' || L.SHIPMENT_NUMBER || decode(L.OPTION_NUMBER,null,null,'.'||L.OPTION_NUMBER)) linenum, lh.shipment_number shipnum, lh.option_number optionnum, lh.ordered_quantity ordered_qty, lh.cancelled_quantity cancelled_qty, lh.cancelled_quantity2 cancelled_qty2, lh.order_quantity_uom unit1, lh.ordered_quantity_uom2 unit2, lu.meaning cancel_reason , h.salesrep_id hsalesrep_id, lh.salesrep_id lsalesrep_id, sr2.name lsalesrep, sr.name salesrep, lh.hist_creation_date candate, fnd_user.user_name username, lh.item_identifier_type, lh.ordered_item_id, lh.ordered_item, --&rp_item_flex_all_seg item_flex, h.conversion_rate conversion_rate, h.conversion_type_code conversion_type_code, h.transactional_curr_code currency_code, lh.line_category_code cat_code, NULL, ONT_OEXOEOCR_XMLP_PKG.c_currency_codeformula(h.transactional_curr_code) C_CURRENCY_CODE, ONT_OEXOEOCR_XMLP_PKG.c_gl_conv_rateformula(h.transactional_curr_code, h.ordered_date, h.conversion_type_code, h.conversion_rate) C_GL_CONV_RATE, --ONT_OEXOEOCR_XMLP_PKG.c_amountformula(:Calc_amount, :C_GL_CONV_RATE, :C_precision) C_AMOUNT, ONT_OEXOEOCR_XMLP_PKG.c_amountformula(ONT_OEXOEOCR_XMLP_PKG.calc_amountformula(lh.line_id, lh.cancelled_quantity), ONT_OEXOEOCR_XMLP_PKG.c_gl_conv_rateformula(h.transactional_curr_code, h.ordered_date, h.conversion_type_code, h.conversion_rate), ONT_OEXOEOCR_XMLP_PKG.c_precisionformula(h.transactional_curr_code)) C_AMOUNT, ONT_OEXOEOCR_XMLP_PKG.cf_unit1formula(lh.order_quantity_uom) CF_unit1, ONT_OEXOEOCR_XMLP_PKG.cf_unit2formula(lh.ordered_quantity_uom2) CF_unit2, --&item_dsp item_dsp, ONT_OEXOEOCR_XMLP_PKG.c_cancelled_qtyformula(lh.line_id, lh.cancelled_quantity) C_cancelled_qty, ONT_OEXOEOCR_XMLP_PKG.calc_amountformula(lh.line_id, lh.cancelled_quantity) Calc_amount, ONT_OEXOEOCR_XMLP_PKG.item_dspFormula(lh.item_identifier_type,lh.inventory_item_id,SI.ORGANIZATION_ID,SI.INVENTORY_ITEM_ID,lh.ordered_item_id,lh.ordered_item) item_dsp, ONT_OEXOEOCR_XMLP_PKG.c_precisionformula(h.transactional_curr_code) C_precision FROM oe_order_lines_history lh, oe_order_lines_all l, oe_order_headers_all h, oe_reasons r, mtl_system_items_vl SI, ra_salesreps sr, ra_salesreps sr2, oe_lookups lu, oe_sold_to_orgs_v org, fnd_user WHERE lh.header_id = h.header_id and l.header_id = h.header_id and l.line_id = lh.line_id AND lh.hist_type_code='CANCELLATION' AND h.salesrep_id=sr.salesrep_id(+) AND lh.salesrep_id=sr2.salesrep_id(+) AND r.reason_id=lh.reason_id AND r.reason_code = lu.lookup_code AND lu.lookup_type = 'CANCEL_CODE' AND nvl(SI.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0) AND lh.inventory_item_id=SI.inventory_item_id AND org.organization_id=lh.sold_to_org_id AND lh.hist_created_by=fnd_user.user_id and nvl(h.org_id,0)= nvl(:p_organization_id,0) &lp_order_num &lp_salesrep &lp_customer_name &lp_order_date &lp_item_flex_all_seg &lp_cancelled_by &lp_cancel_date &lp_cancel_reason &lp_order_category &lp_line_category --ORDER BY linenum,shipnum,optionnum,candate ORDER BY 1 ASC,2 ASC,4 ASC,3 ASC,7 ASC,9 ASC,27 ASC,35 ASC,34 ASC,38 ASC , linenum , shipnum , optionnum , candate ONT OEXOEOCR_XML AR ONT تقرير تفاصيل أسباب الطلبات الملغاة Imported from BI Publisher Description: تقرير تفاصيل أسباب الطلبات الملغاة Application: إدارة الطلبات Source: تقرير تفاصيل أسباب الطلبات الملغاة (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG D ONT Gründe für stornierte Aufträge - Details Imported from BI Publisher Description: Gründe für stornierte Aufträge - Details Application: Order Management Source: Gründe für stornierte Aufträge - Details (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG E ONT Informe Detalle de Motivos de Pedidos Cancelados Imported from BI Publisher Description: Detalle de Motivos de Pedidos Cancelados Application: Order Management Source: Informe Detalle de Motivos de Pedidos Cancelados (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG F ONT Etat Détail des motifs d'annulation des commandes Imported from BI Publisher Description: Etat Détail des motifs d'annulation des commandes Application: Order Management Source: Etat Détail des motifs d'annulation des commandes (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG I ONT Rapporto Dettagli motivi annullamento ordini Imported from BI Publisher Description: Rapporto dettagliato motivo annullamento ordini Application: Order Management Source: Rapporto Dettagli motivi annullamento ordini (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG JA ONT 取消受注事由詳細レポート Imported from BI Publisher Description: 取消受注事由詳細レポート Application: Order Management Source: 取消受注事由詳細レポート(XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG KO ONT 취소된 주문 사유 상세 보고서 Imported from BI Publisher Description: 취소된 주문 사유 상세내역 보고서 Application: Order Management Source: 취소된 주문 사유 상세 보고서(XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG PTB ONT Relatório de Detalhes do Motivo das Ordens Canceladas Imported from BI Publisher Description: Relatório de Detalhes do Motivo das Ordens Canceladas Application: Gerenciamento de Ordens Source: Relatório de Detalhes do Motivo das Ordens Canceladas (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG RU ONT Подробный отчет об основаниях отмены заказов Imported from BI Publisher Description: Подробный отчет об основаниях отмены заказов Application: Управление заказами Source: Подробный отчет об основаниях отмены заказов (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG S ONT Orsak till annullerade order - detaljrapport Imported from BI Publisher Description: Orsak till annullerade order - detaljrapport Application: Order Management Source: Orsak till annullerade order - detaljrapport (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG TR ONT İptal Edilen Siparişler Neden Detay Raporu Imported from BI Publisher Description: İptal Edilen Siparişler Neden Detay Raporu Application: Sipariş Yönetimi(1) Source: İptal Edilen Siparişler Neden Detay Raporu (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG US ONT Cancelled Orders Reason Detail Imported from BI Publisher Description: Cancelled Orders Reason Detail Report Application: Order Management Source: Cancelled Orders Reason Detail Report (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG ZHS ONT 取消订单原因详细信息报表 Imported from BI Publisher Description: 取消订单原因详细资料报表 Application: 订单管理 Source: 取消订单原因详细信息报表 (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG BI Publisher &item_dsp &lp_cancel_date &lp_cancel_reason &lp_cancelled_by &lp_customer_name &lp_item_flex_all_seg &lp_line_category &lp_order_category &lp_order_date &lp_order_num &lp_salesrep &rp_item_flex_all_seg :cp_unit1 :cp_unit2 :lp_cancel_date :lp_cancel_date_high :lp_cancel_date_low :lp_cancel_reason :lp_cancelled_by :lp_customer_name :lp_item_flex_all_seg :lp_item_flex_code_high :lp_item_flex_code_low :lp_line_category :lp_order_by :lp_order_category :lp_order_date :lp_order_date_high :lp_order_date_low :lp_order_num :lp_salesrep :operating_unit :p_cancel_date_high :p_cancel_date_low :p_cancel_reason :p_cancelled_by_high :p_cancelled_by_low :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_item :p_item_flex_code :p_item_name :p_item_structure_num :p_line_category :p_mixed_precision :p_order_by :p_order_category :p_order_date_high :p_order_date_low :p_order_num_high :p_order_num_low :p_order_type :p_organization_id :p_print_description :p_salesrep_high :p_salesrep_low :p_sob_id :p_use_functional_currency :rp_cancel_date_range :rp_cancel_reason :rp_cancelled_by_range :rp_company_name :rp_customer_range :rp_data_found :rp_date_lbl :rp_dummy_item :rp_flex_or_desc :rp_functional_currency :rp_item_flex_all_seg :rp_item_flex_all_seg_where :rp_item_flex_aprompt :rp_item_flex_lprompt :rp_order_by :rp_order_date_range :rp_order_range :rp_report_name :rp_sales_reason_lbl :rp_sales_reason_lbl_2 :rp_salesperson_range :rp_sub_title :rp_use_functional_currency 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 FlexFeld-Schlüssel Lagerartikel E Código de Estructura de Artículo Código de Estructura de Artículo de Inventario F Code clé article Code clé article stocké I Codice flexfield Articolo Codice del flexfield Articolo di magazzino JA 品目フレックス・コード 在庫品目フレックス・コード KO 품목 가변 코드 재고 품목 가변 코드 PTB Código Flex. do Item Código do Flexf. de Item do Inventário RU Код ГП позиции Код ГП позиции запасов S Artikelflexkod Flexkod för lagerartikel TR Kalem Esnek Kodu Envanter Kalemi Esnek Kodu US Item Flex Code Inventory 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_order_by LOV Oracle ONT_SRS_OEXOEOCR_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXOEOCR SORT BY' order by meaning select meaning from oe_lookups where lookup_type='OEXOEOCR SORT BY' and lookup_code='CANCEL_REASON' 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 排序依据 排序依据 5 20 :p_cancel_reason LOV Oracle ONT_SRS_CANCEL_REASON Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='CANCEL_CODE' order by meaning AR سبب الإلغاء سبب الإلغاء D Stornogrund Stornogrund E Motivo de Cancelación Motivo de Cancelación F Motif d'annulation Motif d'annulation I Motivo annullamento Motivo annullamento JA 取消事由 取消事由 KO 취소 사유 취소 사유 PTB Motivo Cancelam. Motivo Cancelam. RU Основание отмены Основание отмены S Annulleringsorsak Annulleringsorsak TR İptal Nedeni İptal Nedeni US Cancel Reason Cancel Reason ZHS 取消原因 取消原因 6 30 :p_cancel_date_low Date AR تاريخ الإلغاء (من) تاريخ الإلغاء من D Von Stornodatum Von Stornodatum E Fecha de Cancelación (De) De Fecha de Cancelación F Date annulation (Du) Date annulation - Du I Data annullamento - Da Data annullamento (minimo) JA 取消日 (自) 取消日:自 KO 취소 일자(부터) 취소 일자 하한 PTB Cancelar Data (De) Data do Cancelamento - Inferior RU Дата отмены с Дата отмены с S Annulleringsdatum (från) Från annulleringsdatum TR İptal Tarihi (İlk) İptal Tarihi Alt Değeri US Cancel Date (From) Cancel Date Low ZHS 取消日期（自） 取消日期下限 7 40 :p_cancel_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.cancel_date_from)) from DUAL AR تاريخ الإلغاء (إلى) تاريخ الإلغاء إلى D Bis Stornodatum Bis Stornodatum E Fecha de Cancelación (A) A Fecha de Cancelación F Date annulation (Au) Date annulation - Au I Data annullamento - A Data annullamento (massimo) JA 取消日 (至) 取消日:至 KO 취소 일자(까지) 취소 일자 상한 PTB Cancelar Data (Até) Data do Cancelamento - Superior RU Дата отмены по Дата отмены по S Annulleringsdatum (till) Till annulleringsdatum TR İptal Tarihi (Son) İptal Tarihi Üst Değeri US Cancel Date (To) Cancel Date High ZHS 取消日期（至） 取消日期上限 8 50 :p_cancelled_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 Storniert von Von Storniert von E Cancelado por (De) De Cancelado por F Annulé par (De) Annulé par - De I Annullato da - Da Annullato da - Minimo JA 取消者 (自) 取消者:自 KO 취소자(부터) 취소자 하한 PTB Cancelado por (De) Cancelado por - Inferior RU Отменено с Отменено с S Annullerad av (från) Från Annullerad av TR İptal Eden (İlk) İptal Eden Alt Değeri US Cancelled By (From) Cancelled By Low ZHS 取消人（自） 取消人下限 9 60 :p_cancelled_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$.cancelled_by_from from dual AR إلغاء بواسطة (إلى) إلغاء بواسطة إلى D Bis Storniert von Bis Storniert von E Cancelado por (A) A Cancelado por F Annulé par (A) Annulé par - A I Annullato da - A Annullato da - Massimo JA 取消者 (至) 取消者:至 KO 취소자(까지) 취소자 상한 PTB Cancelado por (Até) Cancelado por - Superior RU Отменено по Отменено по S Annullerad av (till) Till Annullerad av TR İptal Eden (İlk) 2 İptal Eden Üst Değeri US Cancelled By (To) Cancelled By High ZHS 取消人（至） 取消人上限 10 70 :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) 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 客户名称（自） 客户名称下限 11 80 :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 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 客户名称（至） 客户名称上限 12 90 :p_order_num_low Number AR رقم الطلب (من) رقم الطلب من D Von Auftragsnummer Von Auftragsnummer E Número de Pedido (De) De Número de Pedido F Numéro commande (De) Numéro de commande - De I Numero ordine - Da Numero ordine (minimo) JA 受注番号 (自) 受注番号:自 KO 주문 번호(부터) 주문 번호 하한 PTB Número de Ordem (De) Nº da Ordem - Inferior RU Номер заказа с Номер заказа с S Ordernummer (från) Från ordernummer TR Sipariş Numarası (İlk) Sipariş Numarası Alt Değeri US Order Number (From) Order Number Low ZHS 订单编号（自） 订单编号下限 13 100 :p_order_num_high Number select :$flex$.order_number_from from sys.dual AR رقم الطلب (إلى) رقم الطلب إلى D Bis Auftragsnummer Bis Auftragsnummer E Número de Pedido (A) A Número de Pedido F Numéro commande (A) Numéro de commande - A I Numero ordine - A Numero ordine - Massimo JA 受注番号 (至) 受注番号:至 KO 주문 번호(까지) 주문 번호 상한 PTB Número de Ordem (Até) Nº da Ordem - Superior RU Номер заказа по Номер заказа по S Ordernummer (till) Till ordernummer TR Sipariş Numarası (Son) Sipariş Numarası Üst Değeri US Order Number (To) Order Number High ZHS 订单编号（至） 订单编号上限 14 110 :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) De Vendedor F Vendeur (De) Vendeur - De I Rappresentante commerciale - Da Venditore - Minimo JA 営業担当 (自) 営業担当:自 KO 영업사원(부터) 영업사원 하한 PTB Vendedor (De) Vendedor (Inferior) RU Продавец с Продавец с S Säljare (från) Från säljare TR Satış Elemanı (İlk) Satış Elemanı Alt Değeri US Salesperson (From) Salesperson Low ZHS 销售人员（自） 销售人员下限 15 120 :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) A Vendedor F Vendeur (A) Vendeur - A I Rappresentante commerciale - A Venditore - Massimo JA 営業担当 (至) 営業担当:至 KO 영업사원(까지) 영업사원 상한 PTB Vendedor (Até) Vendedor (Superior) RU Продавец по Продавец по S Säljare (till) Till säljare TR Satış Elemanı (Son) Satış Elemanı Üst Değeri US Salesperson (To) Salesperson High ZHS 销售人员（至） 销售人员上限 16 130 :p_order_date_low Date AR تاريخ الطلب (من) تاريخ الطلب من D Von Auftragsdatum Von Auftragsdatum E Fecha de Pedido (De) De Fecha de Pedido F Date commande (Du) Date commande - Du I Data ordine - Da Data ordine (minimo) JA 受注日 (自) 受注日:自 KO 주문 일자(부터) 주문일자 하한 PTB Data da Ordem (De) Data da Ordem - Inferior RU Дата заказа с Дата заказа с S Orderdatum (från) Från orderdatum TR Sipariş Tarihi (İlk) Sipariş Tarihi Alt Değeri US Order Date (From) Order Date Low ZHS 订单日期（自） 订单日期下限 17 140 :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) A Fecha de Pedido F Date commande (Au) Date commande - Au I Data ordine - A Data ordine (massimo) JA 受注日 (至) 受注日:至 KO 주문 일자(까지) 주문일자 상한 PTB Data da Ordem (Até) Data da Ordem - Superior RU Дата заказа по Дата заказа по S Orderdatum (till) Till orderdatum TR Sipariş Tarihi (Son) Sipariş Tarihi Üst Değeri US Order Date (To) Order Date High ZHS 订单日期（至） 订单日期上限 18 150 :p_item LOV Oracle ONT: Internal_item Y select inventory_item_id id, concatenated_segments value, null description from mtl_system_items_kfv where customer_order_enabled_flag='Y' and bom_item_type in (1,4) and organization_id= oe_sys_parameters.value('MASTER_ORGANIZATION_ID') order by value,description AR الصنف حقل الصنف المرن D Artikel Artikel-FlexFeld E Artículo Estructura de Artículo F Article Clé flexible Article I Articolo Flexfield Articolo JA 品目 品目フレックスフィールド KO 품목 품목 가변필드 PTB Item Flexfield do Item RU Позиция ГП позиции S Artikel Artikelflexfält TR Kalem Kalem Esnekalanı US Item Item Flexfield ZHS 物料 项目弹性域 19 160 :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 项目显示 项目显示 20 170 :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 180 :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='SALES' 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 190 :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_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 以分类帐币种显示 分类帐币种 23 200 :p_mixed_precision Number fnd_profile.value('CURRENCY:MIXED_PRECISION') Y AR الدقة المختلطة الدقة المختلطة D Untersch. Kommastellen Untersch. Kommastellen E Precisión Mixta Precisión Mixta F Précision mixte Précision mixte I Precisione combinata Precisione combinata JA 精度の混合 精度の混合 KO 혼합 소수점자리 혼합 소수점자리 PTB Precisão Mista Precisão Mista RU Смешанная точность Смешанная точность S Blandad precision Blandad precision TR Karma Duyarlılık Karma Duyarlılık US Mixed Precision Mixed Precision ZHS 混合精确度 混合精确度 :$flex$.cancel_date_from Cancel Date (From) Y Cancel Date (To) :$flex$.cancelled_by_from Cancelled By (From) Cancelled By (To) :$flex$.customer_name_from Customer Name (From) Customer Name (To) :$flex$.order_date_from Order Date (From) Y Order Date (To) :$flex$.order_number_from Order Number (From) Order Number (To)