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）限制的操作单元。 C6E085D471C651A9E05362FB09050512Y SELECT prh.segment1 Req_Number , trunc(prh.creation_date) Creation_Date , papf.full_name Preparer , prh.description Description , prh.requisition_header_id requisition_header_id_header FROM po_requisition_headers prh , per_all_people_f papf , po_system_parameters_all psp WHERE prh.preparer_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 trunc(prh.creation_date) BETWEEN nvl(:P_date_from,trunc(prh.creation_date) - 1) AND nvl(:P_date_to,trunc(prh.creation_date) + 1) &C_WHERE_REQ_NUM AND papf.full_name = nvl(:P_preparer, papf.full_name) AND prh.type_lookup_code in ('INTERNAL','PURCHASE') AND psp.ORG_ID = prh.ORG_ID AND EXISTS (SELECT 'requisition line exists' FROM po_req_distributions prd , po_requisition_lines prl , po_lookup_codes plc2 &from_failed_f WHERE prh.requisition_header_id = prl.requisition_header_id AND prl.requisition_line_id = prd.requisition_line_id AND prl.source_type_code = plc2.lookup_code &where_failed_f AND plc2.lookup_type = 'REQUISITION SOURCE TYPE') AND NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' ORDER BY decode(psp.manual_req_num_type,'NUMERIC',decode(rtrim(prh.segment1,'0123456789'),NULL, to_number(prh.segment1),null)), decode(psp.manual_req_num_type,'ALPHANUMERIC',prh.segment1,null) PO POXRQDDR_XML AR PO تقرير تفاصيل توزيع طلب الشراء (بتنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل توزيعات طلبات الشراء Application: المشتريات Source: تقرير تفاصيل توزيع طلب الشراء (بتنسيق XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG D PO Anforderungen - Aufteilungen Imported from BI Publisher Description: Anforderungen - Aufteilungen Application: Einkauf Source: Anforderungen - Aufteilungen (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG E PO Informe Detalle de Distribución de Solicitudes Imported from BI Publisher Description: Detalle de Distribución de Solicitudes Application: Purchasing Source: Informe Detalle de Distribución de Solicitudes (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG F PO Etat détaillé des imputations de demandes d'approvisionnement Imported from BI Publisher Description: Etat détaillé des imputations de demandes internes Application: Purchasing Source: Etat détaillé des imputations de demandes d'approvisionnement (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG I PO Rapporto Dettagli distribuzione richiesta di acquisto Imported from BI Publisher Description: Rapporto Dettagli distribuzione richiesta di acquisto Application: Purchasing Source: Rapporto Dettagli distribuzione richiesta di acquisto (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG JA PO 購買依頼配分詳細レポート Imported from BI Publisher Description: 購買依頼配分詳細レポート Application: Purchasing Source: 購買依頼配分詳細レポート(XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG KO PO 구매요청 분배 상세 보고서 Imported from BI Publisher Description: 구매요청 분배 상세내역 보고서 Application: Purchasing Source: 구매요청 분배 상세 보고서(XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG PTB PO Relatório Detalhado de Distribuições de Requisição Imported from BI Publisher Description: Relatório Detalhado da Classe Contábil de Requisições Application: Compra Source: Relatório Detalhado de Distribuições de Requisição (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG RU PO Подробный отчет о распределении заявок Imported from BI Publisher Description: Подробный отчет о распределении заявок Application: Закупки Source: Подробный отчет о распределении заявок (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG S PO Rekvisitionskontering - detaljrapport Imported from BI Publisher Description: Rekvisitionskontering - detaljrapport Application: Purchasing Source: Rekvisitionskontering - detaljrapport (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG TR PO Talep Dağıtımı Detay Raporu Imported from BI Publisher Description: Talepler Dağıtım Detay Raporu Application: Satın Alma Yönetimi Source: Talep Dağıtımı Detay Raporu (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG US PO Requisition Distribution Detail Imported from BI Publisher Description: Requisitions Distribution Detail Report Application: Purchasing Source: Requisition Distribution Detail Report (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG ZHS PO 申请分配明细报表 Imported from BI Publisher Description: 申请分配明细报表 Application: 采购管理系统 Source: 申请分配明细报表 (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG BI Publisher &c_where_req_num &from_failed_f &where_failed_f :operating_unit :p_chart_of_accounts_id :p_conc_request_id :p_date_from :p_date_to :p_failed_funds :p_failed_funds_disp :p_failed_funds_lp :p_flex_acc :p_flex_item :p_item_struct_num :p_preparer :p_qty_precision :p_req_num_from :p_req_num_to :p_title :qty_precision 1 -20 :p_chart_of_accounts_id Number select gsb.chart_of_accounts_id from gl_sets_of_books gsb, financials_system_parameters fsp where gsb.set_of_books_id = fsp.set_of_books_id Y AR P_CHART_OF_ACCOUNTS_ID رقم هيكل الأستاذ العام # المرن D P_CHART_OF_ACCOUNTS_ID RW# FlexFeld-Struktur-Nummer E P_CHART_OF_ACCOUNTS_ID Número de Tipo de Estructura de GL F P_CHART_OF_ACCOUNTS_ID Numéro de structure de champ flexible GL I P_CHART_OF_ACCOUNTS_ID Numero struttura flexfield GL JA P_CHART_OF_ACCOUNTS_ID GL#フレックス体系番号 KO P_CHART_OF_ACCOUNTS_ID GL# 가변 구조번호 PTB P_CHART_OF_ACCOUNTS_ID Número da estrutura do Flexfield GL# RU P_CHART_OF_ACCOUNTS_ID Номер структуры ГП ГК S P_CHART_OF_ACCOUNTS_ID Bokf.nr: flexfältstrukturnummer TR P_CHART_OF_ACCOUNTS_ID GL# Esnek yapı numarası US P_CHART_OF_ACCOUNTS_ID GL# Flex structure number ZHS P_CHART_OF_ACCOUNTS_ID GL# 弹性结构编号 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_req_num_from LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) AR أرقام طلب الشراء من أرقام طلب الشراء من D Von Anforderungsnummer Von Anforderungsnummer E De Número de Solicitud De Número de Solicitud F Numéros de demande d'approvisionnement - De Numéros de demande d'appro - De I Numeri RdA - Da Numeri RdA - Da JA 購買依頼番号:自 購買依頼番号:自 KO 구매요청 번호: 부터 구매요청 번호: 부터 PTB Números da Requisição - De Números de Requisição - De RU Номера заявок с Номера заявок с S Från rekvisitionsnummer Från rek.nummer TR Talep Numaraları, İlk Talep Numaraları: İlk US Requisition Numbers From Req Numbers From ZHS 申请编号自 申请编号自 5 30 :p_req_num_to LOV Oracle PO_SRS_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED') and nvl(prh.conformed_header_id,0)=0 order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)) ,decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1) AR إلى أرقام طلب الشراء إلى D Bis Bis Anforderungsnummer E A A Número de Solicitud F A Numéros de demande d'appro - A I A Numeri richieste di acquisto - A JA 至 購買依頼番号:至 KO 까지 구매요청 번호: 까지 PTB Até Números de Requisição - Até RU По Номера заявок по S Till Till rek.nummer TR Son Talep Numaraları: Son US To Req Numbers To ZHS 至 申请编号至 6 40 :p_date_from Date AR تواريخ تكوين طلب الشراء من تواريخ تكوين طلب الشراء من D Von Erstellungsdatum Anforderung Von Erstellungsdatum Anforderung E De Fecha de Creación de Solicitud De Fecha de Creación de Solicitud F Dates de création des D.A. - Du Dates de création des D.A. - Du I Date creazione RdA - Da Date creazione RdA - Da JA 購買依頼作成日:自 購買依頼作成日:自 KO 구매요청 생성 일자: 부터 구매요청 생성 일자: 부터 PTB Datas Criação Requisição - De Datas Criação Requisição - De RU Даты создания заявок с Даты создания заявок с S Från skapandedatum för rekv. Från skapandedatum för rekv. TR Talep Oluşturma Tarihleri: İlk Talep Oluşturma Tarihleri: İlk US Requisition Creation Dates From Requisition Creation Dates From ZHS 申请创建日期自 申请创建日期自 7 50 :p_date_to Date AR إلى 2 تواريخ تكوين طلب الشراء إلى D Bis 2 Bis Erstellungsdatum Anforderung E A 2 A Fecha de Creación de Solicitud F Au Dates de création des D.I. - Au I A 2 Date creazione richieste di acquisto - A JA 至 2 購買依頼作成日:至 KO 까지 2 구매요청 생성일자: 까지 PTB Até 2 Datas de Criação de Requisição - Até RU По 2 Даты создания заявок по S Till 2 Rekvisition skapad till TR Son 2 Talep Oluşturma Tarihleri: Son US To 2 Requisition Creation Dates To ZHS 至 2 申请创建日期至 8 60 :p_preparer LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR المُعِد المُعِد D Bearbeiter Bearbeiter E Preparador Preparador F Emetteur Emetteur I Preparatore Preparatore JA 作成者 作成者 KO 작성자 작성자 PTB Preparador Preparador RU Составитель Составитель S Handläggare Handläggare TR Hazırlayan Hazırlayan US Preparer Preparer ZHS 编制人 编制人 9 70 :p_failed_funds 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 Nur nicht genehmigte Mittel Nur nicht genehmigte Mittel E Solo Fondos Insuficientes Solo Fondos Insuficientes F Fonds insuffisants seulement Fonds insuffisants seulement I Solo controllo fondi non superato Solo controllo fondi non superato JA 予算引当失敗のみ 予算引当失敗のみ KO 미집행 예산만 미집행 예산만 PTB Somente Fundos com Falha Somente Fundos com Falha RU Только недостаток фондов Только недостаток фондов S Endast ej godkända medel Endast ej godkända medel TR Salt Geçersiz Fonlar Salt Geçersiz Fonlar US Failed Funds Only Failed Funds Only ZHS 仅限于未通过资金检查的采购单 仅限于未通过资金检查的采购单 10 80 :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 动态精确度选项 数量精确度