ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US EC810CE1D4D4CEF2E0530100007FED94 select distinct bc.calendar_code, bc.description, xxen_util.meaning(bc.quarterly_calendar_type,'BOM_CALENDAR_QT',700) quarterly_calendar_type, bc.calendar_start_date, bc.calendar_end_date, &calendar_date min(bcd.calendar_date) over (partition by bcd.calendar_code) min_calendar_date, max(bcd.calendar_date) over (partition by bcd.calendar_code) max_calendar_date, &organization_code xxen_util.user_name(bc.created_by) created_by, xxen_util.client_time(bc.creation_date) creation_date, xxen_util.user_name(bc.last_updated_by) last_updated_by, xxen_util.client_time(bc.last_update_date) last_update_date from bom_calendars bc, bom_calendar_dates bcd, (select mp.* from mtl_parameters mp where '&show_organizations'='Y') mp, hr_all_organization_units_vl haouv where 1=1 and bc.calendar_code=bcd.calendar_code(+) and bc.calendar_code=mp.calendar_code(+) and mp.organization_id=haouv.organization_id(+) order by bc.calendar_code Y US BOM Calendars Bill of material calendars and calendar dates Enginatics &calendar_date &organization_code &show_organizations 1=1 1 10 1=1 bc.calendar_code=:calendar LOV custom Y select calendar_code value, description description from bom_calendars order by calendar_code F Calendrier US Calendar 2 30 &show_organizations Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Organizations 3 &organization_code mp.organization_code, haouv.name organization, US Show Organizations 4 40 1=1 mp.organization_code=:organization_code LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where :$flex$.show_organizations is not null and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code F Code de l'organisation US Organization Code 5 45 &calendar_date bcd.calendar_date, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Dates 6 50 1=1 bcd.calendar_date>=trunc(sysdate) LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.show_dates is not null Y F Futur seulement US Future only :$flex$.show_dates Show Dates Future only :$flex$.show_organizations Show Organizations Organization Code