View: OKS_ENT_REACT_TIME_H_V

Product:	OKS - Service Contracts
Description:	Lists all Reaction time header informations.
Implementation/DBA Data:	APPS.OKS_ENT_REACT_TIME_H_V

View Text

SELECT BP.CLE_ID COVERAGE_ID
, RT.CLE_ID TXN_GROUP_ID
, RT.ID REACTION_TIME_ID
, ACT.ID REACTION_INTERVAL_ID
, TL.NAME NAME
, SV.ID1 SEVERITY_ID
, SV.NAME SEVERITY_NAME
, OKSRTV.WORK_THRU_YN WORK_THROUGH_YN
, OKSRTV.REACT_ACTIVE_YN ACTIVE_YN
, ACT.ACTION_TYPE_CODE TIME_TYPE
FROM OKC_K_LINES_B BP
, OKC_K_LINES_B RT
, OKC_K_LINES_TL TL
, OKS_K_LINES_V OKSRTV
, OKS_ACTION_TIME_TYPES ACT
, OKX_INCIDENT_SEVERITS_V SV
WHERE BP.ID=RT.CLE_ID
AND RT.LSE_ID IN(4
, 17
, 22)
AND RT.ID = TL.ID
AND TL.LANGUAGE = USERENV('LANG')
AND OKSRTV.INCIDENT_SEVERITY_ID = SV.ID1
AND OKSRTV.CLE_ID = RT.ID
AND ACT.CLE_ID = RT.ID

Columns