ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 65486EF3B99D39D8E0530100007FF20EY select ood.organization_name organization, ood.organization_code, nvl(mfds0.forecast_designator,mfds.forecast_designator) forecast_set, nvl(mfds0.description,mfds.description) set_description, nvl2(mfds.forecast_set,mfds.forecast_designator,null) forecast, nvl2(mfds.description,mfds.description,null) description, msiv.planner_code planner, mpl.description planner_description, msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, msiv.primary_uom_code uom, mfiv.alternate_bom_designator alternate_bill, xxen_util.meaning(mfiv.bom_item_type,'BOM_ITEM_TYPE',700) bill_type, mfiv.ato_forecast_control_desc forecast_control, mfiv.mrp_planning_code_desc mrp_planning_method, xxen_util.meaning(mfd.origination_type,'MRP_FORECAST_ORIG',700) origination_type, xxen_util.meaning(mfd.bucket_type,'MRP_BUCKET_TYPE',700) bucket_type, mfd.forecast_date, to_char(mfd.forecast_date,'YYYY-MM') forecast_month, mfd.rate_end_date end_date, mfd.current_forecast_quantity&first_consumption current_quantity, mfd.original_forecast_quantity&first_consumption original_quantity, &consumption_columns ppa.project_number project, pt.task_number task, mfd.confidence_percentage, mfiv.alternate_bom_designator, wl.line_code, mfd.comments from org_organization_definitions ood, mrp_forecast_items_v mfiv, mrp_forecast_dates mfd, mrp_forecast_designators mfds, mrp_forecast_designators mfds0, mtl_system_items_vl msiv, &consumption_tables ( select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union select psm.project_id, psm.project_number from pjm_seiban_numbers psm ) ppa, pa_tasks pt, wip_lines wl, mtl_planners mpl where 1=1 and mfiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and ood.organization_id=mfiv.organization_id and mfiv.organization_id=mfd.organization_id and mfiv.forecast_designator=mfd.forecast_designator and mfiv.inventory_item_id=mfd.inventory_item_id and mfiv.organization_id=mfds.organization_id and mfiv.forecast_designator=mfds.forecast_designator and mfds.organization_id=mfds0.organization_id(+) and mfds.forecast_set=mfds0.forecast_designator(+) and mfiv.organization_id=msiv.organization_id and mfiv.inventory_item_id=msiv.inventory_item_id and mfd.project_id=ppa.project_id(+) and mfd.task_id=pt.task_id(+) and mfd.line_id=wl.line_id(+) and &consumption_joins msiv.planner_code=mpl.planner_code(+) and msiv.organization_id=mpl.organization_id(+) order by forecast_set, forecast, msiv.concatenated_segments, mfd.forecast_date desc&consumption_order Organization security from the Blitz Report organization access, which follows profiles Blitz Report Organization Access All Responsibilities, Blitz Report Use Operating Unit Security and Blitz Report Use Ledger Security. AR MRP Item Forecast تقرير تفصيلي لتوقع تخطيط الصنف ، بما في ذلك وصف التنبؤ ، والمخطط ، والعنصر ، ونوع الحاوية ، وتوقع تواريخ البدء والانتهاء ، والكمية الحالية ، والكمية الأصلية ، والبيانات المتعلقة بالمشروع ، وإسقاط الثقة. D MRP Item Forecast Detailbericht für die Artikelplanungsprognose, einschließlich Prognosebeschreibung, Planer, Artikel, Eimertyp, Start- und Enddatum der Prognose, aktuelle Menge, ursprüngliche Menge, projektbezogene Daten und Konfidenzprognose. E MRP Item Forecast Informe detallado de la previsión de la planificación de artículos, incluyendo la descripción de la previsión, el planificador, el artículo, el tipo de cubo, las fechas de inicio y fin de la previsión, la cantidad actual, la cantidad original, los datos relacionados con el proyecto y la proyección de confianza. F MRP Item Forecast Rapport détaillé pour la prévision de planification des articles, comprenant la description de la prévision, le planificateur, l'article, le type de seau, les dates de début et de fin de la prévision, la quantité actuelle, la quantité d'origine, les données relatives au projet et la projection de confiance. I MRP Item Forecast Rapporto dettagliato per la previsione di pianificazione degli articoli, compresa la descrizione della previsione, il pianificatore, l'articolo, il tipo di secchio, le date di inizio e fine della previsione, la quantità corrente, la quantità originale, i dati relativi al progetto e la proiezione di fiducia. JA MRP Item Forecast 予測説明、プランナー、アイテム、バケットタイプ、予測開始日と終了日、現在の数量、元の数量、プロジェクト関連データ、信頼性予測を含むアイテム企画予測の詳細レポートです。 KO MRP Item Forecast 예측 설명, 계획자, 품목, 버켓 유형, 예측 시작 및 종료 날짜, 현재 수량, 원래 수량, 프로젝트 관련 데이터 및 신뢰도 예측을 포함한 품목 계획 예측에 대한 상세 보고서입니다. PTB MRP Item Forecast Relatório detalhado da previsão de planejamento do item, incluindo descrição da previsão, planejador, item, tipo de balde, datas de início e fim da previsão, quantidade atual, quantidade original, dados relacionados ao projeto e projeção de confiança. RU MRP Item Forecast Подробный отчет для прогноза планирования товара, включая описание прогноза, планировщик, товар, тип ковша, даты начала и окончания прогноза, текущее количество, исходные qty, данные, связанные с проектом, и прогноз доверия. S MRP Item Forecast Detaljrapport för artikelplaneringsprognos, inklusive prognosbeskrivning, planerare, artikel, skopa, prognos start- och slutdatum, aktuell kvantitet, originalantal, projektrelaterade data och konfidensprojektion. TR MRP Item Forecast Tahmin açıklaması, planlayıcı, madde, kova türü, tahmin başlangıç ve bitiş tarihleri, geçerli miktar, orijinal miktar, projeyle ilgili veriler ve güven projeksiyonunu içeren öğe planlama tahmini için ayrıntılı rapor. US MRP Item Forecast Detail report for item planning forecast, including forecast description, planner, item, bucket type, forecast start and end dates, current quantity, original qty, project related data, and confidence projection. Show Consumption adds one row per sales order consumption of each forecast entry from the forecast consumption history: sales order, line, customer, ship-to, schedule date, order quantity, consumed quantity and the date the consumption was recorded. A negative consumed quantity reverses an earlier consumption, for example after an order line was cancelled or reduced. With Show Consumption, the current and original forecast quantity are shown on the first row of each forecast entry only, so that they sum correctly. Original minus current quantity equals the consumed quantity of the entry, unless the forecast quantity was changed manually. ZHS MRP Item Forecast 项目计划预测的详细报告，包括预测说明、计划员、项目、斗型、预测起止日期、当前数量、原始数量、项目相关数据、置信度预测。 Enginatics &consumption_columns &consumption_joins &consumption_order &consumption_tables &first_consumption 1=1 1 -10 1=1 (msiv.organization_id,msiv.inventory_item_id) in ( select distinct xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',1) organization_id, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',2) inventory_item_id from xxen_report_run_param_values xrrpv where xrrpv.parameter_id in (select xrpv.parameter_id from xxen_report_parameters_v xrpv where xrpv.parameter_name='organization_id|inventory_item_id') and xrrpv.run_id=:run_id ) Char F organisation_id|inventory_item_id US organization_id|inventory_item_id 2 10 1=1 nvl(mfds0.forecast_designator,mfds.forecast_designator)=:forecast_set LOV custom select distinct nvl(mfds0.forecast_designator,mfds.forecast_designator) value, nvl(mfds0.description,mfds.description) description from mtl_parameters mp, mrp_forecast_designators mfds, mrp_forecast_designators mfds0 where ( :$flex$.organization_code is null and mfds.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and mp.organization_id=mfds.organization_id and mfds.organization_id=mfds0.organization_id(+) and mfds.forecast_set=mfds0.forecast_designator(+) order by value F Ensemble de prévisions US Forecast Set 3 20 1=1 nvl2(mfds.forecast_set,mfds.forecast_designator,null)=:forecast LOV custom select distinct mfds.forecast_designator value, mfds.description from mtl_parameters mp, mrp_forecast_designators mfds where ( :$flex$.organization_code is null and mfds.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and mp.organization_id=mfds.organization_id and mfds.forecast_set is not null order by value F Prévision US Forecast 4 30 1=1 ood.organization_code=:organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or not exists (select null from xxen_report_org_access xroa where xroa.access_type='INV') and ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') F Code de l'organisation US Organization Code 5 40 1=1 msiv.planner_code=:planner_code LOV INV Planner Code 8E2FF36EDEC079D2E0530100007F1FF2 select x.* from ( select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by mp.planner_code ) x union all select '<null>' value, null description from dual F Planificateur US Planner 6 50 1=1 msiv.concatenated_segments like :item LOV custom select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where (msiv.organization_id,msiv.inventory_item_id) in ( select mfi.organization_id, mfi.inventory_item_id from mtl_parameters mp, mrp_forecast_items mfi where ( :$flex$.organization_code is null and mfi.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and mp.organization_id=mfi.organization_id ) order by msiv.concatenated_segments F Article US Item 7 60 1=1 ppa.project_number=:project LOV custom select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date, ppa.project_id from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date, psm.project_id from pjm_seiban_numbers psm ) ppa, org_organization_definitions ood where ppa.org_id=ood.operating_unit and ( :$flex$.organization_code is null and ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') or xxen_util.contains(:$flex$.organization_code,ood.organization_id)='Y' ) and ( :$flex$.organization_code is null or ppa.project_id in ( select mfd.project_id from mrp_forecast_dates mfd where mfd.project_id is not null and xxen_util.contains(mfd.organization_id,:$flex$.organization_code)='Y' ) ) order by ppa.creation_date desc, ppa.project_number desc F Projet US Project 8 70 1=1 mfd.forecast_date>=:forecast_date_from Date F Date prévisionnelle du US Forecast Date From 9 80 1=1 mfd.forecast_date<:forecast_date_to+1 Date F Date prévisionnelle jusqu'au US Forecast Date To 10 90 1=1 mfd.forecast_date<sysdate-:oder_days Number F Prévision datant de plus de x jours US Forecast older than x days 11 100 &consumption_columns mso.segment1 sales_order, mso.segment2 order_type, mfu.line_num order_line, hp.party_name customer, hca.account_number customer_number, hcsua.location ship_to, xxen_util.meaning(mfu.demand_class,'DEMAND_CLASS',3) demand_class, mfu.sales_order_schedule_date schedule_date, mfu.sales_order_quantity order_quantity, mfu.update_quantity consumed_quantity, mfu.creation_date consumption_date, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Consumption Show one row per sales order consumption of each forecast entry. Forecast quantities are shown on the first row of each entry only. 12 &consumption_joins mfd.transaction_id=mfu.transaction_id(+) and mfu.update_sales_order=mso.sales_order_id(+) and mfu.customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and mfu.ship_id=hcsua.site_use_id(+) and US Show Consumption 13 &consumption_order , mfd.transaction_id, mfu.creation_date, mso.segment1, mfu.line_num, mfu.rowid US Show Consumption 14 &consumption_tables mrp_forecast_updates mfu, mtl_sales_orders mso, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, US Show Consumption 15 &first_consumption *decode(row_number() over (partition by mfd.transaction_id order by mfu.creation_date,mso.segment1,mfu.line_num,mfu.rowid),1,1) US Show Consumption 15EB0D78D6C548C8BB469ED1595EB6FA Forecast Consumption Details Sales order lines that consumed each forecast entry, with original and current forecast quantity, sales order, line, customer, ship-to, schedule date, order quantity, consumed quantity and consumption date. SYSADMIN 7 BUCKET_TYPE 20 CONSUMED_QUANTITY 21 CONSUMPTION_DATE 5 10 CURRENT_QUANTITY 14 CUSTOMER 15 CUSTOMER_NUMBER 17 DEMAND_CLASS 3 FORECAST 2 8 FORECAST_DATE 4 2 FORECAST_SET 1 4 ITEM 3 5 ITEM_DESCRIPTION 13 ORDER_LINE 7 19 ORDER_QUANTITY 12 ORDER_TYPE 1 ORGANIZATION_CODE 9 ORIGINAL_QUANTITY 11 SALES_ORDER 6 18 SCHEDULE_DATE 16 SHIP_TO 6 UOM Show Consumption Y S Site 715CD8088124466DA66EBCEECB233C65 Forecast vs Consumed by Month Monthly pivot of forecast against consumed sales order quantity per item: original, current and consumed quantity by forecast month, with the consumption details on the data sheet, for forecast accuracy and consumption review. SYSADMIN 7 BUCKET_TYPE 15 CONSUMED_QUANTITY 16 CONSUMPTION_DATE 5 11 CURRENT_QUANTITY 14 CUSTOMER 3 FORECAST 2 8 FORECAST_DATE 4 9 FORECAST_MONTH 2 FORECAST_SET 1 4 ITEM 3 5 ITEM_DESCRIPTION 13 ORDER_LINE 7 1 ORGANIZATION_CODE 10 ORIGINAL_QUANTITY 12 SALES_ORDER 6 6 UOM CONSUMED_QUANTITY VALUE 3 SUM CURRENT_QUANTITY VALUE 2 SUM FORECAST FILTER 3 FORECAST_MONTH COLUMN 1 FORECAST_SET FILTER 2 ITEM ROW 1 ORGANIZATION_CODE FILTER 1 ORIGINAL_QUANTITY VALUE 1 SUM Show Consumption Y S Site