DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on MRP_FORECAST_DESIGNATORS

Line 1119: MRP_FORECAST_DESIGNATORS DESIG1,

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

Line 1120: MRP_FORECAST_DESIGNATORS DESIG2

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

Line 1160: MRP_FORECAST_DESIGNATORS DESIG1,

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

Line 1161: MRP_FORECAST_DESIGNATORS DESIG2

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

Line 1206: MRP_FORECAST_DESIGNATORS DESIG1,

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

Line 1207: MRP_FORECAST_DESIGNATORS DESIG2

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