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.

Skip to content FND Design Data

[Home] [Help]

View: OKX_PM_ACTIVITIES_V

Product:	OKX - Contracts Integration
Description:	This view is the source for all the activities associated to a preventive maintenance program.
Implementation/DBA Data:	APPS.OKX_PM_ACTIVITIES_V

View Text

SELECT ACT.MR_HEADER_ID ID1
, '#' ID2
, ACT.TITLE NAME
, ACT.DESCRIPTION DESCRIPTION
, ACT.TYPE_CODE TYPE_CODE
, ACT.TYPE TYPE
, ACT.EFFECTIVE_FROM EFFECTIVE_FROM
, ACT.EFFECTIVE_TO EFFECTIVE_TO
, ACT.MR_STATUS_CODE MR_STATUS_CODE
, ACT.STATUS STATUS
, ACT.DOWN_TIME
, ACT.UOM
, AMR.MR_HEADER_ID PROGRAM_ID
FROM AHL_MR_RELATIONSHIPS_APP_V AMR
, AHL_MR_HEADERS_V ACT
WHERE AMR.RELATED_MR_HEADER_ID = ACT.MR_HEADER_ID
AND ACT.TYPE_CODE = 'ACTIVITY'

Columns

Name
ID1
ID2
NAME
DESCRIPTION
TYPE_CODE
TYPE
EFFECTIVE_FROM
EFFECTIVE_TO
MR_STATUS_CODE
STATUS
DOWN_TIME
UOM
PROGRAM_ID