APPS.MSC_X_HZ_PLAN dependencies on MSC_WORKBENCH_DISPLAY_OPTIONS

Line 897: FROM msc_workbench_display_options

893: NVL(summary_display_periods,NOT_SELECTED)
894: , NVL(shift_days, 0)
895: , decode(net_forecast, 'Y', SELECTED, NOT_SELECTED)
896: , decode(total_supply, 'Y', SELECTED, NOT_SELECTED)
897: FROM msc_workbench_display_options
898: WHERE public_flag = 'Y'
899: ORDER BY named_set ASC
900: ;
901:

Line 948: FROM msc_workbench_display_options

944: NVL(summary_display_periods,NOT_SELECTED)
945: , NVL(shift_days, 0)
946: , decode(net_forecast, 'Y', SELECTED, NOT_SELECTED)
947: , decode(total_supply, 'Y', SELECTED, NOT_SELECTED)
948: FROM msc_workbench_display_options
949: WHERE NVL(public_flag, 'N') <> 'Y'
950: AND NVL(default_set, 'N') <> 'Y'
951: ORDER BY named_set ASC
952: ;

Line 1024: FROM msc_workbench_display_options

1020: period_bucket_count
1021: , v_shift_days
1022: , v_net_forecast
1023: , v_total_supply
1024: FROM msc_workbench_display_options
1025: WHERE rtrim(ltrim(named_set)) = rtrim(ltrim(v_pref_name))
1026: AND rownum < 2
1027: AND ( SCE_USER_ID = FND_GLOBAL.user_id
1028: OR PUBLIC_FLAG = 'Y' )

Line 1097: FROM msc_workbench_display_options

1093: period_bucket_count
1094: , v_shift_days
1095: , v_net_forecast
1096: , v_total_supply
1097: FROM msc_workbench_display_options
1098: WHERE upper(default_set) = 'Y'
1099: AND rownum < 2
1100: AND SCE_USER_ID = FND_GLOBAL.user_id ;
1101: end if;