Reports2017-11-18T12:27:27+00:00

BOM Calendar Exceptions

Description
Categories: Enginatics, Manufacturing

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
Future only
bce.exception_date>=trunc(sysdate)
LOV Oracle

By continuing to use the site, you agree to the use of cookies. Accept