VIEW: APPS.CS_COV_REACTION_TIMES_V

Source

View Text - Preformatted

SELECT CRT.ROWID ROW_ID , CRT.REACTION_TIME_ID , CRT.COVERAGE_TXN_GROUP_ID , CRT.NAME , CRT.DESCRIPTION , CRT.REACTION_TIME_SUNDAY , CRT.REACTION_TIME_MONDAY , CRT.REACTION_TIME_TUESDAY , CRT.REACTION_TIME_WEDNESDAY , CRT.REACTION_TIME_THURSDAY , CRT.REACTION_TIME_FRIDAY , CRT.REACTION_TIME_SATURDAY , CRT.WORKFLOW , CRT.INCIDENT_SEVERITY_ID , CIS.NAME SEVERITY_NAME , CRT.ALWAYS_COVERED , CRT.USE_FOR_SR_DATE_CALC , CRT.LAST_UPDATE_DATE , CRT.LAST_UPDATED_BY , CRT.CREATION_DATE , CRT.CREATED_BY , CRT.LAST_UPDATE_LOGIN , CRT.ATTRIBUTE1 , CRT.ATTRIBUTE2 , CRT.ATTRIBUTE3 , CRT.ATTRIBUTE4 , CRT.ATTRIBUTE5 , CRT.ATTRIBUTE6 , CRT.ATTRIBUTE7 , CRT.ATTRIBUTE8 , CRT.ATTRIBUTE9 , CRT.ATTRIBUTE10 , CRT.ATTRIBUTE11 , CRT.ATTRIBUTE12 , CRT.ATTRIBUTE13 , CRT.ATTRIBUTE14 , CRT.ATTRIBUTE15 , CRT.CONTEXT , CRT.OBJECT_VERSION_NUMBER FROM CS_COV_REACTION_TIMES CRT, CS_INCIDENT_SEVERITIES CIS WHERE CRT.INCIDENT_SEVERITY_ID = CIS.INCIDENT_SEVERITY_ID(+)

View Text - HTML Formatted

SELECT CRT.ROWID ROW_ID
, CRT.REACTION_TIME_ID
, CRT.COVERAGE_TXN_GROUP_ID
, CRT.NAME
, CRT.DESCRIPTION
, CRT.REACTION_TIME_SUNDAY
, CRT.REACTION_TIME_MONDAY
, CRT.REACTION_TIME_TUESDAY
, CRT.REACTION_TIME_WEDNESDAY
, CRT.REACTION_TIME_THURSDAY
, CRT.REACTION_TIME_FRIDAY
, CRT.REACTION_TIME_SATURDAY
, CRT.WORKFLOW
, CRT.INCIDENT_SEVERITY_ID
, CIS.NAME SEVERITY_NAME
, CRT.ALWAYS_COVERED
, CRT.USE_FOR_SR_DATE_CALC
, CRT.LAST_UPDATE_DATE
, CRT.LAST_UPDATED_BY
, CRT.CREATION_DATE
, CRT.CREATED_BY
, CRT.LAST_UPDATE_LOGIN
, CRT.ATTRIBUTE1
, CRT.ATTRIBUTE2
, CRT.ATTRIBUTE3
, CRT.ATTRIBUTE4
, CRT.ATTRIBUTE5
, CRT.ATTRIBUTE6
, CRT.ATTRIBUTE7
, CRT.ATTRIBUTE8
, CRT.ATTRIBUTE9
, CRT.ATTRIBUTE10
, CRT.ATTRIBUTE11
, CRT.ATTRIBUTE12
, CRT.ATTRIBUTE13
, CRT.ATTRIBUTE14
, CRT.ATTRIBUTE15
, CRT.CONTEXT
, CRT.OBJECT_VERSION_NUMBER
FROM CS_COV_REACTION_TIMES CRT
, CS_INCIDENT_SEVERITIES CIS
WHERE CRT.INCIDENT_SEVERITY_ID = CIS.INCIDENT_SEVERITY_ID(+)