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）限制的操作单元。 C6E085D471C351A9E05362FB09050512Y SELECT null C_FLEX_ITEM , pol.item_id Item_Id , pol.item_description Item_Description , poh.segment1 PO_Number , pll.line_location_id parent_line_location_id , round(pll.quantity,:P_qty_precision) pll_quantity_ordered , round(pll.quantity_accepted,:P_qty_precision) pll_quantity_accepted , round(pll.quantity_rejected,:P_qty_precision) pll_quantity_rejected , poh.vendor_id , uom.uom_code PO_unit_of_measure , nvl(msi.primary_uom_code, uom.uom_code) Item_Unit , nvl(msi.primary_unit_of_measure, pll.unit_meas_lookup_code) Item_primary_unit, 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, /* PO_POXQUAPR_XMLP_PKG.c_item_per_acceptedformula(:C_item_sum_rec, :C_item_sum_acc) C_Item_Per_Accepted, PO_POXQUAPR_XMLP_PKG.c_item_per_rejectedformula(:C_item_sum_rec, :C_item_sum_rej) C_Item_Per_Rejected, PO_POXQUAPR_XMLP_PKG.c_item_per_uninsformula(:C_item_sum_rec, :C_item_sum_unins) C_item_Per_Unins, PO_POXQUAPR_XMLP_PKG.c_item_per_returnedformula(:C_item_sum_rec, :C_item_sum_ret) C_Item_Per_Returned, PO_POXQUAPR_XMLP_PKG.c_item_per_rtv_wout_insformula(:C_item_sum_rec, :C_item_sum_rtv_wout_ins) C_item_Per_Rtv_wout_ins, PO_POXQUAPR_XMLP_PKG.uninspectedformula(:Received, :Accepted, :Rejected) Uninspected, PO_POXQUAPR_XMLP_PKG.per_acceptedformula(:Received, :Accepted) Per_Accepted, PO_POXQUAPR_XMLP_PKG.per_rejectedformula(:Received, :Rejected) Per_Rejected, PO_POXQUAPR_XMLP_PKG.per_uninspectedformula(:Received, :Uninspected) Per_Uninspected, PO_POXQUAPR_XMLP_PKG.per_returnedformula(:Received, :Returned) Per_Returned, PO_POXQUAPR_XMLP_PKG.per_rtv_wout_inspectformula(:Received, :Rtv_wout_inspect) Per_Rtv_wout_inspect, */ PO_POXQUAPR_XMLP_PKG.quantity_acceptedformula(round ( pll.quantity_accepted , :P_qty_precision ), PO_POXQUAPR_XMLP_PKG.conversion_rate(pol.item_id,nvl(msi.organization_id,:c_organization_id),nvl(msi.primary_uom_code, uom.uom_code),uom.uom_code)) quantity_accepted, /* bug #11840167 */ PO_POXQUAPR_XMLP_PKG.quantity_rejectedformula(PO_POXQUAPR_XMLP_PKG.conversion_rate(pol.item_id,nvl(msi.organization_id,:c_organization_id),nvl(msi.primary_uom_code, uom.uom_code),uom.uom_code), round ( pll.quantity_rejected , :P_qty_precision )) quantity_rejected, /* bug #11840167 */ PO_POXQUAPR_XMLP_PKG.quantity_orderedformula(PO_POXQUAPR_XMLP_PKG.conversion_rate(pol.item_id,nvl(msi.organization_id,:c_organization_id),nvl(msi.primary_uom_code, uom.uom_code),uom.uom_code), round ( pll.quantity , :P_qty_precision )) quantity_ordered, /* bug #11840167 */ PO_POXQUAPR_XMLP_PKG.c_tot_returnedformula(pll.line_location_id, pol.item_id) C_tot_returned, PO_POXQUAPR_XMLP_PKG.c_tot_inspectedformula(pll.line_location_id, pol.item_id) C_tot_inspected, PO_POXQUAPR_XMLP_PKG.c_tot_receivedformula(pll.line_location_id, pol.item_id) C_tot_received, /* bug #11840167 */ PO_POXQUAPR_XMLP_PKG.uninspectedformula(PO_POXQUAPR_XMLP_PKG.c_tot_receivedformula(pll.line_location_id, pol.item_id), PO_POXQUAPR_XMLP_PKG.quantity_acceptedformula(round ( pll.quantity_accepted , :P_qty_precision ), PO_POXQUAPR_XMLP_PKG.conversion_rate(pol.item_id,nvl(msi.organization_id,:c_organization_id),nvl(msi.primary_uom_code, uom.uom_code),uom.uom_code)), PO_POXQUAPR_XMLP_PKG.quantity_rejectedformula(PO_POXQUAPR_XMLP_PKG.conversion_rate(pol.item_id,nvl(msi.organization_id,:c_organization_id),nvl(msi.primary_uom_code, uom.uom_code),uom.uom_code), round ( pll.quantity_rejected , :P_qty_precision ))) Uninspected /* bug #11840167 */ FROM po_line_locations pll , po_lines pol , po_headers poh , po_vendors pov , mtl_system_items msi , mtl_units_of_measure uom , mtl_categories mca , per_all_people_f papf WHERE pll.po_line_id = pol.po_line_id AND pol.po_header_id = poh.po_header_id AND pol.item_id = msi.inventory_item_id(+) AND pol.category_id = mca.category_id AND nvl(msi.organization_id,:c_organization_id) = :c_organization_id AND poh.vendor_id = pov.vendor_id AND nvl(pll.cancel_flag,'N') = 'N' AND &P_WHERE_ITEM AND &P_WHERE_CAT AND exists (select 'receiving transaction for this PO' from rcv_transactions rct where rct.transaction_type = 'RECEIVE' and rct.po_header_id = poh.po_header_id) AND poh.vendor_id = :Parent_vendor_id AND papf.person_id = poh.agent_id and papf.full_name = nvl(:P_buyer,papf.full_name) AND PAPF.BUSINESS_GROUP_ID = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID),0) FROM FINANCIALS_SYSTEM_PARAMETERS FSP) AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F',PAPF.PERSON_ID, PAPF.PERSON_TYPE_ID, PAPF.EMPLOYEE_NUMBER,PAPF.APPLICANT_NUMBER , PAPF.NPW_NUMBER)) = 'TRUE' AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF.BUSINESS_GROUP_ID , HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID and pol.unit_meas_lookup_code = uom.unit_of_measure and trunc(poh.creation_date) between nvl(:P_creation_date_from,poh.creation_date -1) and nvl(:P_creation_date_to,poh.creation_date + 1) and poh.vendor_id=:Parent_vendor_id order by C_FLEX_ITEM_DISP,Item_Unit,poh.vendor_id,Item_Id,Item_Description,Item_primary_unit, poh.segment1, round(pll.quantity_accepted,:P_qty_precision), round(pll.quantity_rejected,:P_qty_precision), uom.uom_code, round(pll.quantity,:P_qty_precision), pll.line_location_id PO POXQUAPR_XML AR PO تقرير تحليل أداء جودة المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير تحليل أداء جودة المورد Application: المشتريات Source: تقرير تحليل أداء جودة المورد (بتنسيق XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG D PO Lieferanten - Qualitätsanalyse Imported from BI Publisher Description: Lieferanten - Qualitätsanalyse Application: Einkauf Source: Lieferanten - Qualitätsanalyse (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG E PO Informe Análisis de Calidad de Proveedores Imported from BI Publisher Description: Informe de análisis de calidad de proveedores Application: Purchasing Source: Informe Análisis de Calidad de Proveedores (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG F PO Analyse performances qualité par fournisseur Imported from BI Publisher Description: Analyse performances qualité par fournisseur Application: Purchasing Source: Analyse performances qualité par fournisseur (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG I PO Rapporto Analisi prestazioni qualità fornitore Imported from BI Publisher Description: Rapporto Analisi prestazioni qualità fornitore Application: Purchasing Source: Rapporto Analisi prestazioni qualità fornitore (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG JA PO 仕入先品質実績分析レポート Imported from BI Publisher Description: 仕入先品質実績分析レポート Application: Purchasing Source: 仕入先品質実績分析レポート(XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG KO PO 공급자 품질 성과 분석 보고서 Imported from BI Publisher Description: 공급자 품질 비교 분석 보고서 Application: Purchasing Source: 공급자 품질 성과 분석 보고서(XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG PTB PO Relatório de Análise de Desempenho de Qualidade do Fornecedor Imported from BI Publisher Description: Análise da Qualidade de Fornecedores Application: Compra Source: Relatório de Análise de Desempenho de Qualidade do Fornecedor (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG RU PO Аналитический отчет о качестве по поставщикам Imported from BI Publisher Description: Аналитический отчет о качестве по поставщикам Application: Закупки Source: Аналитический отчет о качестве по поставщикам (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG S PO Kvalitetsresultatanalys för leverantörer - rapport Imported from BI Publisher Description: Kvalitetsresultatanalys för leverantörer - rapport Application: Purchasing Source: Kvalitetsresultatanalys för leverantörer - rapport (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG TR PO Tedarikçi Kalite Performans Analizi Raporu Imported from BI Publisher Description: Tedarikçi Kalite Performans Analizi Raporu Application: Satın Alma Yönetimi Source: Tedarikçi Kalite Performans Analizi Raporu (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG US PO Vendor Quality Performance Analysis Imported from BI Publisher Description: Vendor Quality Performance Analysis Report Application: Purchasing Source: Vendor Quality Performance Analysis Report (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG ZHS PO 供应商质量表现分析报表 Imported from BI Publisher Description: 供应商质量表现分析报表 Application: 采购管理系统 Source: 供应商质量表现分析报表 (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG BI Publisher &p_where_cat &p_where_item :c_organization_id :format_mask :operating_unit :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_detail_summary :p_flex_item :p_get_precision :p_item_from :p_item_struct_num :p_item_to :p_qty_precision :p_report_type :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_cat :p_where_item :parent_vendor_id 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 Kategoriestruktur-Nummer E P_STRUCT_NUM Número de Estructura de Categoría F P_STRUCT_NUM Numéro de structure de catégorie I P_STRUCT_NUM Numero struttura categoria JA P_STRUCT_NUM カテゴリ体系番号 KO P_STRUCT_NUM 범주 구조번호 PTB P_STRUCT_NUM Número da Estrutura da categoria RU P_STRUCT_NUM Номер структуры категории S P_STRUCT_NUM Kategoristrukturnummer TR P_STRUCT_NUM Kategori Yapı numarası US P_STRUCT_NUM Category 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_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 物料自 物料自 5 30 :p_item_to Char AR إلى الأصناف إلى D Bis Bis Artikel E A A Artículo F A Articles - A I A Articoli - A JA 至 品目:至 KO 까지 품목: 까지 PTB Até Itens - Até RU По Позиции по S Till Till artiklar TR Son Kalemler, Son US To Items To ZHS 至 物料至 6 40 :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 供应商自 供应商自 7 50 :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 2 Fournisseurs - A I A 2 Fornitori - A JA 至 2 仕入先:至 KO 까지 2 공급자: 까지 PTB Até 2 Fornecedores - Até RU По 2 Поставщики по S Till 2 Leverantörer till TR Son 2 Tedarikçiler: Son US To 2 Vendors To ZHS 至 2 供应商至 8 60 :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 类别自 类别自 9 70 :p_category_to Char AR إلى 3 الفئات إلى D Bis 3 Bis Kategorie E A 3 A Categoría F A 3 Catégories - A I A 3 Categorie - A JA 至 3 カテゴリ:至 KO 까지 3 범주: 까지 PTB Até 3 Categorias - Até RU По 3 Категории по S Till 3 Till kategorier TR Son 3 Kategoriler: Son US To 3 Categories To ZHS 至 3 类别至 10 80 :p_buyer LOV Oracle PO_SRS_BUYER_NAME Y select hre.full_name id, hre.full_name value, null description from po_agents poa,hr_employees hre where poa.agent_id=hre.employee_id order by full_name AR اسم المشتري اسم المشتري D Einkäufername Einkäufername E Nombre de Comprador Nombre de Comprador F Nom de l'acheteur Nom de l'acheteur I Nome buyer Nome buyer JA 購買担当名 購買担当名 KO 구매자명 구매자명 PTB Nome do Comprador Nome do Comprador RU Имя покупателя Имя покупателя S Köpare Köpare TR Satın Alan Adı Satın Alan Adı US Buyer Name Buyer Name ZHS 采购员姓名 采购员姓名 11 90 :p_creation_date_from Date AR تواريخ التكوين من تواريخ التكوين من D Von Erstellungsdatum Von Erstellungsdatum E De Fecha de Creación De Fecha de Creación F Dates de création - Du Dates de création - Du I Date creazione - Da Date creazione - Da JA 作成日:自 作成日:自 KO 생성 일자: 부터 생성 일자: 부터 PTB Datas de Criação - De Datas de Criação - De RU Даты создания с Даты создания с S Från skapandedatum Från skapandedatum TR Oluşturma Tarihleri, İlk Oluşturma Tarihleri, İlk US Creation Dates From Creation Dates From ZHS 创建日期自 创建日期自 12 100 :p_creation_date_to Date AR إلى 4 تواريخ التكوين إلى D Bis 4 Bis Erstellungsdatum E A 4 A Fecha de Creación F Au Dates de création - Au I A 4 Date creazione - A JA 至 4 作成日:至 KO 까지 4 생성일자: 까지 PTB Até 4 Datas de Criação - Até RU По 4 Даты создания по S Till 4 Till skapandedatum TR Son 4 Oluşturma Tarihleri: Son US To 4 Creation Dates To ZHS 至 4 创建日期至 13 110 :p_detail_summary LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description Y AR التفاصيل تفاصيل أو إجمالي D Details Details oder Übersicht E Detalle Detalle o Resumen F Détail Détail ou synthèse I Dettaglio Dettaglio o sintetico JA 詳細 詳細または要約 KO 상세내역 상세내역 혹은 요약 PTB Detalhe Detalhe ou Sumário RU Подробный Подробный или сводный S Detalj Detalj eller översikt TR Detay Detay veya Özet US Detail Detail or Summary ZHS 详细信息 明细或汇总 14 120 :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 动态精确度选项 数量精确度