ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFB79D2E0530100007F1FF2 INV Pegging Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='ASSEMBLY_PEGGING_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'Y',2,'B',3,'I',4,'X',5,'N',6) 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 FA4C095F18CC772AE0530100007F3924 WIP Supply Type Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' order by ml.meaning US 56D217BC85417BD0E0530100007F1033Y update bom_small_expl_temp bset set bset.request_id=null, bset.extended_quantity=bset.component_quantity*nvl(:p_extended_qty,1) where (bset.organization_id,bset.component_item_id) in ( select msib.organization_id, msib.inventory_item_id from mtl_system_items_b msib where 1=1 ) S nvl(:Extended_Qty,1) > 0 US XXEN_SCHUB_ITEM_FILTER System report controlling the item filter functionality on the Supply Chain Hub form Please enter a positive value for the Extended Qty Supply Chain Hub 1=1 :p_extended_qty 1 5 1=1 msib.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:org_code) LOV custom Y select distinct mp.organization_code value, null description from bom_small_expl_temp bset, mtl_parameters mp where bset.organization_id=mp.organization_id order by mp.organization_code F Organisation US Organization 2 10 1=1 msib.buyer_id in ( select ppx.person_id from per_people_x ppx where ppx.full_name=:buyer and ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa) ) 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 D Einkäufer F Acheteur US Buyer 3 20 1=1 msib.planner_code=:planner_code LOV custom Y select distinct mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id in (select distinct bset.organization_id from bom_small_expl_temp bset) order by mp.planner_code D Planer F Planificateur US Planner 4 30 1=1 msib.planning_make_buy_code=xxen_util.lookup_code(:make_or_buy,'MTL_PLANNING_MAKE_BUY',700) LOV custom Y select flv.meaning value, null description from fnd_lookup_values flv where flv.lookup_type='MTL_PLANNING_MAKE_BUY' and flv.language=userenv('lang') and flv.view_application_id=700 and flv.security_group_id=0 order by flv.meaning D Fert./Eink. F Fabriquer ou acheter US Make or Buy 5 40 1=1 msib.end_assembly_pegging_flag=xxen_util.lookup_code(:pegging,'ASSEMBLY_PEGGING_CODE',0) LOV INV Pegging 8E2FF36EDEFB79D2E0530100007F1FF2 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='ASSEMBLY_PEGGING_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'Y',2,'B',3,'I',4,'X',5,'N',6) D Bezugszuordnung US Pegging 6 60 1=1 :exception_message is not null and (msib.organization_id,msib.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_exceptions_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,:exception_message)) x ) LOV custom Y select y.exception_type value ,y.exception_cnt description from ( select substr(column_value,1, instr(column_value,'|',1,1)-1) exception_type , substr(column_value, instr(column_value,'|',1,1)+1) exception_cnt from table(xxen_schub.get_planning_excptns_summary(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,'Y')) order by exception_type asc ) y D Ausnahme US Exception 7 70 1=1 :exception_exists='Y' and (msib.organization_id,msib.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_exceptions_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,null)) x ) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y D Ausn. existiert F Une exception existe US Exception exists 8 1=1 :exception_exists='N' and (msib.organization_id,msib.inventory_item_id) not in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_exceptions_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,null)) x ) N F Une exception existe US Exception exists 9 90 1=1 msib.bom_item_type=:bom_item_type LOV Oracle BOM_TYPE Y select to_char(lookup_code) id, meaning value, null description from fnd_lookup_values where lookup_type='BOM_ITEM_TYPE' and language=userenv('LANG') order by value,description 4 D Stücklistenart F Type de poste de nomenclature US BOM Item Type 10 100 1=1 msib.inventory_item_flag='Y' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y D Nur Lagerartikel F Articles d'inventaire uniquement US Inventory Items only 11 105 1=1 msib.wip_supply_type=xxen_util.lookup_code(:wip_supply_type_incl,'WIP_SUPPLY',700) LOV WIP Supply Type FA4C095F18CC772AE0530100007F3924 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' order by ml.meaning US WIP Supply Type 12 107 1=1 msib.wip_supply_type!=xxen_util.lookup_code(:wip_supply_type_excl,'WIP_SUPPLY',700) LOV WIP Supply Type FA4C095F18CC772AE0530100007F3924 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' order by ml.meaning US Excl. WIP Supply Type 13 110 1=1 (msib.inventory_item_id, msib.organization_id) in ( select wdj.primary_item_id, wdj.organization_id from bom_small_expl_temp bset, wip_discrete_jobs wdj where bset.organization_id = wdj.organization_id and bset.component_item_id = wdj.primary_item_id and wdj.status_type in (1,3,6,8,9,10,11,13,14,15,16,17) ) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F WIP Job existe US WIP Job exists 14 1=1 not exists ( select null from bom_small_expl_temp bset, wip_discrete_jobs wdj where bset.organization_id = wdj.organization_id and bset.component_item_id = wdj.primary_item_id and msib.inventory_item_id=wdj.primary_item_id and msib.organization_id=wdj.organization_id and wdj.status_type in (1,3,6,8,9,10,11,13,14,15,16,17) ) N F WIP Job existe US WIP Job exists 15 120 1=1 nvl(( select sum(moq.transaction_quantity) on_hand from mtl_onhand_quantities moq where msib.organization_id=moq.organization_id and msib.inventory_item_id=moq.inventory_item_id ),0)<=0 LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N D Bestand existiert F Existe en main US On Hand exists 16 1=1 ( select sum(moq.transaction_quantity) on_hand from mtl_onhand_quantities moq where msib.organization_id=moq.organization_id and msib.inventory_item_id=moq.inventory_item_id )>0 Y D Bestand existiert F Existe en main US On Hand exists 17 125 1=1 (case when xxen_schub.get_planning_source='MSC' then xxen_schub.get_max_compression_days(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,msib.organization_id,xxen_schub.get_msc_inventory_item_id(msib.inventory_item_id)) else xxen_schub.get_max_compression_days(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,msib.organization_id,msib.inventory_item_id) end)>0 LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y D In Verzug US Compression exists 18 1=1 nvl((case when xxen_schub.get_planning_source='MSC' then xxen_schub.get_max_compression_days(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,msib.organization_id,xxen_schub.get_msc_inventory_item_id(msib.inventory_item_id)) else xxen_schub.get_max_compression_days(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,msib.organization_id,msib.inventory_item_id) end),0)<=0 N D In Verzug US Compression exists 19 130 :p_extended_qty Number D In Verzug US Extended Qty