VIEW: APPS.CS_INCIDENT_ACTION_AUDIT_V

Source

View Text - Preformatted

SELECT AUDIT1.ROWID ROW_ID , AUDIT1.INCIDENT_ACTION_AUDIT_ID , AUDIT1.LAST_UPDATE_DATE , AUDIT1.LAST_UPDATED_BY , AUDIT1.CREATION_DATE , AUDIT1.CREATED_BY , AUDIT1.LAST_UPDATE_LOGIN , AUDIT1.INCIDENT_ACTION_ID , AUDIT1.INCIDENT_ID , AUDIT1.CHANGE_ACTION_OWNER_FLAG , AUDIT1.ACTION_OWNER_ID , AUDIT1.OLD_ACTION_OWNER_ID , AUDIT1.CHANGE_ACTION_STATUS_FLAG , AUDIT1.ACTION_STATUS_ID , AUDIT1.OLD_ACTION_STATUS_ID , AUDIT1.CHANGE_ACTION_SEVERITY_FLAG , AUDIT1.ACTION_SEVERITY_ID , AUDIT1.OLD_ACTION_SEVERITY_ID , AUDIT1.CHANGE_ACTION_TYPE_FLAG , AUDIT1.ACTION_TYPE_ID , AUDIT1.OLD_ACTION_TYPE_ID , AUDIT1.CHANGE_RESPONSIBLE_GROUP_FLAG , AUDIT1.RESPONSIBLE_GROUP_ID , AUDIT1.OLD_RESPONSIBLE_GROUP_ID , AUDIT1.ACTION_RESPONSE_FLAG , AUDIT1.ACTION_RESPONSE , AUDIT1.EXPECTED_RESOLUTION_DATE , AUDIT1.OLD_EXPECTED_RESOLUTION_DATE , AUDIT1.CHANGE_EXPECTED_DATE_FLAG , USER3.USER_NAME RESPONSIBLE_PERSON , STATUS1.NAME STATUS_CODE_NEW , STATUS2.NAME STATUS_CODE_OLD , TYPE1.NAME ACTION_TYPE_NEW , TYPE2.NAME ACTION_TYPE_OLD , SEVERITY1.NAME SEVERITY_NEW , SEVERITY2.NAME SEVERITY_OLD , USER1.FULL_NAME USER_NAME_NEW , USER2.FULL_NAME USER_NAME_OLD , AUDIT1.NEW_WORKFLOW_FLAG , AUDIT1.WORKFLOW_PROCESS_ITEMKEY , CS_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME('SRACTION',AUDIT1.WORKFLOW_PROCESS_NAME) WORKFLOW_DISPLAY_NAME FROM CS_INCIDENT_ACTION_AUDIT AUDIT1, CS_INCIDENT_STATUSES STATUS1, CS_INCIDENT_STATUSES STATUS2, CS_INCIDENT_TYPES TYPE1, CS_INCIDENT_TYPES TYPE2, CS_INCIDENT_SEVERITIES SEVERITY1, CS_INCIDENT_SEVERITIES SEVERITY2, PER_PEOPLE_X USER1, PER_PEOPLE_X USER2, FND_USER USER3 WHERE AUDIT1.ACTION_STATUS_ID = STATUS1.INCIDENT_STATUS_ID(+) AND STATUS1.INCIDENT_SUBTYPE(+) = 'ACT' AND AUDIT1.OLD_ACTION_STATUS_ID = STATUS2.INCIDENT_STATUS_ID(+) AND STATUS2.INCIDENT_SUBTYPE(+) = 'ACT' AND AUDIT1.ACTION_TYPE_ID = TYPE1.INCIDENT_TYPE_ID(+) AND AUDIT1.OLD_ACTION_TYPE_ID = TYPE2.INCIDENT_TYPE_ID(+) AND AUDIT1.ACTION_SEVERITY_ID = SEVERITY1.INCIDENT_SEVERITY_ID(+) AND SEVERITY1.INCIDENT_SUBTYPE(+) = 'ACT' AND AUDIT1.OLD_ACTION_SEVERITY_ID = SEVERITY2.INCIDENT_SEVERITY_ID(+) AND SEVERITY2.INCIDENT_SUBTYPE(+) = 'ACT' AND AUDIT1.ACTION_OWNER_ID = USER1.PERSON_ID(+) AND AUDIT1.OLD_ACTION_OWNER_ID = USER2.PERSON_ID(+) AND AUDIT1.LAST_UPDATED_BY = USER3.USER_ID(+)

View Text - HTML Formatted

SELECT AUDIT1.ROWID ROW_ID
, AUDIT1.INCIDENT_ACTION_AUDIT_ID
, AUDIT1.LAST_UPDATE_DATE
, AUDIT1.LAST_UPDATED_BY
, AUDIT1.CREATION_DATE
, AUDIT1.CREATED_BY
, AUDIT1.LAST_UPDATE_LOGIN
, AUDIT1.INCIDENT_ACTION_ID
, AUDIT1.INCIDENT_ID
, AUDIT1.CHANGE_ACTION_OWNER_FLAG
, AUDIT1.ACTION_OWNER_ID
, AUDIT1.OLD_ACTION_OWNER_ID
, AUDIT1.CHANGE_ACTION_STATUS_FLAG
, AUDIT1.ACTION_STATUS_ID
, AUDIT1.OLD_ACTION_STATUS_ID
, AUDIT1.CHANGE_ACTION_SEVERITY_FLAG
, AUDIT1.ACTION_SEVERITY_ID
, AUDIT1.OLD_ACTION_SEVERITY_ID
, AUDIT1.CHANGE_ACTION_TYPE_FLAG
, AUDIT1.ACTION_TYPE_ID
, AUDIT1.OLD_ACTION_TYPE_ID
, AUDIT1.CHANGE_RESPONSIBLE_GROUP_FLAG
, AUDIT1.RESPONSIBLE_GROUP_ID
, AUDIT1.OLD_RESPONSIBLE_GROUP_ID
, AUDIT1.ACTION_RESPONSE_FLAG
, AUDIT1.ACTION_RESPONSE
, AUDIT1.EXPECTED_RESOLUTION_DATE
, AUDIT1.OLD_EXPECTED_RESOLUTION_DATE
, AUDIT1.CHANGE_EXPECTED_DATE_FLAG
, USER3.USER_NAME RESPONSIBLE_PERSON
, STATUS1.NAME STATUS_CODE_NEW
, STATUS2.NAME STATUS_CODE_OLD
, TYPE1.NAME ACTION_TYPE_NEW
, TYPE2.NAME ACTION_TYPE_OLD
, SEVERITY1.NAME SEVERITY_NEW
, SEVERITY2.NAME SEVERITY_OLD
, USER1.FULL_NAME USER_NAME_NEW
, USER2.FULL_NAME USER_NAME_OLD
, AUDIT1.NEW_WORKFLOW_FLAG
, AUDIT1.WORKFLOW_PROCESS_ITEMKEY
, CS_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME('SRACTION'
, AUDIT1.WORKFLOW_PROCESS_NAME) WORKFLOW_DISPLAY_NAME
FROM CS_INCIDENT_ACTION_AUDIT AUDIT1
, CS_INCIDENT_STATUSES STATUS1
, CS_INCIDENT_STATUSES STATUS2
, CS_INCIDENT_TYPES TYPE1
, CS_INCIDENT_TYPES TYPE2
, CS_INCIDENT_SEVERITIES SEVERITY1
, CS_INCIDENT_SEVERITIES SEVERITY2
, PER_PEOPLE_X USER1
, PER_PEOPLE_X USER2
, FND_USER USER3
WHERE AUDIT1.ACTION_STATUS_ID = STATUS1.INCIDENT_STATUS_ID(+)
AND STATUS1.INCIDENT_SUBTYPE(+) = 'ACT'
AND AUDIT1.OLD_ACTION_STATUS_ID = STATUS2.INCIDENT_STATUS_ID(+)
AND STATUS2.INCIDENT_SUBTYPE(+) = 'ACT'
AND AUDIT1.ACTION_TYPE_ID = TYPE1.INCIDENT_TYPE_ID(+)
AND AUDIT1.OLD_ACTION_TYPE_ID = TYPE2.INCIDENT_TYPE_ID(+)
AND AUDIT1.ACTION_SEVERITY_ID = SEVERITY1.INCIDENT_SEVERITY_ID(+)
AND SEVERITY1.INCIDENT_SUBTYPE(+) = 'ACT'
AND AUDIT1.OLD_ACTION_SEVERITY_ID = SEVERITY2.INCIDENT_SEVERITY_ID(+)
AND SEVERITY2.INCIDENT_SUBTYPE(+) = 'ACT'
AND AUDIT1.ACTION_OWNER_ID = USER1.PERSON_ID(+)
AND AUDIT1.OLD_ACTION_OWNER_ID = USER2.PERSON_ID(+)
AND AUDIT1.LAST_UPDATED_BY = USER3.USER_ID(+)