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）限制的操作单元。 C6E085D471C251A9E05362FB09050512Y SELECT distinct papf.full_name Buyer , poh.segment1 Quotation_Number , pov.vendor_name , pov.vendor_name||' ['||pov.segment1||']' Vendor_Name_Vendor_Number , pvs.vendor_site_code Vendor_Site , decode(pvc.last_name||', '||pvc.first_name,', ','', pvc.last_name||', '||pvc.first_name) Vendor_Contact , pvc.phone Telephone_Number , poh.quote_vendor_quote_number Vendor_Quotation_Number , poh.end_date Expiration_Date , nvl(poh.quote_warning_delay,0) Warning_Delay , poh.comments Description , plc.displayed_field Quotation_Type , poh.currency_code Currency , poh.po_header_id Parent_po_header_id FROM po_vendor_sites pvs , po_vendor_contacts pvc , per_all_people_f papf , po_lookup_codes plc , po_headers poh , po_vendors pov WHERE pov.vendor_id = poh.vendor_id AND poh.vendor_site_id = pvs.vendor_site_id(+) AND poh.vendor_contact_id = pvc.vendor_contact_id(+) AND poh.type_lookup_code = 'QUOTATION' AND poh.agent_id = papf.person_id 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 pov.vendor_name >= nvl(:P_vendor_from , pov.vendor_name ) AND pov.vendor_name <= nvl(:P_vendor_to , pov.vendor_name) AND papf.full_name = nvl(:P_buyer,papf.full_name) AND nvl(:P_date_from, nvl(poh.end_date,sysdate)) <= decode(:P_date_from,NULL,nvl(poh.end_date,sysdate),poh.end_date) AND nvl(:P_date_to, (nvl(poh.end_date,sysdate)-nvl(poh.quote_warning_delay,0))) >= decode(:P_date_to,NULL,nvl(poh.end_date,sysdate) -nvl(poh.quote_warning_delay,0) , poh.end_date - nvl(poh.quote_warning_delay,0)) AND plc.lookup_type (+) = 'QUOTATION CLASS' AND plc.lookup_code(+) = poh.quote_type_lookup_code AND EXISTS (select 'lines and shipments exist' from po_line_locations pll , po_lines pol , mtl_categories mca where poh.po_header_id = pol.po_header_id and pol.po_line_id = pll.po_line_id AND nvl(:P_date_from,nvl(pll.end_date,nvl(poh.end_date,sysdate))) <= decode(:P_date_from,NULL,nvl(pll.end_date,nvl(poh.end_date,sysdate)), nvl(pll.end_date,poh.end_date)) and nvl(:P_date_to,nvl(pll.end_date,nvl(poh.end_date,sysdate)) - nvl(poh.quote_warning_delay,0)) >= decode(:P_date_to,NULL,nvl(pll.end_date,nvl(poh.end_date,sysdate))-nvl(poh.quote_warning_delay,0), nvl(pll.end_date,poh.end_date) - nvl(poh.quote_warning_delay,0)) AND pol.category_id = mca.category_id and &P_where_cat ) ORDER BY papf.full_name , pov.vendor_name PO POXQTQAR_XML AR PO تقرير إجراء عرض الأسعار المطلوب (بتنسيق XML) Imported from BI Publisher Description: تقرير إجراء عرض الأسعار المطلوب Application: المشتريات Source: تقرير إجراء عرض الأسعار المطلوب (بتنسيق XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG D PO Angebote - ausstehende Vorgänge Imported from BI Publisher Description: Angebote - ausstehende Vorgänge Application: Einkauf Source: Angebote - ausstehende Vorgänge (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG E PO Informe Seguimiento de Ofertas Imported from BI Publisher Description: Informe de seguimiento de ofertas Application: Purchasing Source: Informe Seguimiento de Ofertas (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG F PO Suivi des propositions de prix Imported from BI Publisher Description: Suivi des propositions de prix Application: Purchasing Source: Suivi des propositions de prix (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG I PO Rapporto Azione richiesta su preventivo Imported from BI Publisher Description: Rapporto Azione richiesta su preventivo Application: Purchasing Source: Rapporto Azione richiesta su preventivo (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG JA PO 見積処理指定レポート Imported from BI Publisher Description: 見積処理指定レポート Application: Purchasing Source: 見積処理指定レポート(XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG KO PO 견적 조치 필수 보고서 Imported from BI Publisher Description: 견적 조치 요구 보고서 Application: Purchasing Source: 견적 조치 필수 보고서(XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG PTB PO Relatório de Ação Necessária da Cotação Imported from BI Publisher Description: Relatório de Ação de Cotação Necessária Application: Compra Source: Relatório de Ação Necessária da Cotação (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG RU PO Отчет о необходимых действиях по котировкам Imported from BI Publisher Description: Отчет о необходимых действиях по котировкам Application: Закупки Source: Отчет о необходимых действиях по котировкам (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG S PO Offert att åtgärda - rapport Imported from BI Publisher Description: Offert att åtgärda - rapport Application: Purchasing Source: Offert att åtgärda - rapport (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG TR PO Fiyat Teklifi Eylemi için Gerekli Rapor Imported from BI Publisher Description: Fiyat Teklifi Eylemi Gerekli Raporu Application: Satın Alma Yönetimi Source: Fiyat Teklifi Eylemi için Gerekli Rapor (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG US PO Quotation Action Required Imported from BI Publisher Description: Quotation Action Required Report Application: Purchasing Source: Quotation Action Required Report (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG ZHS PO 要求报价活动报表 Imported from BI Publisher Description: 要求报价活动报表 Application: 采购管理系统 Source: 要求报价活动报表 (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG BI Publisher &p_where_cat :format_mask :operating_unit :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_date_from :p_date_to :p_flex_cat :p_flex_item :p_qty_precision :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_cat 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_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 采购员姓名 采购员姓名 7 50 :p_date_from Date AR تواريخ انتهاء صلاحية عروض الأسعار من تواريخ انتهاء صلاحية عروض الأسعار من D Von Gültigkeitsdatum Angebot Von Gültigkeitsdatum Angebot E De Fecha de Caducidad de Solicitud De Fecha de Caducidad de Solicitud F Dates d'expiration des propositions - Du Dates d'expiration des propositions - Du I Date scadenza preventivo - Da Date scadenza preventivo - Da JA 見積失効日:自 見積失効日:自 KO 견적 만기일자: 부터 견적 만기일자: 부터 PTB Datas Expiração Cotação - De Datas Expiração Cotação - De RU Окончание действия котировки с Окончание действия котировки с S Sista giltighet offert från Sista giltighet offert från TR Fiyat Teklifi Geçerlilik Bitiş Tarihleri: İlk Fiyat Teklifi Geçerlilik Bitiş Tarihleri: İlk US Quotation Expiration Dates From Quotation Expiration Dates From ZHS 报价单过期日自 报价单过期日自 8 60 :p_date_to Date AR إلى 2 تواريخ انتهاء صلاحية عروض الأسعار إلى D Bis 2 Bis Gültigkeitsdatum Angebot E A 2 A Fecha de Caducidad de la Oferta F Au Dates d'expiration des propositions - A I A 2 Date scadenza preventivo - A JA 至 2 見積失効日:至 KO 까지 2 견적 만기 일자: 까지 PTB Até 2 Datas Expiração Cotação - Até RU По 2 Окончание действия котировки по S Till 2 Sista giltighet offert till TR Son 2 Fiyat Teklifi Geçerlilik Bitiş Tarihleri: Son US To 2 Quotation Expiration Dates To ZHS 至 2 报价单过期日至 9 70 :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 类别自 类别自 10 80 :p_category_to Char AR إلى 3 إلى D Bis 3 Bis E A 3 A F A 2 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 90 :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 动态精确度选项 数量精确度