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）限制的操作单元。 C6E085D471C851A9E05362FB09050512Y SELECT decode(psp.manual_req_num_type, 'NUMERIC', null, prh.segment1) dummy1 , decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1), null) dummy2 , prh.segment1 ReqNumber , prl.line_num Line , null C_FLEX_CAT , null C_FLEX_ITEM , prl.item_revision Rev , prl.item_description Item_Description , papf.full_name Requestor , round(prl.quantity,:P_qty_precision) Ordered , round(prl.quantity_delivered,:P_qty_precision) Delivered , oeh.order_number Order_Number , oel.line_number OLine , round(oel.shipped_quantity,:P_qty_precision) Shipped , fnd.user_name Cancelled_By , ohis.creation_date C_Date , olu.meaning Cancel_Reason, 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, 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') C_FLEX_ITEM_DISP FROM po_requisition_lines prl , po_requisition_headers prh , per_all_people_f papf , mtl_system_items msi , mtl_categories mca , oe_order_lines_all oel , oe_order_headers_all oeh , oe_lookups olu , fnd_user fnd , po_system_parameters psp , oe_order_lines_history ohis , oe_reasons oer WHERE papf.full_name = nvl(:P_requestor,papf.full_name) AND papf.person_id = prl.to_person_id AND prl.requisition_header_id = prh.requisition_header_id AND prl.source_type_code = 'INVENTORY' AND nvl(prh.transferred_to_oe_flag, 'N') = 'Y' AND nvl(prl.cancel_flag,'N') = 'N' AND nvl(prl.closed_code,'OPEN') <> 'FINALLY CLOSED' AND mca.category_id = prl.category_id AND msi.inventory_item_id(+) = prl.item_id AND nvl(msi.organization_id,prl.source_organization_id) = prl.source_organization_id AND exists (select 1 from oe_order_lines_history ohis where oel.line_id = ohis.line_id) AND oel.ordered_quantity = 0 AND oel.line_id = ohis.line_id AND ohis.hist_type_code = 'CANCELLATION' AND ohis.rowid = (select max(rowid) from oe_order_lines_history oh1 where oel.line_id = oh1.line_id and oh1.hist_type_code = 'CANCELLATION' and creation_date = ( select max(creation_date) from oe_order_lines_history oh2 where oel.line_id = oh2.line_id AND oh2.hist_type_code = 'CANCELLATION' ) ) AND oel.header_id = oeh.header_id AND oeh.source_document_id = prh.requisition_header_id AND oel.source_document_line_id = prl.requisition_line_id AND oeh.order_source_id = psp.order_source_id AND ohis.reason_id = oer.reason_id AND oer.reason_code || '' = olu.lookup_code AND olu.lookup_type = 'CANCEL_CODE' AND fnd.user_id = ohis.created_by 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 &P_WHERE_CAT AND &P_WHERE_ITEM order by 1,2,4,12,13 PO POXRQRCO_XML AR PO تقرير طلبات الشراء بالأمر الملغي (بتنسيق XML) Imported from BI Publisher Description: تقرير طلبات الشراء على الأمر الملغي Application: المشتريات Source: تقرير طلبات الشراء بالأمر الملغي (بتنسيق XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG D PO Anforderungen - für stornierte Aufträge Imported from BI Publisher Description: Anforderungen - für stornierte Aufträge Application: Einkauf Source: Anforderungen - für stornierte Aufträge (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG E PO Informe Solicitudes de Pedidos de Venta Cancelados Imported from BI Publisher Description: Solicitudes de Informe de Pedido Cancelado Application: Purchasing Source: Informe Solicitudes de Pedidos de Venta Cancelados (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG F PO Liste des demandes d'approvisionnement sur commandes annulées Imported from BI Publisher Description: Listes des demandes d'achat sur commandes annulées Application: Purchasing Source: Liste des demandes d'approvisionnement sur commandes annulées (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG I PO Rapporto Richieste di acquisto per ordine annullato Imported from BI Publisher Description: Rapporto Richieste di acquisto per ordine annullato Application: Purchasing Source: Rapporto Richieste di acquisto per ordine annullato (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG JA PO 取消済受注への購買依頼レポート Imported from BI Publisher Description: 取消済受注への購買依頼レポート Application: Purchasing Source: 取消済受注への購買依頼レポート(XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG KO PO 취소된 주문 보고서의 구매요청 Imported from BI Publisher Description: 취소된 주문 보고서의 구매요청 Application: Purchasing Source: 취소된 주문 보고서의 구매요청(XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG PTB PO Requisições no Relatório de Ordem Cancelada Imported from BI Publisher Description: Requisições no Relatório de Ordem Cancelada Application: Compra Source: Requisições no Relatório de Ordem Cancelada (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG RU PO Отчет о заявках на отмену заказов Imported from BI Publisher Description: Отчет о заявках на отмену заказов Application: Закупки Source: Отчет о заявках на отмену заказов (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG S PO Rekvisitioner i rapporten Annullerade order Imported from BI Publisher Description: Rekvisitioner i rapporten Annullerade order Application: Purchasing Source: Rekvisitioner i rapporten Annullerade order (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG TR PO İptal Edilen Siparişteki Talepler Raporu Imported from BI Publisher Description: İptal Edilen Sipariş Raporundaki İstekler Application: Satın Alma Yönetimi Source: İptal Edilen Siparişteki Talepler Raporu (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG US PO Requisitions on Cancelled Order Imported from BI Publisher Description: Requisitions on Cancelled Order Report Application: Purchasing Source: Requisitions on Cancelled Order Report (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG ZHS PO 被取消订单上的申请报表 Imported from BI Publisher Description: 被取消订单上的申请报表 Application: 采购管理系统 Source: 被取消订单上的申请报表 (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG BI Publisher &p_where_cat &p_where_item :c_industry_code :c_order_title :operating_unit :p_category_from :p_category_to :p_conc_request_id :p_flex_cat :p_flex_item :p_item_from :p_item_to :p_oe_status :p_qty_precision :p_requestor :p_struct_num :p_title :p_where_cat :p_where_item :qty_precision 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_item_from Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler, İlk Kalemler, İlk US Items From Items From ZHS 物料自 物料自 5 30 :p_item_to Char AR إلى الأصناف إلى D Bis Bis Artikel E A A Artículo F A Articles - A I A Articoli - A JA 至 品目:至 KO 까지 품목: 까지 PTB Até Itens - Até RU По Позиции по S Till Till artiklar TR Son Kalemler, Son US To Items To ZHS 至 物料至 6 40 :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 申请人 申请人 7 50 :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 类别自 类别自 8 60 :p_category_to Char AR إلى 2 الفئات إلى D Bis 2 Bis Kategorie E A 2 A Categoría F A 2 Catégories - A I A 2 Categorie - A JA 至 2 カテゴリ:至 KO 까지 2 범주: 까지 PTB Até 2 Categorias - Até RU По 2 Категории по S Till 2 Till kategorier TR Son 2 Kategoriler: Son US To 2 Categories To ZHS 至 2 类别至 9 70 :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 动态精确度选项 数量精确度