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