Product: | CS - Service |
---|---|
Description: | Related statuses for a service request type |
Implementation/DBA Data: | APPS.CS_INC_RELATED_STATUSES_V |
SELECT C.ROWID ROW_ID
, NAME STATUS_NAME
, C.INCIDENT_CYCLE_STEPS_ID
, C.STEP_LEVEL
, C.INCIDENT_STATUS_ID
, C.INCIDENT_TYPE_ID
, C.NEXT_INCIDENT_STEP_LEVEL
, C.DESCRIPTION
, C.END_DATE_ACTIVE
, C.START_DATE_ACTIVE
, C.VALIDATE_FLAG
, C.CLOSE_FLAG
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_LOGIN
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
, C.CONTEXT
, C.OBJECT_VERSION_NUMBER
FROM CS_INCIDENT_CYCLE_STEPS C
, CS_INCIDENT_STATUSES_VL STATUS
WHERE C.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID