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）限制的操作单元。 C6E085D471D051A9E05362FB09050512Y SELECT poh.segment1||decode(por.release_num,null,null,'-'||por.release_num) Document_Number , T.type_name Document_Type , pov.vendor_name || decode( pvs.vendor_site_code ,null,null,',' || pvs.vendor_site_code ) Source , papf1.full_name Buyer , TO_CHAR(poh.creation_date, 'DD/MON/YYYY HH24:MI:SS') Creation_Date , 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 , pol.line_num Line , null C_FLEX_ITEM_ORD , pol.item_revision Rev , pol.item_description Description , null C_FLEX_ITEM_SUB , rct.po_revision_num Rev1 , rsl.item_description Description1 , round(rct.quantity,:P_qty_precision) Received , rct.unit_of_measure Unit , papf.full_name Receiver , lot.location_code Location , TO_CHAR(rct.transaction_date, 'DD/MON/YYYY HH24:MI:SS') TDate , rsh.receipt_num Receipt_Number , substr(rct.comments,1,240) Comments , plc.displayed_field Displayed_Source_Type , ood.organization_code Org, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_ord_disp', 'INV', 'MSTK', 101, MSI1.ORGANIZATION_ID, MSI1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_ORD_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_sub_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_SUB_DISP FROM mtl_system_items msi , mtl_system_items msi1 , PER_ALL_PEOPLE_F PAPF , PER_ALL_PEOPLE_F PAPF1 , hr_locations_all_tl lot , po_lines_all pol , po_lookup_codes plc , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B , po_system_parameters_all psp , po_releases_all por , po_vendor_sites_all pvs , po_vendors pov , po_headers poh , rcv_shipment_lines rsl , rcv_shipment_headers rsh , rcv_transactions rct , org_organization_definitions ood WHERE poh.org_id = pvs.org_id AND poh.org_id = psp.org_id AND poh.vendor_id = pov.vendor_id AND poh.vendor_site_id = pvs.vendor_site_id (+) AND PAPF1.BUSINESS_GROUP_ID = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID),0) FROM FINANCIALS_SYSTEM_PARAMETERS FSP) AND TRUNC(SYSDATE) BETWEEN PAPF1.EFFECTIVE_START_DATE AND PAPF1.EFFECTIVE_END_DATE AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_PERSON (PAPF1.person_id ,PAPF1.current_applicant_flag ,PAPF1.current_employee_Flag ,PAPF1.current_npw_flag ,PAPF1.employee_number ,PAPF1.applicant_number ,PAPF1.npw_number)) = 'TRUE' AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF1.BUSINESS_GROUP_ID , HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF1.BUSINESS_GROUP_ID AND poh.agent_id = PAPF1.person_id AND rct.po_header_id = poh.po_header_id AND rct.po_line_id = pol.po_line_id AND rct.po_release_id = por.po_release_id (+) AND rct.shipment_line_id = rsl.shipment_line_id AND rct.shipment_header_id = rsh.shipment_header_id AND rct.substitute_unordered_code = 'SUBSTITUTE' AND rct.transaction_type = 'RECEIVE' AND rsl.item_id = msi.inventory_item_id(+) AND pol.item_id = msi1.inventory_item_id(+) AND nvl(msi.organization_id,:c_organization_id) = :c_organization_id AND nvl(msi1.organization_id,:c_organization_id) = :c_organization_id 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 rct.location_id = LOT.location_id(+) AND LOT.LANGUAGE(+) = USERENV('LANG') AND plc.lookup_type = 'SHIPMENT SOURCE TYPE' AND plc.lookup_code = rsh.receipt_source_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 poh.type_lookup_code = B.document_subtype AND B.document_type_code in ('PO', 'PA') 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.organization_id = nvl(:P_org_id,rct.organization_id) AND ood.organization_id = rct.organization_id ORDER BY Document_Number , DISPLAYED_SOURCE_TYPE , BUYER , CREATION_DATE , DOCUMENT_TYPE , SOURCE , DOCUMENT_NUMBERING1 , DOCUMENT_NUMBERING2 , ORG , LINE PO POXRVRSR_XML AR PO تقرير الاستلام البديل (بتنسيق XML) Imported from BI Publisher Description: تقرير الاستلام البديل Application: المشتريات Source: تقرير الاستلام البديل (بتنسيق XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG D PO Wareneingang - Substitute Imported from BI Publisher Description: Wareneingang - Substitute Application: Einkauf Source: Wareneingang - Substitute (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG E PO Informe Recepciones Sustitutas Imported from BI Publisher Description: Informe de recepciones sustitutas Application: Purchasing Source: Informe Recepciones Sustitutas (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG F PO Etat Réceptions d'articles de substitution Imported from BI Publisher Description: Etat Réceptions d'articles de substitution Application: Purchasing Source: Etat Réceptions d'articles de substitution (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG I PO Rapporto Ricezioni articoli sostitutivi Imported from BI Publisher Description: Rapporto Ricevute articoli sostitutivi Application: Purchasing Source: Rapporto Ricezioni articoli sostitutivi (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG JA PO 代替受入レポート Imported from BI Publisher Description: 代替受入レポート Application: Purchasing Source: 代替受入レポート(XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG KO PO 대체 입고 보고서 Imported from BI Publisher Description: 대체 입고 보고서 Application: Purchasing Source: 대체 입고 보고서(XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG PTB PO Relatório de Recebimentos Substitutos Imported from BI Publisher Description: Recebimentos Substitutos Application: Compra Source: Relatório de Recebimentos Substitutos (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG RU PO Отчет о замене поступлений Imported from BI Publisher Description: Отчет о замене поступлений Application: Закупки Source: Отчет о замене поступлений (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG S PO Ersättningsinleveranser - rapport Imported from BI Publisher Description: Ersättningsinleveranser - rapport Application: Purchasing Source: Ersättningsinleveranser - rapport (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG TR PO Eşdeğer Malzeme Teslim Alma Raporu Imported from BI Publisher Description: Eşdeğer Malzeme Teslim Alma Raporu Application: Satın Alma Yönetimi Source: Eşdeğer Malzeme Teslim Alma Raporu (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG US PO Substitute Receipts Imported from BI Publisher Description: Substitute Receipts Report Application: Purchasing Source: Substitute Receipts Report (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG ZHS PO 替代接收报表 Imported from BI Publisher Description: 替代接收报表 Application: 采购管理系统 Source: 替代接收报表 (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG BI Publisher :c_organization_id :format_mask :operating_unit :organization_id :p_conc_request_id :p_flex_item_ord :p_flex_item_sub :p_item_struct_num :p_org_displayed :p_org_id :p_qty_precision :p_struct_num :p_title :p_trans_date_from :p_trans_date_to 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_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 接收日期自 接收日期自 5 30 :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 至 收款日期至 6 40 :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 组织名 组织名 7 50 :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 动态精确度选项 数量精确度