ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US DD9AAB107ED27FFAE0530100007F0C7AY update xxen_schub_plan_sup_dmd_gt xspsd set xspsd.filter_exclude_flag=null where rowid in (select chartorowid(xssdv.msdt_rowid) from xxen_schub_supply_demand_v xssdv where 1=1 ) or rowid in (select chartorowid(xssdv.mosv_rowid) from xxen_schub_supply_demand_v xssdv where 1=1 ) S US XXEN_SCHUB_SUPPLY_DEMAND_FILTER System report controlling the supply/demand filter functionality on the Supply Chain Hub form Supply Chain Hub 1=1 1 10 1=1 xssdv.organization_code = :org_code LOV custom Y select distinct xssdv.organization_code value, null description from xxen_schub_supply_demand_v xssdv order by value F Organisation US Organization 2 20 1=1 xssdv.date_ >= trunc(:req_date_from) Date F Date du US Date From 3 30 1=1 xssdv.date_ < trunc(:req_date_to)+1 Date F Date à US Date To 4 40 1=1 xssdv.supply_or_demand_ = :supply_or_demand LOV custom Y select distinct xssdv.supply_or_demand_ value, null description from xxen_schub_supply_demand_v xssdv order by value F Offre/Demande US Supply/Demand 5 50 1=1 xssdv.type = :order_type LOV custom Y select distinct xssdv.type value, null description from xxen_schub_supply_demand_v xssdv order by value US Type 6 60 1=1 xssdv.type != :exclude_order_type LOV custom Y select distinct xssdv.type value, null description from xxen_schub_supply_demand_v xssdv order by value F Type d'exclusion US Exclude Type 7 65 1=1 not exists (select null from wip_discrete_jobs wdj where xssdv.disposition_type = 5 and wdj.wip_entity_id = xssdv.msdt_disposition_id and wdj.organization_id = xssdv.organization_id and nvl(wdj.status_type,-99) in (4,5) union select null from wip_repetitive_schedules wrs where xssdv.disposition_type = 4 and wrs.wip_entity_id = xssdv.msdt_disposition_id and wrs.organization_id = xssdv.organization_id and nvl(wrs.status_type,-99) in (4,5) ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Plainte exclue WO US Excl. Compl. WO 8 70 1=1 xssdv.identifier = :identifier LOV custom Y select distinct xssdv.identifier value, null description from xxen_schub_supply_demand_v xssdv order by value F Identifiant US Identifier 9 80 1=1 upper(xssdv.identifier) like '%' || upper(:identifier_contains) || '%' Char F Identifie. Contient US Identif. Contains 10 90 1=1 xssdv.action = :action LOV custom Y select distinct xssdv.action value, null description from xxen_schub_supply_demand_v xssdv order by value US Action 11 100 1=1 xssdv.exception_message = :exception_message LOV custom Y select distinct xssdv.exception_message value, null description from xxen_schub_supply_demand_v xssdv order by value D Ausnahme US Exception 12 110 1=1 xssdv.exception_message is not null 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 13 1=1 xssdv.exception_message is null N F Une exception existe US Exception exists 14 120 1=1 xssdv.pegged_item = :pegged_item LOV custom Y select distinct xssdv.pegged_item value, null description from xxen_schub_supply_demand_v xssdv order by value F Point d'ancrage US Pegged Item 15 130 1=1 xssdv.pegging_info = :pegging_info LOV custom Y select distinct xssdv.pegging_info value, null description from xxen_schub_supply_demand_v xssdv order by value F Informations sur le piquage US Pegging Info 16 140 1=1 xssdv.reschedule_date >= trunc(:resch_date_from) Date F Resch Date de US Resch Date From 17 150 1=1 xssdv.reschedule_date < trunc(:resch_date_to)+1 Date F Resch Date à US Resch Date To 18 160 1=1 xssdv.start_date >= trunc(:start_date_from) Date F Date de début de US Start Date From 19 170 1=1 xssdv.start_date < trunc(:start_date_to)+1 Date F Date de début au US Start Date To 20 180 1=1 xssdv.project = :project LOV custom Y select distinct xssdv.project value, null description from xxen_schub_supply_demand_v xssdv order by value F Projet US Project 21 190 1=1 xssdv.task = :task LOV custom Y select distinct xssdv.task value, null description from xxen_schub_supply_demand_v xssdv where (:$flex$.project is null or xssdv.project = :$flex$.project) order by value F Tâche US Task