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）限制的操作单元。 C6E085D471BE51A9E05362FB09050512Y SELECT decode (:P_ORDERBY,'VENDOR TYPE',pov.vendor_type_lookup_code,pov.vendor_name) sort_column , pov.vendor_name Vendor , pov.segment1 Vendor_Number , pov.vendor_type_lookup_code Vendor_Type, decode(pov.small_business_flag,'Y', :yes,:no) Small_Business , decode(pov.women_owned_flag,'Y', :yes,:no) Women_Owned , decode(psp1.manual_po_num_type, 'NUMERIC', null, poh.segment1) , decode(psp1.manual_po_num_type, 'NUMERIC', to_number(poh.segment1), null) , plc1.displayed_field Minority_Owned , pvs.vendor_site_code Vendor_Site , plkc.displayed_field PO_Type , poh.segment1 PO_Number , poh.revision_num Rev , trunc(poh.creation_date) Creation_Date , poh.revised_date Revised_Date , poh.currency_code C_CURRENCY , fc.precision po_currency_precision , poh.comments Description , sum(pll.price_override * (nvl(pll.quantity,0) -nvl(pll.quantity_cancelled,0))) C_AMOUNT_PO , sum(pll.price_override * (nvl(pll.quantity,0) -nvl(pll.quantity_cancelled,0)) * nvl(poh.rate,1)) C_AMOUNT_FUNCTIONAL, PO_POXPOVPS_XMLP_PKG.C_amount_func_vendor_round_p C_amount_func_vendor_round, PO_POXPOVPS_XMLP_PKG.C_amount_rep_round_p C_amount_rep_round, PO_POXPOVPS_XMLP_PKG.C_amount_func_site_round_p C_amount_func_site_round, PO_POXPOVPS_XMLP_PKG.C_amount_func_po_type_round_p C_amount_func_po_type_round, PO_POXPOVPS_XMLP_PKG.C_amount_po_round_p C_amount_po_round, PO_POXPOVPS_XMLP_PKG.C_amount_functional_round_p C_amount_functional_round FROM po_line_locations pll , po_headers poh , po_vendor_sites pvs , po_vendors pov , po_lookup_codes plkc , po_system_parameters psp1 , po_lookup_codes plc1 , fnd_currencies fc WHERE pov.vendor_id = pvs.vendor_id AND pov.vendor_id = poh.vendor_id AND poh.po_header_id = pll.po_header_id AND pvs.vendor_site_id = poh.vendor_site_id AND fc.currency_code = poh.currency_code AND pov.minority_group_lookup_code = plc1.lookup_code(+) AND plc1.lookup_type(+) = 'MINORITY GROUP' AND poh.type_lookup_code = plkc.lookup_code AND plkc.lookup_type = 'PO TYPE' AND plkc.lookup_code not in ('QUOTATION','RFQ') AND (pll.po_release_id is not null OR poh.type_lookup_code not in ('BLANKET', 'PLANNED')) AND ((poh.type_lookup_code != 'PLANNED' AND trunc(poh.creation_date) BETWEEN nvl(:P_creation_date_from, trunc(poh.creation_date) - 1) AND nvl(:P_creation_date_to, trunc(poh.creation_date) + 1)) OR (poh.type_lookup_code = 'PLANNED' AND poh.start_date BETWEEN nvl(:P_creation_date_from, poh.start_date - 1) AND nvl(:P_creation_date_to, poh.start_date + 1) AND pll.shipment_type = 'PLANNED')) AND nvl(pov.vendor_type_lookup_code,'-1') = decode(:P_vendor_type, null, nvl(pov.vendor_type_lookup_code,'-1'), :P_vendor_type) AND nvl(:P_SMALL_BUSINESS, pov.small_business_flag) = pov.small_business_flag AND nvl(:P_WOMEN_OWNED,pov.women_owned_flag) = pov.women_owned_flag AND ((:P_MINORITY_OWNED = 'Y' and pov.minority_group_lookup_code is not null) OR (:P_MINORITY_OWNED = 'N' and pov.minority_group_lookup_code is null) OR (:P_MINORITY_OWNED is null)) GROUP BY poh.po_header_id, poh.segment1, pov.small_business_flag, pov.women_owned_flag, plc1.displayed_field, pov.vendor_name, pov.vendor_id, pov.vendor_type_lookup_code, pvs.vendor_site_code, poh.revision_num, poh.creation_date, poh.revised_date, plkc.displayed_field, pvs.vendor_site_id, pov.segment1, poh.currency_code, fc.precision, poh.comments, psp1.manual_po_num_type ORDER BY &orderby_clause PO POXPOVPS_XML AR PO تقرير إجمالي مشتريات المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير إجمالي مشتريات المورد Application: المشتريات Source: تقرير إجمالي مشتريات المورد (بتنسيق XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG D PO Lieferanten - Bestellübersicht Imported from BI Publisher Description: Lieferanten - Bestellübersicht Application: Einkauf Source: Lieferanten - Bestellübersicht (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG E PO Informe Resumen de Compras a Proveedores Imported from BI Publisher Description: Informe de resumen de compras a proveedores Application: Purchasing Source: Informe Resumen de Compras a Proveedores (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG F PO Etat de synthèse des achats par fournisseur Imported from BI Publisher Description: Etat de synthèse des achats par fournisseur Application: Purchasing Source: Etat de synthèse des achats par fournisseur (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG I PO Rapporto Sintetico acquisti per fornitore Imported from BI Publisher Description: Rapporto Sintetico ordini di acquisto per fornitore Application: Purchasing Source: Rapporto Sintetico acquisti per fornitore (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG JA PO 仕入先別購買要約レポート Imported from BI Publisher Description: 仕入先別購買要約レポート Application: Purchasing Source: 仕入先別購買要約レポート(XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG KO PO 공급자 구매 요약 보고서 Imported from BI Publisher Description: 공급자 구매 요약 보고서 Application: Purchasing Source: 공급자 구매 요약 보고서(XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG PTB PO Relatório Resumido de Compras do Fornecedor Imported from BI Publisher Description: Relat. Sumar. OCs Fornecedores Application: Compra Source: Relatório Resumido de Compras do Fornecedor (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG RU PO Сводный отчет о закупках у поставщиков Imported from BI Publisher Description: Сводный отчет о закупках у поставщиков Application: Закупки Source: Сводный отчет о закупках у поставщиков (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG S PO Inköpsöversikt leverantörer - rapport Imported from BI Publisher Description: Inköpsöversikt leverantörer - rapport Application: Purchasing Source: Inköpsöversikt leverantörer - rapport (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG TR PO Tedarikçi Satın Alma Özeti Raporu Imported from BI Publisher Description: Tedarikçi Satın Alma Özet Raporu Application: Satın Alma Yönetimi Source: Tedarikçi Satın Alma Özeti Raporu (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG US PO Vendor Purchase Summary Imported from BI Publisher Description: Vendor Purchase Summary Report Application: Purchasing Source: Vendor Purchase Summary Report (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG ZHS PO 供应商采购汇总报表 Imported from BI Publisher Description: 供应商采购汇总报表 Application: 采购管理系统 Source: 供应商采购汇总报表 (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG BI Publisher &orderby_clause :c_amount_func_po_type_round :c_amount_func_site_round :c_amount_func_vendor_round :c_amount_functional_round :c_amount_mo_round :c_amount_po_round :c_amount_rep_round :c_amount_sb_round :c_amount_wo_round :lp_orderby_displayed :no :operating_unit :p_base_currency :p_conc_request_id :p_creation_date_from :p_creation_date_from_lp :p_creation_date_to :p_creation_date_to_lp :p_minority_owned :p_minority_owned_disp :p_orderby :p_orderby_displayed :p_small_business :p_small_business_disp :p_small_business_flag :p_title :p_vendor_type :p_women_owned :p_women_owned_disp :yes 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_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 创建日期自 创建日期自 5 30 :p_creation_date_to Date AR إلى تواريخ التكوين إلى D Bis Bis Erstellungsdatum E A A Fecha de Creación F Au Dates de création - Au I A Date creazione - A JA 至 作成日:至 KO 까지 생성일자: 까지 PTB Até Datas de Criação - Até RU По Даты создания по S Till Till skapandedatum TR Son Oluşturma Tarihleri: Son US To Creation Dates To ZHS 至 创建日期至 6 40 :p_vendor_type LOV Oracle PO_SRS_VENDOR_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='VENDOR TYPE' order by displayed_field AR نوع المورد نوع المورد D Lieferantenart Lieferantenart E Tipo de Proveedor Tipo de Proveedor F Type de fournisseur Type de fournisseur I Tipo fornitore Tipo di fornitore JA 仕入先タイプ 仕入先タイプ KO 공급자 유형 공급자 유형 PTB Tipo de Fornecedor Tipo de Fornecedor RU Тип поставщика Тип поставщика S Leverantörstyp Leverantörstyp TR Tedarikçi Tipi Tedarikçi Tipi US Vendor Type Vendor Type ZHS 供应商类型 供应商类型 7 50 :p_small_business LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR مؤسسات صغيرة مؤسسات صغيرة D Mittelständisches Unternehmen Mittelständisches Unternehmen E PYME PYME F Petite entreprise Petite entreprise I Piccola impresa Piccola impresa JA 中小法人 中小法人 KO 중소 기업 중소 기업 PTB Empresa de Pequeno Porte Empresa de Pequeno Porte RU Малое предприятие Малое предприятие S Småföretag Småföretag TR Küçük İşletme Küçük İşletme US Small Business Small Business ZHS 小型企业 小型企业 8 60 :p_minority_owned LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR ملكية الأقلية ملكية الأقلية D Freie Kategorie Freie Kategorie E Propiedad de Minorías Propiedad de Minorías F Détenu par minorité (USA) Détenu par minorité (USA) I Relativo a minoranza Relativo a minoranza JA 少数民族所有 少数民族所有 KO 소수 민족 소유 소수 민족 소유 PTB Controlado por Minoria Controlado por Minoria RU В собственности меньшинства В собственности меньшинства S Minoritetsägd Minoritetsägd TR Sahibi Azınlık Sahibi Azınlık US Minority Owned Minority Owned ZHS 少数民族经营的企业 少数民族经营的企业 9 70 :p_women_owned LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR ملكية النساء ملكية النساء D Weiteres Kriterium Weiteres Kriterium E Propiedad Mujeres Propiedad Mujeres F Détenu par des femmes Détenu par des femmes I A conduzione femminile A conduzione femminile JA 女性所有 女性所有 KO 여성 소유 여성 소유 PTB Controlado por Mulher Controlado por Mulher RU В собственности женщин В собственности женщин S Kvinnoägd Kvinnoägd TR Sahibi Bayan Sahibi Bayan US Women Owned Women Owned ZHS 女性经营的企业 女性经营的企业 10 80 :p_orderby LOV Oracle PO_SRS_POXPOVPS_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','VENDOR TYPE') 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 bazı US Sort By Sort by ZHS 排序依据 排序依据