ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 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 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 B0B5FC7B97ED64BCE0530100007F8BA8 MFG Make or Buy Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_PLANNING_MAKE_BUY' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 7FD9FC4D26BA1737E0530100007F1CEA select xxen_util.meaning( case when mfp0.demand_id<0 then mfp0.demand_id else mgr.origination_type end, case when mfp0.demand_id<0 then 'MRP_FLP_SUPPLY_DEMAND_TYPE' else 'MRP_DEMAND_ORIGINATION' end,700)|| nvl2(flv.meaning,'/'||flv.meaning,null) origination_type, coalesce(we0.wip_entity_name,mipo0.po_number,to_char(ooha.order_number)) demand_number, rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') order_line, (select os.set_name from oe_sets os where oola.ship_set_id=os.set_id) ship_set, xxen_util.meaning(oola.flow_status_code,'LINE_FLOW_STATUS',660) line_status, nvl(ottt.name,msiv0.concatenated_segments||' '||msiv0.description) demand_description, xxen_util.user_name(nvl(we0.created_by,ooha.created_by)) created_by, case when mfp0.demand_id in (-1,-3) then mrp_get_project.project(mfp0.project_id) else mrp_get_project.project(mgr.project_id) end project, case when mfp0.demand_id in (-1,-3) then mrp_get_project.task(mfp0.task_id) else mrp_get_project.task(mgr.task_id) end task, msiv0.concatenated_segments end_asembly, msiv0.description end_asembly_description, msiv1.concatenated_segments component, msiv1.description component_description, xxen_util.meaning(msiv1.item_type,'ITEM_TYPE',3) item_type, xxen_util.meaning(msiv1.end_assembly_pegging_flag,'ASSEMBLY_PEGGING_CODE',0) pegging, msiv1.planner_code, mpl.description planner, ppx.full_name buyer, round(nvl(mfp1.allocated_quantity/xxen_util.zero_to_null(mfp1.end_item_usage),0),4) end_demand_pegged_qty, round(mfp1.demand_quantity,4) demand_quantity, round(mfp1.allocated_quantity,4) pegged_quantity, muot.unit_of_measure_tl uom, mfp1.demand_date plan_demand_date, mr.new_wip_start_date plan_start_date, mfp1.supply_date plan_supply_date, mfp1.demand_date-mfp1.supply_date plan_delay, xxen_util.meaning(msiv1.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_or_buy, round(mfp1.supply_quantity,4) supply_quantity, xxen_util.meaning(mfp1.supply_type,'MRP_ORDER_TYPE',700) supply_type, nvl(we.wip_entity_name,mipo.po_number) supply_number, wdj0.scheduled_start_date demand_date, wdj.scheduled_completion_date from mtl_parameters mp, mrp_full_pegging mfp0, mrp_full_pegging mfp1, mtl_system_items_vl msiv0, mtl_system_items_vl msiv1, mtl_units_of_measure_tl muot, per_people_x ppx, mtl_planners mpl, fnd_lookup_values flv, mrp_recommendations mr, mrp_item_purchase_orders mipo, wip_entities we, wip_discrete_jobs wdj, mrp_gross_requirements mgr, oe_order_lines_all oola, oe_order_headers_all ooha, oe_transaction_types_tl ottt, wip_entities we0, wip_discrete_jobs wdj0, mrp_item_purchase_orders mipo0 where 1=1 and mp.organization_code=:organization_code and mfp0.compile_designator=:compile_designator and mp.organization_id=mfp0.organization_id and mfp0.pegging_id=mfp1.end_pegging_id and ( :p_assbly_pegging_only is null or (:p_assbly_pegging_only is not null and exists (select null from mrp_full_pegging mfp where mfp.prev_pegging_id = mfp0.pegging_id ) ) ) and mfp0.inventory_item_id=msiv0.inventory_item_id and mfp1.inventory_item_id=msiv1.inventory_item_id and mfp0.organization_id=msiv0.organization_id and mfp1.organization_id=msiv1.organization_id and msiv1.primary_uom_code=muot.uom_code(+) and muot.language(+)=userenv('lang') and msiv1.buyer_id=ppx.person_id(+) and msiv1.planner_code=mpl.planner_code(+) and msiv1.organization_id=mpl.organization_id(+) and case when mfp0.demand_id=-1 and mfp0.prev_pegging_id is null then to_char(case when mfp0.supply_type in (10,13) then 5 else mfp0.supply_type end) end=flv.lookup_code(+) and flv.lookup_type(+) in ('MRP_FLP_SUPPLY_DEMAND_TYPE','MRP_ORDER_TYPE') and flv.language(+)=userenv('lang') and flv.view_application_id(+)=700 and flv.security_group_id(+)=0 and not (flv.lookup_code(+)='18' and flv.lookup_type(+)='MRP_FLP_SUPPLY_DEMAND_TYPE') and mfp1.transaction_id=mr.transaction_id(+) and case when mr.order_type in (1,2,8,11,12) then mr.disposition_id end=mipo.transaction_id(+) and case when mr.order_type in (3,7,14,15,27,28) then mr.disposition_id end=we.wip_entity_id(+) and we.wip_entity_id=wdj.wip_entity_id(+) and we.organization_id=wdj.organization_id(+) and mfp0.demand_id=mgr.demand_id(+) and decode(mgr.origination_type,6,mgr.reservation_id)=oola.line_id(+) and oola.header_id=ooha.header_id(+) and ooha.order_type_id=ottt.transaction_type_id(+) and ottt.language(+)=userenv('lang') and case when mgr.origination_type in (2,3,17,25,26) then mgr.disposition_id end=we0.wip_entity_id(+) and we0.wip_entity_id=wdj0.wip_entity_id(+) and we0.organization_id=wdj0.organization_id(+) and case when mgr.origination_type in (18,19,20,23,24) then mgr.disposition_id end=mipo0.transaction_id(+) Y AR MRP End Assembly Pegging تقرير تفصيلي لربط MRP من التجميع النهائي لكل مكون ، بما في ذلك: المخطط ، والكمية المرتبطة بطلب نهاية الطلب ، وتواريخ الطلب والخطة ، وكمية العرض ، وتاريخ العرض. D MRP End Assembly Pegging Detailbericht für die Dispositionsverriegelung von der Endmontage zu jeder Komponente, einschließlich: Planer, verriegelte Menge des Endbedarfs, Bedarfs- und Plandaten, Liefermenge und Lieferdatum. E MRP End Assembly Pegging Informe detallado de la planificación de necesidades desde el ensamblaje final hasta cada componente, incluyendo: planificador, cantidad vinculada a la demanda final, fechas de la demanda y del plan, cantidad de suministro y fecha de suministro. F MRP End Assembly Pegging Rapport détaillé pour le rattachement du MRP depuis l'assemblage final jusqu'à chaque composant, comprenant : le planificateur, la demande finale rattachée à la quantité, la demande et les dates de planification, la quantité et la date d'approvisionnement. I MRP End Assembly Pegging Rapporto dettagliato per il pegging MRP dall'assemblaggio finale ad ogni componente, incluso: pianificatore, qtà pegata della domanda finale, data della domanda e del piano, quantità di fornitura e data di fornitura. JA MRP End Assembly Pegging 最終組立から各部品までのMRPペギングの詳細レポートで、プランナ、最終需要ペギング数量、需要・計画日、供給数量、供給日を含む。 KO MRP End Assembly Pegging 계획자, 최종 수요 페깅 수량, 수요 및 계획 일자, 공급 수량 및 공급 일자를 포함하여 최종 조립품에서 각 구성품으로의 MRP 페깅에 대한 상세 보고서. PTB MRP End Assembly Pegging Relatório detalhado para a fixação do MRP desde a montagem final até cada componente, incluindo: planejador, qtd. de fixação da demanda final, datas de demanda e planejamento, quantidade de fornecimento e data de fornecimento. RU MRP End Assembly Pegging Подробный отчет по привязке MRP от конечной сборки к каждому компоненту, включая: планировщик, привязка к конечному спросу qty, спрос и даты плана, количество и дату поставки. S MRP End Assembly Pegging Detaljrapport för MRP-koppling från slutmontering till varje komponent, inklusive: planerare, slutlig efterfrågan kopplad antal, efterfrågan och plandatum, leveransmängd och leveransdatum TR MRP End Assembly Pegging Planlayıcı, son talebe göre belirlenen miktar, talep ve plan tarihleri, tedarik miktarı ve tedarik tarihi dahil olmak üzere son montajdan her bileşene ilişkilendirme MRP için ayrıntılı rapor. US MRP End Assembly Pegging Detail report for MRP pegging from final assembly to each component, including: planner, end demand pegged qty, demand and plan dates, supply quantity, and supply date. ZHS MRP End Assembly Pegging 从总装到各部件的MRP挂钩的详细报告，包括：计划员、最终需求挂钩数量、需求和计划日期、供应数量、供应日期。 Enginatics 1=1 :compile_designator :organization_code :p_assbly_pegging_only 1 10 :organization_code LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where 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) 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 order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y F Code de l'organisation US Organization Code 2 20 :compile_designator 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),mpsv.plan_completion_date desc) compile_designator from mrp_plans_sc_v mpsv, mtl_parameters mp where mpsv.plan_completion_date is not null and mpsv.planned_organization=mp.organization_id and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and nvl(mpsv.disable_date,sysdate)>=sysdate Y US Plan 3 30 1=1 msiv0.concatenated_segments=:assembly 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 Assemblage d'extrémité US End Assembly 4 40 1=1 msiv1.concatenated_segments=:component 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 Composant US Component 5 50 1=1 mipo.transaction_id=mr.disposition_id and mr.order_type in (1,2,8,11,12) and mipo.vendor_id in ( select aps.vendor_id from ap_suppliers aps where aps.vendor_name=:vendor_name ) LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 6 60 1=1 msiv1.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 select mp.planner_code from fnd_user fu, per_people_x ppx, mtl_planners mp where 1=2 and fu.user_id=fnd_global.user_id and fu.employee_id=mp.employee_id and nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') F Planificateur US Planner 7 70 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 select ppx.full_name from fnd_user fu, per_people_x ppx where 1=2 and fu.user_id=fnd_global.user_id and fu.employee_id=ppx.person_id and ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa) F Acheteur US Buyer 8 80 1=1 msiv1.planning_make_buy_code=xxen_util.lookup_code(:make_or_buy,'MTL_PLANNING_MAKE_BUY',700) LOV MFG Make or Buy B0B5FC7B97ED64BCE0530100007F8BA8 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_PLANNING_MAKE_BUY' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning F Fabriquer ou acheter US Make or Buy 9 90 :p_assbly_pegging_only LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US End-Assembly Pegging Only If set to yes, end demand for non-assembly items will be excluded. If left null, dend demand for assembly and non-assenmbly items will be included (this mode is equivalent to the MRP Pegging Report). :$flex$.organization_code Organization Code Buyer :$flex$.organization_code Organization Code Component :$flex$.organization_code Organization Code End Assembly :$flex$.organization_code Organization Code Plan :$flex$.organization_code Organization Code Supplier