1115: FROM
1116: BOM_CALENDAR_DATES CAL1,
1117: BOM_CALENDAR_DATES CAL2,
1118: MRP_FORECAST_DATES FC,
1119: MRP_FORECAST_DESIGNATORS DESIG1,
1120: MRP_FORECAST_DESIGNATORS DESIG2
1121: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG
1122: AND DESIG1.ORGANIZATION_ID = FC.ORGANIZATION_ID
1123: AND DESIG2.ORGANIZATION_ID = FC.ORGANIZATION_ID
1116: BOM_CALENDAR_DATES CAL1,
1117: BOM_CALENDAR_DATES CAL2,
1118: MRP_FORECAST_DATES FC,
1119: MRP_FORECAST_DESIGNATORS DESIG1,
1120: MRP_FORECAST_DESIGNATORS DESIG2
1121: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG
1122: AND DESIG1.ORGANIZATION_ID = FC.ORGANIZATION_ID
1123: AND DESIG2.ORGANIZATION_ID = FC.ORGANIZATION_ID
1124: AND FC.ORGANIZATION_ID = ORG_ID
1156: BOM_CALENDAR_DATES CAL1,
1157: BOM_CALENDAR_DATES CAL2,
1158: BOM_CAL_WEEK_START_DATES WEEK,
1159: MRP_FORECAST_DATES FC,
1160: MRP_FORECAST_DESIGNATORS DESIG1,
1161: MRP_FORECAST_DESIGNATORS DESIG2
1162: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG
1163: AND DESIG1.ORGANIZATION_ID = FC.ORGANIZATION_ID
1164: AND DESIG2.ORGANIZATION_ID = FC.ORGANIZATION_ID
1157: BOM_CALENDAR_DATES CAL2,
1158: BOM_CAL_WEEK_START_DATES WEEK,
1159: MRP_FORECAST_DATES FC,
1160: MRP_FORECAST_DESIGNATORS DESIG1,
1161: MRP_FORECAST_DESIGNATORS DESIG2
1162: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG
1163: AND DESIG1.ORGANIZATION_ID = FC.ORGANIZATION_ID
1164: AND DESIG2.ORGANIZATION_ID = FC.ORGANIZATION_ID
1165: AND FC.ORGANIZATION_ID = ORG_ID
1202: BOM_CALENDAR_DATES CAL1,
1203: BOM_CALENDAR_DATES CAL2,
1204: BOM_PERIOD_START_DATES PER,
1205: MRP_FORECAST_DATES FC,
1206: MRP_FORECAST_DESIGNATORS DESIG1,
1207: MRP_FORECAST_DESIGNATORS DESIG2
1208: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG
1209: AND DESIG1.ORGANIZATION_ID = FC.ORGANIZATION_ID
1210: AND DESIG2.ORGANIZATION_ID = FC.ORGANIZATION_ID
1203: BOM_CALENDAR_DATES CAL2,
1204: BOM_PERIOD_START_DATES PER,
1205: MRP_FORECAST_DATES FC,
1206: MRP_FORECAST_DESIGNATORS DESIG1,
1207: MRP_FORECAST_DESIGNATORS DESIG2
1208: WHERE DESIG2.FORECAST_DESIGNATOR = FORECAST_DESIG
1209: AND DESIG1.ORGANIZATION_ID = FC.ORGANIZATION_ID
1210: AND DESIG2.ORGANIZATION_ID = FC.ORGANIZATION_ID
1211: AND FC.ORGANIZATION_ID = ORG_ID