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.

VIEW: APPS.EAM_PM_ACTIVITYGROUP_V

Source

View Text - Preformatted


SELECT epa.rowid row_id, epa.pm_schedule_id, epa.activity_association_id, (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = eaa.asset_activity_id and rownum = 1) as concatenated_segments, eaa.maintenance_object_id, eaa.maintenance_object_type, epa.interval_multiple, epa.allow_repeat_in_cycle, epa.day_tolerance, eaa.asset_activity_id, epa.created_by, epa.creation_date, epa.last_update_login, epa.last_update_date, epa.last_updated_by FROM eam_pm_schedulings pm, mtl_eam_asset_activities eaa, eam_pm_activities epa WHERE epa.activity_association_id = eaa.activity_association_id and pm.pm_schedule_id=epa.pm_schedule_id and eaa.maintenance_object_id=pm.maintenance_object_id

View Text - HTML Formatted

SELECT EPA.ROWID ROW_ID
, EPA.PM_SCHEDULE_ID
, EPA.ACTIVITY_ASSOCIATION_ID
, (SELECT CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_KFV
WHERE INVENTORY_ITEM_ID = EAA.ASSET_ACTIVITY_ID
AND ROWNUM = 1) AS CONCATENATED_SEGMENTS
, EAA.MAINTENANCE_OBJECT_ID
, EAA.MAINTENANCE_OBJECT_TYPE
, EPA.INTERVAL_MULTIPLE
, EPA.ALLOW_REPEAT_IN_CYCLE
, EPA.DAY_TOLERANCE
, EAA.ASSET_ACTIVITY_ID
, EPA.CREATED_BY
, EPA.CREATION_DATE
, EPA.LAST_UPDATE_LOGIN
, EPA.LAST_UPDATE_DATE
, EPA.LAST_UPDATED_BY
FROM EAM_PM_SCHEDULINGS PM
, MTL_EAM_ASSET_ACTIVITIES EAA
, EAM_PM_ACTIVITIES EPA
WHERE EPA.ACTIVITY_ASSOCIATION_ID = EAA.ACTIVITY_ASSOCIATION_ID
AND PM.PM_SCHEDULE_ID=EPA.PM_SCHEDULE_ID
AND EAA.MAINTENANCE_OBJECT_ID=PM.MAINTENANCE_OBJECT_ID