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）限制的操作单元。 C6E085D471CE51A9E05362FB09050512Y SELECT pll.line_location_id Parent_Line_location_id , plc.displayed_field Source_Type , pov.vendor_name||', '||pvs.vendor_site_code Source , null C_FLEX_CAT , null C_FLEX_ITEM , poh.segment1 Document_Number , T.type_name Document_Type , lot.location_code Ship_To_Location , pol.line_num Line , TO_CHAR(pll.need_by_date, 'DD/MON/YYYY HH24:MI:SS') Need_By_Date , plt.line_type Line_Type , pol.item_description Description , round((pll.quantity - nvl(pll.quantity_cancelled,0)) ,:P_qty_precision) Quantity_Amount_Ordered , round(pll.quantity_received,:P_qty_precision) Quantity_Amount_Received , round(-1 * (nvl(pll.quantity,0) - nvl(pll.quantity_cancelled,0) - nvl(pll.quantity_received,0)),:P_qty_precision) Quantity_amount_remaining , round(pll.quantity_cancelled,:P_qty_precision) Quantity_amount_cancelled , poh.currency_code currency , pol.item_revision rev , pol.unit_meas_lookup_code unit , decode(psp.manual_po_num_type,'NUMERIC', null, poh.segment1) Document_Numbering1 , decode(psp.manual_po_num_type,'NUMERIC',to_number(poh.segment1), null) Document_Numbering2, decode(pol.category_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE')) C_FLEX_CAT_DISP, decode(msi.inventory_item_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_FLEX_ITEM_DISP from po_vendors pov , po_vendor_sites_all pvs , po_lines_all pol , mtl_system_items msi , financials_system_params_all fsp , hr_locations_all_tl lot , po_line_types plt , po_line_locations pll , po_headers poh , mtl_categories mca , po_lookup_codes plc , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B , po_system_parameters_all psp where poh.org_id = pvs.org_id AND poh.org_id = fsp.org_id AND poh.org_id = psp.org_id and poh.po_header_id = pol.po_header_id and pol.line_type_id = plt.line_type_id and plt.matching_basis <> 'AMOUNT' and pol.po_line_id = pll.po_line_id and pol.item_id = msi.inventory_item_id (+) and pol.category_id = mca.category_id and nvl(msi.organization_id,fsp.inventory_organization_id) = fsp.inventory_organization_id and msi.organization_id (+) = :organization_id and pll.ship_to_location_id = lot.location_id (+) and LOT.LANGUAGE (+) = USERENV('LANG') and pll.ship_to_location_id is not null and poh.vendor_id = pov.vendor_id and poh.vendor_site_id = pvs.vendor_site_id and plc.lookup_type = 'REQUISITION SOURCE TYPE' and plc.lookup_code = 'VENDOR' and B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = poh.org_id AND T.LANGUAGE = USERENV('LANG') and poh.type_lookup_code = B.document_subtype and B.document_type_code in ('PO', 'PA') and &P_WHERE_VD_SITE and &P_WHERE_ST and &P_WHERE_VF and &P_WHERE_VT and nvl(pll.quantity,0) - nvl(pll.quantity_cancelled,0) < nvl(pll.quantity_received,0) and exists (select 'receipt exists' from rcv_transactions rct , rcv_shipment_headers rsh , per_all_people_f ppf where rct.po_line_location_id = pll.line_location_id and rct.shipment_header_id = rsh.shipment_header_id and rct.transaction_type in ('RECEIVE', 'RETURN TO RECEIVING', 'CORRECT', 'RETURN TO VENDOR') and &P_WHERE_TXND_FO and &P_WHERE_TXND_TO and rsh.employee_id = ppf.person_id(+) and &P_WHERE_RCER and &P_WHERE_ORG and ppf.business_group_id + 0 = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date) ORDER BY &orderby_clause PO POXRVOVS_XML AR PO تقرير شحنات زائدة (بتنسيق XML) Imported from BI Publisher Description: تقرير شحنات زائدة Application: المشتريات Source: تقرير شحنات زائدة (بتنسيق XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG D PO Wareneingang - Mehrlieferungen Imported from BI Publisher Description: Wareneingang - Mehrlieferungen Application: Einkauf Source: Wareneingang - Mehrlieferungen (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG E PO Informe Envíos en Exceso Imported from BI Publisher Description: Informe Envíos en Exceso Application: Purchasing Source: Informe Envíos en Exceso (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG F PO Etat des livraisons excédentaires Imported from BI Publisher Description: Etat des livraisons excédentaires Application: Purchasing Source: Etat des livraisons excédentaires (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG I PO Rapporto Spedizioni in eccesso Imported from BI Publisher Description: Rapporto Spedizioni superiori a ordine Application: Purchasing Source: Rapporto Spedizioni in eccesso (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG JA PO 期限超過納入レポート Imported from BI Publisher Description: 期限超過納入レポート Application: Purchasing Source: 期限超過納入レポート(XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG KO PO 초과출하 보고서 Imported from BI Publisher Description: 초과출하 보고서 Application: Purchasing Source: 초과출하 보고서(XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG PTB PO Relatório de Entregas Excedentes Imported from BI Publisher Description: Relatório de Entregas Excedentes Application: Compra Source: Relatório de Entregas Excedentes (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG RU PO Отчет об избыточных поставках Imported from BI Publisher Description: Отчет об избыточных поставках Application: Закупки Source: Отчет об избыточных поставках (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG S PO Överleveranser - rapport Imported from BI Publisher Description: Överleveranser - rapport Application: Purchasing Source: Överleveranser - rapport (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG TR PO Fazla Sevkiyat Raporu Imported from BI Publisher Description: Fazla Sevkiyat Raporu Application: Satın Alma Yönetimi Source: Fazla Sevkiyat Raporu (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG US PO Overshipments Imported from BI Publisher Description: Overshipments Report Application: Purchasing Source: Overshipments Report (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG ZHS PO 过量发运报表 Imported from BI Publisher Description: 过量发货报表 Application: 采购管理系统 Source: 过量发运报表 (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG BI Publisher &orderby_clause &p_where_org &p_where_rcer &p_where_st &p_where_txnd_fo &p_where_txnd_to &p_where_vd_site &p_where_vf &p_where_vt :format_mask :operating_unit :organization_id :p_conc_request_id :p_flex_cat :p_flex_item :p_item_struct_num :p_org_displayed :p_org_id :p_qty_precision :p_receiver :p_ship_to :p_site :p_sort :p_sort_disp :p_struct_num :p_title :p_trans_date_from :p_trans_date_to :p_vendor_from :p_vendor_to :p_where_org :p_where_org1 :p_where_rcer :p_where_rcer1 :p_where_st :p_where_txnd_fo :p_where_txnd_fo1 :p_where_txnd_to :p_where_txnd_to1 :p_where_vd_site :p_where_vf :p_where_vt 1 -20 :p_struct_num Number select structure_id from mtl_default_sets_view where functional_area_id = 2 Y AR هيكل الفئة رقم هيكل P D Kategoriestruktur P Strukturnummer E Estructura de Categoría Número de Estructura de Posición F Structure de catégorie Numéro de structure P I Struttura categoria P Numero struttura JA カテゴリ体系 P体系番号 KO 범주 구조 P 구조번호 PTB Estrutura da Categoria Núm. de estr. de c. RU Структура категорий P struct num S Kategoristruktur Strukturnummer TR Kategori Yapısı P yapı no US Category Structure P struct num 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_title Char AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Название Название S Titel Titel TR Başlık Başlık US Title Title ZHS 标题 标题 4 20 :p_ship_to LOV Oracle PO_SRS_LOCATION Y select location_code id, location_code value, null description from hr_locations order by location_code AR موقع الاستلام موقع الاستلام D Wareneingangsstandort Wareneingangsstandort E Ubicación de Recepción Ubicación de Recepción F Lieu de réception Lieu de réception I Ubicazione di ricezione Ubicazione di ricezione JA 受入事業所 受入事業所 KO 입고 위치 입고 위치 PTB Local do Recebimento Local do Recebimento RU Расположение поступления Расположение поступления S Godsmottagningsadress Godsmottagningsadress TR Teslim Alma Yeri Teslim Alma Yeri US Receipt Location Receipt Location ZHS 接收地点 接收地点 5 30 :p_receiver LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR مستلم مستلم D Warenannahme Warenannahme E Receptor Receptor F Bénéficiaire Bénéficiaire I Destinatario Destinatario JA 受入担当 受入担当 KO 입고자 입고자 PTB Recebedor Recebedor RU Получатель Получатель S Mottagare Mottagare TR Teslim Alan Teslim Alan US Receiver Receiver ZHS 接收人 接收人 6 40 :p_trans_date_from DateTime AR تاريخ الاستلام من تاريخ الاستلام من D Von Wareneingangsdatum Von Wareneingangsdatum E De Fecha de Recepción De Fecha de Recepción F Dates de réception - Du Dates de réception - Du I Data ricevuta - Da Data ricevuta - Da JA 受入日:自 受入日:自 KO 입고 일자: 부터 입고 일자: 부터 PTB Data do Recebimento - De Data do Recebimento - De RU Дата поступления с Дата поступления с S Från inleveransdatum Från inleveransdatum TR Teslimat Tarihi: İlk Teslimat Tarihi: İlk US Receipt Date From Receipt Date From ZHS 接收日期自 接收日期自 7 50 :p_trans_date_to DateTime AR إلى تاريخ الاستلام إلى D Bis Bis Wareneingangsdatum E A A Fecha de Recepción F Au Dates de réception - Au I A Data ricevuta - A JA 至 受入期日 KO 까지 입고 일자 To PTB Até Data do Recebimento - Até RU По Дата поступления по S Till Till inleveransdatum TR Son Teslimat Tarihi: Son US To Receipt Date To ZHS 至 收款日期至 8 60 :p_vendor_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR المورد من المورد من D Von Lieferant Von Lieferant E De Proveedor De Proveedor F Fournisseur - De Fournisseur - De I Fornitore - Da Fornitore - Da JA 仕入先:自 仕入先:自 KO 공급자 From 공급자 From PTB Fornecedor - De Fornecedor - De RU Поставщик с Поставщик с S Från leverantör Från leverantör TR İlk Tedarikçi İlk Tedarikçi US Vendor From Vendor From ZHS 供应商自 供应商自 9 70 :p_vendor_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR إلى 2 المورد إلى D Bis 2 Bis Lieferant E A 2 A Proveedor F A Fournisseur - A I A 2 Fornitore - A JA 至 2 仕入先:至 KO 까지 2 공급자 To PTB Até 2 Fornecedor - A RU По 2 Поставщик по S Till 2 Till leverantör TR Son 2 Son Tedarikçi US To 2 Vendor To ZHS 至 2 供应商至 10 80 :p_site LOV Oracle PO_SRS_VENDOR_SITE_NAME Y select povs.vendor_site_code id, pov.vendor_name||'-'||povs.vendor_site_code value, null description from po_vendor_sites povs,po_vendors pov where povs.vendor_id=pov.vendor_id order by pov.vendor_name AR موقع المورد موقع المورد D Lieferantenadresse Lieferantenadresse E Sitio de Proveedor Sitio de Proveedor F Site fournisseur Site fournisseur I Sede fornitore Sede del venditore JA 仕入先サイト 仕入先サイト KO 공급자 지점 공급자 지점 PTB Site do Fornecedor Site do Fornecedor RU Отделение поставщика Отделение поставщика S Leverantörsplats Leverantörsplats TR Tedarikçi İşletme Birimi Tedarikçi İşletme Birimi US Vendor Site Vendor Site ZHS 供应商地点 供应商地点 11 90 :p_org_id LOV Oracle PO_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by value,description AR اسم التنظيم اسم التنظيم D Organisationsbezeichnung Organisationsbezeichnung E Nombre de Organización Nombre de Organización F Nom de l'organisation Nom de l'organisation I Nome organizzazione Nome organizzazione JA 組織名 組織名 KO 조직명 조직명 PTB Nome da Organização Nome da Organização RU Организация Организация S Organisation Organisation TR Organizasyon Adı Organizasyon Adı US Organization Name Organization Name ZHS 组织名 组织名 12 100 :p_sort LOV Oracle PO_SRS_POXRVOVS_SORT Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('VENDOR','PO NUMBER') order by displayed_field 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 Esası Sıralama Esası US Sort By Sort By ZHS 排序依据 排序依据 13 110 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR خيار دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Opción de Precisión de Cantidad Precisión de Cantidad F Option précision des quantités Précision des quantités I Opzione Precisione quantità Precisione quantità JA 数量精度オプション 数量精度 KO 수량 정확도 옵션 수량 소수점 이하 자릿수 PTB Opção de Precisão de Quantidade Precisão da Quantidade RU Параметр точности количества Точность количества S Alternativ för kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılık Seçeneği Miktar Duyarlılığı US Quantity Precision Option Quantity Precision ZHS 数量精确度选项 数量精确度