VIEW: APPS.OKS_ENT_REACT_TIME_H_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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