DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on BOM_CAL_WEEK_START_DATES

Line 779: FROM bom_cal_week_start_dates

775: AND icat.organization_id = dates.organization_id
776: AND ((dates.bucket_type = 1)
777: OR (dates.bucket_type = 2 AND cal.calendar_date IN
778: (SELECT week_start_date
779: FROM bom_cal_week_start_dates
780: WHERE week_start_date BETWEEN dates.forecast_date AND
781: NVL(dates.rate_end_date,dates.forecast_date)
782: AND calendar_code = cal.calendar_code
783: AND exception_set_id = cal.exception_set_id))

Line 1042: FROM bom_cal_week_start_dates

1038: AND sys.inventory_item_id = dates.inventory_item_id
1039: AND ((dates.bucket_type = 1)
1040: OR (dates.bucket_type = 2 AND cal.calendar_date IN
1041: (SELECT week_start_date
1042: FROM bom_cal_week_start_dates
1043: WHERE week_start_date BETWEEN dates.forecast_date AND
1044: NVL(dates.rate_end_date,dates.forecast_date)
1045: AND calendar_code = cal.calendar_code
1046: AND exception_set_id = cal.exception_set_id))