BOM Calendar Exceptions

select
bce.calendar_code,
bce.exception_date,
to_char(bce.exception_date,'Day') weekday,
xxen_util.meaning(bce.exception_type,'BOM_ON_OFF',700) exception_type,
mp.organization_code,
haouv.name organization
from
hr_all_organization_units_vl haouv,
mtl_parameters mp,
bom_calendar_exceptions bce
where
1=1 and
haouv.organization_id=mp.organization_id and
mp.calendar_code=bce.calendar_code
order by
bce.calendar_code,
mp.organization_code,
bce.exception_date

select bce.calendar_code, bce.exception_date, to_char(bce.exception_date,'Day') weekday, xxen_util.meaning(bce.exception_type,'BOM_ON_OFF',700) exception_type, mp.organization_code, haouv.name organization from hr_all_organization_units_vl haouv, mtl_parameters mp, bom_calendar_exceptions bce where 1=1 and haouv.organization_id=mp.organization_id and mp.calendar_code=bce.calendar_code order by bce.calendar_code, mp.organization_code, bce.exception_date