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）限制的操作单元。 C6E085D470F651A9E05362FB09050512Y SELECT h.transactional_curr_code Currency2, h.conversion_rate conversion_rate, h.conversion_type_code conversion_type_code, a.name agreement_name, a.start_date_active start_date , a.end_date_active end_date, sr.name salesperson, c.party_name customer_name, acct.account_number customer_number, h.order_number order_number, h.ordered_date order_date, a.purchase_order_num purchase_order_num, sum((nvl(l.ordered_quantity,0) -nvl(l.cancelled_quantity,0)) * nvl(l.unit_selling_price,0)) qty_ordered, sum(nvl(l.shipped_quantity,0)*nvl(l.unit_selling_price,0)) qty_shipped, SUM(nvl(trxl.quantity_invoiced,0)*nvl(trxl.unit_selling_price,0)) qty_invoiced, ONT_OEXOEASR_XMLP_PKG.C_CONVERT_AMOUNTFormula(:P_USE_FUNCTIONAL_CURRENCY,sum((nvl(l.ordered_quantity,0) -nvl(l.cancelled_quantity,0)) * nvl(l.unit_selling_price,0)) , SUM(nvl(trxl.quantity_invoiced,0)*nvl(trxl.unit_selling_price,0)),sum(nvl(l.shipped_quantity,0)*nvl(l.unit_selling_price,0)) , h.transactional_curr_code,:rp_functional_currency, h.conversion_rate,:P_SOB_ID,h.ordered_date,h.conversion_type_code) C_CONVERT_AMOUNT, ONT_OEXOEASR_XMLP_PKG.c_use_currencyformula(h.transactional_curr_code) C_USE_CURRENCY, ONT_OEXOEASR_XMLP_PKG.c_data_not_foundformula(h.transactional_curr_code) C_DATA_NOT_FOUND, ONT_OEXOEASR_XMLP_PKG.c_qty_ordered_p c_qty_ordered, ONT_OEXOEASR_XMLP_PKG.c_qty_shipped_p c_qty_shipped, ONT_OEXOEASR_XMLP_PKG.c_qty_shipped_dsp_p c_qty_shipped_dsp, ONT_OEXOEASR_XMLP_PKG.c_qty_ordered_dsp_p c_qty_ordered_dsp, ONT_OEXOEASR_XMLP_PKG.c_qty_invoiced_dsp_p c_qty_invoiced_dsp, ONT_OEXOEASR_XMLP_PKG.c_qty_invoiced_p c_qty_invoiced --added FROM OE_AGREEMENTS a, OE_ORDER_HEADERS h, OE_ORDER_LINES_ALL l, RA_CUSTOMER_TRX_LINES_ALL trxl, QP_LOOKUPS lu, HZ_PARTIES c, HZ_CUST_ACCOUNTS acct, JTF_RS_SALESREPS sr WHERE a.agreement_type_code = lu.lookup_code(+) AND lu.lookup_type(+)='QP_AGREEMENT_TYPE' AND a.agreement_id = l.AGREEMENT_ID AND h.header_id = l.header_id AND l.line_category_code = 'ORDER' AND to_char(l.line_id) = trxl.interface_line_attribute6(+) AND trxl.interface_line_context(+) = :p_interface_line_context AND c.party_id = acct.party_id AND acct.cust_account_id = h.sold_to_org_id AND a.salesrep_id =sr.salesrep_id(+) &lp_agreement_range &lp_customer_range &lp_agreement_type &lp_purchase_num &lp_order_number_range &lp_salesperson GROUP BY h.transactional_curr_code, h.conversion_rate, h.conversion_type_code, a.name, a.start_date_active , a.end_date_active, sr.name, c.party_name, acct.account_number, h.order_number, h.ordered_date, a.purchase_order_num ORDER BY h.transactional_curr_code,a.name,c.party_name,h.order_number ONT OEXOEASR_XML AR ONT تقرير نشاط الاتفاقية Imported from BI Publisher Description: تقرير نشاط الاتفاقية Application: إدارة الطلبات Source: تقرير نشاط الاتفاقية (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG D ONT Rahmenverträge - Vorgänge Imported from BI Publisher Description: Rahmenverträge - Vorgänge Application: Order Management Source: Rahmenverträge - Vorgänge (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG E ONT Informe Actividad de Acuerdos Imported from BI Publisher Description: Informe Actividad de Acuerdos Application: Order Management Source: Informe Actividad de Acuerdos (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG F ONT Etat Commandes associées à des accords-cadres Imported from BI Publisher Description: Etat Commandes associées à des accords-cadres Application: Order Management Source: Etat Commandes associées à des accords-cadres (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG I ONT Rapporto Attività contratto Imported from BI Publisher Description: Rapporto Attività contratto Application: Order Management Source: Rapporto Attività contratto (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG JA ONT 基本契約活動レポート Imported from BI Publisher Description: 基本契約活動レポート Application: Order Management Source: 基本契約活動レポート(XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG KO ONT 계약 현황 보고서 Imported from BI Publisher Description: 계약 활동 보고서 Application: Order Management Source: 계약 현황 보고서(XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG PTB ONT Relatório de Atividades do Acordo Imported from BI Publisher Description: Relatório de Atividades do Acordo Application: Gerenciamento de Ordens Source: Relatório de Atividades do Acordo (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG RU ONT Отчет об операциях по соглашению Imported from BI Publisher Description: Отчет об операциях по соглашению Application: Управление заказами Source: Отчет об операциях по соглашению (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG S ONT Avtalsaktivitet - rapport Imported from BI Publisher Description: Avtalsaktivitet Application: Order Management Source: Avtalsaktivitet - rapport (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG TR ONT Anlaşma Etkinlik Raporu Imported from BI Publisher Description: Anlaşma Etkinlik Raporu Application: Sipariş Yönetimi(1) Source: Anlaşma Etkinlik Raporu (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG US ONT Agreement Activity Imported from BI Publisher Description: Agreement Activity Report Application: Order Management Source: Agreement Activity Report (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG ZHS ONT 协议活动报表 Imported from BI Publisher Description: 协议活动报表 Application: 订单管理 Source: 协议活动报表 (XML) Short Name: OEXOEASR_XML DB package: ONT_OEXOEASR_XMLP_PKG BI Publisher &lp_agreement_range &lp_agreement_type &lp_customer_range &lp_order_number_range &lp_purchase_num &lp_salesperson :c_qty_invoiced :c_qty_invoiced_dsp :c_qty_ordered :c_qty_ordered_dsp :c_qty_shipped :c_qty_shipped_dsp :lp_agreement_range :lp_agreement_type :lp_agreement_type_dsp :lp_customer_range :lp_order_number_range :lp_purchase_num :lp_salesperson :operating_unit :p_agreement_high :p_agreement_low :p_agreement_type :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_interface_line_context :p_order_number_high :p_order_number_low :p_purchase_num :p_salesperson :p_sob_id :p_use_functional_currency :rp_agreement_name_high :rp_agreement_name_low :rp_agreement_range :rp_company_name :rp_customer_name_range :rp_data_found :rp_functional_currency :rp_report_name :rp_sub_title 1 -20 :p_interface_line_context Char fnd_profile.value('ONT_SOURCE_CODE') Y AR سياق سطر الفاتورة D Kontext Rechnungsposition E Contexto de Línea de Factura F Contexte ligne de facture I Contesto linea fattura JA 請求書明細コンテキスト KO 송장 라인 컨텍스트 PTB Contexto da Linha da NFF RU Контекст строки счета-фактуры S Sammanhang för fakturarad TR Fatura Satır İçeriği US Invoice Line Context 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_agreement_low LOV Oracle OM: Agreement Name Y select name id, name value, null description from oe_agreements order by name AR اسم الاتفاقية (من) D Von Vereinbarung E De Nombre de Acuerdo F Nom de l'accord-cadre (De) I Nome contratto (minimo) JA 基本契約名 (自) KO 계약명 (하위) PTB Nome do Acordo (Inferior) RU Имя соглашения с S Avtalsnamn (från) TR Anlaşma Adı (Alt) US Agreement Name (Low) ZHS 协议名称（下限） 4 20 :p_agreement_high LOV Oracle OM: Agreement Name Y select name id, name value, null description from oe_agreements order by name AR اسم الاتفاقية (إلى) D Bis Vereinbarung E A Nombre de Acuerdo F Nom de l'accord-cadre (A) I Nome contratto (massimo) JA 基本契約名 (至) KO 계약명 (상위) PTB Nome do Acordo (Superior) RU Имя соглашения по S Avtalsnamn (till) TR Anlaşma Adı (Üst) US Agreement Name (High) ZHS 协议名称（上限） 5 30 :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 E De Cliente F Client (De) I Cliente (minimo) JA 顧客 (自) KO 고객 (하위) PTB Cliente (Inferior) RU Заказчик с S Kund (från) TR Müşteri (Alt) US Customer (Low) ZHS 客户（下限） 6 40 :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 AR العميل (إلى) D Bis Kunde E A Cliente F Client (A) I Cliente (massimo) JA 顧客 (至) KO 고객 (상위) PTB Cliente (Superior) RU Заказчик по S Kund (till) TR Müşteri (Üst) US Customer (High) ZHS 客户（上限） 7 50 :p_agreement_type LOV Oracle OM: Agreement Type Y select lookup_code id, meaning value, null description from qp_lookups where lookup_type='QP_AGREEMENT_TYPE' order by meaning AR نوع الاتفاقية D Vereinbarungsart E Tipo de Acuerdo F Type d'accord-cadre I Tipo di contratto JA 基本契約タイプ KO 계약 유형 PTB Tipo de Acordo RU Тип соглаш. S Avtalstyp TR Anlaşma Tipi US Agreement Type ZHS 协议类型 8 60 :p_purchase_num LOV Oracle ONT_MOAC_SRS_HDR_CUST_PO_NUMBER Y select oh.cust_po_number id, oh.cust_po_number value, null description from oe_order_headers oh,hr_operating_units ou where oh.cust_po_number is not null and oh.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=oh.org_id) order by oh.order_number desc AR رقم أمر الشراء D Bestellnummer E Número de Pedido de Compra F Numéro d'ordre d'achat I Numero ordine di acquisto JA 発注番号 KO 구매발주 번호 PTB Nº da Ordem de Compra RU Номер заказа на приобретение S Ordernummer TR Satınalma Siparişi Numarası US Purchase Order Number ZHS 采购订单编号 9 70 :p_salesperson 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 E Vendedor F Vendeur I Rappresentante commerciale JA 営業担当 KO 영업사원 PTB Vendedor RU Продавец S Säljare TR Satış Elemanı US Sales Person ZHS 销售人员 10 80 :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 Buchwährung verwenden E Utilizar Divisa de Libro Mayor F Utiliser la devise comptable I Usa divisa libro contabile JA 元帳通貨の使用 KO 원장 통화 사용 PTB Usar Moeda do Razão RU Использовать валюту книги S Använd reskontravaluta TR Defter Para Birimini Kullan US Use Ledger Currency ZHS 使用分类帐币种 11 90 :p_order_number_low Char AR رقم الطلب (من) D Von Auftragsnummer E De Número de Pedido F Numéro commande (De) I Numero ordine (minimo) JA 受注番号 (自) KO 주문번호(하한) PTB Número da Ordem (Inferior) RU Номер заказа с S Ordernummer (från) TR Sipariş Numarası (Alt Değer) US Order Number (Low) ZHS 订单编号（下限） 12 100 :p_order_number_high Char AR رقم الطلب (إلى) D Bis Auftragsnummer E A Número de Pedido F Numéro commande (Au) I Numero ordine (massimo) JA 受注番号 (至) KO 주문번호(상한) PTB Número da Ordem (Superior) RU Номер заказа по S Ordernummer (till) TR Sipariş Numarası (Üst Değer) US Order Number (High) ZHS 订单编号（上限）