View: OKS_REACTION_TIMES_HV

Product:	OKS - Service Contracts
Description:	History View for Coverage Reaction Times
Implementation/DBA Data:	APPS.OKS_REACTION_TIMES_HV

View Text

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLEB.MAJOR_VERSION MAJOR_VERSION
, CLEB.CLE_ID BUS_PROCESS_CLE_ID
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, RULES.ID REACTION_RULE_ID
, SUBSTR(RULES.RULE_INFORMATION1
, 1
, 150) PROCESS_DEF_ID
, SUBSTR(RULES.RULE_INFORMATION2
, 1
, 150) REACTION_TIME_NAME
, SUBSTR(RULES.RULE_INFORMATION3
, 1
, 1) WORK_THRU_YN
, SUBSTR(RULES.RULE_INFORMATION4
, 1
, 1) ACTIVE_YN
, RULES.OBJECT1_ID1 INCIDENT_SEVERITY_ID1
, RULES.OBJECT1_ID2 INCIDENT_SEVERITY_ID2
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_LINES_HV CLEB
, OKC_RULE_GROUPS_BH RLGRP
, OKC_RULES_BH RULES
WHERE CLEB.LSE_ID IN ( 4
, 17
, 22 )
AND RLGRP.CLE_ID = CLEB.ID
AND RLGRP.MAJOR_VERSION = CLEB.MAJOR_VERSION
AND RLGRP.RGD_CODE = 'SVC_K'
AND RULES.RGP_ID = RLGRP.ID
AND RULES.MAJOR_VERSION = RLGRP.MAJOR_VERSION
AND RULES.RULE_INFORMATION_CATEGORY = 'RCN'

Columns