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）限制的操作单元。 C6E085D470F851A9E05362FB09050512Y select acct_site.cust_account_id Customer_Id, c.name Customer_Name, c.customer_number Customer_Number, loc.address1 Address1, loc.city City, loc.state State, h.transactional_curr_code Currency1, h.order_number Order_Number, h.ordered_date Order_Date, 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.ordered_item , --l.inventory_item_id , --l.ordered_item_id , l.ordered_item ORDERED_ITEM1, l.inventory_item_id INVENTORY_ITEM_ID1, l.ordered_item_id ORDERED_ITEM_ID1, &rp_item_flex_all_seg item_flex, nvl(l.ordered_quantity,0) ordered_quantity, nvl(l.unit_selling_price,0) * nvl(l.ordered_quantity,0) extended_selling_price, oh.creation_date Date_Placed_On_Hold, round(sysdate - oh.creation_date) Days_On_Hold, ONT_OEXOECCL_XMLP_PKG.c_addressformula(loc.address1, loc.city, loc.state) C_ADDRESS, ONT_OEXOECCL_XMLP_PKG.c_data_not_foundformula(c.name) C_DATA_NOT_FOUND, ONT_OEXOECCL_XMLP_PKG.Item_DspFormula(l.item_identifier_type,l.ordered_item_id ,l.ordered_item,SI.ORGANIZATION_ID,SI.INVENTORY_ITEM_ID) item_dsp, ONT_OEXOECCL_XMLP_PKG.inventory_item_id_p inventory_item_id, ONT_OEXOECCL_XMLP_PKG.ordered_item_p ordered_item, ONT_OEXOECCL_XMLP_PKG.ordered_item_id_p ordered_item_id from oe_hold_sources_all hs, oe_order_holds_all oh, oe_order_headers_all h, oe_order_lines_all l, oe_order_types_v ot, oe_line_types_v lt, HZ_CUST_SITE_USES_ALL su, hz_cust_acct_sites_all acct_site, hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site, mtl_system_items si, oe_sold_to_orgs_v c where hs.hold_id = 1 and hs.hold_entity_code = 'O' and hs.released_flag = 'N' and hs.hold_entity_id = h.header_id and oh.hold_source_id = hs.hold_source_id and nvl(hs.org_id,0) = nvl(oh.org_id,0) and nvl(oh.org_id,0) = nvl(l.org_id,0) and nvl(l.org_id,0) = nvl(h.org_id,0) and nvl(h.org_id,0) = nvl(:lp_org_id,0) and oh.line_id = l.line_id and oh.hold_release_id is null and h.header_id = oh.header_id and h.header_id = l.header_id and h.order_type_id = ot.order_type_id(+) and l.line_type_id = lt.line_type_id(+) and nvl(h.cancelled_flag, 'N') = 'N' and l.inventory_item_id = si.inventory_item_id and nvl(si.organization_id,0) = :RP_DUMMY_ITEM and acct_site.cust_account_id = c.customer_id(+) and su.CUST_ACCT_SITE_ID = acct_site.cust_acct_site_id and acct_site.party_site_id = party_site.party_site_id and party_site.location_id = loc.location_id and loc.location_id = loc_assign.location_id and nvl(acct_site.org_id, -99 ) = nvl(loc_assign.org_id, -99) and h.invoice_to_org_id = su.site_use_id(+) &lp_customer_name &lp_customer_number &lp_currency_code &lp_order_number &lp_order_type &lp_line_type &lp_date_hold_applied GROUP BY acct_site.cust_account_id, c.name, c.customer_number, loc.address1, loc.city, loc.state, h.transactional_curr_code, h.order_number, h.ordered_date, l.line_number, l.shipment_number, l.option_number, nvl(l.ordered_quantity,0), l.unit_selling_price, oh.creation_date, sysdate - oh.creation_date, l.item_identifier_type, l.ordered_item, l.inventory_item_id, l.ordered_item_id, si.segment1, si.segment2, si.segment3, si.segment4, si.segment5, si.segment6, si.segment7, si.segment8, si.segment9, si.segment10, si.segment11, si.segment12, si.segment13, si.segment14, si.segment15, si.segment16, si.segment17, si.segment18, si.segment19, si.segment20, SI.ORGANIZATION_ID, SI.INVENTORY_ITEM_ID having sum(nvl(l.ordered_quantity,0)) > 0 ORDER BY 2 ASC,1 ASC,7 ASC,8 ASC ONT OEXOECCL_XML AR ONT تقرير السطور الموقوفة بفحص الائتمان Imported from BI Publisher Description: تقرير السطور الموقوفة لفحص الائتمان Application: إدارة الطلبات Source: تقرير السطور الموقوفة بفحص الائتمان (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG D ONT Positionen in der Kreditprüfungssperre Imported from BI Publisher Description: Positionen in der Kreditprüfungssperre Application: Order Management Source: Positionen in der Kreditprüfungssperre (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG E ONT Informe Líneas Retenidas por Comprobación de Crédito Imported from BI Publisher Description: Informe Líneas Retenidas por Comprobación de Crédito Application: Order Management Source: Informe Líneas Retenidas por Comprobación de Crédito (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG F ONT Etat Lignes bloquées en contrôle du crédit Imported from BI Publisher Description: Etat Lignes bloquées en contrôle du crédit Application: Order Management Source: Etat Lignes bloquées en contrôle du crédit (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG I ONT Rapporto Linee bloccate per controllo credito Imported from BI Publisher Description: Rapporto sulle linee con blocco del controllo del credito Application: Order Management Source: Rapporto Linee bloccate per controllo credito (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG JA ONT 与信チェック保留レポートの明細 Imported from BI Publisher Description: 与信チェック保留レポートの明細 Application: Order Management Source: 与信チェック保留レポートの明細(XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG KO ONT 신용 확인 보류 보고서의 라인 Imported from BI Publisher Description: 신용 검사 보류 보고서의 라인 Application: Order Management Source: 신용 확인 보류 보고서의 라인(XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG PTB ONT Linhas no Relatório de Retenção de Verificação de Crédito Imported from BI Publisher Description: Linhas no Relatório de Retenção de Verificação de Crédito Application: Gerenciamento de Ordens Source: Linhas no Relatório de Retenção de Verificação de Crédito (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG RU ONT Отчет о строках, заблокированных для проверки кредита Imported from BI Publisher Description: Отчет о строках, заблокированных для проверки кредита Application: Управление заказами Source: Отчет о строках, заблокированных для проверки кредита (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG S ONT Rader i kreditkontrollsspärr - rapport Imported from BI Publisher Description: Rader i kreditkontrollsspärr - rapport Application: Order Management Source: Rader i kreditkontrollsspärr - rapport (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG TR ONT Kredi Kontrolü Durdurma Raporundaki Satırlar Imported from BI Publisher Description: Kredi Kontrolü Durdurma Raporundaki Satırlar Application: Sipariş Yönetimi(1) Source: Kredi Kontrolü Durdurma Raporundaki Satırlar (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG US ONT Lines on Credit Check Hold Imported from BI Publisher Description: Lines on Credit Check Hold Report Application: Order Management Source: Lines on Credit Check Hold Report (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG ZHS ONT 置于信用检查暂挂的行报表 Imported from BI Publisher Description: 置于信用检查暂挂的行报表 Application: 订单管理 Source: 置于信用检查暂挂的行报表 (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG BI Publisher &lp_currency_code &lp_customer_name &lp_customer_number &lp_date_hold_applied &lp_line_type &lp_order_number &lp_order_type &rp_item_flex_all_seg :inventory_item_id :l_line_type :l_order_type :lp_currency_code :lp_customer_name :lp_customer_number :lp_date_hold_applied :lp_line_type :lp_order_number :lp_order_type :lp_org_id :operating_unit :ordered_item :ordered_item_id :p_conc_request_id :p_currency_code :p_customer_name :p_customer_number :p_date_hold_applied_high :p_date_hold_applied_low :p_item_description :p_item_flex_code :p_item_structure_num :p_line_type :p_order_number :p_order_type :p_org_id :p_sob_id :p_vat_profile :rp_company_name :rp_data_found :rp_date_hold_applied_range :rp_dummy_item :rp_functional_currency :rp_item_flex_all_seg :rp_order :rp_print_description :rp_report_name :rp_ship :rp_sub_title :rp_vat_profile 1 -20 :p_sob_id Number select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) from dual Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_customer_name 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 Kundenname Kundenname E Nombre de Cliente Nombre de Cliente F Nom du client Nom du client I Nome cliente Nome cliente JA 顧客名 顧客名 KO 고객명 고객명 PTB Nome do Cliente Nome do Cliente RU Имя заказчика Имя заказчика S Kund Kund TR Müşteri Adı Müşteri Adı US Customer Name Customer Name ZHS 客户名称 客户名称 4 20 :p_customer_number LOV Oracle ONT_SRS_CUSTOMER_NUMBER Y select customer_number id, customer_number value, null description from oe_sold_to_orgs_v order by customer_number AR رقم العميل رقم العميل D Kundennummer Kundennummer E Número de Cliente Número de Cliente F Numéro de client Numéro de client I Numero cliente Numero cliente JA 顧客番号 顧客番号 KO 고객 번호 고객 번호 PTB Nº do Cliente Nº do Cliente RU Номер заказчика Номер заказчика S Kundnummer Kundnummer TR Müşteri Numarası Müşteri Numarası US Customer Number Customer Number ZHS 客户编号 客户编号 5 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 订单类型 订单类型 6 40 :p_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 Positionsart E Tipo de Línea Tipo de Línea F Type de ligne Type de ligne I Tipo di linea Tipo di linea JA 明細タイプ 明細タイプ KO 라인 유형 라인 유형 PTB Tipo Linha Tipo Linha RU Тип строки Тип строки S Radtyp Radtyp TR Satır Tipi Satır Tipi US Line Type Line Type ZHS 行类型 行类型 7 50 :p_order_number Number AR رقم الطلب رقم الطلب D Auftragsnummer Auftragsnummer E Número de Pedido Número de Pedido F Numéro de commande Numéro de commande I Numero ordine Numero ordine JA 受注番号 受注番号 KO 주문 번호 주문 번호 PTB Nº da Ordem Nº da Ordem RU Номер заказа Номер заказа S Ordernummer Ordernummer TR Sipariş Numarası Sipariş Numarası US Order Number Order Number ZHS 订单编号 订单编号 8 60 :p_item_description LOV Oracle ONT_SRS_ITEM_DISPLAY_CODE Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='ITEM_DISPLAY_CODE' order by value,description select meaning from oe_lookups where lookup_type = 'ITEM_DISPLAY_CODE' and lookup_code = 'D' AR عرض الصنف خيارات عرض الصنف D Artikelanzeige 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 项目显示 项目显示选项 9 70 :p_date_hold_applied_low Date AR تاريخ تطبيق الإيقاف (من) تاريخ تطبيق الإيقاف (من) D Von Sperrdatum Von Sperrdatum E Fecha de Aplicación de Retención (De) De Fecha de Aplicación de Retención F Date application blocage (Du) Date application blocage (Du) I Data applicazione blocco - Da Data applicazione blocco (minimo) JA 保留適用日 (自) 保留処理日 (自) KO 보류 적용 일자(부터) 보류 적용일자 (하한) PTB Data de Aplicação da Retenção (De) Data da Retenção Aplicada (Inferior) RU Дата блокировки с Дата блокировки с S Spärrdatum (från) Spärrdatum (från) TR Durdurma Uygulanan Tarih (İlk) Durdurmanın Uygulandığı Tarih (Alt Değer) US Hold Applied Date (From) Hold Applied Date (Low) ZHS 应用暂挂日期（自） 应用暂挂日期（下限） 10 80 :p_date_hold_applied_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.hold_applied_date_from)) from sys.dual AR تاريخ تطبيق الإيقاف (إلى) تاريخ تطبيق الإيقاف (إلى) D Bis Sperrdatum Bis Sperrdatum E Fecha de Aplicación de Retención (A) A Fecha de Aplicación de Retención F Date application blocage (Au) Date application blocage (Au) I Data applicazione blocco - A Data applicazione blocco (massimo) JA 保留適用日 (至) 保留処理日 (至) KO 보류 적용 일자(까지) 보류 적용일자 (상한) PTB Data de Aplicação da Retenção (Até) Data da Retenção Aplicada (Superior) RU Дата блокировки по Дата блокировки по S Spärrdatum (till) Spärrdatum (till) TR Durdurma Uygulanan Tarih (Son) Durdurmanın Uygulandığı Tarih (Üst Değer) US Hold Applied Date (To) Hold Applied Date (High) ZHS 应用暂挂日期（至） 应用暂挂日期（上限） 11 90 :p_currency_code LOV Oracle ONT_SRS_CURRENCIES Y select currency_code id, currency_code value, null description from fnd_currencies_vl where enabled_flag='Y' order by currency_code AR رمز العملة رمز العملة D Währungsschlüssel Währungsschlüssel E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Cód. da Moeda Cód. da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码