ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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 msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 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 8E2FF36EDF0F79D2E0530100007F1FF2 MRP Exception Y select x.exception_type_desc value, count(*) description from ( select xxen_util.meaning(med.exception_type,'MRP_EXCEPTION_CODE_TYPE',700) exception_type_desc, med.* from mrp_exception_details med, mtl_parameters mp where med.organization_id=mp.organization_id and xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and med.compile_designator=:$flex$.plan and med.exception_type<>5 and med.exception_type in (1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29) ) x group by x.exception_type_desc order by count(*) desc US B58640C5F231626AE0530100007F518E MRP Plan Y select mpsv.compile_designator value, mp.organization_code||' ('||xxen_util.meaning(nvl(mpsv.curr_plan_type,mpsv.plan_type),'MRP_PLAN_TYPE',700)||')' description from mrp_plans_sc_v mpsv, mtl_parameters mp where mpsv.planned_organization 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 mpsv.planned_organization=mp.organization_id and mpsv.plan_completion_date is not null and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and nvl(mpsv.disable_date,sysdate)>=sysdate order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2), nvl(mpsv.curr_plan_type,mpsv.plan_type), mpsv.compile_designator US 8E2FF36EDF2F79D2E0530100007F1FF2 PO Buyer Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name Corrected restriction to show buyers of the inventory orgs business group US 547F865D20E03424E0530100007FCDE8 select medv.organization_code, medv.compile_designator plan, medv.item_segments item, msiv.description item_description, xxen_util.meaning(msiv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_or_buy, ppx.full_name buyer, msiv.planner_code planner, mpl.description planner_description, medv.exception_type_text exception_message, medv.project_number, medv.task_number, medv.to_project_number, medv.to_task_number, medv.due_date, medv.from_date, medv.to_date, medv.days_compressed, medv.quantity, medv.lot_number, medv.order_number, medv.supply_type, medv.end_item_segments end_item, medv.end_order_number, medv.planning_group, medv.department_line_code, medv.resource_code, medv.utilization_rate, medv.exception_type from mrp_exception_details_v medv, mtl_system_items_vl msiv, per_people_x ppx, mtl_planners mpl where 1=1 and ( medv.exception_type<>19 or not exists ( select null from mrp_exception_details_v medv2 where medv.exception_type=medv2.exception_type and medv.compile_designator=medv2.compile_designator and medv.organization_id=medv2.organization_id and medv.inventory_item_id=medv2.inventory_item_id and medv.to_project_number=medv2.project_number and medv.to_task_number=medv2.task_number ) ) and medv.exception_type<>5 and medv.exception_type in (1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29) and medv.organization_id=msiv.organization_id(+) and medv.inventory_item_id=msiv.inventory_item_id(+) and msiv.buyer_id=ppx.person_id(+) and msiv.planner_code=mpl.planner_code(+) and msiv.organization_id=mpl.organization_id(+) Y AR MRP Exceptions تقرير تفصيلي لرسائل استثناء MRP ، بما في ذلك العنصر أو الصنع أو الشراء والمشتري الافتراضي والمخطط ورسالة الاستثناء المراد استخدامها. D MRP Exceptions Detailbericht für MRP-Ausnahmemeldungen, einschließlich Artikel, Fabrikat oder Kauf, Standardkäufer, Planer und zu verwendende Ausnahmemeldung. E MRP Exceptions Informe detallado de los mensajes de excepción de MRP, incluyendo el artículo, la marca o la compra, el comprador por defecto, el planificador y el mensaje de excepción a utilizar. F MRP Exceptions Rapport détaillé pour les messages d'exception MRP, y compris l'article, la fabrication ou l'achat, l'acheteur par défaut, le planificateur et le message d'exception à utiliser. I MRP Exceptions Rapporto dettagliato per i messaggi di eccezione MRP, inclusi articolo, marca o acquisto, acquirente predefinito, pianificatore e messaggio di eccezione da utilizzare. JA MRP Exceptions MRPの例外メッセージの詳細レポートで、品目、製造または購入、デフォルトバイヤー、プランナー、使用する例外メッセージを含む。 KO MRP Exceptions 품목, 제조 또는 구매, 기본 구매자, 계획자 및 사용할 예외 메시지를 포함한 MRP 예외 메시지에 대한 상세 보고서입니다. PTB MRP Exceptions Relatório detalhado das mensagens de exceção do MRP, incluindo item, marca ou compra, comprador padrão, planejador e mensagem de exceção a ser usada. RU MRP Exceptions Подробный отчет для сообщений MRP Исключения, включая пункт, сделать или купить, покупатель по умолчанию, планировщик и сообщение об исключении для использования. S MRP Exceptions Detaljrapport för MRP-undantagsmeddelanden, inklusive artikel, märke eller köp, standardköpare, planerare och undantagsmeddelande att använda. TR MRP Exceptions Ürün, marka veya satın alma, varsayılan alıcı, planlayıcı ve kullanılacak istisna mesajı dahil olmak üzere MİP İstisna mesajları için detay raporu. US MRP Exceptions Detail report for MRP Exception messages, including item, make or buy, default buyer, planner and exception message to use. ZHS MRP Exceptions MRP异常信息的详细报告，包括项目、制作或购买、默认买家、计划员和要使用的异常信息。 Enginatics 1=1 1 -10 1=1 (medv.compile_designator,medv.organization_id,medv.inventory_item_id) in ( select distinct xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',1) compile_designator, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',2) organization_id, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',3) 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='compile_designator|organization_id|inventory_item_id') and xrrpv.run_id=:run_id ) Char F compiler_designator|organization_id|inventory_item_id US compile_designator|organization_id|inventory_item_id 2 10 1=1 medv.organization_id in (select mp.organization_id from mtl_parameters mp where mp.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 coalesce( (select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')), (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id not in (select mp.master_organization_id from mtl_parameters mp) and rownum=1) ) Y F Code de l'organisation US Organization Code 3 20 1=1 medv.compile_designator=:plan LOV MRP Plan B58640C5F231626AE0530100007F518E Y select mpsv.compile_designator value, mp.organization_code||' ('||xxen_util.meaning(nvl(mpsv.curr_plan_type,mpsv.plan_type),'MRP_PLAN_TYPE',700)||')' description from mrp_plans_sc_v mpsv, mtl_parameters mp where mpsv.planned_organization 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 mpsv.planned_organization=mp.organization_id and mpsv.plan_completion_date is not null and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and nvl(mpsv.disable_date,sysdate)>=sysdate order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2), nvl(mpsv.curr_plan_type,mpsv.plan_type), mpsv.compile_designator select distinct min(mpsv.compile_designator) keep (dense_rank first order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2)) over (partition by mpsv.planned_organization) compile_designator from mrp_plans_sc_v mpsv, mtl_parameters mp where mpsv.data_completion_date is not null and mpsv.planned_organization=mp.organization_id and xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and nvl(mpsv.plan_type,mpsv.curr_plan_type)=1 and nvl(mpsv.disable_date,sysdate)>=sysdate Y US Plan 4 30 1=1 medv.exception_type_text=:exception LOV MRP Exception 8E2FF36EDF0F79D2E0530100007F1FF2 Y select x.exception_type_desc value, count(*) description from ( select xxen_util.meaning(med.exception_type,'MRP_EXCEPTION_CODE_TYPE',700) exception_type_desc, med.* from mrp_exception_details med, mtl_parameters mp where med.organization_id=mp.organization_id and xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and med.compile_designator=:$flex$.plan and med.exception_type<>5 and med.exception_type in (1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29) ) x group by x.exception_type_desc order by count(*) desc US Exception 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 Code du planificateur US Planner Code 6 50 1=1 ppx.full_name=:buyer LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name F Acheteur US Buyer 7 60 1=1 msiv.concatenated_segments=:item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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 msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article US Item :$flex$.organization_code Organization Code Buyer :$flex$.organization_code Organization Code Exception :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Plan :$flex$.plan Plan Exception