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

Line 55: mtl_eam_asset_activities eaa

51: begin
52: select count(*) into x_num
53: from eam_suppression_relations sup,
54: -- eam_pm_schedulings pms,
55: mtl_eam_asset_activities eaa
56: where sup.child_association_id = p_child_assoc_id
57: -- and sup.child_association_id = pms.activity_association_id
58: and sup.child_association_id = eaa.activity_association_id
59: -- and nvl(pms.from_effective_date, sysdate-1) < sysdate

Line 94: mtl_eam_asset_activities meaa

90: /* cursor asset_supp_csr is
91: select supp.parent_association_id, supp.child_association_id,
92: msn.inventory_item_id
93: from mtl_serial_numbers msn, eam_suppression_relations supp,
94: mtl_eam_asset_activities meaa
95: where msn.gen_object_id = p_maintenance_object_id and
96: supp.tmpl_flag = 'Y' and
97: meaa.tmpl_flag = 'Y' and
98: supp.parent_association_id = meaa.activity_association_id and

Line 105: mtl_eam_asset_activities meaa

101: cursor asset_supp_csr is
102: select supp.parent_association_id, supp.child_association_id,
103: cii.inventory_item_id
104: from csi_item_instances cii, eam_suppression_relations supp,
105: mtl_eam_asset_activities meaa
106: where cii.instance_id = p_maintenance_object_id and
107: supp.tmpl_flag = 'Y' and
108: meaa.tmpl_flag = 'Y' and
109: supp.parent_association_id = meaa.activity_association_id and

Line 205: from mtl_eam_asset_activities meaa_an,

201: and child_association_id = p_child_association_id;
202: supp_rec supp_cursor%ROWTYPE;
203: BEGIN
204: select meaa_an.activity_association_id into l_parent_assoc_id
205: from mtl_eam_asset_activities meaa_an,
206: mtl_eam_asset_activities meaa_ag
207: where meaa_ag.activity_association_id = p_parent_association_id
208: and meaa_ag.asset_activity_id = meaa_an.asset_activity_id
209: and meaa_an.maintenance_object_id = p_maintenance_object_id;

Line 206: mtl_eam_asset_activities meaa_ag

202: supp_rec supp_cursor%ROWTYPE;
203: BEGIN
204: select meaa_an.activity_association_id into l_parent_assoc_id
205: from mtl_eam_asset_activities meaa_an,
206: mtl_eam_asset_activities meaa_ag
207: where meaa_ag.activity_association_id = p_parent_association_id
208: and meaa_ag.asset_activity_id = meaa_an.asset_activity_id
209: and meaa_an.maintenance_object_id = p_maintenance_object_id;
210:

Line 212: from mtl_eam_asset_activities meaa_an,

208: and meaa_ag.asset_activity_id = meaa_an.asset_activity_id
209: and meaa_an.maintenance_object_id = p_maintenance_object_id;
210:
211: select meaa_an.activity_association_id into l_child_assoc_id
212: from mtl_eam_asset_activities meaa_an,
213: mtl_eam_asset_activities meaa_ag
214: where meaa_ag.activity_association_id = p_child_association_id
215: and meaa_ag.asset_activity_id = meaa_an.asset_activity_id
216: and meaa_an.maintenance_object_id = p_maintenance_object_id;

Line 213: mtl_eam_asset_activities meaa_ag

209: and meaa_an.maintenance_object_id = p_maintenance_object_id;
210:
211: select meaa_an.activity_association_id into l_child_assoc_id
212: from mtl_eam_asset_activities meaa_an,
213: mtl_eam_asset_activities meaa_ag
214: where meaa_ag.activity_association_id = p_child_association_id
215: and meaa_ag.asset_activity_id = meaa_an.asset_activity_id
216: and meaa_an.maintenance_object_id = p_maintenance_object_id;
217: