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 ;