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）限制的操作单元。 C6E085D4710051A9E05362FB09050512 select lu.meaning reason, h.order_number order_number, h.ordered_date order_date, h.transactional_curr_code currency_code, OTYPE.name credit_order_type, l.line_id line_id, l.line_number line_number, l.line_number || decode (l.shipment_number, null, null, '.' || l.shipment_number) || decode (l.option_number, null, null, '.' || l.option_number) line_shipment_option_number, l.item_identifier_type, L.INVENTORY_ITEM_ID, L.ORDERED_ITEM_ID, L.ORDERED_ITEM, &RP_ITEM_FLEX_ALL_SEG ITEM_FLEX, &RP_ITEM_FLEX_CODE item_code, nvl(l.ordered_quantity,0) authorized_qty, nvl(l.fulfilled_quantity,0) fulfilled_qty, nvl(l.unit_selling_price,0) unit_selling_price, LTYPE.name line_type, l.item_revision, ONT_OEXOEORR_XMLP_PKG.Item_dspFormula (l.item_identifier_type , l.inventory_item_id, l.ordered_item_id,l.ordered_item,SI.ORGANIZATION_ID, l.inventory_item_id) Item_dsp_1, ONT_OEXOEORR_XMLP_PKG.c_valueformula(nvl ( l.unit_selling_price , 0 ), nvl ( l.fulfilled_quantity , 0 )) c_value from oe_order_headers_all h, oe_order_lines_all l, OE_TRANSACTION_TYPES_TL OTYPE, OE_TRANSACTION_TYPES_TL LTYPE, ar_lookups lu , mtl_system_items_vl si where h.header_id = l.header_id and l.line_category_code = 'RETURN' and l.return_reason_code = lu.lookup_code (+) and lu.lookup_type (+) = 'CREDIT_MEMO_REASON' and l.item_type_code(+) != 'INCLUDED' and h.booked_flag = 'Y' and l.booked_flag = 'Y' and nvl(h.cancelled_flag, 'N') = 'N' and l.inventory_item_id = si.inventory_item_id and nvl(si.organization_id,0) = nvl(:c_master_org,0) and h.order_type_id = OTYPE.TRANSACTION_TYPE_ID (+) and otype.language(+) = userenv('LANG') and l.line_type_id = LTYPE.TRANSACTION_TYPE_ID (+) and ltype.language(+) = userenv('LANG') and nvl(l.org_id,0) = nvl(h.org_id,0) and nvl(h.org_id,0) = nvl(:p_org_id, 0) &lp_item_flex_all_seg &lp_return_reason &lp_order_date &lp_credit_order_type &lp_credit_order_line_type order by lu.meaning &RP_ITEM_ORDER_BY Y ONT OEXOEORR_XML AR ONT تقرير المرتجعات حسب السبب Imported from BI Publisher Description: تقرير المرتجعات بواسطة السبب Application: إدارة الطلبات Source: تقرير المرتجعات حسب السبب (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG D ONT Rücksendungen nach Grund Imported from BI Publisher Description: Rücksendungen nach Grund Application: Order Management Source: Rücksendungen nach Grund (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG E ONT Informe Devoluciones por Motivo Imported from BI Publisher Description: Informe Devoluciones por Motivo Application: Order Management Source: Informe Devoluciones por Motivo (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG F ONT Etat Retours par motif Imported from BI Publisher Description: Etat Retours par motif Application: Order Management Source: Etat Retours par motif (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG I ONT Rapporto Restituzioni per motivo Imported from BI Publisher Description: Rapporto Restituzioni per motivo Application: Order Management Source: Rapporto Restituzioni per motivo (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG JA ONT 事由別返品レポート Imported from BI Publisher Description: 事由別返品レポート Application: Order Management Source: 事由別返品レポート(XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG KO ONT 사유별 반품 보고서 Imported from BI Publisher Description: 사유별 반품 보고서 Application: Order Management Source: 사유별 반품 보고서(XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG PTB ONT Relatório de Devoluções por Motivo Imported from BI Publisher Description: Relatório de Devoluções por Motivo Application: Gerenciamento de Ordens Source: Relatório de Devoluções por Motivo (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG RU ONT Отчет о возвратах по основаниям Imported from BI Publisher Description: Отчет о возвратах по основаниям Application: Управление заказами Source: Отчет о возвратах по основаниям (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG S ONT Returer per orsak - rapport Imported from BI Publisher Description: Returer per orsak - rapport Application: Order Management Source: Returer per orsak - rapport (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG TR ONT Nedene Göre İadeler Raporu Imported from BI Publisher Description: Nedenlere göre İadeler Raporu Application: Sipariş Yönetimi(1) Source: Nedene Göre İadeler Raporu (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG US ONT Returns by Reason Imported from BI Publisher Description: Returns by Reason Report Application: Order Management Source: Returns by Reason Report (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG ZHS ONT 按原因列出的退货报表 Imported from BI Publisher Description: 按原因列出的退货报表 Application: 订单管理 Source: 按原因列出的退货报表 (XML) Short Name: OEXOEORR_XML DB package: ONT_OEXOEORR_XMLP_PKG BI Publisher &lp_credit_order_line_type &lp_credit_order_type &lp_item_flex_all_seg &lp_order_date &lp_return_reason &rp_item_flex_all_seg &rp_item_flex_code &rp_item_order_by :c_master_org :cp_order_date_high :cp_order_date_low :l_line_type :l_order_type :lp_credit_order_line_type :lp_credit_order_type :lp_item_flex_all_seg :lp_item_flex_code_high :lp_item_flex_code_low :lp_order_date :lp_return_reason :operating_unit :p_conc_request_id :p_credit_order_line_type :p_credit_order_type :p_enable_trace :p_item :p_item_flex_code :p_item_name :p_item_structure_num :p_mixed_precision :p_order_by :p_order_date_high :p_order_date_low :p_org_id :p_print_description :p_return_reason :p_sob_id :rp_company_name :rp_credit_line_type :rp_credit_order_type :rp_data_found :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_code :rp_item_flex_lprompt :rp_item_order_by :rp_order_by :rp_order_date_range :rp_report_name :rp_return_reason :rp_sub_title 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_return_reason LOV Oracle OE_SRS_RETURN_REASON Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='CREDIT_MEMO_REASON' order by meaning AR سبب المرتجع سبب المرتجع D Rücksendungsgrund Rücksendungsgrund E Motivo de Devolución Motivo de Devolución F Motif du retour Motif du retour I Motivo restituzione Motivo restituzione JA 返品事由 返品事由 KO 반품 사유 반품 사유 PTB Motivo da Devolução Motivo da Devolução RU Основание возврата Основание возврата S Returorsak Returorsak TR İade Nedeni İade Nedeni US Return Reason Return Reason ZHS 退货原因 退货原因 5 20 :p_order_date_low Date AR تاريخ الطلب الدائن (من) تاريخ الطلب الدائن (من) D Von Datum gutschriftsfähiger Auftrag Von Datum gutschriftsfähiger Auftrag E Fecha de Pedido de Abono (De) Fecha de Pedido de Abono (De) F Date commande créditrice (Du) Date commande créditrice (Du) I Data ordine di accredito - Da Data ordine di accredito - Da JA クレジット受注日 (自) クレジット受注日 (自) KO 신용 주문 일자(부터) 신용 주문 일자(부터) PTB Data da Ordem de Crédito (De) Data da Ordem de Crédito (De) RU Дата возврата кредита с Дата возврата кредита с S Kreditorderdatum (från) Kreditorderdatum (från) TR Kredili Sipariş Tarihi (İlk) Kredili Sipariş Tarihi (İlk) US Credit Order Date (From) Credit Order Date (From) ZHS 信用订单日期（自） 信用订单日期（自） 6 30 :p_order_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.credit_order_date_from)) from DUAL AR تاريخ الطلب الدائن (إلى) تاريخ الطلب الدائن (إلى) D Bis Datum gutschriftsfähiger Auftrag Bis Datum gutschriftsfähiger Auftrag E Fecha de Pedido de Abono (A) Fecha de Pedido de Abono (A) F Date commande créditrice (Au) Date commande créditrice (Au) I Data ordine di accredito - A Data ordine di accredito - A JA クレジット受注日 (至) クレジット受注日 (至) KO 신용 주문 일자(까지) 신용 주문 일자(까지) PTB Data da Ordem de Crédito (Até) Data da Ordem de Crédito (Até) RU Дата возврата кредита по Дата возврата кредита по S Kreditorderdatum (till) Kreditorderdatum (till) TR Kredili Sipariş Tarihi (Son) Kredili Sipariş Tarihi (Son) US Credit Order Date (To) Credit Order Date (To) ZHS 信用订单日期（至） 信用订单日期（至） 7 40 :p_credit_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 Art gutschriftsfähiger Auftrag Art gutschriftsfähiger Auftrag E Tipo de Pedido de Abono Tipo de Pedido de Abono F Type commande créditrice Type commande créditrice I Tipo ordine di accredito Tipo ordine di accredito JA クレジット受注タイプ クレジット受注タイプ KO 신용 주문 유형 신용 주문 유형 PTB Tipo da Ordem de Crédito Tipo da Ordem de Crédito RU Тип заказа на возврат кредита Тип заказа на возврат кредита S Kreditordertyp Kreditordertyp TR Kredili Sipariş Tipi Kredili Sipariş Tipi US Credit Order Type Credit Order Type ZHS 信用订单类型 信用订单类型 8 50 :p_credit_order_line_type 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 Positionsart gutschriftsfähiger Auftrag Positionsart gutschriftsfähiger Auftrag E Tipo de Línea de Pedido de Abono Tipo de Línea de Pedido de Abono F Type de ligne commande créditrice Type de ligne commande créditrice I Tipo linea ordine di accredito Tipo linea ordine di accredito JA クレジット受注明細タイプ クレジット受注明細タイプ KO 신용 주문 라인 유형 신용 주문 라인 유형 PTB Tipo de Linha da Ordem de Crédito Tipo de Linha da Ordem de Crédito RU Тип строки заказа на возврат кредита Тип строки заказа на возврат кредита S Kreditorderradtyp Kreditorderradtyp TR Kredili Sipariş Satır Tipi Kredili Sipariş Satır Tipi US Credit Order Line Type Credit Order Line Type ZHS 信用订单行类型 信用订单行类型 9 60 :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 物料 项目弹性域 10 70 :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 Optionen Artikelanzeige E Presentación de Artículo Opciones de presentación de artículo F Affichage article Options d'affichage article I Visualizzazione articolo Opzioni di visualizzazione dell'articolo JA 品目表示 品目表示オプション KO 품목 표시 품목 표시 옵션 PTB Exibição do Item Opções de Exibição do Item RU Вывод позиции Параметры вывода позиции S Artikelvisning Artikelformatalternativ TR Kalem Görüntüleme Kalem Görüntüleme seçenekleri US Item Display Item Display options ZHS 项目显示 项目显示选项 11 80 :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$.credit_order_date_from Credit Order Date (From) Y Credit Order Date (To)