BOM Calendar Exceptions
Description
Categories: Enginatics, Kcapps
Repository: Github
Repository: Github
Master data report showing bill of material exceptions dates, exception types and organization code.
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 |
|
LOV | |
Calendar |
|
LOV | |
Future only |
|
LOV Oracle |