eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_FORECAST SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48


    mrp_calendar.select_calendar_defaults(arg_org_id,
            var_calendar_code, var_exception_set_id);

Line: 52


      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;

Line: 63


    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;

Line: 83


         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;

Line: 183


         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) */

Line: 222


      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) */

Line: 274


    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;

Line: 386


     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;

Line: 524


    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;

Line: 751


           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);