eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WB_UTILS dependencies on EAM_WO_STATUSES_V

Line 124: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi

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
128: meaa.maintenance_object_id = cii.instance_id and cii.inventory_item_id =

Line 138: eam_wo_statuses_v ewsv

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
142: order by fw.cycle_id,fw.seq_id ; --added order by for bug13903329

Line 519: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi

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
523: meaa.maintenance_object_id = cii.instance_id and cii.inventory_item_id =

Line 533: eam_wo_statuses_v ewsv

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 ;
537: