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）限制的操作单元。 C6E085D471D651A9E05362FB09050512Y SELECT null C_FLEX_ITEM , msi.description Description , sv.vendor Vendor , sv.rank Rank , round((nvl(sv.quantity,0)- nvl(sv.quantity_cancelled,0))* nvl(sv.price_override,0) * nvl(sv.rate,1) ,:precision) Expenditure , sv.split Split, 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_POXVCVAR_XMLP_PKG.get_actual(:Expenditure_Total, :C_Vendor_total) C_actual, PO_POXVCVAR_XMLP_PKG.c_intendedformula(sv.split, :Expenditure_Total) C_intended FROM po_source_vendors_v sv , mtl_system_items msi WHERE sv.item_id = msi.inventory_item_id(+) AND po_creation_date BETWEEN nvl(:P_Creation_Date_From,po_creation_date - 1) AND nvl(:P_Creation_Date_To,po_creation_date + 1) AND sv.assignment_set_id = :P_ASSIGNMENT_SET_ID_Qry AND sv.organization_id = :P_ORGANIZATION_ID AND nvl(msi.organization_id,:P_ORGANIZATION_ID) = :P_ORGANIZATION_ID AND &P_WHERE_ITEM ORDER BY msi.description, 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') , sv.vendor , sv.split, sv.rank PO POXVCVAR_XML AR PO تقرير تحليل مجلد المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير تحليل مجلد المورد Application: المشتريات Source: تقرير تحليل مجلد المورد (بتنسيق XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG D PO Lieferanten - Mengenanalyse Imported from BI Publisher Description: Lieferanten - Mengenanalyse Application: Einkauf Source: Lieferanten - Mengenanalyse (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG E PO Informe Volumen de Compra a Proveedores Imported from BI Publisher Description: Volumen de Compra a Proveedores Application: Purchasing Source: Informe Volumen de Compra a Proveedores (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG F PO Analyse des quantités par fournisseur Imported from BI Publisher Description: Analyse des quantités par fournisseur Application: Purchasing Source: Analyse des quantités par fournisseur (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG I PO Rapporto Analisi volume fornitore Imported from BI Publisher Description: Rapporto Analisi volume fornitore Application: Purchasing Source: Rapporto Analisi volume fornitore (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG JA PO 仕入先ボリューム分析レポート Imported from BI Publisher Description: 仕入先ボリューム分析レポート Application: Purchasing Source: 仕入先ボリューム分析レポート(XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG KO PO 공급자 거래액 분석 보고서 Imported from BI Publisher Description: 공급자 거래액 분석 보고서 Application: Purchasing Source: 공급자 거래액 분석 보고서(XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG PTB PO Relatório de Análise de Volume do Fornecedor Imported from BI Publisher Description: Relatório Análise Volume Fornecedor Application: Compra Source: Relatório de Análise de Volume do Fornecedor (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG RU PO Аналитический отчет об объеме закупок у поставщика Imported from BI Publisher Description: Аналитический отчет об объеме закупок у поставщика Application: Закупки Source: Аналитический отчет об объеме закупок у поставщика (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG S PO Volymanalys för leverantör - rapport Imported from BI Publisher Description: Volymanalys för leverantör - rapport Application: Purchasing Source: Volymanalys för leverantör - rapport (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG TR PO Tedarikçi İşlem Hacmi Analiz Raporu Imported from BI Publisher Description: Tedarikçi İşlem Hacmi Analiz Raporu Application: Satın Alma Yönetimi Source: Tedarikçi İşlem Hacmi Analiz Raporu (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG US PO Vendor Volume Analysis Imported from BI Publisher Description: Vendor Volume Analysis Report Application: Purchasing Source: Vendor Volume Analysis Report (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG ZHS PO 供应商供货能量分析报表 Imported from BI Publisher Description: 供应商供货能量分析报表 Application: 采购管理系统 Source: 供应商供货能量分析报表 (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG BI Publisher &p_where_item :c_vendor_total :cp_organization_code :expenditure_total :operating_unit :p_asl_installed :p_assignment_set_id :p_assignment_set_id_qry :p_base_currency :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_flex_item :p_inventory_item_id_from :p_inventory_item_id_to :p_item_from :p_item_struct_num :p_item_to :p_organization_code :p_organization_id :p_title :p_where_item :precision 1 -20 :p_base_currency LOV Oracle PO_SRS_BASE_CURRENCY Y select gsb.currency_code id, gsb.currency_code value, null description from gl_sets_of_books gsb,financials_system_parameters fsp where gsb.set_of_books_id=fsp.set_of_books_id order by value,description SELECT GSB.CURRENCY_CODE FROM GL_SETS_OF_BOOKS GSB, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID Y US P_BASE_CURRENCY P_BASE_CURRENCY 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_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 创建日期自 创建日期自 7 50 :p_creation_date_to Date AR إلى 2 تواريخ التكوين إلى D Bis 2 Bis Erstellungsdatum E A 2 A Fecha de Creación F Au Dates de création - Au I A 2 Date creazione - A JA 至 2 作成日:至 KO 까지 2 생성일자: 까지 PTB Até 2 Datas de Criação - Até RU По 2 Даты создания по S Till 2 Till skapandedatum TR Son 2 Oluşturma Tarihleri: Son US To 2 Creation Dates To ZHS 至 2 创建日期至 8 60 :p_organization_id LOV Oracle INV_SRS_ORG Y select to_char(organization_id) id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,sysdate+1)>sysdate order by value,description select organization_code from financials_system_parameters f, mtl_parameters mp where mp.organization_id = f.inventory_organization_id Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织