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_ORGANIZATIONS

Object Details

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

Contains the count of processes , risks and controls for an organiztaion within an engagement

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_PROJECT_ID	NUMBER		Yes	Audit project Identifier
SUBSIDIARY_VS	VARCHAR2	(150)		Subsidiary vs
SUBSIDIARY_CODE	VARCHAR2	(150)		Subsidiary code
LOB_VS	VARCHAR2	(150)		Line of Business vs
LOB_CODE	VARCHAR2	(150)		Line of Business code
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
EVALUATION_OPINION_ID	NUMBER			Evaluation opinion identifier
SUB_ORGS_EVALUATED	NUMBER			number of sub organizations evaluated
INEFFECTIVE_SUB_ORGS	NUMBER			number of ineffective sub organizations
TOTAL_SUB_ORGS	NUMBER			Totam number of organizations
PROCESSES_EVALUATED	NUMBER			Number of processes evaluated
INEFFECTIVE_PROCESSES	NUMBER			Number of ineffective processes
TOTAL_PROCESSES	NUMBER			Total number of processes
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 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
,      SUBSIDIARY_VS
,      SUBSIDIARY_CODE
,      LOB_VS
,      LOB_CODE
,      ORGANIZATION_ID
,      EVALUATION_OPINION_ID
,      SUB_ORGS_EVALUATED
,      INEFFECTIVE_SUB_ORGS
,      TOTAL_SUB_ORGS
,      PROCESSES_EVALUATED
,      INEFFECTIVE_PROCESSES
,      TOTAL_PROCESSES
,      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_ORGANIZATIONS;

Dependencies

[top of page]

AMW.AMW_AUDIT_SCOPE_ORGANIZATIONS does not reference any database object

AMW.AMW_AUDIT_SCOPE_ORGANIZATIONS is referenced by following:

APPS: AMW_AUDIT_SCOPE_ORGANIZATIONS