eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AMW.AMW_AUDIT_SCOPE_PROCESSES

Object Details

Object Name:	AMW_AUDIT_SCOPE_PROCESSES
Object Type:	TABLE
Owner:	AMW
FND Design Data:	AMW.AMW_AUDIT_SCOPE_PROCESSES
Subobject Name:
Status:	VALID

Contains the count of risks and controls for a process in an organization in engagement

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
AUDIT_PROJECT_ID	NUMBER	Yes	Audit project indentifier
ORGANIZATION_ID	NUMBER	Yes	organization identifier
PROCESS_ID	NUMBER	Yes	process identifier
PROCESS_ORG_REV_ID	NUMBER		process organization revision identifier
EVALUATION_OPINION_ID	NUMBER		Evaluation opinion identifier
RISKS_EVALUATED	NUMBER		number of risks evaluated
UNMITIGATED_RISKS	NUMBER		number of unmitigated risks
TOTAL_RISKS	NUMBER		total number of risks
CONTROLS_EVALUATED	NUMBER		number of controls evaluated
INEFFECTIVE_CONTROLS	NUMBER		number of ineffective controls
TOTAL_CONTROLS	NUMBER		total number of controls
OPEN_FINDINGS	NUMBER		number of open findings
OPEN_ISSUES	NUMBER		number of open issues
CREATED_BY	NUMBER	Yes	Standard WHO column
CREATION_DATE	DATE	Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	Yes	Standard WHO column
SECURITY_GROUP_ID	NUMBER		Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER		This Column is used for locking purpose

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUDIT_PROJECT_ID
,      ORGANIZATION_ID
,      PROCESS_ID
,      PROCESS_ORG_REV_ID
,      EVALUATION_OPINION_ID
,      RISKS_EVALUATED
,      UNMITIGATED_RISKS
,      TOTAL_RISKS
,      CONTROLS_EVALUATED
,      INEFFECTIVE_CONTROLS
,      TOTAL_CONTROLS
,      OPEN_FINDINGS
,      OPEN_ISSUES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM AMW.AMW_AUDIT_SCOPE_PROCESSES;

Dependencies

[top of page]

AMW.AMW_AUDIT_SCOPE_PROCESSES does not reference any database object

AMW.AMW_AUDIT_SCOPE_PROCESSES is referenced by following:

APPS: AMW_AUDIT_SCOPE_PROCESSES