The following lines contain the word 'select', 'insert', 'update' or 'delete':
mrp_calendar.select_calendar_defaults(arg_org_id,
var_calendar_code, var_exception_set_id);
SELECT NVL(item_cost,0)
INTO var_item_cost
FROM cst_item_costs_for_gl_view
WHERE organization_id = arg_org_id
AND inventory_item_id = arg_inventory_item_id;
SELECT cal1.calendar_date
INTO var_fc_begin_date
FROM bom_calendar_dates cal1,
bom_calendar_dates cal2,
mrp_forecast_designators desig
WHERE cal1.seq_num =
cal2.prior_seq_num -
LEAST(NVL(desig.backward_update_time_fence, 0),
cal2.seq_num - 1)
AND cal1.calendar_code = var_calendar_code
AND cal1.exception_set_id = var_exception_set_id
AND cal2.calendar_date =
TRUNC(arg_start_date)
AND cal2.calendar_code = var_calendar_code
AND cal2.exception_set_id = var_exception_set_id
AND desig.forecast_designator = arg_forecast_designator
AND desig.organization_id = arg_org_id;
SELECT DECODE(arg_past_due, SYS_YES,
forecast_date,
GREATEST(arg_start_date,forecast_date)),
NVL(rate_end_date, forecast_date),
current_forecast_quantity,
original_forecast_quantity,
forecast_designator,
NVL(bucket_type, 0),
arg_org_id
FROM mrp_forecast_dates
WHERE DECODE(arg_past_due, SYS_YES, arg_start_date,
DECODE(bucket_type, 1,
DECODE(rate_end_date, NULL,
forecast_date, rate_end_date), arg_start_date))
>= arg_start_date
AND forecast_designator = arg_forecast_designator
AND organization_id = arg_org_id
AND inventory_item_id = arg_inventory_item_id
ORDER BY 1,2,4,5;
INSERT INTO mrp_form_query
(QUERY_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
DATE1, /* forecast date */
NUMBER1, /* org id */
NUMBER2, /* inventory item id */
NUMBER3, /* daily curr qty */
NUMBER5, /* daily orig qty */
NUMBER7, /* daily sales order qty */
CHAR1) /* forecast designator (added for web inquiries) */
VALUES
(arg_query_id,
sysdate,
-1,
sysdate,
-1,
var_curr_date,
arg_org_id,
arg_inventory_item_id,
decode(arg_form_mode,QUERY_MODE,decode(sign(var_rep_curr_qty),-1,0,
var_rep_curr_qty),var_rep_curr_qty),
var_rep_orig_qty,
var_rep_orig_qty - var_rep_curr_qty,
arg_forecast_designator); /* (added for web inquiries) */
ELSE /* no entires were found, insert a psuedo one */
INSERT INTO mrp_form_query
(QUERY_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
DATE1, /* forecast date */
NUMBER1, /* org id */
NUMBER2, /* inventory item id */
NUMBER3, /* daily curr qty */
NUMBER5, /* daily orig qty */
NUMBER7, /* daily sales order qty */
CHAR1) /* forecast designator (added for web inquiries) */
VALUES
(arg_query_id,
sysdate,
-1,
sysdate,
-1,
arg_start_date,
arg_org_id,
arg_inventory_item_id,
0,
0,
0,
arg_forecast_designator); /* (added for web inquiries) */
INSERT INTO mrp_form_query
(QUERY_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
DATE1, /* bucket start date */
DATE2, /* next bucket start date */
NUMBER1, /* bucket curr qty */
NUMBER3, /* bucket cum curr qty */
NUMBER5, /* bucket orig qty */
NUMBER7, /* bucket cum orig qty */
NUMBER9, /* bucket sales order qty */
NUMBER11, /* bucket cum sales order qty */
NUMBER12, /* item id (added for web inquiries) */
NUMBER13, /* org id (added for web inquiries) */
CHAR1) /* forecast designator (added for web inquiries) */
SELECT arg_secondary_query_id,
sysdate,
-1,
sysdate,
-1,
DATES.CALENDAR_DATE,
DATES.NEXT_DATE,
/* curr qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
(DECODE(DATES.CALENDAR_DATE, arg_bucket_start_date,
DECODE(LEAST(arg_bucket_start_date, MRP_FQ.DATE1),
MRP_FQ.DATE1, MRP_FQ.NUMBER3, 0),
DECODE(MRP_FQ.DATE1, DATES.CALENDAR_DATE,
MRP_FQ.NUMBER3,0))),
DECODE(MRP_FQ.DATE1, DATES.CALENDAR_DATE,
MRP_FQ.NUMBER3,0))),0), 6),
/*cum curr qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
(DECODE(DATES.CALENDAR_DATE, arg_bucket_start_date,
DECODE(LEAST(arg_bucket_start_date, MRP_FQ.DATE1),
MRP_FQ.DATE1, MRP_FQ.NUMBER3, 0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.CALENDAR_DATE),
MRP_FQ.DATE1,
MRP_FQ.NUMBER3,0))),
DECODE(LEAST(MRP_FQ.DATE1, DATES.CALENDAR_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
MRP_FQ.NUMBER3,0)))),0), 6),
/*orig qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
(DECODE(DATES.CALENDAR_DATE, arg_bucket_start_date,
DECODE(LEAST(arg_bucket_start_date, MRP_FQ.DATE1),
MRP_FQ.DATE1, MRP_FQ.NUMBER5, 0),
DECODE(MRP_FQ.DATE1, DATES.CALENDAR_DATE,
MRP_FQ.NUMBER5,0))),
DECODE(MRP_FQ.DATE1, DATES.CALENDAR_DATE,
MRP_FQ.NUMBER5,0))),0), 6),
/*cum orig qty*/
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
(DECODE(DATES.CALENDAR_DATE, arg_bucket_start_date,
DECODE(LEAST(arg_bucket_start_date, MRP_FQ.DATE1),
MRP_FQ.DATE1, MRP_FQ.NUMBER5, 0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.CALENDAR_DATE),
MRP_FQ.DATE1,
MRP_FQ.NUMBER5,0))),
DECODE(LEAST(MRP_FQ.DATE1, DATES.CALENDAR_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
MRP_FQ.NUMBER5,0)))),0), 6),
/* sales order qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
(DECODE(DATES.CALENDAR_DATE, arg_bucket_start_date,
DECODE(LEAST(arg_bucket_start_date, MRP_FQ.DATE1),
MRP_FQ.DATE1, MRP_FQ.NUMBER7, 0),
DECODE(MRP_FQ.DATE1, DATES.CALENDAR_DATE,
MRP_FQ.NUMBER7,0))),
DECODE(MRP_FQ.DATE1, DATES.CALENDAR_DATE,
MRP_FQ.NUMBER7,0))),0), 6),
/*cum sales order qty*/
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
(DECODE(DATES.CALENDAR_DATE, arg_bucket_start_date,
DECODE(LEAST(arg_bucket_start_date, MRP_FQ.DATE1),
MRP_FQ.DATE1, MRP_FQ.NUMBER7, 0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.CALENDAR_DATE),
MRP_FQ.DATE1,
MRP_FQ.NUMBER7,0))),
DECODE(LEAST(MRP_FQ.DATE1, DATES.CALENDAR_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
MRP_FQ.NUMBER7,0)))),0), 6),
MRP_FQ.NUMBER2, /* (added for web inquiries) */
MRP_FQ.NUMBER1, /* (added for web inquiries) */
MRP_FQ.CHAR1 /* (added for web inquiries) */
FROM BOM_CALENDAR_DATES DATES,
MTL_PARAMETERS PARAM,
MRP_FORM_QUERY MRP_FQ
WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND DATES.SEQ_NUM is not NULL
AND DATES.CALENDAR_DATE BETWEEN arg_bucket_start_date
AND arg_cutoff_date
AND PARAM.ORGANIZATION_ID = arg_org_id
AND MRP_FQ.query_id = arg_query_id
AND MRP_FQ.DATE1 <= arg_cutoff_date
GROUP BY MRP_FQ.QUERY_ID,
MRP_FQ.NUMBER2, /* (added for web inquiries) */
MRP_FQ.NUMBER1, /* (added for web inquiries) */
MRP_FQ.CHAR1, /* (added for web inquiries) */
DATES.CALENDAR_DATE,
DATES.NEXT_DATE;
INSERT INTO mrp_form_query
(QUERY_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
DATE1, /* bucket date */
DATE2, /* next bucket start date */
NUMBER1, /* bucket curr qty */
NUMBER3, /* bucket cum curr qty */
NUMBER5, /* bucket orig qty */
NUMBER7, /* bucket cum orig qty */
NUMBER9, /* bucket sales order qty */
NUMBER11, /* bucket cum sales order qty */
NUMBER12, /* item id (added for web inquiries) */
NUMBER13, /* org id (added for web inquiries) */
CHAR1) /* forecast designator (added for web inquiries) */
SELECT
arg_secondary_query_id,
sysdate,
-1,
sysdate,
-1,
DATES.WEEK_START_DATE,
DATES.NEXT_DATE,
/*curr qty*/
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(DATES.WEEK_START_DATE, arg_bucket_start_date,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.WEEK_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0))),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.WEEK_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0)))),0), 6),
/*cum curr qty*/
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0)))),0), 6),
/* orig qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(DATES.WEEK_START_DATE, arg_bucket_start_date,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.WEEK_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0))),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.WEEK_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0)))),0), 6),
/* cum orig qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0)))),0), 6),
/* sales order qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(DATES.WEEK_START_DATE, arg_bucket_start_date,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.WEEK_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0))),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.WEEK_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0)))),0), 6),
/* cum sales order qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0)))),0), 6),
MRP_FQ.NUMBER2, /* (added for web inquiries) */
MRP_FQ.NUMBER1, /* (added for web inquiries) */
MRP_FQ.CHAR1 /* (added for web inquiries) */
FROM BOM_CAL_WEEK_START_DATES DATES,
MTL_PARAMETERS PARAM,
MRP_FORM_QUERY MRP_FQ
WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND DATES.WEEK_START_DATE BETWEEN arg_bucket_start_date
AND arg_cutoff_date
AND PARAM.ORGANIZATION_ID = arg_org_id
AND MRP_FQ.query_id = arg_query_id
AND MRP_FQ.DATE1 <= arg_cutoff_date
GROUP BY MRP_FQ.QUERY_ID,
MRP_FQ.NUMBER2, /* (added for web inquiries) */
MRP_FQ.NUMBER1, /* (added for web inquiries) */
MRP_FQ.CHAR1, /* (added for web inquiries) */
DATES.WEEK_START_DATE,
DATES.NEXT_DATE;
INSERT INTO mrp_form_query
(QUERY_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
DATE1, /* bucket date */
DATE2, /* next bucket start date */
NUMBER1, /* bucket curr qty */
NUMBER3, /* bucket cum curr qty */
NUMBER5, /* bucket orig qty */
NUMBER7, /* bucket cum orig qty */
NUMBER9, /* bucket sales order qty */
NUMBER11, /* bucket cum sales order qty */
NUMBER12, /* item id (added for web inquiries) */
NUMBER13, /* org id (added for web inquiries) */
CHAR1) /* forecast designator (added for web inquiries) */
SELECT
arg_secondary_query_id,
sysdate,
-1,
sysdate,
-1,
DATES.PERIOD_START_DATE,
DATES.NEXT_DATE,
/*curr qty*/
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(DATES.PERIOD_START_DATE, arg_bucket_start_date,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.PERIOD_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0))),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.PERIOD_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0)))),0), 6),
/*cum curr qty*/
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER3),0)))),0), 6),
/* orig qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(DATES.PERIOD_START_DATE, arg_bucket_start_date,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.PERIOD_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0))),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.PERIOD_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0)))),0), 6),
/* cum orig qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER5),0)))),0), 6),
/* sales order qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(DATES.PERIOD_START_DATE, arg_bucket_start_date,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.PERIOD_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0))),
DECODE(GREATEST(MRP_FQ.DATE1, DATES.PERIOD_START_DATE),
MRP_FQ.DATE1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0)))),0), 6),
/* cum sales order qty */
ROUND(NVL(SUM(DECODE(arg_past_due, 1,
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0),
DECODE(LEAST(MRP_FQ.DATE1, DATES.NEXT_DATE),
MRP_FQ.DATE1,
DECODE(GREATEST(MRP_FQ.DATE1, arg_bucket_start_date),
MRP_FQ.DATE1,
DECODE(MRP_FQ.DATE1, DATES.NEXT_DATE, 0,
MRP_FQ.NUMBER7),0)))),0), 6),
MRP_FQ.NUMBER2, /* (added for web inquiries) */
MRP_FQ.NUMBER1, /* (added for web inquiries) */
MRP_FQ.CHAR1 /* (added for web inquiries) */
FROM MTL_PARAMETERS PARAM,
BOM_PERIOD_START_DATES DATES,
MRP_FORM_QUERY MRP_FQ
WHERE DATES.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND DATES.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND PARAM.ORGANIZATION_ID = arg_org_id
AND MRP_FQ.query_id = arg_query_id
AND MRP_FQ.DATE1 <= arg_cutoff_date
AND DATES.PERIOD_START_DATE BETWEEN arg_bucket_start_date
AND arg_cutoff_date
GROUP BY MRP_FQ.QUERY_ID,
MRP_FQ.NUMBER2, /* (added for web inquiries) */
MRP_FQ.NUMBER1, /* (added for web inquiries) */
MRP_FQ.CHAR1, /* (added for web inquiries) */
DATES.PERIOD_START_DATE,
DATES.NEXT_DATE;
SELECT forecast_designator
FROM mrp_forecast_designators
WHERE organization_id = arg_org_id
AND (forecast_set = arg_forecast_set
OR forecast_designator = arg_forecast_set);