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）限制的操作单元。 C6E085D471D551A9E05362FB09050512Y SELECT null C_FLEX_CAT , poh.segment1 PO_Number , T.type_name PO_Type , ppf.full_name Buyer , pov.vendor_name Vendor , poh.creation_date Creation_Date , poh.currency_code C_CURRENCY , SUM ( DECODE ( POL.order_type_lookup_code, 'RATE', POLL.amount, 'FIXED PRICE', POLL.amount, NVL (POLL.price_override, 0) * (NVL(POLL.quantity, 0) - NVL(POLL.quantity_cancelled, 0))) ) C_AMOUNT , ROUND(SUM ( DECODE ( POL.order_type_lookup_code, 'RATE', POLL.amount, 'FIXED PRICE', POLL.amount, NVL (POLL.price_override, 0) * (NVL(POLL.quantity, 0) - NVL(POLL.quantity_cancelled, 0)))) * NVL(POH.rate, 1), :C_PRECISION) C_AMOUNT_FUNC, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_sort', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEX_CAT_SORT, 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 FROM per_people_f ppf , po_vendors pov , mtl_categories mca , po_line_locations poll , po_lines pol , po_headers poh , po_document_types_all_tl T , po_document_types_all_b B , po_releases por WHERE pol.category_id = mca.category_id AND pol.po_header_id = poh.po_header_id AND poll.po_header_id = poh.po_header_id AND poll.po_release_id = por.po_release_id(+) AND poll.po_line_id = pol.po_line_id AND pov.vendor_id (+) = poh.vendor_id AND pov.vendor_name is not null &WHERE_PERFORMANCE AND ppf.person_id = poh.agent_id AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date AND B.document_type_code in ('PO','PA') AND B.document_subtype = poh.type_lookup_code and poll.shipment_type not in ('PRICE BREAK','PLANNED') 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 &P_WHERE_CAT GROUP BY poh.segment1 , T.type_name , ppf.full_name , pov.vendor_name , poh.creation_date , poh.currency_code , nvl(poh.rate,1), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_sort', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') , 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') order by 10, 11, 2, 3, 4, 5, 6, 7, 8, 9 PO POXSUCAT_XML AR PO تقرير إجمالي المشتريات حسب الفئة (بتنسيق XML) Imported from BI Publisher Description: إجمالي المشتريات حسب الفئة Application: المشتريات Source: تقرير إجمالي المشتريات حسب الفئة (بتنسيق XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG D PO Bestellungen - Übersicht nach Kategorie Imported from BI Publisher Description: Bestellungen - Übersicht nach Kategorie Application: Einkauf Source: Bestellungen - Übersicht nach Kategorie (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG E PO Informe Resumen de Pedidos por Categoría Imported from BI Publisher Description: Resumen de Pedidos por Categoría Application: Purchasing Source: Informe Resumen de Pedidos por Categoría (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG F PO Etat de synthèse des achats par catégorie Imported from BI Publisher Description: Etat de synthèse des achats par catégorie Application: Purchasing Source: Etat de synthèse des achats par catégorie (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG I PO Rapporto Sintetico acquisti per categoria Imported from BI Publisher Description: Rapporto Sintetico ordini di acquisto per categoria Application: Purchasing Source: Rapporto Sintetico acquisti per categoria (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG JA PO カテゴリ別購買要約レポート Imported from BI Publisher Description: カテゴリ別購買要約 Application: Purchasing Source: カテゴリ別購買要約レポート(XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG KO PO 범주별 구매 요약 보고서 Imported from BI Publisher Description: 범주별 구매 요약 Application: Purchasing Source: 범주별 구매 요약 보고서(XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG PTB PO Relatório Resumido de Compras por Categoria Imported from BI Publisher Description: Sumário de Compras por Categoria Application: Compra Source: Relatório Resumido de Compras por Categoria (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG RU PO Сводный отчет о закупках по категориям Imported from BI Publisher Description: Сводка закупок по категориям Application: Закупки Source: Сводный отчет о закупках по категориям (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG S PO Inköpsöversikt per kategori - rapport Imported from BI Publisher Description: Inköpsöversikt per kategori Application: Purchasing Source: Inköpsöversikt per kategori - rapport (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG TR PO Kategori Bazında Satın Alma Özet Raporu Imported from BI Publisher Description: Kategori Bazında Satın Alma Özet Raporu Application: Satın Alma Yönetimi Source: Kategori Bazında Satın Alma Özet Raporu (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG US PO Purchase Summary Report By Category Imported from BI Publisher Description: Purchase Summary By Category Application: Purchasing Source: Purchase Summary Report By Category (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG ZHS PO 按类别列出的采购汇总报表 Imported from BI Publisher Description: 按类别列出的采购汇总 Application: 采购管理系统 Source: 按类别列出的采购汇总报表 (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG BI Publisher &p_where_cat &where_performance :c_precision :operating_unit :p_base_currency :p_buyer_from :p_buyer_to :p_category_from :p_category_to :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_flex_cat :p_po_creation_date_from :p_po_creation_date_to :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_cat :where_performance 1 -30 :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 -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 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_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 标题 标题 5 20 :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 类别自 类别自 6 30 :p_category_to Char 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 至 至 7 40 :p_buyer_from 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 Von Einkäufer Von Einkäufer E De Comprador De Comprador F Acheteurs - De Acheteurs - De I Buyer - Da Buyer - Da JA 購買担当:自 購買担当:自 KO 구매자 From 구매자 From PTB Compradores - De Compradores - De RU Покупатели с Покупатели с S Från inköpare Från inköpare TR Satın Alanlar: İlk Satın Alanlar: İlk US Buyers From Buyers From ZHS 采购员自 采购员自 8 50 :p_buyer_to 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 إلى 2 مشترون إلى D Bis 2 Bis Einkäufer E A 2 A Comprador F A 2 Acheteurs - A I A 2 Buyer - A JA 至 2 購買担当:至 KO 까지 2 구매자: 까지 PTB Até 2 Compradores Até RU По 2 Покупатели по S Till 2 Till inköpare TR Son 2 Satın Alanlar, Son US To 2 Buyers To ZHS 至 2 采购员至 9 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 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 供应商自 供应商自 10 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 إلى 3 إلى D Bis 3 Bis E A 3 A F A 3 A I A 3 A JA 至 3 至 KO 까지 3 까지 PTB Até 3 Até RU По 3 По S Till 3 Till TR Son 3 Son US To 3 To ZHS 至 3 至 11 80 :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 90 :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 创建日期至