VIEW: APPS.CS_INCIDENT_ACTIONS_V

Source

View Text - Preformatted

SELECT ACTION.ROWID ROW_ID , ACTION.INCIDENT_ACTION_ID , ACTION.INCIDENT_ID , ACTION.ACTION_CODE , ACTION.ACTION_NUM , ACTION.ACTION_TYPE_ID , ACTION.ACTION_STATUS_ID , ACTION.ACTION_SEVERITY_ID , ACTION.RESPONSIBLE_PERSON_ID ACTION_ASSIGNEE_ID , ACTION.TEXT , ACTION.TEXT_DESCRIPTION , ACTION.TEXT_RESOLUTION , ACTION.ACTION_EFFECTIVE_DATE , ACTION.EXPECTED_RESOLUTION_DATE , ACTION.ACTUAL_RESOLUTION_DATE , ACTION.SERVICE_INVENTORY_ITEM_ID , ACTION.EFFORT_MINUTES , ACTION.COMPLETION_DATE , ACTION.START_DATE_ACTIVE , ACTION.END_DATE_ACTIVE , ACTION.CREATION_DATE , ACTION.CREATED_BY , ACTION.LAST_UPDATED_BY , ACTION.LAST_UPDATE_DATE , ACTION.LAST_UPDATE_LOGIN , ACTION.ATTRIBUTE1 , ACTION.ATTRIBUTE2 , ACTION.ATTRIBUTE3 , ACTION.ATTRIBUTE4 , ACTION.ATTRIBUTE5 , ACTION.ATTRIBUTE6 , ACTION.ATTRIBUTE7 , ACTION.ATTRIBUTE8 , ACTION.ATTRIBUTE9 , ACTION.ATTRIBUTE10 , ACTION.ATTRIBUTE11 , ACTION.ATTRIBUTE12 , ACTION.ATTRIBUTE13 , ACTION.ATTRIBUTE14 , ACTION.ATTRIBUTE15 , ACTION.CONTEXT , ACTION.OPEN_FLAG , ACTION.ACTUAL_TIME , STATUS.NAME ACTION_STATUS_MEANING , TYPE.NAME ACTION_TYPE_MEANING , SEVERITY.NAME ACTION_SEVERITY_MEANING , USERS.FULL_NAME ACTION_ASSIGNEE , CS_SR_UTIL_PKG.GET_RELATED_STATUSES_CNT(TYPE.INCIDENT_TYPE_ID) RELATED_STATUSES_CNT_V , ACTION.WORKFLOW_PROCESS_ID , DECODE(ACTION.WORKFLOW_PROCESS_ID,NULL,'N', CS_WORKFLOW_PKG.IS_ACTION_ITEM_ACTIVE(ACTION.INCIDENT_ID, ACTION.ACTION_NUM,ACTION.WORKFLOW_PROCESS_ID)) ACTIVE_WF_PROCESS , TYPE.WORKFLOW WORKFLOW_PROCESS_NAME , CS_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME('SRACTION',TYPE.WORKFLOW) WORKFLOW_DISPLAY_NAME , ACTION.DISPATCHER_ORIG_SYST , ACTION.DISPATCHER_ORIG_SYST_ID , ACTION.DISPATCH_ROLE_NAME FROM CS_INCIDENT_SEVERITIES SEVERITY, PER_ALL_PEOPLE_F USERS, CS_INCIDENT_STATUSES STATUS, CS_INCIDENT_TYPES TYPE, CS_INCIDENT_ACTIONS ACTION WHERE ACTION.ACTION_STATUS_ID = STATUS.INCIDENT_STATUS_ID (+) AND ACTION.ACTION_TYPE_ID = TYPE.INCIDENT_TYPE_ID (+) AND ACTION.RESPONSIBLE_PERSON_ID = USERS.PERSON_ID (+) AND TRUNC(SYSDATE) BETWEEN nvl(USERS.EFFECTIVE_START_DATE,TRUNC(SYSDATE)) AND nvl(USERS.EFFECTIVE_END_DATE,TRUNC(SYSDATE)) AND ACTION.ACTION_SEVERITY_ID = SEVERITY.INCIDENT_SEVERITY_ID (+)

View Text - HTML Formatted

SELECT ACTION.ROWID ROW_ID
, ACTION.INCIDENT_ACTION_ID
, ACTION.INCIDENT_ID
, ACTION.ACTION_CODE
, ACTION.ACTION_NUM
, ACTION.ACTION_TYPE_ID
, ACTION.ACTION_STATUS_ID
, ACTION.ACTION_SEVERITY_ID
, ACTION.RESPONSIBLE_PERSON_ID ACTION_ASSIGNEE_ID
, ACTION.TEXT
, ACTION.TEXT_DESCRIPTION
, ACTION.TEXT_RESOLUTION
, ACTION.ACTION_EFFECTIVE_DATE
, ACTION.EXPECTED_RESOLUTION_DATE
, ACTION.ACTUAL_RESOLUTION_DATE
, ACTION.SERVICE_INVENTORY_ITEM_ID
, ACTION.EFFORT_MINUTES
, ACTION.COMPLETION_DATE
, ACTION.START_DATE_ACTIVE
, ACTION.END_DATE_ACTIVE
, ACTION.CREATION_DATE
, ACTION.CREATED_BY
, ACTION.LAST_UPDATED_BY
, ACTION.LAST_UPDATE_DATE
, ACTION.LAST_UPDATE_LOGIN
, ACTION.ATTRIBUTE1
, ACTION.ATTRIBUTE2
, ACTION.ATTRIBUTE3
, ACTION.ATTRIBUTE4
, ACTION.ATTRIBUTE5
, ACTION.ATTRIBUTE6
, ACTION.ATTRIBUTE7
, ACTION.ATTRIBUTE8
, ACTION.ATTRIBUTE9
, ACTION.ATTRIBUTE10
, ACTION.ATTRIBUTE11
, ACTION.ATTRIBUTE12
, ACTION.ATTRIBUTE13
, ACTION.ATTRIBUTE14
, ACTION.ATTRIBUTE15
, ACTION.CONTEXT
, ACTION.OPEN_FLAG
, ACTION.ACTUAL_TIME
, STATUS.NAME ACTION_STATUS_MEANING
, TYPE.NAME ACTION_TYPE_MEANING
, SEVERITY.NAME ACTION_SEVERITY_MEANING
, USERS.FULL_NAME ACTION_ASSIGNEE
, CS_SR_UTIL_PKG.GET_RELATED_STATUSES_CNT(TYPE.INCIDENT_TYPE_ID) RELATED_STATUSES_CNT_V
, ACTION.WORKFLOW_PROCESS_ID
, DECODE(ACTION.WORKFLOW_PROCESS_ID
, NULL
, 'N'
, CS_WORKFLOW_PKG.IS_ACTION_ITEM_ACTIVE(ACTION.INCIDENT_ID
, ACTION.ACTION_NUM
, ACTION.WORKFLOW_PROCESS_ID)) ACTIVE_WF_PROCESS
, TYPE.WORKFLOW WORKFLOW_PROCESS_NAME
, CS_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME('SRACTION'
, TYPE.WORKFLOW) WORKFLOW_DISPLAY_NAME
, ACTION.DISPATCHER_ORIG_SYST
, ACTION.DISPATCHER_ORIG_SYST_ID
, ACTION.DISPATCH_ROLE_NAME
FROM CS_INCIDENT_SEVERITIES SEVERITY
, PER_ALL_PEOPLE_F USERS
, CS_INCIDENT_STATUSES STATUS
, CS_INCIDENT_TYPES TYPE
, CS_INCIDENT_ACTIONS ACTION
WHERE ACTION.ACTION_STATUS_ID = STATUS.INCIDENT_STATUS_ID (+)
AND ACTION.ACTION_TYPE_ID = TYPE.INCIDENT_TYPE_ID (+)
AND ACTION.RESPONSIBLE_PERSON_ID = USERS.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN NVL(USERS.EFFECTIVE_START_DATE
, TRUNC(SYSDATE))
AND NVL(USERS.EFFECTIVE_END_DATE
, TRUNC(SYSDATE))
AND ACTION.ACTION_SEVERITY_ID = SEVERITY.INCIDENT_SEVERITY_ID (+)