Line 419: from ( select distinct forecast_designator from msd_mfg_forecast);
415: from msd_cs_definitions
416: where name='MSD_MANUFACTURING_FORECAST';
417:
418: select count(*) into lv_forecast_designator 419: from ( select distinct forecast_designator from msd_mfg_forecast); 420:
421: IF ( lv_forecast_designator = 1 ) THEN
422:
423: OPEN mfg_forecast;