[Home] [Help]
161: raise NO_DATA_FOUND;
162: end if;
163:
164: select decode(eps.RESCHEDULING_POINT,6,epr.meter_id ,null) into l_base_meter_id
165: from eam_pm_schedulings eps,eam_pm_scheduling_rules epr where
166: eps.pm_schedule_id = epr.pm_schedule_id and rownum = 1
167: and eps.pm_schedule_id = sugg_rec.pm_schedule_id;
168:
169: -- Now process the suggestion and fill out the parameters for the
1295: l_forecast_total := eam_wb_utils.get_forecast_total;
1296:
1297: for c1 in (
1298: select fwo.cycle_id,fwo.seq_id,eps.maintenance_object_id,eps.maintenance_object_type
1299: from eam_forecasted_work_orders fwo,eam_pm_schedulings eps
1300: where fwo.pm_schedule_id=eps.pm_schedule_id and fwo.pm_forecast_id in (
1301: ( select * from table( cast ( current_forecasts_index as system.eam_wipid_tab_type
1302: )
1303: )
1320: end if;
1321:
1322: if l_total = 0 then
1323: select count(1) into l_cnt from
1324: eam_forecasted_work_orders fwo,eam_pm_schedulings eps
1325: where fwo.pm_schedule_id = eps.pm_schedule_id and group_id = p_pm_group_id
1326: and (cycle_id >0 and seq_id >0 and (( cycle_id=l_cycle_id and seq_id <= l_seq_id) or cycle_id < l_cycle_id ))
1327: and action_type NOT IN(3,4) and maintenance_object_id =l_maint_id and maintenance_object_type = l_maint_type;
1328: end if;