APPS.EAM_WB_UTILS dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 123: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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

Line 137: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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

Line 518: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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

Line 532: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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 ;