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）限制的操作单元。 C6E085D471BF51A9E05362FB09050512Y select a.*,(C_amount_fix/Q_purchased_Fix) average_purchase_fix , PO_POXPRIPR_XMLP_PKG.average_invoiceformula(Q_Invoiced_fix, Total_amount_invoiced_fix) Average_Invoice_fix from (SELECT pov.vendor_name Vendor , pol.item_id , poh.agent_id , pol.category_id category_id1 , pll.unit_meas_lookup_code Unit_Of_measure , sum ( ( nvl ( pll.price_override , pol.unit_price ) * nvl ( poh.rate,1 ) ) * ( nvl ( pod.quantity_ordered , 0 ) - nvl ( pod.quantity_cancelled, 0 ) ) ) Amount_purchased , sum ( ( nvl ( pll.price_override , pol.unit_price ) * nvl ( poh.rate,1 ) ) * ( nvl ( pod.quantity_ordered , 0 ) - nvl ( pod.quantity_cancelled, 0 ) ) ) C_amount_fix , sum ( aid1.Invoice_Amt ) Amount_Invoiced , sum ( aid1.Invoice_Amt ) Total_amount_invoiced_fix , sum ( nvl ( pod.quantity_ordered , 0 ) - nvl ( pod.quantity_cancelled, 0 ) ) PO_Quantity , sum ( aid1.qty_invoiced ) AP_Quantity, PO_POXPRIPR_XMLP_PKG.c_amount_roundformula(:C_amount, :C_FND_PRECISION) C_AMOUNT_ROUND, PO_POXPRIPR_XMLP_PKG.average_purchase_roundformula(:Average_Purchase, :C_FND_PRECISION) AVERAGE_PURCHASE_ROUND, PO_POXPRIPR_XMLP_PKG.average_invoice_roundformula(:Average_Invoice, :C_FND_PRECISION) AVERAGE_INVOICE_ROUND, -- PO_POXPRIPR_XMLP_PKG.average_invoiceformula(:Q_Invoiced, :Total_amount_invoiced) Average_Invoice, PO_POXPRIPR_XMLP_PKG.average_purchaseformula(:C_amount, :Q_Purchased) Average_Purchase, PO_POXPRIPR_XMLP_PKG.ipvformula(:Average_Purchase, :Average_Invoice) IPV, PO_POXPRIPR_XMLP_PKG.po_primary_qtyformula(sum ( nvl ( pod.quantity_ordered , 0 ) - nvl ( pod.quantity_cancelled , 0 ) ), PO_POXPRIPR_XMLP_PKG.rateformula(pll.unit_meas_lookup_code, :UNIT, pol.item_id)) PO_Primary_qty, sum(PO_POXPRIPR_XMLP_PKG.po_primary_qtyformula(sum ( nvl ( pod.quantity_ordered , 0 ) - nvl ( pod.quantity_cancelled , 0 ) ), PO_POXPRIPR_XMLP_PKG.rateformula(pll.unit_meas_lookup_code, :UNIT, pol.item_id))) over() Q_purchased_Fix, PO_POXPRIPR_XMLP_PKG.ap_primary_qtyformula(sum ( aid1.qty_invoiced ), PO_POXPRIPR_XMLP_PKG.rateformula(pll.unit_meas_lookup_code, :UNIT, pol.item_id)) AP_Primary_qty , sum(PO_POXPRIPR_XMLP_PKG.ap_primary_qtyformula(sum ( aid1.qty_invoiced ), PO_POXPRIPR_XMLP_PKG.rateformula(pll.unit_meas_lookup_code, :UNIT, pol.item_id))) over() q_invoiced_fix , PO_POXPRIPR_XMLP_PKG.rateformula(pll.unit_meas_lookup_code, :UNIT, pol.item_id) Conv_Rate FROM ( Select sum ( nvl ( aid.quantity_invoiced , 0 ) * aid.unit_price * nvl ( aia.exchange_rate,1 ) ) Invoice_Amt, sum ( nvl ( aid.quantity_invoiced ,0 ) ) Qty_invoiced, aid.po_distribution_id po_distribution_id from ap_invoice_distributions aid ,ap_invoices_all aia where nvl ( aid.reversal_flag, 'N' ) = 'N' AND aia.invoice_id=aid.invoice_id AND &period_where group by aid.po_distribution_id ) aid1 , po_distributions pod , po_line_locations pll , po_lines pol , po_headers poh , po_vendors pov WHERE poh.vendor_id = pov.vendor_id AND poh.po_header_id = pol.po_header_id AND pol.po_line_id = pll.po_line_id AND pll.line_location_id = pod.line_location_id AND pod.po_distribution_id = aid1.po_distribution_id AND (poh.type_lookup_code = 'STANDARD' OR poh.type_lookup_code = 'PLANNED' OR poh.type_lookup_code = 'BLANKET') AND nvl ( poh.approved_flag, 'N' ) = 'Y' AND pll.shipment_type in ( 'STANDARD' , 'BLANKET' , 'SCHEDULED' ) AND pov.vendor_name BETWEEN nvl(:P_vendor_from,pov.vendor_name) AND nvl(:P_vendor_to,pov.vendor_name) AND trunc(poh.creation_date) BETWEEN nvl( trunc ( :P_creation_date_from ), trunc ( poh.creation_date - 1) ) AND nvl( trunc ( :P_creation_date_to ), trunc ( poh.creation_date + 1 ) ) and pol.item_id=:inventory_item_id and poh.agent_id=:employee_id and pol.category_id=:category_id GROUP BY pov.vendor_name , pol.item_id , pol.category_id , poh.agent_id , pll.unit_meas_lookup_code ORDER BY 1 ASC,3 ASC,2 ASC,4 ASC , avg ( nvl ( pll.price_override , pol.unit_price ) * nvl ( poh.rate , 1 ) ) ASC , pov.vendor_name) a PO POXPRIPR_XML AR PO تقرير تحليل أداء سعر المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير تحليل أداء سعر المورد Application: المشتريات Source: تقرير تحليل أداء سعر المورد (بتنسيق XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG D PO Lieferanten - Preisanalyse Imported from BI Publisher Description: Lieferanten - Preisanalyse Application: Einkauf Source: Lieferanten - Preisanalyse (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG E PO Informe Análisis de Precios de Proveedores Imported from BI Publisher Description: Informe de análisis de precios de proveedores Application: Purchasing Source: Informe Análisis de Precios de Proveedores (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG F PO Analyse des meilleurs prix par fournisseur Imported from BI Publisher Description: Analyse des meilleurs prix par fournisseur Application: Purchasing Source: Analyse des meilleurs prix par fournisseur (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG I PO Rapporto Analisi prestazioni prezzi fornitore Imported from BI Publisher Description: Rapporto Analisi andamento prezzi fornitore Application: Purchasing Source: Rapporto Analisi prestazioni prezzi fornitore (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG JA PO 仕入先価格実績分析レポート Imported from BI Publisher Description: 仕入先価格実績分析レポート Application: Purchasing Source: 仕入先価格実績分析レポート(XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG KO PO 공급자 가격 성과 분석 보고서 Imported from BI Publisher Description: 공급자 가격 비교 분석 보고서 Application: Purchasing Source: 공급자 가격 성과 분석 보고서(XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG PTB PO Relatório de Análise de Desempenho de Preços entre Fornecedores Imported from BI Publisher Description: Relat. Anál. Preços entre Fornecedores Application: Compra Source: Relatório de Análise de Desempenho de Preços entre Fornecedores (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG RU PO Аналитический отчет о ценах поставщиков Imported from BI Publisher Description: Аналитический отчет о ценах поставщиков Application: Закупки Source: Аналитический отчет о ценах поставщиков (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG S PO Prisresultatanalys för leverantörer - rapport Imported from BI Publisher Description: Prisresultatanalys för leverantörer - rapport Application: Purchasing Source: Prisresultatanalys för leverantörer - rapport (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG TR PO Tedarikçi Fiyat Performansı Analiz Raporu Imported from BI Publisher Description: Tedarikçi Fiyat Performans Analizi Raporu Application: Satın Alma Yönetimi Source: Tedarikçi Fiyat Performansı Analiz Raporu (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG US PO Vendor Price Performance Analysis Imported from BI Publisher Description: Vendor Price Performance Analysis Report Application: Purchasing Source: Vendor Price Performance Analysis Report (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG ZHS PO 供应商价格分析报表 Imported from BI Publisher Description: 供应商价格分析报表 Application: 采购管理系统 Source: 供应商价格分析报表 (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG BI Publisher &period_where :average_invoice :average_purchase :c_amount :c_fnd_precision :category_id :employee_id :inventory_item_id :lp_orderby_clause :lp_orderby_displayed :operating_unit :p_base_currency :p_category_from :p_category_to :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_flex_cat :p_flex_item :p_item_from :p_item_struct_num :p_item_to :p_orderby :p_orderby_cat :p_orderby_clause :p_orderby_displayed :p_orderby_item :p_period_end_date :p_period_from :p_period_start_date :p_period_to :p_qty_precision :p_struct_num :p_struct_num1 :p_title :p_vendor_from :p_vendor_to :p_where_cat :p_where_item :period_where :q_purchased :qty_precision :unit 1 -20 :p_struct_num Number select structure_id from mtl_default_sets_view where functional_area_id = 2 Y AR P_STRUCT_NUM رقم الهيكل D P_STRUCT_NUM Strukturnummer E P_STRUCT_NUM Número de Estructura F P_STRUCT_NUM Numéro de structure I P_STRUCT_NUM Numero struttura JA P_STRUCT_NUM 体系番号 KO P_STRUCT_NUM 구조 번호 PTB P_STRUCT_NUM Número da Estrutura RU P_STRUCT_NUM Номер структуры S P_STRUCT_NUM Strukturnummer TR P_STRUCT_NUM Yapı Numarası US P_STRUCT_NUM Structure Number ZHS P_STRUCT_NUM 结构编号 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_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 Fournisseurs - De Fournisseurs - De I Fornitori - Da Fornitori - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedores - De Fornecedores - De RU Поставщики с Поставщики с S Från leverantörer Från leverantörer TR Tedarikçiler, İlk Tedarikçiler, İlk US Vendors From Vendors From ZHS 供应商自 供应商自 5 30 :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 إلى إلى D Bis Bis E A A F A A I A A JA 至 至 KO 까지 까지 PTB Até Até RU По По S Till Till TR Son Son US To To ZHS 至 至 6 40 :p_period_from LOV Oracle PO_SRS_PERIODS_2 Y select gps.period_name id, gps.period_name value, null description from financials_system_parameters fsp,gl_period_statuses gps where gps.application_id=201 and gps.set_of_books_id=fsp.set_of_books_id order by gps.start_date AR فترة من فترة من D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間:自 期間:自 KO 기간: 부터 기간: 부터 PTB Período - De Período - De RU Период с Период с S Från period Från period TR Dönem Başlangıcı Dönem Başlangıcı US Period From Period From ZHS 期间自 期间自 7 50 :p_period_to LOV Oracle PO_SRS_PERIODS_2 Y select gps.period_name id, gps.period_name value, null description from financials_system_parameters fsp,gl_period_statuses gps where gps.application_id=201 and gps.set_of_books_id=fsp.set_of_books_id order by gps.start_date AR إلى 2 الفترة إلى D Bis 2 Bis Periode E A 2 A Período F A 2 Période - A I A 2 Periodo - A JA 至 2 期間: 至 KO 까지 2 기간: 까지 PTB Até 2 Período - Até RU По 2 Период по S Till 2 Till period TR Son 2 Dönem Sonu US To 2 Period To ZHS 至 2 终止期间 8 60 :p_creation_date_from Date AR تاريخ التكوين من تاريخ التكوين من D Von Erstellungsdatum Von Erstellungsdatum E De Fecha de Creación De Fecha de Creación F Date de création - Du Date de création - Du I Data creazione - Da Data creazione - Da JA 作成日:自 作成日:自 KO 생성일자: 부터 생성일자: 부터 PTB Data de Criação - De Data de Criação - De RU Дата создания с Дата создания с S Från skapandedatum Från skapandedatum TR İlk Oluşturma Tarihi İlk Oluşturma Tarihi US Creation Date From Creation Date From ZHS 创建日期自 创建日期自 9 70 :p_creation_date_to Date AR إلى 3 تاريخ التكوين إلى D Bis 3 Bis Erstellungsdatum E A 3 A Fecha de Creación F Au Date de création - Au I A 3 Data creazione - A JA 至 3 作成日:至 KO 까지 3 생성 일자: 까지 PTB Até 3 Data de Criação - Até RU По 3 Дата создания по S Till 3 Till skapandedatum TR Son 3 Son Oluşturma Tarihi US To 3 Creation Date To ZHS 至 3 创建日期至 10 80 :p_category_from Char AR الفئات من الفئات من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie - Da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De Categorias - De RU Категории с Категории с S Från kategorier Från kategorier TR Kategoriler, İlk Kategoriler, İlk US Categories From Categories From ZHS 类别自 类别自 11 90 :p_category_to Char AR إلى 4 إلى D Bis 4 Bis E A 4 A F A 3 A I A 4 A JA 至 4 至 KO 까지 4 까지 PTB Até 4 Até RU По 4 По S Till 4 Till TR Son 4 Son US To 4 To ZHS 至 4 至 12 100 :p_item_from Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler, İlk Kalemler, İlk US Items From Items From ZHS 物料自 物料自 13 110 :p_item_to Char AR إلى 5 الأصناف إلى D Bis 5 Bis Artikel E A 5 A Artículo F A 4 Articles - A I A 5 Articoli - A JA 至 5 品目:至 KO 까지 5 품목: 까지 PTB Até 5 Itens - Até RU По 5 Позиции по S Till 5 Till artiklar TR Son 5 Kalemler, Son US To 5 Items To ZHS 至 5 物料至 14 120 :p_orderby LOV Oracle PO_SRS_POXPRIPR_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 ('ITEM','CATEGORY') 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 排序依据 排序依据 15 130 :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 Option Nachkommastellen Nachkommastellen E Opción Precisión Dinámica Precisión de Cantidad F Option précision dynamique Précision des quantités I Opzione precisione dinamica Precisione quantità JA 動的演算精度オプション 数量精度 KO 동적 소수점자리 옵션 수량 소수점 이하 자릿수 PTB Opção de Precisão Dinâmica Precisão da Quantidade RU Динамическая точность Точность количества S Alternativ för dynamisk precision Kvantitetsprecision TR Dinamik Duyarlılık Seçeneği Miktar Duyarlılığı US Dynamic Precision Option Quantity Precision ZHS 动态精确度选项 数量精确度