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_ORG_CERT_AGGR_SUM

Object Details

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

aggregated object information within the financial certiification

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_ORG_CERT_AGGR_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERTIFICATION_ID
AMW_ORG_CERT_AGGR_SUM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID

Columns

Name	Datatype	Length	Comments
CERT_ORG_AGGR_SUM_ID	NUMBER		primary key of this table amw_org_cert_aggr_sum
CERTIFICATION_ID	NUMBER		organization certification id
OBJECT_TYPE	VARCHAR2	(30)	object type
OBJECT_ID	NUMBER		object id
SUB_ORG_CERT	NUMBER		certified sub organization
TOTAL_SUB_ORG	NUMBER		total number of sub organizations
PROCESSES_CERTIFIED	NUMBER		number of certified processes
TOTAL_PROCESSES	NUMBER		total number of processes
EVALUATED_PROCESSES	NUMBER		number of evaluated processes
INEFF_PROCESSES	NUMBER		processes that are evaluated as ineffective
UNMITIGATED_RISKS	NUMBER		number of risks that are evaluated as unmitigated
EVALUATED_RISKS	NUMBER		number of risks that are evaluated
TOTAL_RISKS	NUMBER		total number of risks
INEFFECTIVE_CONTROLS	NUMBER		number of controls that are evaluated as ineffective
EVALUATED_CONTROLS	NUMBER		number of evaluated controls
TOTAL_CONTROLS	NUMBER		total number of controls
OPEN_FINDINGS	NUMBER		total number of open findings
OPEN_ISSUES	NUMBER		total number of open issues
TOP_ORG_PROCESSES	NUMBER		total number of top organization processes
TOP_ORG_PROC_PENDING_CERT	NUMBER		total number of top organization process that are not certified
CERTIFICATION_OPINION_ID	NUMBER		opinion id for the certification
EVALUATION_OPINION_ID	NUMBER		opinion id for the evaluation
EVALUATION_OPINION_LOG_ID	NUMBER		opinion log id for the evaluation
CREATED_BY	NUMBER		Standard who column
CREATION_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER		Standard who column
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATE_LOGIN	NUMBER		Standard who column
OBJECT_VERSION_NUMBER	NUMBER		Object version number for locking
SUB_ORG_CERT_ISSUES	NUMBER		sub organizations that are certified with issues
PROC_CERT_ISSUES	NUMBER		number of processes certifiied with issues
INEFF_PROCESSES_PRCNT	NUMBER		percentage of ineffecitve processes
UNMITIGATED_RISKS_PRCNT	NUMBER		percentage of unmitigated risks
INEFF_CONTROLS_PRCNT	NUMBER		percentage of ineffective controls

Query Text

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


SELECT CERT_ORG_AGGR_SUM_ID
,      CERTIFICATION_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      SUB_ORG_CERT
,      TOTAL_SUB_ORG
,      PROCESSES_CERTIFIED
,      TOTAL_PROCESSES
,      EVALUATED_PROCESSES
,      INEFF_PROCESSES
,      UNMITIGATED_RISKS
,      EVALUATED_RISKS
,      TOTAL_RISKS
,      INEFFECTIVE_CONTROLS
,      EVALUATED_CONTROLS
,      TOTAL_CONTROLS
,      OPEN_FINDINGS
,      OPEN_ISSUES
,      TOP_ORG_PROCESSES
,      TOP_ORG_PROC_PENDING_CERT
,      CERTIFICATION_OPINION_ID
,      EVALUATION_OPINION_ID
,      EVALUATION_OPINION_LOG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SUB_ORG_CERT_ISSUES
,      PROC_CERT_ISSUES
,      INEFF_PROCESSES_PRCNT
,      UNMITIGATED_RISKS_PRCNT
,      INEFF_CONTROLS_PRCNT
FROM AMW.AMW_ORG_CERT_AGGR_SUM;

Dependencies

[top of page]

AMW.AMW_ORG_CERT_AGGR_SUM does not reference any database object

AMW.AMW_ORG_CERT_AGGR_SUM is referenced by following:

APPS: AMW_ORG_CERT_AGGR_SUM