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_PMDEF_PUB dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 88: from eam_pm_activities epa, mtl_eam_asset_activities meaa

84: epa.allow_repeat_in_cycle,
85: epa.day_tolerance,
86: epa.next_service_start_date,
87: epa.next_service_end_date
88: from eam_pm_activities epa, mtl_eam_asset_activities meaa
89: where epa.pm_schedule_id=p_pm_schedule_id
90: and epa.activity_association_id =meaa.source_tmpl_id
91: and meaa.maintenance_object_id=l_maintenance_object_id;
92:

Line 188: from mtl_eam_asset_activities

184: begin
185:
186: select maintenance_object_id, maintenance_object_type
187: into l_maintenance_object_id, l_maintenance_object_type
188: from mtl_eam_asset_activities
189: where activity_association_id=p_activity_assoc_id;
190:
191: pm_header_row.maintenance_object_id := l_maintenance_object_id;
192: pm_header_row.maintenance_object_type := 3;

Line 399: from mtl_eam_asset_activities

395:
396: -- Get maintenance object id and maintenance type
397: select maintenance_object_id, maintenance_object_type
398: into l_maintenance_object_id, l_maintenance_object_type
399: from mtl_eam_asset_activities
400: where activity_association_id=p_activity_assoc_id;
401:
402: -- for runtime rule, get the meter id
403: if (a_pm_rule.meter_id is not null) then

Line 584: from eam_pm_schedulings eps, mtl_eam_asset_activities meaa, eam_pm_set_names epsn

580: -- of l_activity_assoc_id, that have auto_instantiation_flag as "Y"
581:
582: cursor pm_template_csr_old IS
583: select pm_schedule_id
584: from eam_pm_schedulings eps, mtl_eam_asset_activities meaa, eam_pm_set_names epsn
585: where eps.activity_association_id=meaa.source_tmpl_id
586: and meaa.activity_association_id=l_activity_assoc_id
587: and eps.tmpl_flag='Y'
588: and eps.auto_instantiation_flag='Y'

Line 594: from eam_pm_schedulings eps, eam_pm_activities epa,mtl_eam_asset_activities meaa, eam_pm_set_names epsn

590: and (epsn.end_date is null or (epsn.end_date > sysdate and epsn.end_date > nvl(eps.to_effective_date, sysdate)));
591:
592: cursor pm_template_csr IS
593: select distinct eps.pm_schedule_id
594: from eam_pm_schedulings eps, eam_pm_activities epa,mtl_eam_asset_activities meaa, eam_pm_set_names epsn
595: where eps.pm_schedule_id=epa.pm_schedule_id
596: and epa.activity_association_id=meaa.source_tmpl_id
597: and meaa.activity_association_id=l_activity_assoc_id
598: and eps.tmpl_flag='Y'

Line 2404: from mtl_eam_asset_activities

2400: select last_service_start_date, last_service_end_date,last_scheduled_start_date,last_scheduled_end_date,
2401: maintenance_object_id,asset_activity_id
2402: into l_last_service_start_date, l_last_service_end_date,l_last_scheduled_start_date,l_last_scheduled_end_date,
2403: l_maintenance_object_id,l_asset_activity_id
2404: from mtl_eam_asset_activities
2405: where activity_association_id=p_pm_activity_grp_rec.activity_association_id;
2406:
2407: select distinct msi.concatenated_segments into l_act_name
2408: from mtl_system_items_b_kfv msi

Line 2434: UPDATE mtl_eam_asset_activities

2430: l_lsi_updated := 'Y';
2431: x_activities :=l_act_name;
2432: end if;
2433:
2434: UPDATE mtl_eam_asset_activities
2435: SET last_service_start_date = l_last_service_start_date,
2436: last_service_end_date = l_last_service_end_date,
2437: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,
2438: last_update_login=fnd_global.login_id, created_by = fnd_global.user_id

Line 2484: UPDATE mtl_eam_asset_activities meaa

2480: x_activities :=l_act_name;
2481: end;
2482: end if;
2483:
2484: UPDATE mtl_eam_asset_activities meaa
2485: SET meaa.last_scheduled_start_date = l_last_scheduled_start_date,
2486: meaa.last_scheduled_end_date = l_last_scheduled_end_date,
2487: meaa.wip_entity_id=l_wip_entity_id,
2488: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,

Line 2638: from mtl_eam_asset_activities

2634: if (p_pm_schedule_rec.tmpl_flag='N') then
2635:
2636: select last_service_start_date, last_service_end_date
2637: into l_last_service_start_date, l_last_service_end_date
2638: from mtl_eam_asset_activities
2639: where activity_association_id=p_pm_activity_grp_rec.activity_association_id;
2640:
2641: if (l_last_service_start_date is null or l_last_service_end_date is null) then
2642: x_reason_failed:='EAM_PM_HD_ACT_NO_SERVICE_DATE';

Line 2957: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

2953:
2954: if (l_rescheduling_point in (1,5,6)) then
2955:
2956: select max(meaa.last_service_start_date) into l_last_service_date
2957: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
2958: where epa.activity_association_id=meaa.activity_association_id and
2959: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
2960: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
2961: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0));

Line 2966: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

2962:
2963: elsif (l_rescheduling_point = 2) then
2964:
2965: select max(meaa.last_service_end_date) into l_last_service_date
2966: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
2967: where epa.activity_association_id=meaa.activity_association_id and
2968: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
2969: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
2970: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0));

Line 2975: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

2971:
2972: elsif (l_rescheduling_point = 3) then
2973:
2974: select max(meaa.last_scheduled_start_date) into l_last_service_date
2975: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
2976: where epa.activity_association_id=meaa.activity_association_id and
2977: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
2978: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
2979: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0));

Line 2984: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

2980:
2981: elsif (l_rescheduling_point = 4) then
2982:
2983: select max(meaa.last_scheduled_end_date) into l_last_service_date
2984: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
2985: where epa.activity_association_id=meaa.activity_association_id and
2986: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
2987: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
2988: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0));

Line 2998: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

2994:
2995: if (l_rescheduling_point in (1,5,6)) then
2996:
2997: select max(meaa.last_service_start_date) into l_last_service_date
2998: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
2999: where epa.activity_association_id=meaa.activity_association_id and
3000: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id;
3001:
3002: elsif (l_rescheduling_point = 2) then

Line 3005: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

3001:
3002: elsif (l_rescheduling_point = 2) then
3003:
3004: select max(meaa.last_service_end_date) into l_last_service_date
3005: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3006: where epa.activity_association_id=meaa.activity_association_id and
3007: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id;
3008:
3009: elsif (l_rescheduling_point = 3) then

Line 3012: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

3008:
3009: elsif (l_rescheduling_point = 3) then
3010:
3011: select max(meaa.last_scheduled_start_date) into l_last_service_date
3012: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3013: where epa.activity_association_id=meaa.activity_association_id and
3014: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id;
3015:
3016: elsif (l_rescheduling_point = 4) then

Line 3019: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

3015:
3016: elsif (l_rescheduling_point = 4) then
3017:
3018: select max(meaa.last_scheduled_end_date) into l_last_service_date
3019: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3020: where epa.activity_association_id=meaa.activity_association_id and
3021: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id;
3022:
3023: end if;

Line 3031: SELECT meaa.activity_association_id FROM mtl_eam_asset_activities meaa, eam_pm_activities epa

3027: --based on last service date get the last activity association id of the
3028: --lowest interval multiple activity in case of a tie
3029:
3030: select * into l_act_assoc_id from (
3031: SELECT meaa.activity_association_id FROM mtl_eam_asset_activities meaa, eam_pm_activities epa
3032: WHERE decode(l_rescheduling_point,2,last_service_end_date ,3,last_scheduled_start_date, 4,last_scheduled_end_date ,last_service_start_date)
3033: = l_last_service_date
3034: AND meaa.activity_association_id = epa.activity_association_id AND epa.pm_schedule_id = p_pm_schedule_id
3035: order by interval_multiple