View: OKX_PM_PROGRAMS_V

Product:	OKX - Contracts Integration
Description:	View for preventive maintenance programs.
Implementation/DBA Data:	APPS.OKX_PM_PROGRAMS_V

View Text

SELECT MR_HEADER_ID ID1
, '#' ID2
, TITLE NAME
, DESCRIPTION DESCRIPTION
, TYPE_CODE TYPE_CODE
, TYPE TYPE
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, MR_STATUS_CODE MR_STATUS_CODE
, STATUS STATUS
FROM AHL_MR_HEADERS_V
WHERE TYPE_CODE = 'PROGRAM'

Columns