ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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) ) 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 AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 8E2FF36EDEC079D2E0530100007F1FF2 INV Planner Code Y 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 US Planner codes restricted to the currently selected inv organization 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, mfd.rate_end_date end_date, mfd.current_forecast_quantity current_quantity, mfd.original_forecast_quantity original_quantity, 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, ( 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 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 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. ZHS MRP Item Forecast 项目计划预测的详细报告，包括预测说明、计划员、项目、斗型、预测起止日期、当前数量、原始数量、项目相关数据、置信度预测。 Enginatics 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 Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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) ) 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 Y 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 Y Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 Y 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 mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) 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 :$flex$.organization_code Organization Code Forecast :$flex$.organization_code Organization Code Forecast Set :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Project