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）限制的操作单元。 C6E085D471D251A9E05362FB09050512Y SELECT decode (rct.source_document_code, 'RMA', oec.name, pov.vendor_name) Vendor , null C_FLEX_ITEM , decode(rct.source_document_code, 'RMA', rsl.customer_item_num, rsl.vendor_item_num) Vendor_Product_Number , rsl.item_description Description , papf.full_name Receiver , rsh.receipt_num Receipt_Number , TO_CHAR(rct.transaction_date, 'DD/MON/YYYY HH24:MI:SS') Receipt_Date , rct.unit_of_measure Unit , round(rsl.quantity_received,:P_qty_precision) Quantity_Amount_Received , substr(rct.comments,1,240) Comments , ood.organization_code org_code, 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 rcv_shipment_lines rsl , rcv_transactions rct , rcv_shipment_headers rsh , per_all_people_f papf , po_vendors pov , mtl_system_items msi , org_organization_definitions ood , financials_system_parameters fsp , oe_sold_to_orgs_v oec , po_lookup_codes plc WHERE rct.shipment_line_id = rsl.shipment_line_id AND rsl.shipment_header_id = rsh.shipment_header_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.employee_id = papf.person_id (+) AND rct.vendor_id = pov.vendor_id(+) AND rct.customer_id = oec.customer_id(+) AND rsl.item_id = msi.inventory_item_id(+) AND nvl(msi.organization_id,:c_organization_id) = :c_organization_id 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.substitute_unordered_code = 'UNORDERED' AND rct.transaction_type = 'UNORDERED' AND rct.organization_id = nvl(:P_org_id,rct.organization_id) AND rct.organization_id = ood.organization_id AND rsl.quantity_received > 0 AND rct.source_document_code = nvl(:P_RECEIPT_SOURCE, rct.source_document_code) AND rsh.receipt_source_code = plc.lookup_code AND plc.lookup_type = 'SHIPMENT SOURCE TYPE' AND plc.displayed_field = :P_RECEIPT_SOURCE_CODE AND NOT EXISTS (SELECT NULL FROM rcv_transactions rct1 WHERE rct1.transaction_type = 'MATCH' AND rct1.parent_transaction_id = rct.transaction_id) ORDER BY pov.vendor_name, oec.name PO POXRVRUR_XML AR PO تقرير الاستلام غير المطلوب (بتنسيق XML) Imported from BI Publisher Description: تقرير الاستلام غير المطلوب Application: المشتريات Source: تقرير الاستلام غير المطلوب (بتنسيق XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG D PO Wareneingang - nicht bestellt Imported from BI Publisher Description: Wareneingang - nicht bestellt Application: Einkauf Source: Wareneingang - nicht bestellt (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG E PO Informe Recepciones sin Pedido Imported from BI Publisher Description: Informe de recepciones sin pedido Application: Purchasing Source: Informe Recepciones sin Pedido (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG F PO Etat Réceptions d'articles non commandés Imported from BI Publisher Description: Etat Réceptions d'articles non commandés Application: Purchasing Source: Etat Réceptions d'articles non commandés (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG I PO Rapporto Ricezioni articoli non ordinati Imported from BI Publisher Description: Rapporto Ricevute articoli non ordinati Application: Purchasing Source: Rapporto Ricezioni articoli non ordinati (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG JA PO 未発注受入レポート Imported from BI Publisher Description: 未発注受入レポート Application: Purchasing Source: 未発注受入レポート(XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG KO PO 미주문 입고 보고서 Imported from BI Publisher Description: 미주문 입고 보고서 Application: Purchasing Source: 미주문 입고 보고서(XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG PTB PO Relatório de Recebimentos Não Solicitados Imported from BI Publisher Description: Relatório de Recebimentos Não Solicitados Application: Compra Source: Relatório de Recebimentos Não Solicitados (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG RU PO Отчет о незаказанных поступлениях Imported from BI Publisher Description: Отчет о незаказанных поступлениях Application: Закупки Source: Отчет о незаказанных поступлениях (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG S PO Inleveranser utan order - rapport Imported from BI Publisher Description: Inleveranser utan order - rapport Application: Purchasing Source: Inleveranser utan order - rapport (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG TR PO Sipariş Edilmemiş Teslimatlar Raporu Imported from BI Publisher Description: Siparişsiz Malzeme Kabulleri Raporu Application: Satın Alma Yönetimi Source: Sipariş Edilmemiş Teslimatlar Raporu (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG US PO Unordered Receipts Imported from BI Publisher Description: Unordered Receipts Report Application: Purchasing Source: Unordered Receipts Report (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG ZHS PO 未订购接收报表 Imported from BI Publisher Description: 未订购接收报表 Application: 采购管理系统 Source: 未订购接收报表 (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG BI Publisher :c_organization_id :format_mask :operating_unit :organization_id :p_conc_request_id :p_flex_item :p_item_struct_num :p_org_displayed :p_org_id :p_qty_precision :p_receipt_source :p_receipt_source_code :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 Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción De Fecha de Transacción F Dates de mouvement - Du Dates de mouvement - Du I Date transazione - Da Date transazione - Da JA 取引日:自 取引日:自 KO 트랜잭션 일자: 부터 트랜잭션 일자: 부터 PTB Datas Transação - De Datas Transação - De RU Даты транзакций с Даты транзакций с S Från transaktionsdatum Från transaktionsdatum TR İşlem Tarihleri: İlk İşlem Tarihleri: İlk US Transaction Dates From Transaction Dates From ZHS 事务处理起始日期 事务处理起始日期 5 30 :p_trans_date_to DateTime AR إلى تواريخ الحركات إلى D Bis Bis Transaktionsdatum E A A Fecha de Transacción F Au Dates de mouvement - Au I A Date transazione - A JA 至 取引期日 KO 까지 트랜잭션 일자: 까지 PTB Até Datas de Transação - Até RU По Даты транзакций по S Till Till transaktionsdatum TR Son İşlem Tarihleri: Son US To Transaction Dates 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 动态精确度选项 数量精确度 8 60 :p_receipt_source_code LOV Oracle PO_SRS_SOURCE Y select displayed_field id, displayed_field value, null description from po_lookup_codes where lookup_type='SHIPMENT SOURCE TYPE' and lookup_code in ('CUSTOMER','VENDOR') order by value,description Y AR نوع مصدر الاستلام نوع مصدر الاستلام D Herkunftsart Wareneingang Herkunftsart Wareneingang E Tipo de Origen de Recepción Tipo de Origen de Recepción F Type d'origine de réception Type d'origine de réception I Tipo origine incasso Tipo origine incasso JA 受入ソース・タイプ 受入ソース・タイプ KO 입고 출처 유형 입고 출처 유형 PTB Tipo de Origem do Recebimento Tipo de Origem do Recebimento RU Тип источника поступления Тип источника поступления S Betalningskälltyp Betalningskälltyp TR Teslim Alma Kaynak Tipi Teslim Alma Kaynak Tipi US Receipt Source Type Receipt Source Type ZHS 收款来源类型 收款来源类型