[Home] [Help]
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