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 EAM_PM_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 351: insert into eam_pm_activities

347: l_reason_failed);
348:
349: if (l_validated) then
350:
351: insert into eam_pm_activities
352: (pm_schedule_id,
353: activity_association_id,
354: interval_multiple,
355: allow_repeat_in_cycle,

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

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

Line 982: insert into eam_pm_activities(

978: p_pm_schedule_rec.planner_maintenance );
979:
980: i:=1;
981: while (p_pm_activities_tbl.exists(i)) loop
982: insert into eam_pm_activities(
983: pm_schedule_id,
984: activity_association_id,
985: interval_multiple,
986: allow_repeat_in_cycle,

Line 1414: delete from eam_pm_activities

1410: -- CURRENT_SEQ = p_pm_schedule_rec.CURRENT_SEQ, -- added for bug 14664020 -- removed for bug 16568661
1411: PLANNER_MAINTENANCE = p_pm_schedule_rec.PLANNER_MAINTENANCE -- WO defaults ER
1412: where PM_SCHEDULE_ID=l_pm_schedule_id;
1413:
1414: delete from eam_pm_activities
1415: where pm_schedule_id=l_pm_schedule_id;
1416:
1417: n:=1;
1418: while (p_pm_activities_tbl.exists(n)) loop /*FP of 7030271*/

Line 1420: insert into eam_pm_activities(

1416:
1417: n:=1;
1418: while (p_pm_activities_tbl.exists(n)) loop /*FP of 7030271*/
1419:
1420: insert into eam_pm_activities(
1421: pm_schedule_id,
1422: activity_association_id,
1423: interval_multiple,
1424: allow_repeat_in_cycle,

Line 2623: eam_pm_schedulings eps,eam_pm_activities epa

2619: /* Bug # 3890075 : Modified the logic so that the query is executed only once. */
2620: BEGIN
2621:
2622: select eps.pm_schedule_id into l_pm_schedule_id from
2623: eam_pm_schedulings eps,eam_pm_activities epa
2624: where eps.pm_schedule_id=epa.pm_schedule_id
2625: and epa.activity_association_id=p_pm_activity_grp_rec.activity_association_id
2626: and eps.set_name_id=p_pm_schedule_rec.set_name_id
2627: and eps.tmpl_flag=p_pm_schedule_rec.tmpl_flag;

Line 2658: eam_pm_schedulings eps,eam_pm_activities epa

2654: /* Bug # 3890075 : Modified the logic so that the query is executed only once. */
2655: BEGIN
2656:
2657: select eps.pm_schedule_id into l_pm_schedule_id from
2658: eam_pm_schedulings eps,eam_pm_activities epa
2659: where eps.pm_schedule_id=epa.pm_schedule_id
2660: and epa.activity_association_id=p_pm_activity_grp_rec.activity_association_id
2661: and eps.default_implement = 'Y'
2662: and eps.tmpl_flag=p_pm_schedule_rec.tmpl_flag;

Line 2752: eam_pm_schedulings eps,eam_pm_activities epa

2748: /* Bug # 3890075 : Modified the logic so that the query is executed only once. */
2749: BEGIN
2750:
2751: select eps.pm_schedule_id into l_pm_schedule_id from
2752: eam_pm_schedulings eps,eam_pm_activities epa
2753: where eps.pm_schedule_id=epa.pm_schedule_id
2754: and epa.activity_association_id=p_pm_activity_grp_rec.activity_association_id
2755: and eps.set_name_id=p_pm_schedule_rec.set_name_id
2756: and eps.tmpl_flag=p_pm_schedule_rec.tmpl_flag;

Line 2787: eam_pm_schedulings eps,eam_pm_activities epa

2783: /* Bug # 3890075 : Modified the logic so that the query is executed only once. */
2784: BEGIN
2785:
2786: select eps.pm_schedule_id into l_pm_schedule_id from
2787: eam_pm_schedulings eps,eam_pm_activities epa
2788: where eps.pm_schedule_id=epa.pm_schedule_id
2789: and epa.activity_association_id=p_pm_activity_grp_rec.activity_association_id
2790: and eps.default_implement = 'Y'
2791: and eps.tmpl_flag=p_pm_schedule_rec.tmpl_flag;

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

3040:
3041: if (l_rescheduling_point in (1,5,6)) then
3042:
3043: select max(meaa.last_service_start_date) into l_last_service_date
3044: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3045: where epa.activity_association_id=meaa.activity_association_id and
3046: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
3047: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
3048: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0))

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

3051:
3052: elsif (l_rescheduling_point = 2) then
3053:
3054: select max(meaa.last_service_end_date) into l_last_service_date
3055: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3056: where epa.activity_association_id=meaa.activity_association_id and
3057: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
3058: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
3059: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0))

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

3062:
3063: elsif (l_rescheduling_point = 3) then
3064:
3065: select max(meaa.last_scheduled_start_date) into l_last_service_date
3066: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3067: where epa.activity_association_id=meaa.activity_association_id and
3068: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
3069: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
3070: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0))

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

3073:
3074: elsif (l_rescheduling_point = 4) then
3075:
3076: select max(meaa.last_scheduled_end_date) into l_last_service_date
3077: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3078: where epa.activity_association_id=meaa.activity_association_id and
3079: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id and
3080: ((epa.ALLOW_REPEAT_IN_CYCLE='N' and epa.interval_multiple=eps.current_seq) or
3081: (epa.ALLOW_REPEAT_IN_CYCLE='Y' and mod(eps.current_seq, epa.interval_multiple)=0))

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

3089:
3090: if (l_rescheduling_point in (1,5,6)) then
3091:
3092: select max(meaa.last_service_start_date) into l_last_service_date
3093: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3094: where epa.activity_association_id=meaa.activity_association_id and
3095: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id
3096: and nvl(meaa.start_date_active, sysdate-1) < sysdate and nvl(meaa.end_date_active, sysdate+1) > sysdate; /*bug 10381070 */
3097:

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

3097:
3098: elsif (l_rescheduling_point = 2) then
3099:
3100: select max(meaa.last_service_end_date) into l_last_service_date
3101: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3102: where epa.activity_association_id=meaa.activity_association_id and
3103: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id
3104: and nvl(meaa.start_date_active, sysdate-1) < sysdate and nvl(meaa.end_date_active, sysdate+1) > sysdate; /*bug 10381070 */
3105:

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

3105:
3106: elsif (l_rescheduling_point = 3) then
3107:
3108: select max(meaa.last_scheduled_start_date) into l_last_service_date
3109: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3110: where epa.activity_association_id=meaa.activity_association_id and
3111: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id
3112: and nvl(meaa.start_date_active, sysdate-1) < sysdate and nvl(meaa.end_date_active, sysdate+1) > sysdate; /*bug 10381070 */
3113:

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

3113:
3114: elsif (l_rescheduling_point = 4) then
3115:
3116: select max(meaa.last_scheduled_end_date) into l_last_service_date
3117: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
3118: where epa.activity_association_id=meaa.activity_association_id and
3119: epa.pm_schedule_id=eps.pm_schedule_id and eps.pm_schedule_id=p_pm_schedule_id
3120: and nvl(meaa.start_date_active, sysdate-1) < sysdate and nvl(meaa.end_date_active, sysdate+1) > sysdate; /*bug 10381070 */
3121:

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

3128: --lowest interval multiple activity in case of a tie
3129: -- modified for 9754424, handled no_data_found exception incase of l_last_service_date is null.
3130: Begin
3131: select * into l_act_assoc_id from (
3132: SELECT meaa.activity_association_id FROM mtl_eam_asset_activities meaa, eam_pm_activities epa
3133: WHERE decode(l_rescheduling_point,2,last_service_end_date ,3,last_scheduled_start_date, 4,last_scheduled_end_date ,last_service_start_date)
3134: = l_last_service_date
3135: AND meaa.activity_association_id = epa.activity_association_id AND epa.pm_schedule_id = p_pm_schedule_id
3136: and nvl(meaa.start_date_active, sysdate-1) < sysdate and nvl(meaa.end_date_active, sysdate+1) > sysdate /*bug 10381070 */