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.

[Home] [Help]

View: EAM_PM_ACTIVITYGROUP_V

Product:	EAM - Enterprise Asset Management
Description:	This view will display details of Preventive Maintenance Schedule Activities
Implementation/DBA Data:	APPS.EAM_PM_ACTIVITYGROUP_V

View Text

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

Columns

Name
ROW_ID
PM_SCHEDULE_ID
ACTIVITY_ASSOCIATION_ID
CONCATENATED_SEGMENTS
MAINTENANCE_OBJECT_ID
MAINTENANCE_OBJECT_TYPE
INTERVAL_MULTIPLE
ALLOW_REPEAT_IN_CYCLE
DAY_TOLERANCE
ASSET_ACTIVITY_ID
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
LAST_UPDATED_BY