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）限制的操作单元。 C6E085D471C951A9E05362FB09050512Y SELECT prl.line_num Line , null C_FLEX_ITEM , null C_FLEX_CAT , prl.item_revision Rev , prl.item_description Description , prl.unit_meas_lookup_code Unit , prl.quantity Quantity , prl.unit_price Unit_Price , prl.deliver_to_location_id deliver_to_location_id , papf.full_name Requestor , prl.quantity_delivered Quantity_Delivered , lot.location_code Deliver_To_Location , prl.need_by_date Need_By_Date , plkc.displayed_field On_RFQ , prl2.line_num From_Req_Line , poh.segment1 PO_Number , decode(poh.segment1, '', '', plc.displayed_field) PO_Status , pol.line_num PO_Line , prl.requisition_header_id Req_Header_IdB, 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, nvl2(prl.item_id,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'),null) C_FLEX_ITEM_DISP, PO_POXRQRSR_XMLP_PKG.cf_locationsformula(lot.location_code, prl.deliver_to_location_id) CF_locations FROM po_requisition_lines prl , po_requisition_lines prl2 , po_lookup_codes plc , per_all_people_f papf , HR_LOCATIONS_ALL_TL lot , po_line_locations_all pll , po_lines_all pol , po_headers_all poh , po_lookup_codes plkc , mtl_system_items msi , mtl_categories mca WHERE prl.to_person_id = papf.person_id AND nvl(prl.cancel_flag,'N') = 'N' AND prl.deliver_to_location_id = lot.location_id (+) AND prl.deliver_to_location_id is not null AND pll.line_location_id (+) = prl.line_location_id AND pll.po_line_id = pol.po_line_id (+) AND pol.po_header_id = poh.po_header_id (+) AND plkc.lookup_type = 'YES/NO' AND plkc.lookup_code = nvl(prl.on_rfq_flag,'N') AND prl.item_id = msi.inventory_item_id(+) AND :c_organization_id = nvl(msi.organization_id, :c_organization_id) AND prl.category_id = mca.category_id AND prl.parent_req_line_id = prl2.requisition_line_id (+) AND nvl(poh.authorization_status,'INCOMPLETE') = plc.lookup_code AND plc.lookup_type = 'DOCUMENT STATE' AND nvl( lot.location_code,-1) = nvl(:P_deliver_to,nvl(lot.location_code,-1)) AND nvl(papf.full_name,'A') = nvl(:P_requestor,nvl(papf.full_name,'A')) AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED' AND prl.requisition_header_id = :Req_Header_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 lot.LANGUAGE(+) = USERENV('LANG') and prl.requisition_header_id=:Req_Header_Id ORDER BY prl.line_num PO POXRQRSR_XML AR PO تقرير موقف طلب شراء الشراء (بتنسيق XML) Imported from BI Publisher Description: تقرير موقف طلب شراء الشراء Application: المشتريات Source: تقرير موقف طلب شراء الشراء (بتنسيق XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG D PO Anforderungen - Status (2) Imported from BI Publisher Description: Anforderungen - Status Application: Einkauf Source: Anforderungen - Status (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG E PO Informe Estado de Solicitudes de Compra Imported from BI Publisher Description: Informe de estado de solicitudes de compra Application: Purchasing Source: Informe Estado de Solicitudes de Compra (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG F PO Etat du statut des demandes d'achat (2) Imported from BI Publisher Description: Etat du statut des demandes d'achat Application: Purchasing Source: Etat du statut des demandes d'achat (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG I PO Rapporto Stato richiesta di acquisto Imported from BI Publisher Description: Rapporto Stato richiesta di acquisto Application: Purchasing Source: Rapporto Stato richiesta di acquisto (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG JA PO 購買依頼ステータス・レポート Imported from BI Publisher Description: 購買依頼ステータス・レポート Application: Purchasing Source: 購買依頼ステータス・レポート(XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG KO PO 구매요청 상태 보고서 Imported from BI Publisher Description: 구매요청 상태 보고서 Application: Purchasing Source: 구매요청 상태 보고서(XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG PTB PO Relatório de Status da Requisição de Compra Imported from BI Publisher Description: Relatório Status Requisição Compra Application: Compra Source: Relatório de Status da Requisição de Compra (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG RU PO Отчет о статусе заявок на приобретение Imported from BI Publisher Description: Отчет о статусе заявок на приобретение Application: Закупки Source: Отчет о статусе заявок на приобретение (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG S PO Status på inköpsrekvisition - rapport Imported from BI Publisher Description: Status på inköpsrekvisition - rapport Application: Purchasing Source: Status på inköpsrekvisition - rapport (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG TR PO Satın Alma Talep Statüsü Raporu Imported from BI Publisher Description: Satın Alma Talep Statüsü Raporu Application: Satın Alma Yönetimi Source: Satın Alma Talep Statüsü Raporu (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG US PO Purchase Requisition Status Imported from BI Publisher Description: Purchase Requisition Status Report Application: Purchasing Source: Purchase Requisition Status Report (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG ZHS PO 采购申请状态报表 (2) Imported from BI Publisher Description: 采购申请状态报表 Application: 采购管理系统 Source: 采购申请状态报表 (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG BI Publisher :c_organization_id :format_mask :operating_unit :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_deliver_to :p_flex_cat :p_flex_item :p_item_struct_num :p_qty_precision :p_req_num_from :p_req_num_to :p_requestor :p_struct_num :p_title :req_header_id 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 Kategoriestruktur P_STRUCT_NUM E Estructura de Categoría P_STRUCT_NUM F Structure de catégorie P_STRUCT_NUM I Struttura categoria P_STRUCT_NUM JA カテゴリ体系 P_STRUCT_NUM KO 범주 구조 P_STRUCT_NUM PTB Estrutura da Categoria P_STRUCT_NUM RU Структура категорий P_STRUCT_NUM S Kategoristruktur P_STRUCT_NUM TR Kategori Yapısı P_STRUCT_NUM US Category Structure P_STRUCT_NUM 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_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_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_requestor LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR الطالب الطالب D Anforderer Anforderer E Solicitante Solicitante F Demandeur Demandeur I Richiedente Richiedente JA 依頼者 依頼者 KO 요청자 요청자 PTB Solicitante Solicitante RU Автор запроса Автор запроса S Beställare Beställare TR İstek Sahibi İstek Sahibi US Requester Requester ZHS 申请人 申请人 9 70 :p_deliver_to LOV Oracle PO_SRS_LOCATION Y select location_code id, location_code value, null description from hr_locations order by location_code AR الموقع الموقع D Standort Standort E Ubicación Ubicación F Lieu Lieu I Ubicazione Ubicazione JA 事業所 事業所 KO 위치 위치 PTB Local Local RU Расположение Расположение S Adress Adress TR Yerleşim Yerleşim US Location Location 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 动态精确度选项 数量精确度