View: OKS_COV_ACTION_TIMES_V

Product:	OKS - Service Contracts
Description:	This view lists the action times defined for business processes in a coverage. This will be used by the Coverage UI.
Implementation/DBA Data:	APPS.OKS_COV_ACTION_TIMES_V

View Text

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLEB.CLE_ID BUS_PROCESS_CLE_ID
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, OKSL.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID1
, OKSL.PDF_ID PROCESS_DEF_ID
, OKSL.WORK_THRU_YN WORK_THRU_YN
, OKSL.REACT_ACTIVE_YN ACTIVE_YN
, OKSL.REACT_TIME_NAME REACTION_TIME_NAME
, ACT.ACTION_TYPE_CODE ACTION_TYPE_CODE
, ACY.UOM_CODE UOM_CODE
, ACY.SUN_DURATION SUN_DURATION
, ACY.MON_DURATION MON_DURATION
, ACY.TUE_DURATION TUE_DURATION
, ACY.WED_DURATION WED_DURATION
, ACY.THU_DURATION THU_DURATION
, ACY.FRI_DURATION FRI_DURATION
, ACY.SAT_DURATION SAT_DURATION
, 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_B CLEB
, OKS_K_LINES_V OKSL
, OKS_ACTION_TIME_TYPES ACT
, OKS_ACTION_TIMES ACY
WHERE CLEB.LSE_ID IN (4
, 17
, 22)
AND OKSL.CLE_ID = CLEB.ID
AND ACT.CLE_ID = CLEB.ID
AND ACY.COV_ACTION_TYPE_ID = ACT.ID

Columns