[Home] [Help]
2852: meaa.maintenance_object_type, meaa.maintenance_object_id,
2853: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
2854: fw.scheduled_completion_date, fw.organization_id organization_id,
2855: fw.pm_base_meter_reading
2856: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
2857: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
2858: where group_id = l_group_id and
2859: fw.activity_association_id = meaa.activity_association_id and
2860: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
2866: meaa.maintenance_object_type, meaa.maintenance_object_id,
2867: meaa.maintenance_object_id, 3, fw.scheduled_start_date,
2868: fw.scheduled_completion_date, fw.organization_id organization_id,
2869: fw.pm_base_meter_reading
2870: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
2871: eam_wo_statuses_v ewsv
2872: where group_id = l_group_id and fw.activity_association_id =
2873: meaa.activity_association_id and ewsv.status_id=fw.wo_status and
2874: meaa.maintenance_object_type = 2 ;
2877: CURSOR c1 IS
2878: 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,
2879: meaa.inventory_item_id, default_eam_class wip_acct_class,meaa.eam_item_type,
2880: scheduled_start_date, scheduled_completion_date, meaa.organization_id
2881: from eam_forecasted_work_orders fw, mtl_eam_asset_activities_v meaa,
2882: wip_eam_parameters wep, mtl_system_items msi,eam_wo_statuses_v ewsv
2883: where group_id = l_group_id
2884: and wep.organization_id = meaa.organization_id
2885: and fw.activity_association_id = meaa.activity_association_id