DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on MRP_CALENDAR

Line 838: (mrp_calendar.days_between(p_org_id,

834: IF (c2rec.rate_end_date is NULL) THEN
835: l_rec_demand := c2rec.current_forecast_quantity;
836: ELSE
837: l_rec_demand := c2rec.current_forecast_quantity *
838: (mrp_calendar.days_between(p_org_id,
839: c2rec.bucket_type, c2rec.forecast_date,
840: c2rec.rate_end_date) + 1);
841: END IF;
842: l_demand := l_demand + l_rec_demand;

Line 871: (mrp_calendar.days_between(p_org_id,

867: l_forecast_demand := c2rec.current_forecast_quantity;
868: ELSE
869: l_forecast_demand :=
870: c2rec.current_forecast_quantity *
871: (mrp_calendar.days_between(p_org_id,
872: c2rec.bucket_type, c2rec.forecast_date,
873: c2rec.rate_end_date) + 1);
874: END IF;
875:

Line 917: (mrp_calendar.days_between(p_org_id,

913: l_forecast_demand := c2rec.current_forecast_quantity;
914: ELSE
915: l_forecast_demand :=
916: c2rec.current_forecast_quantity *
917: (mrp_calendar.days_between(p_org_id,
918: c2rec.bucket_type, c2rec.forecast_date,
919: c2rec.rate_end_date) + 1);
920: END IF;
921:

Line 954: (mrp_calendar.days_between(p_org_id,

950: l_forecast_demand := c2rec.current_forecast_quantity;
951: ELSE
952: l_forecast_demand :=
953: c2rec.current_forecast_quantity *
954: (mrp_calendar.days_between(p_org_id,
955: c2rec.bucket_type, c2rec.forecast_date,
956: c2rec.rate_end_date) + 1);
957: END IF;
958:

Line 1293: (mrp_calendar.days_between(p_org_id,

1289: IF (c3rec.rate_end_date is NULL) THEN
1290: l_rec_demand := c3rec.schedule_quantity;
1291: ELSE
1292: l_rec_demand := c3rec.repetitive_daily_rate *
1293: (mrp_calendar.days_between(p_org_id,
1294: 1, c3rec.schedule_date,
1295: c3rec.rate_end_date) + 1);
1296: END IF;
1297: l_demand := l_demand + l_rec_demand;

Line 1326: (mrp_calendar.days_between(p_org_id,

1322: l_mdsmps_demand := c3rec.schedule_quantity;
1323: ELSE
1324: l_mdsmps_demand :=
1325: c3rec.repetitive_daily_rate *
1326: (mrp_calendar.days_between(p_org_id,
1327: 1, c3rec.schedule_date,
1328: c3rec.rate_end_date) + 1);
1329: END IF;
1330:

Line 1372: (mrp_calendar.days_between(p_org_id,

1368: l_mdsmps_demand := c3rec.schedule_quantity;
1369: ELSE
1370: l_mdsmps_demand :=
1371: c3rec.repetitive_daily_rate *
1372: (mrp_calendar.days_between(p_org_id,
1373: 1, c3rec.schedule_date,
1374: c3rec.rate_end_date) + 1);
1375: END IF;
1376:

Line 1409: (mrp_calendar.days_between(p_org_id,

1405: l_mdsmps_demand := c3rec.schedule_quantity;
1406: ELSE
1407: l_mdsmps_demand :=
1408: c3rec.repetitive_daily_rate *
1409: (mrp_calendar.days_between(p_org_id,
1410: 1, c3rec.schedule_date,
1411: c3rec.rate_end_date) + 1);
1412: END IF;
1413: