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）限制的操作单元。 C6E085D471CF51A9E05362FB09050512 SELECT pll.line_location_id Parent_Line_location_id , pov.vendor_name Vendor , pvs.vendor_site_code Vendor_Site , null C_FLEX_CAT , null C_FLEX_ITEM , poh.segment1||decode(por.release_num,null,null,'-'||por.release_num) PO_Number , lot.location_code Ship_To_Location , pol.line_num Line , TO_CHAR(pll.need_by_date, 'DD/MON/YYYY HH24:MI:SS') Need_By_Date , plt.line_type Line_Type , pol.item_description Description , round(pll.quantity,:P_qty_precision) C_QUANTITY , poh.currency_code C_CURRENCY , pol.item_revision Rev , pol.unit_meas_lookup_code Unit , T.type_name Document_Type , 'PO' Parent_Join_type , decode(psp.manual_po_num_type,'NUMERIC',null,poh.segment1) Document_Numbering1 , decode(psp.manual_po_num_type,'NUMERIC',to_number(poh.segment1),null) Document_Numbering2, --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 decode(pol.category_id,null,null,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, -- Bug20005085 decode(msi.inventory_item_id,null,null,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 -- Bug20005085 FROM hr_locations_all_tl lot , po_vendor_sites_all pvs , po_vendors pov , po_line_locations_all pll , po_lines_all pol , po_line_types plt , mtl_system_items msi , mtl_categories mca , po_headers poh , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B , po_system_parameters_all psp , po_releases_all por WHERE poh.org_id = pvs.org_id AND poh.org_id = psp.org_id AND poh.po_header_id = pol.po_header_id AND B.document_type_code in ('PO', 'PA') AND B.document_subtype = poh.type_lookup_code AND B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = poh.org_id AND T.LANGUAGE = USERENV('LANG') AND mca.category_id = pol.category_id AND msi.inventory_item_id (+) = pol.item_id AND :organization_id = nvl(msi.organization_id,:organization_id ) AND pol.line_type_id = plt.line_type_id AND pol.po_line_id = pll.po_line_id AND pll.ship_to_location_id = lot.location_id (+) AND pll.ship_to_location_id is not null AND LOT.LANGUAGE (+) = USERENV('LANG') AND pll.po_release_id = por.po_release_id (+) AND poh.vendor_id = pov.vendor_id AND poh.vendor_site_id = pvs.vendor_site_id AND pov.vendor_name BETWEEN nvl(:P_vendor_from,pov.vendor_name) AND nvl(:P_vendor_to,pov.vendor_name) AND pvs.vendor_site_code = nvl(:P_site, pvs.vendor_site_code) AND lot.location_code (+) = nvl(:P_ship_to ,lot.location_code (+)) AND EXISTS (SELECT 'x' FROM rcv_transactions rct, per_all_people_f papf WHERE rct.po_line_location_id = pll.line_location_id AND rct.receipt_exception_flag = 'Y' AND rct.transaction_date BETWEEN nvl(:P_trans_date_from,rct.transaction_date - 1) AND nvl(:P_trans_date_to,rct.transaction_date + 1) AND rct.employee_id = papf.person_id (+) and trunc(sysdate) between pAPF.effective_start_date (+) and pAPF.effective_end_date (+) and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_PERSON (PAPF.person_id (+),PAPF.current_applicant_flag (+),PAPF.current_employee_Flag (+),PAPF.current_npw_flag (+),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 nvl(papf.full_name (+), 'A') = nvl(:P_receiver, nvl(papf.full_name (+),'A')) AND rct.organization_id = nvl(:P_org_id,rct.organization_id) ) UNION SELECT prl.requisition_line_id Parent_Line_location_id , null Vendor , null Vendor_Site , null C_FLEX_CAT , null C_FLEX_ITEM , prh.segment1 PO_Number , lot.location_code Ship_To_Location , prl.line_num Line , TO_CHAR(prl.need_by_date, 'DD/MON/YYYY HH24:MI:SS') Need_By_Date , plt.line_type Line_Type , prl.item_description Description , round(prl.quantity,:P_qty_precision) C_QUANTITY , :GL_CURRENCY C_CURRENCY , prl.item_revision Rev , prl.unit_meas_lookup_code Unit , T.type_name Document_Type , 'REQ' Parent_Join_type , decode(psp.manual_req_num_type,'NUMERIC',null,prh.segment1) Document_Numbering1 , decode(psp.manual_req_num_type,'NUMERIC',to_number(prh.segment1),null) Document_Numbering2 , -- 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 decode(prl.category_id,null,null,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, -- Bug20005085 decode(msi.inventory_item_id,null,null,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 -- Bug20005085 FROM hr_locations_all_tl lot , po_requisition_lines_all prl , po_requisition_headers prh , po_line_types plt , mtl_system_items msi , mtl_categories mca , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B , po_system_parameters_all psp WHERE prh.org_id = psp.org_id AND prh.requisition_header_id = prl.requisition_header_id AND B.document_type_code = 'REQUISITION' AND B.document_subtype = prh.type_lookup_code AND B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = PRH.ORG_ID AND T.LANGUAGE = USERENV('LANG') AND mca.category_id = prl.category_id AND msi.inventory_item_id (+) = prl.item_id AND :organization_id = nvl(msi.organization_id,:organization_id ) AND prl.line_type_id = plt.line_type_id AND prl.deliver_to_location_id = lot.location_id (+) AND prl.deliver_to_location_id is not null AND LOT.LANGUAGE (+) = USERENV('LANG') AND lot.location_code (+) = nvl(:P_ship_to ,lot.location_code (+) ) AND EXISTS (SELECT 'x' FROM rcv_transactions rct, per_all_people_f papf WHERE rct.requisition_line_id = prl.requisition_line_id AND rct.receipt_exception_flag = 'Y' AND rct.transaction_date BETWEEN nvl(:P_trans_date_from,rct.transaction_date - 1) AND nvl(:P_trans_date_to,rct.transaction_date + 1) AND rct.employee_id = papf.person_id (+) and trunc(sysdate) between pAPF.effective_start_date (+) and pAPF.effective_end_date (+) and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_PERSON (PAPF.person_id (+),PAPF.current_applicant_flag (+),PAPF.current_employee_Flag (+),PAPF.current_npw_flag (+),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 nvl(papf.full_name (+), 'A') = nvl(:P_receiver, nvl(papf.full_name (+),'A')) AND rct.organization_id = nvl(:P_org_id,rct.organization_id) ) ORDER BY &orderby_clause Y PO POXRVRER_XML AR PO تقرير استثناءات الاستلام (بتنسيق XML) Imported from BI Publisher Description: تقرير استثناءات الاستلام Application: المشتريات Source: تقرير استثناءات الاستلام (بتنسيق XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG D PO Wareneingang - Ausnahmen Imported from BI Publisher Description: Wareneingang - Ausnahmen Application: Einkauf Source: Wareneingang - Ausnahmen (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG E PO Informe Excepciones de Recepción Imported from BI Publisher Description: Informe de excepciones de recepción Application: Purchasing Source: Informe Excepciones de Recepción (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG F PO Etat des réceptions à signaler Imported from BI Publisher Description: Etat des réceptions à signaler Application: Purchasing Source: Etat des réceptions à signaler (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG I PO Rapporto Eccezioni ricezione Imported from BI Publisher Description: Rapporto Eccezioni ricezione Application: Purchasing Source: Rapporto Eccezioni ricezione (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG JA PO 受入差異レポート Imported from BI Publisher Description: 受入差異レポート Application: Purchasing Source: 受入差異レポート(XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG KO PO 입고 예외 보고서 Imported from BI Publisher Description: 입고 예외 보고서 Application: Purchasing Source: 입고 예외 보고서(XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG PTB PO Relatório de Exceções de Recebimento Imported from BI Publisher Description: Relatório de Exceções de Recebimento Application: Compra Source: Relatório de Exceções de Recebimento (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG RU PO Отчет об исключениях получения Imported from BI Publisher Description: Отчет об исключениях получения Application: Закупки Source: Отчет об исключениях получения (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG S PO Inleveransavvikelser - rapport Imported from BI Publisher Description: Inleveransavvikelser - rapport Application: Purchasing Source: Inleveransavvikelser - rapport (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG TR PO Teslim Alma İstisnaları Raporu Imported from BI Publisher Description: Teslim Alma İstisnalar Raporu Application: Satın Alma Yönetimi Source: Teslim Alma İstisnaları Raporu (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG US PO Receiving Exceptions Imported from BI Publisher Description: Receiving Exceptions Report Application: Purchasing Source: Receiving Exceptions Report (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG ZHS PO 接收例外报表 Imported from BI Publisher Description: 接收例外报表 Application: 采购管理系统 Source: 接收例外报表 (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG BI Publisher &orderby_clause :gl_currency :operating_unit :organization_id :p_1 :p_conc_request_id :p_flex_cat :p_flex_item :p_item_struct_num :p_org_displayed :p_org_id :p_qty_precision :p_receiver :p_ship_to :p_site :p_sort :p_sort_disp :p_struct_num :p_title :p_trans_date_from :p_trans_date_to :p_vendor_from :p_vendor_to :qty_precision 1 -20 :p_struct_num Number select structure_id from mtl_default_sets_view where functional_area_id = 2 Y AR هيكل الفئة رقم هيكل P D Kategoriestruktur P Strukturnummer E Estructura de Categoría Número de Estructura de Posición F Structure de catégorie Numéro de structure P I Struttura categoria P Numero struttura JA カテゴリ体系 P体系番号 KO 범주 구조 P 구조번호 PTB Estrutura da Categoria Núm. de estr. de c. RU Структура категорий P struct num S Kategoristruktur Strukturnummer TR Kategori Yapısı P yapı no US Category Structure P struct num ZHS 类别结构 结构编号 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_ship_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 Wareneingangsstandort Wareneingangsstandort E Ubicación de Recepción Ubicación de Recepción F Lieu de réception Lieu de réception I Ubicazione di ricezione Ubicazione di ricezione JA 受入事業所 受入事業所 KO 입고 위치 입고 위치 PTB Local do Recebimento Local do Recebimento RU Расположение поступления Расположение поступления S Godsmottagningsadress Godsmottagningsadress TR Teslim Alma Yeri Teslim Alma Yeri US Receipt Location Receipt Location ZHS 接收地点 接收地点 5 30 :p_receiver LOV Oracle PO_SRS_EMPLOYEE Y select full_name id, full_name value, null description from hr_employees order by full_name AR مستلم مستلم D Warenannahme Warenannahme E Receptor Receptor F Bénéficiaire Bénéficiaire I Destinatario Destinatario JA 受入担当 受入担当 KO 입고자 입고자 PTB Recebedor Recebedor RU Получатель Получатель S Mottagare Mottagare TR Teslim Alan Teslim Alan US Receiver Receiver ZHS 接收人 接收人 6 40 :p_trans_date_from DateTime AR تاريخ الاستلام من تاريخ الاستلام من D Von Wareneingangsdatum Von Wareneingangsdatum E De Fecha de Recepción De Fecha de Recepción F Dates de réception - Du Dates de réception - Du I Data ricevuta - Da Data ricevuta - Da JA 受入日:自 受入日:自 KO 입고 일자: 부터 입고 일자: 부터 PTB Data do Recebimento - De Data do Recebimento - De RU Дата поступления с Дата поступления с S Från inleveransdatum Från inleveransdatum TR Teslimat Tarihi: İlk Teslimat Tarihi: İlk US Receipt Date From Receipt Date From ZHS 接收日期自 接收日期自 7 50 :p_trans_date_to DateTime AR إلى تاريخ الاستلام إلى D Bis Bis Wareneingangsdatum E A A Fecha de Recepción F Au Dates de réception - Au I A Data ricevuta - A JA 至 受入期日 KO 까지 입고 일자 To PTB Até Data do Recebimento - Até RU По Дата поступления по S Till Till inleveransdatum TR Son Teslimat Tarihi: Son US To Receipt Date To ZHS 至 收款日期至 8 60 :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 Fournisseur - De Fournisseur - De I Fornitore - Da Fornitore - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedor - De Fornecedor - De RU Поставщик с Поставщик с S Från leverantör Från leverantör TR İlk Tedarikçi İlk Tedarikçi US Supplier From Supplier From ZHS 起始供应商 起始供应商 9 70 :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 إلى 2 مورد إلى D Bis 2 Bis Lieferant E A 2 A Proveedor F A Fournisseur - A I A 2 Fornitore - A JA 至 2 仕入先:至 KO 까지 2 공급자: 까지 PTB Até 2 Fornecedor - Até RU По 2 Поставщик по S Till 2 Till leverantör TR Son 2 Son Tedarikçi US To 2 Supplier To ZHS 至 2 供应商至 10 80 :p_site LOV Oracle PO_SRS_VENDOR_SITE Y select vendor_site_code id, vendor_site_code value, null description from po_vendor_sites order by vendor_site_code AR موقع المورِّد موقع المورِّد D Lieferantenadresse Lieferantenadresse E Sitio de Proveedor Sitio de Proveedor F Site fournisseur Site fournisseur I Sede fornitore Sede fornitore JA 仕入先サイト 仕入先サイト KO 공급자 지점 공급자 지점 PTB Local do Fornecedor Local do Fornecedor RU Отделение поставщика Отделение поставщика S Leverantörsplats Leverantörsplats TR Tedarikçi İşletme Birimi Tedarikçi İşletme Birimi US Supplier Site Supplier Site ZHS 供应商地点 供应商地点 11 90 :p_org_id LOV Oracle PO_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by value,description AR اسم التنظيم اسم التنظيم D Organisationsbezeichnung Organisationsbezeichnung E Nombre de Organización Nombre de Organización F Nom de l'organisation Nom de l'organisation I Nome organizzazione Nome organizzazione JA 組織名 組織名 KO 조직명 조직명 PTB Nome da Organização Nome da Organização RU Организация Организация S Organisation Organisation TR Organizasyon Adı Organizasyon Adı US Organization Name Organization Name ZHS 组织名 组织名 12 100 :p_sort LOV Oracle PO_SRS_POXRVRER_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','PO NUMBER') 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 Esası US Sort By Sort By ZHS 排序依据 排序依据 13 110 :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 动态精确度选项 数量精确度