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）限制的操作单元。 C6E085D470F451A9E05362FB09050512 SELECT c.name om_customer_name , c.customer_number om_customer_number , oeh.header_id om_header_id , oeh.order_number om_order_number , oet.name om_order_type , oeh.ordered_date om_order_date , oel.line_id om_line_id , lk.meaning om_open_order , oel.line_number || decode(oel.shipment_number, null, null, '.'||oel.shipment_number) || decode(oel.option_number, null, null, '.'||oel.option_number) line_shipment_option_number ,oel.item_identifier_type -- &Item_dsp item_flex , oel.inventory_item_id , oel.ORDERED_ITEM_ID , oel.ordered_item --&RP_ITEM_FLEX2 rq_item_flex , porh.segment1 requisition_number , porl.line_num requisition_line_number , msi2.description rq_item_description , oel.ordered_quantity om_quantity , porl.quantity rq_quantity , oel.order_quantity_uom om_unit , muom2.uom_code rq_unit , oel.schedule_arrival_date om_schedule_date , porl.need_by_date rq_needby_date , rasu.location_code om_ship_to_location , rasu2.location rq_ship_to_location, &CF_so_item_display CF_so_item_display, ONT_OEXIODIS_XMLP_PKG.cf_so_holdformula(oel.line_id, oeh.header_id) CF_so_hold, -- &item_dsp item_dsp, &CF_item_flex CF_item_flex, ONT_OEXIODIS_XMLP_PKG.cf_po_item_displayformula(:CF_item_flex, msi2.description) CF_item_display, ONT_OEXIODIS_XMLP_PKG.item_dspFormula(oel.item_identifier_type,oel.ordered_item_id,oel.ordered_item,msi.ORGANIZATION_ID,msi.INVENTORY_ITEM_ID) Item_dsp FROM oe_ship_to_orgs_v rasu , HZ_CUST_SITE_USES_ALL rasu2 , mtl_system_items msi , mtl_system_items_b_kfv msi2 , mtl_system_items_tl msit , mtl_units_of_measure muom2 , oe_lookups lk , po_location_associations pola2 , po_requisition_lines_all porl , po_requisition_headers_all porh , oe_order_lines_all oel , oe_transaction_types_tl oet , oe_order_headers_all oeh , oe_sold_to_orgs_v c WHERE oeh.order_source_id = 10 and oeh.sold_to_org_id = c.customer_id(+) and oet.transaction_type_id(+) = oeh.order_type_id and oet.language (+) = userenv('LANG') and msi.inventory_item_id (+)= oel.inventory_item_id and nvl(msi.organization_id(+),0) = :RP_DUMMY_ITEM and lk.lookup_type = 'YES_NO' and lk.lookup_code = nvl(oeh.open_flag,'N') and msi2.inventory_item_id(+) = porl.item_id and nvl(msi2.organization_id(+),0) = :RP_DUMMY_ITEM and msi2.INVENTORY_ITEM_ID = msit.INVENTORY_ITEM_ID and msi2.ORGANIZATION_ID = msit.ORGANIZATION_ID AND msit.LANGUAGE = userenv('LANG') and porh.requisition_header_id = porl.requisition_header_id and porh.segment1 = oel.orig_sys_document_ref and porh.segment1 = oeh.orig_sys_document_ref and to_char(porl.line_num) = oel.orig_sys_line_ref and oeh.header_id = oel.header_id and rasu.organization_id(+) = oel.ship_to_org_id and rasu2.site_use_id(+) = pola2.site_use_id and pola2.location_id(+) = porl.deliver_to_location_id and muom2.unit_of_measure(+) = porl.unit_meas_lookup_code and ( nvl(oel.org_id,0) = nvl(:p_organization_id,0) or nvl(porl.org_id,0) = nvl(:p_organization_id,0)) and porl.requisition_header_id = oel.source_document_id -- Added for 8702891 and porl.requisition_line_id = oel.source_document_line_id -- Added for 8702891 and nvl(rasu2.org_id,0) = nvl(:p_organization_id,0) and ( porl.item_id != oel.inventory_item_id OR trunc(porl.need_by_date) != trunc(oel.schedule_arrival_date) OR pola2.site_use_id != oel.ship_to_org_id OR muom2.uom_code != oel.order_quantity_uom OR porl.quantity != oel.ordered_quantity - oel.cancelled_quantity OR 0 NOT IN ( select decode( count(order_hold_id), 0, 0, 1) from oe_order_holds_all where header_id = oel.header_id and hold_release_id is null and (line_id = oel.line_id or line_id is null) ) ) &lp_open_order_only &lp_order_num_low &lp_order_num_high &lp_order_date_low &lp_order_date_high &lp_order_type_low &lp_order_type_high and &lp_item &lp_requisition_num_low &lp_requisition_num_high ORDER BY 3 ASC,4 ASC,5 ASC,6 ASC,1 ASC,2 ASC,7 ASC,13 ASC,10 ASC,11 ASC,14 ASC,12 ASC,9 ASC,19 ASC,21 ASC,23 ASC,25 ASC , :CF_order_by Y ONT OEXIODIS_XML AR ONT تقرير تعارض الطلب الداخلي وطلب الشراء Imported from BI Publisher Description: تقرير تعارض الطلب الداخلي وتوريد المشتريات Application: إدارة الطلبات Source: تقرير تعارض الطلب الداخلي وطلب الشراء (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG D ONT Interne Aufträge und Bestellanforderungen - Differenzen Imported from BI Publisher Description: Auswertung "Interne Aufträge und Bestellanforderungen - Differenzen" Application: Order Management Source: Interne Aufträge und Bestellanforderungen - Differenzen (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG E ONT Informe Discrepancias entre Solicitudes de Compra y Órdenes Internas Imported from BI Publisher Description: Informe Discrepancias entre Solicitudes de Compra y Órdenes Internas Application: Order Management Source: Informe Discrepancias entre Solicitudes de Compra y Órdenes Internas (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG F ONT Etat Ecarts entre demande d'achat et commande interne Imported from BI Publisher Description: Etat Ecarts entre demande d'achat et commande interne Application: Order Management Source: Etat Ecarts entre demande d'achat et commande interne (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG I ONT Rapporto Discrepanza ordine interno/richiesta di acquisto Imported from BI Publisher Description: Rapporto Discrepanza ordine interno/richiesta di acquisto Application: Order Management Source: Rapporto Discrepanza ordine interno/richiesta di acquisto (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG JA ONT 社内受注および購買依頼差異レポート Imported from BI Publisher Description: 社内受注および購買依頼差異レポート Application: Order Management Source: 社内受注および購買依頼差異レポート(XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG KO ONT 내부 주문 및 구매 요청 불일치 보고서 Imported from BI Publisher Description: 내부 주문 및 구매 요청 불일치 보고서 Application: Order Management Source: 내부 주문 및 구매 요청 불일치 보고서(XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG PTB ONT Relatório de Discrepância da Requisição de Compra e Ordem Interna Imported from BI Publisher Description: Relatório de Discrepância da Requisição de Compra e Ordem Interna Application: Gerenciamento de Ordens Source: Relatório de Discrepância da Requisição de Compra e Ordem Interna (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG RU ONT Отчет о расхождениях внутренних заказов и заявок на приобретение Imported from BI Publisher Description: Отчет о расхождениях внутренних заказов и заявок на приобретение Application: Управление заказами Source: Отчет о расхождениях внутренних заказов и заявок на приобретение (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG S ONT Avvikelser mellan internorder och inköpsrekvisition - rapport Imported from BI Publisher Description: Avvikelser mellan internorder och inköpsrekvisition - rapport Application: Order Management Source: Avvikelser mellan internorder och inköpsrekvisition - rapport (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG TR ONT Dahili Sipariş ve Satınalma Talebi Uyuşmazlık Raporu Imported from BI Publisher Description: Dahili Sipariş ve Satınalma Talebi Uyuşmazlık Raporu Application: Sipariş Yönetimi(1) Source: Dahili Sipariş ve Satınalma Talebi Uyuşmazlık Raporu (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG US ONT Internal Order and Purchasing Requisition Discrepancy Imported from BI Publisher Description: Internal Order and Purchasing Requisition Discrepancy Report Application: Order Management Source: Internal Order and Purchasing Requisition Discrepancy Report (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG ZHS ONT 内部订单与采购申请差异报表 Imported from BI Publisher Description: 内部订单与采购申请差异报表 Application: 订单管理 Source: 内部订单与采购申请差异报表 (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG BI Publisher &cf_item_flex &cf_so_item_display &item_dsp &lp_item &lp_open_order_only &lp_order_date_high &lp_order_date_low &lp_order_num_high &lp_order_num_low &lp_order_type_high &lp_order_type_low &lp_requisition_num_high &lp_requisition_num_low &rp_item_flex2 :cf_item_flex :cf_order_by :cp_order_date_high :cp_order_date_low :cp_organization_id :l_order_type_high :l_order_type_low :lp_customer_name_high :lp_customer_name_low :lp_customer_number_high :lp_customer_number_low :lp_item :lp_item_high :lp_item_low :lp_open_order_only :lp_order_category :lp_order_date_high :lp_order_date_low :lp_order_num_high :lp_order_num_low :lp_order_type :lp_order_type_high :lp_order_type_low :lp_pur_order_num_high :lp_pur_order_num_low :lp_requisition_num_high :lp_requisition_num_low :operating_unit :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_item :p_item_display :p_item_flex_code :p_item_high :p_item_low :p_item_structure_num :p_open_order_only :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_order_type_high :p_order_type_low :p_organization_id :p_print_description :p_pur_order_num_high :p_pur_order_num_low :p_requisition_num_high :p_requisition_num_low :p_sob_id :rp_company_name :rp_data_found :rp_dummy_item :rp_item_display_method :rp_item_flex2 :rp_item_flex_all_seg :rp_item_range :rp_open_order_only :rp_order_by :rp_order_date_range :rp_order_range :rp_order_type_range :rp_report_name :rp_requisition_range :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_order_by LOV Oracle ONT_SRS_OEXIODIS_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXIODIS ORDER BY' order by meaning select meaning from oe_lookups where lookup_type='OEXIODIS ORDER BY' and lookup_code='ORDER_DATE' 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_open_order_only 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 Mostrar Sólo Pedidos Abiertos F Commandes en cours uniquement Afficher commandes en cours uniquement I Solo ordini aperti Mostra solo ordini aperti JA オープン受注のみ オープン受注のみ表示 KO 개설 주문만 개설 주문만 표시 PTB Somente Ordens em Aberto Mostrar Apenas Ordens em Aberto RU Только открытые заказы Показывать только открытые заказы S Endast uteliggande order Visa endast öppna order TR Sadece Açık Siparişler Sadece Açık Siparişleri Göster US Open Orders Only Show Open Orders Only ZHS 仅限于未完成订单 仅显示打开的订单 6 30 :p_order_num_low Number AR من رقم الطلب رقم الطلب من D Von Auftragsnummer Von Auftragsnummer E De Número de Pedido 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 Från ordernummer Från ordernummer TR İlk Sipariş Numarası Sipariş Numarası Alt Değeri US From Order Number Order Number Low ZHS 订单编号自 订单编号下限 7 40 :p_order_num_high Number select :$flex$.from_order_number from sys.dual AR إلى رقم الطلب رقم الطلب إلى D Bis Auftragsnummer Bis Auftragsnummer E A Número de Pedido 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º da Ordem - Até Nº da Ordem - Superior RU Номер заказа по Номер заказа по S Till ordernummer Till ordernummer TR Son Sipariş Numarası Sipariş Numarası Üst Değeri US To Order Number Order Number High ZHS 终止订单编号 订单编号上限 8 50 :p_order_date_low Date AR من تاريخ الطلب تاريخ الطلب من D Von Auftragsdatum Von Auftragsdatum E De Fecha de Pedido 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 Från orderdatum Från orderdatum TR İlk Sipariş Numarası 2 Sipariş Tarihi Alt Değeri US From Order Date Order Date Low ZHS 订单日期自 订单日期下限 9 60 :p_order_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.from_order_date)) from dual AR إلى تاريخ الطلب تاريخ الطلب إلى D Bis Auftragsdatum Bis Auftragsdatum E A Fecha de Pedido 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 Till orderdatum Till orderdatum TR Son Sipariş Numarası 2 Sipariş Tarihi Üst Değeri US To Order Date Order Date High ZHS 订单日期至 订单日期上限 10 70 :p_order_type_low 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 Von Auftragsart Von Auftragsart E De Tipo de Pedido De Tipo de Pedido F Type commande - De Type commande - De I Tipo di ordine - Da Tipo di ordine - Da JA 受注タイプ:自 受注タイプ:自 KO 주문 유형: 부터 주문 유형: 부터 PTB Tipo da Ordem - De Tipo da Ordem - De RU Тип заказа с Тип заказа с S Från ordertyp Från ordertyp TR İlk Sipariş Tipi İlk Sipariş Tipi US From Order Type From Order Type ZHS 订单类型自 订单类型自 11 80 :p_order_type_high 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 Bis Auftragsart Bis Auftragsart E A Tipo de Pedido A Tipo de Pedido F Type commande - A Type commande - A I Tipo di ordine - A Tipo di ordine - A JA 受注タイプ:至 受注タイプ:至 KO 주문 유형: 까지 주문 유형: 까지 PTB Tipo da Ordem - Até Tipo da Ordem - Até RU Тип заказа по Тип заказа по S Till ordertyp Till ordertyp TR Son Sipariş Tipi Son Sipariş Tipi US To Order Type To Order Type ZHS 订单类型至 订单类型至 12 90 :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' AR عرض الصنف طباعة الحقل المرن أو البيان D Artikelanzeige FlexFeld oder Beschreibung drucken E Presentación de Artículo Imprimir Estructura o Descripción F Affichage article Imprimer clé flexible ou description I Visualizzazione articolo Stampa flexfield o descrizione JA 品目表示 フレックスフィールドまたは摘要の印刷 KO 품목 표시 가변필드 또는 내용 인쇄 PTB Exibição do Item Imprimir Flexfield ou Descrição RU Вывод позиции Печать ГП или описания S Artikelvisning Skriv ut flexfält eller beskrivning TR Kalem Görüntüleme Esnekalanı veya Tanımlamayı yazdırır US Item Display Print Flexfieid or Description ZHS 项目显示 打印弹性域或说明 13 100 :p_requisition_num_low LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) AR من رقم التوريد رقم التوريد من D Von Anforderungsnummer Von Anforderungsnummer E De Número de Solicitud De Número de Solicitud F Numéro D.A. - De Numéro de D.A. - De I Numero richiesta di acquisto - Da Numero richiesta di acquisto (minimo) JA 購買依頼番号:自 購買依頼番号:自 KO 구매요청 번호: 부터 구매요청 번호 하한 PTB Número da Requisição - De Número da Requisição - Inferior RU Номер заявки с Номер заявки с S Från rekvisitionsnummer Från rekvisitionsnummer TR İlk Talep Numarası Talep Numarası Alt Değeri US From Requisition Number Requisition Number Low ZHS 申请编号自 申请编号下限 14 110 :p_requisition_num_high LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) select :$flex$.from_requisition_number from dual AR إلى رقم التوريد رقم التوريد إلى D Bis Anforderungsnummer Bis Anforderungsnummer E A Número de Solicitud A Número de Solicitud F Numéro D.A. - A Numéro de D.A. - A I Numero richiesta di acquisto - A Numero richiesta di acquisto (massimo) JA 購買依頼番号:至 購買依頼番号:至 KO 구매요청 번호: 까지 구매요청 번호 상한 PTB Número da Requisição - Até Número da Requisição - Superior RU Номер заявки по Номер заявки по S Till rekvisitionsnummer Till rekvisitionsnummer TR Son Talep Numarası Talep Numarası Üst Değeri US To Requisition Number Requisition Number High ZHS 申请编号至 申请编号上限 15 120 :p_item_low Char AR من صنف من صنف D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목:부터 품목:부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR İlk Kalem İlk Kalem US From Item From Item ZHS 起始项目 起始项目 16 130 :p_item_high Char AR الصنف إلى إلى الصنف D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목:까지 PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Kalem Son Son Kalem US Item To To Item ZHS 项目至 终止项目 :$flex$.from_order_date From Order Date Y To Order Date :$flex$.from_order_number From Order Number To Order Number :$flex$.from_requisition_number From Requisition Number To Requisition Number