[Home] [Help]
393: null,
394: null,
395: dcs_pk.level_value
396: from
397: msd_mfg_forecast mbd,
398: msd_level_values org_pk,
399: msd_level_values dcs_pk,
400: msd_level_values item_pk,
401: msd_level_values sales_channel_pk,
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;