APPS.EAM_PM_UTILS dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 121: from wip_discrete_jobs wdj, mtl_eam_asset_activities meaa

117:
118: -- Get the activity_association_id for this work order
119:
120: select meaa.activity_association_id into l_activity_association_id
121: from wip_discrete_jobs wdj, mtl_eam_asset_activities meaa
122: where
123: wdj.wip_entity_id=p_wip_entity_id and
124: wdj.maintenance_object_id=meaa.maintenance_object_id and
125: wdj.maintenance_object_type=meaa.maintenance_object_type and

Line 227: from mtl_eam_asset_activities

223: prev_pm_suggested_start_date, prev_pm_suggested_end_date
224: into l_prev_service_start_date, l_prev_service_end_date,
225: l_prev_scheduled_start_date, l_prev_scheduled_end_date,
226: l_prev_pm_suggested_start_date,l_prev_pm_suggested_end_date
227: from mtl_eam_asset_activities
228: where activity_association_id=p_activity_association_id;
229:
230: if (l_prev_service_start_date is not null and l_prev_service_end_date is not null and
231: l_prev_scheduled_start_date is not null and l_prev_scheduled_end_date is not null) then

Line 232: update mtl_eam_asset_activities

228: where activity_association_id=p_activity_association_id;
229:
230: if (l_prev_service_start_date is not null and l_prev_service_end_date is not null and
231: l_prev_scheduled_start_date is not null and l_prev_scheduled_end_date is not null) then
232: update mtl_eam_asset_activities
233: set last_service_start_date = l_prev_service_start_date,
234: last_service_end_date = l_prev_service_end_date,
235: last_scheduled_start_date = l_prev_scheduled_start_date,
236: last_scheduled_end_date = l_prev_scheduled_end_date,

Line 241: update mtl_eam_asset_activities

237: last_pm_suggested_start_date = l_prev_pm_suggested_start_date,
238: last_pm_suggested_end_date = l_prev_pm_suggested_end_date
239: where activity_association_id=p_activity_association_id;
240:
241: update mtl_eam_asset_activities
242: set prev_service_start_date = null,
243: prev_service_end_date = null,
244: prev_scheduled_start_date = null,
245: prev_scheduled_end_date = null,

Line 279: mtl_eam_asset_activities eaa

275: p_asset_number varchar2,
276: p_asset_activity_id number) is
277: select pms.pm_schedule_id
278: from eam_pm_schedulings pms,
279: mtl_eam_asset_activities eaa
280: where pms.activity_association_id = eaa.activity_association_id
281: and eaa.organization_id = p_org_id
282: and eaa.inventory_item_id = p_asset_group_id
283: and eaa.serial_number = p_asset_number

Line 456: from mtl_eam_asset_activities

452: l_activity_source,
453: l_tagging_required_flag,
454: l_shutdown_type_code,
455: l_priority_code
456: from mtl_eam_asset_activities
457: where activity_association_id = p_assoc_id;
458:
459: if (l_serial_number is not null) then
460: select wip_accounting_class_code, gen_object_id