[Home] [Help]
1482: ' ASSET_ID: ' || l_asset_ID || ' ASSET_TYPE: ' ||
1483: l_asset_TYPE);
1484: END LOOP;
1485:
1486: delete from eam_forecasted_work_orders where
1487: group_id = l_pm_group_id and
1488: scheduled_start_date < l_start_date;
1489:
1490: --select count(*) into l_count from wip_discrete_jobs;
3190: meaa.maintenance_object_type, meaa.maintenance_object_id,
3191: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
3192: fw.scheduled_completion_date, fw.organization_id organization_id,
3193: fw.pm_base_meter_reading
3194: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
3195: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
3196: where group_id = l_group_id and
3197: fw.activity_association_id = meaa.activity_association_id and
3198: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
3204: meaa.maintenance_object_type, meaa.maintenance_object_id,
3205: meaa.maintenance_object_id, 3, fw.scheduled_start_date,
3206: fw.scheduled_completion_date, fw.organization_id organization_id,
3207: fw.pm_base_meter_reading
3208: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
3209: eam_wo_statuses_v ewsv
3210: where group_id = l_group_id and fw.activity_association_id =
3211: meaa.activity_association_id and ewsv.status_id=fw.wo_status and
3212: meaa.maintenance_object_type = 2 ;
3215: CURSOR c1 IS
3216: SELECT meaa.asset_activity_id, pm_schedule_id, action_type, fw.wip_entity_id, fw.wo_status,ewsv.system_status,fw.cycle_id,fw.seq_id,maintenance_object_type, maintenance_object_id,
3217: meaa.inventory_item_id, default_eam_class wip_acct_class,meaa.eam_item_type,
3218: scheduled_start_date, scheduled_completion_date, meaa.organization_id
3219: from eam_forecasted_work_orders fw, mtl_eam_asset_activities_v meaa,
3220: wip_eam_parameters wep, mtl_system_items msi,eam_wo_statuses_v ewsv
3221: where group_id = l_group_id
3222: and wep.organization_id = meaa.organization_id
3223: and fw.activity_association_id = meaa.activity_association_id
3308:
3309: end loop;
3310:
3311: /*
3312: delete from eam_forecasted_work_orders
3313: where group_id = l_group_id;
3314: */
3315:
3316: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);