[Home] [Help]
111: meaa.maintenance_object_type, meaa.maintenance_object_id,
112: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
113: fw.scheduled_completion_date, fw.organization_id organization_id,
114: fw.pm_base_meter_reading
115: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
116: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
117: where PM_FORECAST_ID = l_forecast_id and
118: fw.activity_association_id = meaa.activity_association_id and
119: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
125: meaa.maintenance_object_type, meaa.maintenance_object_id,
126: meaa.maintenance_object_id, 3, fw.scheduled_start_date,
127: fw.scheduled_completion_date, fw.organization_id organization_id,
128: fw.pm_base_meter_reading
129: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
130: eam_wo_statuses_v ewsv
131: where PM_FORECAST_ID = l_forecast_id and fw.activity_association_id =
132: meaa.activity_association_id and ewsv.status_id=fw.wo_status and
133: meaa.maintenance_object_type = 2 ;
463: meaa.maintenance_object_type, meaa.maintenance_object_id,
464: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
465: fw.scheduled_completion_date, fw.organization_id organization_id,
466: fw.pm_base_meter_reading
467: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
468: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
469: where group_id = l_group_id and
470: fw.activity_association_id = meaa.activity_association_id and
471: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
477: meaa.maintenance_object_type, meaa.maintenance_object_id,
478: meaa.maintenance_object_id, 3, fw.scheduled_start_date,
479: fw.scheduled_completion_date, fw.organization_id organization_id,
480: fw.pm_base_meter_reading
481: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
482: eam_wo_statuses_v ewsv
483: where group_id = l_group_id and fw.activity_association_id =
484: meaa.activity_association_id and ewsv.status_id=fw.wo_status and
485: meaa.maintenance_object_type = 2 ;
674: l_req_id NUMBER;
675:
676: CURSOR c1 IS
677: SELECT PROCESS_FLAG
678: from eam_forecasted_work_orders
679: where PM_FORECAST_ID = l_forecast_id
680: for update of process_flag nowait;
681:
682: begin
697: end if;
698: close c1;
699:
700: if l_old_flag <> 'Y' then
701: update eam_forecasted_work_orders
702: set process_flag = 'Y'
703: where pm_forecast_id = l_forecast_id;
704: else
705: raise_application_error(
800:
801:
802:
803: BEGIN
804: delete from eam_forecasted_work_orders
805: where group_id = p_group_id and
806: process_flag = 'N';
807: commit;
808: END clear_forecasted_work_orders;
1269:
1270: i number;
1271: l_forecast_total number;
1272:
1273: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1274: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1275: l_seq_id eam_forecasted_work_orders.seq_id%type;
1276: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1277: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1270: i number;
1271: l_forecast_total number;
1272:
1273: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1274: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1275: l_seq_id eam_forecasted_work_orders.seq_id%type;
1276: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1277: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1278:
1271: l_forecast_total number;
1272:
1273: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1274: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1275: l_seq_id eam_forecasted_work_orders.seq_id%type;
1276: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1277: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1278:
1279: l_cnt number;
1272:
1273: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1274: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1275: l_seq_id eam_forecasted_work_orders.seq_id%type;
1276: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1277: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1278:
1279: l_cnt number;
1280: l_forecast_id NUMBER;
1273: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1274: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1275: l_seq_id eam_forecasted_work_orders.seq_id%type;
1276: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1277: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1278:
1279: l_cnt number;
1280: l_forecast_id NUMBER;
1281: l_total NUMBER;
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;
1333: i:=1;
1334: l_forecast_id :=eam_wb_utils.current_forecasts.FIRST;
1335: while ( i <= l_forecast_total ) loop
1336:
1337: delete from eam_forecasted_work_orders
1338: where PM_FORECAST_ID = l_forecast_id;
1339:
1340: if i < l_forecast_total then
1341: l_forecast_id := eam_wb_utils.current_forecasts.NEXT(l_forecast_id);