View: OKS_EVENTS_V

Product:	OKS - Service Contracts
Description:	View for Service Contracts Events
Implementation/DBA Data:	APPS.OKS_EVENTS_V

View Text

SELECT CNHB.ID
, CNHB.COUNTER_GROUP_ID
, CNHT.NAME
, CNHT.DESCRIPTION
, CNHB.ONE_TIME_YN
, CNHB.DATE_ACTIVE
, CNHB.DATE_INACTIVE
, CNHB.CNH_TYPE
, CNHB.TEMPLATE_YN
FROM OKC_CONDITION_HEADERS_B CNHB
, OKC_CONDITION_HEADERS_TL CNHT
WHERE CNHB.ID = CNHT.ID
AND CNHT.LANGUAGE = USERENV('LANG')

Columns