BOM Calendar Exceptions

Description
Categories: Enginatics, Kcapps, Toolkit - Operations, Toolkit - Setup & Support
Repository: Github
Master data report showing bill of material exceptions dates, exception types and organization code.
Run BOM Calendar Exceptions and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Organization Code
mp.organization_code=:organization_code
LOV
Calendar
bce.calendar_code=:calendar
LOV
Future only
bce.exception_date>=trunc(sysdate)
LOV Oracle