BOM Calendar Exceptions

➜ Back to Library
Description
Categories: Enginatics, Kcapps
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
mp.organization_code in (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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
Download
 
Related Blitz Reports
CAC ICP PII Inventory and Intransit Value (Period-End) CAC ICP PII Inventory Pending Cost Adjustment CAC Calculate ICP PII Item Costs by Where Used CRP Resource Plan INV Organization Parameters CAC Inventory and Intransit Value (Period-End) CAC Standard Cost Update Submissions CAC Inventory Pending Cost Adjustment CAC Internal Order Shipment Margin
Blitz Report™

Blitz Report™ provides multiple benefits: