[Home] [Help]
119: meaa.maintenance_object_type, meaa.maintenance_object_id,
120: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
121: fw.scheduled_completion_date, fw.organization_id organization_id,
122: fw.pm_base_meter_reading
123: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
124: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
125: where PM_FORECAST_ID = l_forecast_id and
126: fw.activity_association_id = meaa.activity_association_id and
127: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
133: meaa.maintenance_object_type, meaa.maintenance_object_id,
134: meaa.maintenance_object_id as inventory_item_id, 3 as eam_item_type, fw.scheduled_start_date,
135: fw.scheduled_completion_date, fw.organization_id organization_id,
136: fw.pm_base_meter_reading
137: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
138: eam_wo_statuses_v ewsv
139: where PM_FORECAST_ID = l_forecast_id and fw.activity_association_id =
140: meaa.activity_association_id and ewsv.status_id=fw.wo_status and
141: meaa.maintenance_object_type = 2) fw
514: meaa.maintenance_object_type, meaa.maintenance_object_id,
515: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
516: fw.scheduled_completion_date, fw.organization_id organization_id,
517: fw.pm_base_meter_reading
518: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
519: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
520: where group_id = l_group_id and
521: fw.activity_association_id = meaa.activity_association_id and
522: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
528: meaa.maintenance_object_type, meaa.maintenance_object_id,
529: meaa.maintenance_object_id, 3, fw.scheduled_start_date,
530: fw.scheduled_completion_date, fw.organization_id organization_id,
531: fw.pm_base_meter_reading
532: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
533: eam_wo_statuses_v ewsv
534: where group_id = l_group_id and fw.activity_association_id =
535: meaa.activity_association_id and ewsv.status_id=fw.wo_status and
536: meaa.maintenance_object_type = 2 ;
726: l_req_id NUMBER;
727:
728: CURSOR c1 IS
729: SELECT PROCESS_FLAG
730: from eam_forecasted_work_orders
731: where PM_FORECAST_ID = l_forecast_id
732: for update of process_flag nowait;
733:
734: begin
749: end if;
750: close c1;
751:
752: if l_old_flag <> 'Y' then
753: update eam_forecasted_work_orders
754: set process_flag = 'Y'
755: where pm_forecast_id = l_forecast_id;
756: else
757: raise_application_error(
852:
853:
854:
855: BEGIN
856: delete from eam_forecasted_work_orders
857: where group_id = p_group_id and
858: process_flag = 'N';
859: commit;
860: END clear_forecasted_work_orders;
1360:
1361: i number;
1362: l_forecast_total number;
1363:
1364: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1365: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1366: l_seq_id eam_forecasted_work_orders.seq_id%type;
1367: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1368: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1361: i number;
1362: l_forecast_total number;
1363:
1364: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1365: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1366: l_seq_id eam_forecasted_work_orders.seq_id%type;
1367: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1368: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1369:
1362: l_forecast_total number;
1363:
1364: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1365: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1366: l_seq_id eam_forecasted_work_orders.seq_id%type;
1367: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1368: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1369:
1370: l_cnt number;
1363:
1364: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1365: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1366: l_seq_id eam_forecasted_work_orders.seq_id%type;
1367: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1368: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1369:
1370: l_cnt number;
1371: l_forecast_id NUMBER;
1364: l_pm_schedule_id eam_forecasted_work_orders.pm_schedule_id%type;
1365: l_cycle_id eam_forecasted_work_orders.cycle_id%type;
1366: l_seq_id eam_forecasted_work_orders.seq_id%type;
1367: l_wip_entity_id eam_forecasted_work_orders.wip_entity_id%type;
1368: l_activity_association_id eam_forecasted_work_orders.activity_association_id%type;
1369:
1370: l_cnt number;
1371: l_forecast_id NUMBER;
1372: l_total NUMBER;
1391: l_forecast_total := eam_wb_utils.get_forecast_total;
1392:
1393: for c1 in (
1394: select fwo.cycle_id,fwo.seq_id,eps.maintenance_object_id,eps.maintenance_object_type,fwo.activity_association_id
1395: from eam_forecasted_work_orders fwo,eam_pm_schedulings eps
1396: where fwo.pm_schedule_id=eps.pm_schedule_id and fwo.pm_forecast_id in (
1397: ( select * from table( cast ( current_forecasts_index as system.eam_wipid_tab_type
1398: )
1399: )
1419: end if;
1420:
1421: if l_total = 0 then
1422: select count(1) into l_cnt from
1423: eam_forecasted_work_orders fwo,eam_pm_schedulings eps
1424: where fwo.pm_schedule_id = eps.pm_schedule_id and group_id = p_pm_group_id
1425: 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 ))
1426: and action_type NOT IN(3,4)
1427: and maintenance_object_id =l_maint_id
1435: i:=1;
1436: l_forecast_id :=eam_wb_utils.current_forecasts.FIRST;
1437: while ( i <= l_forecast_total ) loop
1438:
1439: delete from eam_forecasted_work_orders
1440: where PM_FORECAST_ID = l_forecast_id;
1441:
1442: if i < l_forecast_total then
1443: l_forecast_id := eam_wb_utils.current_forecasts.NEXT(l_forecast_id);