DBA Data[Home] [Help]

APPS.EAM_WB_UTILS dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 115: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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

Line 129: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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 ;

Line 467: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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

Line 481: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,

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 ;