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）限制的操作单元。 C6E085D471CD51A9E05362FB09050512Y SELECT nvl(pll.promised_date,pll.need_by_date) P_Date, hre.full_name Buyer, poh.segment1 PO_Number, pol.line_num Line, null C_FLEX_CAT, msib.Segment1 C_FLEX_ITEM_DISP, pol.item_description Item_Description, round(pll.quantity_received,:P_qty_precision) Received, plc.displayed_field Authorization_Status, pol.unit_meas_lookup_code Unit, loc.location_code Location, round(nvl(pll.quantity,0)-nvl(pll.quantity_received,0)-nvl(pll.quantity_cancelled,0),:P_qty_precision) Due, pol.item_revision Rev, pol.vendor_product_num Product_Number, poh.currency_code Currency, ROUND(decode(nvl(pll.quantity,0)-nvl(pll.quantity_received,0)-nvl(pll.quantity_cancelled,0),0,0,decode(nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0),0,0,(nvl(pll.quantity,0)-nvl(pll.quantity_received,0)-nvl(pll.quantity_cancelled,0))/(nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0))*100)), :P_qty_precision) P_due, poh.po_header_id, poh.vendor_id, decode(psp.manual_po_num_type,'NUMERIC',null,poh.segment1) Document_Numbering1, decode(psp.manual_po_num_type,'NUMERIC',poh.segment1,null) Document_Numbering2, mp.organization_code Org, poh.vendor_site_id child_vendor_site_id, nvl(poh.vendor_contact_id, -100) child_vendor_contact_id, pol.item_id item_id, --PO_POXRVODS_XMLP_PKG.c_item_flexformula(pol.item_id, :C_ORGANIZATION_ID) C_FLEX_ITEM, --&C_FLEX_ITEM_DISP C_FLEX_ITEM_DISP, 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 FROM hr_locations_all loc, mtl_parameters mp, po_lookup_codes plc, po_system_parameters psp, mtl_categories mca, po_headers poh, po_lines pol, po_line_locations pll, po_line_types plt, per_all_people_f hre, MTL_SYSTEM_ITEMS_B msib WHERE pol.po_header_id = poh.po_header_id AND pll.po_line_id = pol.po_line_id AND plt.line_type_id = pol.line_type_id AND plt.matching_basis <> 'AMOUNT' AND poh.type_lookup_code = 'STANDARD' AND pll.shipment_type = 'STANDARD' AND plc.lookup_type = 'AUTHORIZATION STATUS' AND plc.lookup_code = nvl(poh.authorization_status,'INCOMPLETE') AND nvl(loc.business_group_id, nvl(hr_general.get_business_group_id, -99) ) = nvl(hr_general.get_business_group_id, -99) AND loc.location_id(+) = pll.ship_to_location_id AND hre.person_id = poh.agent_id AND pol.category_id = mca.category_id AND nvl(pll.closed_code,'OPEN') in ('OPEN','CLOSED FOR INVOICE') AND nvl(pll.cancel_flag,'N') = 'N' AND nvl(pll.quantity_received,0) - nvl(pll.quantity_cancelled,0) < nvl(pll.quantity,0) AND (nvl(pll.promised_date,need_by_date) <= decode(:P_OVERDUE_DATE,'', trunc(sysdate), trunc(to_date(to_char(:P_OVERDUE_DATE,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS') ) ) OR (nvl(pll.promised_date,pll.need_by_date) IS NULL AND TRUNC(SYSDATE) <= DECODE(:P_OVERDUE_DATE, '',trunc(SYSDATE), trunc(to_date(to_char(:P_OVERDUE_DATE,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS'))))) AND nvl(loc.location_code,1) = nvl(:P_ship_to, nvl(loc.location_code,1)) AND pll.ship_to_organization_id = nvl(:P_org_id, pll.ship_to_organization_id) AND &P_WHERE_CAT AND &P_WHERE_BUYER AND poh.vendor_site_id= :parent_vendor_site_id AND mp.organization_id = pll.ship_to_organization_id AND ((HRE.BUSINESS_GROUP_ID +0 = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID),0) FROM FINANCIALS_SYSTEM_PARAMETERS FSP) AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE AND HRE.EFFECTIVE_END_DATE AND HRE.EMPLOYEE_NUMBER IS NOT NULL) OR (HRE.PERSON_ID IS NULL)) and msib.INVENTORY_ITEM_ID = pol.item_id and mp.organization_id = msib.organization_id UNION ALL SELECT nvl(pll.promised_date,pll.need_by_date) P_Date, hre.full_name Buyer, poh.segment1||'-'||por.release_num PO_Number, pol.line_num Line, null C_FLEX_CAT, msib.Segment1 C_FLEX_ITEM_DISP, pol.item_description Item_Description, round(pll.quantity_received,:P_qty_precision) Received, plc.displayed_field Authorization_Status, pol.unit_meas_lookup_code Unit, loc.location_code Location, round(nvl(pll.quantity,0)-nvl(pll.quantity_received,0)-nvl(pll.quantity_cancelled,0),:P_qty_precision) Due, pol.item_revision Rev, pol.vendor_product_num Product_Number, poh.currency_code Currency, ROUND(decode(nvl(pll.quantity,0)-nvl(pll.quantity_received,0)-nvl(pll.quantity_cancelled,0),0,0,decode(nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0),0,0,(nvl(pll.quantity,0)-nvl(pll.quantity_received,0)-nvl(pll.quantity_cancelled,0))/(nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0))*100)), :P_qty_precision) P_due, poh.po_header_id, poh.vendor_id, decode(psp.manual_po_num_type,'NUMERIC',null,poh.segment1||'-'||por.release_num) Document_Numbering1, decode(psp.manual_po_num_type,'NUMERIC',poh.segment1||'-'||por.release_num,null) Document_Numbering2, mp.organization_code Org, poh.vendor_site_id child_vendor_site_id, nvl(poh.vendor_contact_id, -100) child_vendor_contact_id, pol.item_id item_id, --PO_POXRVODS_XMLP_PKG.c_item_flexformula(pol.item_id, :C_FLEX_ITEM, :C_ORGANIZATION_ID) C_FLEX_ITEM, --&C_FLEX_ITEM_DISP C_FLEX_ITEM_DISP, 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 FROM hr_locations_all loc, mtl_parameters mp, po_lookup_codes plc, po_system_parameters psp, mtl_categories mca, po_releases por , po_headers poh, po_lines pol, po_line_locations pll, po_line_types plt, per_all_people_f hre, MTL_SYSTEM_ITEMS_B msib WHERE pol.po_header_id = poh.po_header_id AND pll.po_line_id = pol.po_line_id AND plt.line_type_id = pol.line_type_id AND plt.matching_basis <> 'AMOUNT' AND poh.po_header_id = por.po_header_id AND poh.type_lookup_code in ( 'BLANKET', 'PLANNED') AND pll.shipment_type in ('BLANKET', 'SCHEDULED') AND plc.lookup_type = 'AUTHORIZATION STATUS' AND plc.lookup_code = nvl(por.authorization_status,'INCOMPLETE') AND nvl(loc.business_group_id, nvl(hr_general.get_business_group_id, -99) ) = nvl(hr_general.get_business_group_id, -99) AND loc.location_id(+) = pll.ship_to_location_id AND hre.person_id = por.agent_id AND pol.category_id = mca.category_id AND nvl(pll.closed_code,'OPEN') in ('OPEN','CLOSED FOR INVOICE' ) AND nvl(pll.cancel_flag,'N') = 'N' AND nvl(pll.quantity_received,0) - nvl(pll.quantity_cancelled,0) < nvl(pll.quantity,0) AND (nvl(pll.promised_date,need_by_date) <= decode(:P_OVERDUE_DATE,'', trunc(sysdate), trunc(to_date(to_char(:P_OVERDUE_DATE,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')) ) OR (nvl(pll.promised_date,pll.need_by_date) IS NULL AND trunc(SYSDATE) <= DECODE(:P_OVERDUE_DATE, '',trunc(SYSDATE), trunc(to_date(to_char(:P_OVERDUE_DATE,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS'))))) AND nvl(loc.location_code,1) = nvl(:P_ship_to, nvl(loc.location_code,1)) AND pll.ship_to_organization_id = nvl(:P_org_id, pll.ship_to_organization_id) AND &P_WHERE_CAT AND &P_WHERE_BUYER AND poh.vendor_site_id= :parent_vendor_site_id AND mp.organization_id = pll.ship_to_organization_id and pll.po_release_id = por.po_release_id AND ((HRE.BUSINESS_GROUP_ID +0 = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID),0) FROM FINANCIALS_SYSTEM_PARAMETERS FSP) AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE AND HRE.EFFECTIVE_END_DATE AND HRE.EMPLOYEE_NUMBER IS NOT NULL) OR (HRE.PERSON_ID IS NULL)) and poh.vendor_site_id=:parent_vendor_site_id and nvl ( poh.vendor_contact_id , - 100 )=:parent_vendor_contact_id and poh.vendor_id=:parent_vendor_id and msib.INVENTORY_ITEM_ID = pol.item_id and mp.organization_id = msib.organization_id -- 1,2,19,20,4,11 ORDER BY 1,2,3,4,15,10,11,8,12,13,7,14,17,18,16,25,20,21 PO POXRVODS_XML AR PO تقرير شحنات المورد متجاوزة الاستحقاق (بتنسيق XML) Imported from BI Publisher Description: تقرير شحنات المورد متجاوزة الاستحقاق Application: المشتريات Source: تقرير شحنات المورد متجاوزة الاستحقاق (بتنسيق XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG D PO Lieferanten - überfällige Lieferungen Imported from BI Publisher Description: Lieferanten - überfällige Lieferungen Application: Einkauf Source: Lieferanten - überfällige Lieferungen (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG E PO Informe Envíos Vencidos del Proveedor Imported from BI Publisher Description: Informe de envíos vencidos del proveedor Application: Purchasing Source: Informe Envíos Vencidos del Proveedor (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG F PO Etat des livraisons en retard Imported from BI Publisher Description: Etat des livraisons en retard Application: Purchasing Source: Etat des livraisons en retard (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG I PO Rapporto Spedizioni fornitore in ritardo Imported from BI Publisher Description: Rapporto Spedizioni fornitore in ritardo Application: Purchasing Source: Rapporto Spedizioni fornitore in ritardo (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG JA PO 仕入先別期限超過納入レポート Imported from BI Publisher Description: 仕入先別期限超過納入レポート Application: Purchasing Source: 仕入先別期限超過納入レポート(XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG KO PO 납기경과 공급자 선적 보고서 Imported from BI Publisher Description: 납기경과 공급자 납품 보고서 Application: Purchasing Source: 납기경과 공급자 선적 보고서(XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG PTB PO Relatório de Entregas Vencidas do Fornecedor Imported from BI Publisher Description: Relat. Entregas Forn. Vencidas Application: Compra Source: Relatório de Entregas Vencidas do Fornecedor (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG RU PO Отчет о просроченных поставках поставщика Imported from BI Publisher Description: Отчет о просроченных поставках поставщика Application: Закупки Source: Отчет о просроченных поставках поставщика (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG S PO Försenade leveranser för leverantörer - rapport Imported from BI Publisher Description: Försenade leveranser för leverantörer - rapport Application: Purchasing Source: Försenade leveranser för leverantörer - rapport (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG TR PO Vadesi Geçmiş Tedarikçi Sevkiyatları Raporu Imported from BI Publisher Description: Vadesi Geçmiş Tedarikçi Sevkiyatları Raporu Application: Satın Alma Yönetimi Source: Vadesi Geçmiş Tedarikçi Sevkiyatları Raporu (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG US PO Overdue Vendor Shipments Imported from BI Publisher Description: Overdue Vendor Shipments Report Application: Purchasing Source: Overdue Vendor Shipments Report (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG ZHS PO 供应商过期发运报表 Imported from BI Publisher Description: 供应商过期发货报表 Application: 采购管理系统 Source: 供应商过期发运报表 (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG BI Publisher &c_flex_item_disp &p_where_buyer &p_where_cat :format_mask :operating_unit :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_flex_cat :p_flex_item :p_item_struct_num :p_org_displayed :p_org_id :p_overdue_date :p_overdue_date_param :p_qty_precision :p_ship_to :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_buyer :p_where_cat :p_where_vendor_from :p_where_vendor_to :parent_vendor :parent_vendor_contact_id :parent_vendor_id :parent_vendor_site_id 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_overdue_date Date AR متجاوز الاستحقاق اعتباراً من متجاوز الاستحقاق اعتباراً من D Überfällig seit Überfällig seit E Vencido a la Fecha Vencido a la Fecha F Retards depuis Retards depuis I Scaduto in data Scaduto in data JA 期限超過 期限超過 KO 다음일자 기준 납기 경과 다음일자 기준 납기 경과 PTB Vencido a partir de Vencido a partir de RU Просрочено на Просрочено на S Försenad per den Försenad per den TR Gecikme Başlangıcı Gecikme Başlangıcı US Overdue as of Overdue as of ZHS 到逾期 到逾期 5 30 :p_buyer LOV Oracle PO_SRS_BUYER_NAME Y select hre.full_name id, hre.full_name value, null description from po_agents poa,hr_employees hre where poa.agent_id=hre.employee_id order by full_name AR اسم المشتري اسم المشتري D Einkäufername Einkäufername E Nombre de Comprador Nombre de Comprador F Nom de l'acheteur Nom de l'acheteur I Nome buyer Nome buyer JA 購買担当名 購買担当名 KO 구매자명 구매자명 PTB Nome do Comprador Nome do Comprador RU Имя покупателя Имя покупателя S Köpare Köpare TR Satın Alan Adı Satın Alan Adı US Buyer Name Buyer Name ZHS 采购员姓名 采购员姓名 6 40 :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 Fournisseurs - De Fournisseurs - De I Fornitori - Da Fornitori - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedores - De Fornecedores - De RU Поставщики с Поставщики с S Från leverantörer Från leverantörer TR Tedarikçiler, İlk Tedarikçiler, İlk US Vendors From Vendors From ZHS 供应商自 供应商自 7 50 :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 إلى إلى D Bis Bis E A A F A A I A A JA 至 至 KO 까지 까지 PTB Até Até RU По По S Till Till TR Son Son US To To ZHS 至 至 8 60 :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 Lieferadresse Lieferadresse E Dirección de Envío Dirección de Envío F Lieu de livraison Lieu de livraison I Ubicazione di spedizione Ubicazione di spedizione JA 納入先事業所 納入先事業所 KO 납품처 위치 납품처 위치 PTB Local para Entrega Local para Entrega RU Расположение грузополучателя Расположение грузополучателя S Lev.adress, plats Lev.adress, plats TR Sevk Varış Yeri Sevk Varış Yeri US Ship-to Location Ship-to Location ZHS 收货地点 收货地点 9 70 :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 类别自 类别自 10 80 :p_category_to Char AR إلى 2 إلى D Bis 2 Bis E A 2 A F A 2 A I A 2 A JA 至 2 至 KO 까지 2 까지 PTB Até 2 Até RU По 2 По S Till 2 Till TR Son 2 Son US To 2 To ZHS 至 2 至 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_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 动态精确度选项 数量精确度