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_FIN_PROCESS_EVAL_SUM

Object Details

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

Holds Summarized data on Audit Evaluation and Certification Info. of Processes that have business Processes which has an impact on the Financial Items and Natural Accounts found in a Financial Certification

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_FIN_PROCESS_EVAL_SUM_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID
AMW_FIN_PROCESS_EVAL_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PROCESS_ID
AMW_FIN_PROCESS_EVAL_SUM_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PROCESS_ORG_REV_ID
AMW_FIN_PROCESS_EVAL_SUM_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CERT_OPINION_LOG_ID
AMW_FIN_PROCESS_EVAL_SUM_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	EVAL_OPINION_LOG_ID
AMW_FIN_PROCESS_EVAL_SUM_U1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	FIN_CERTIFICATION_ID ORGANIZATION_ID PROCESS_ORG_REV_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FIN_CERTIFICATION_ID	NUMBER		Yes	Financial Certification Id
PROCESS_ID	NUMBER		Yes	Process ID
CERT_OPINION_ID	NUMBER			Opinion ID for the Certification Record for this Process
EVAL_OPINION_ID	NUMBER			Audit Evaluation ID for this Procecss
UNMITIGATED_RISKS	NUMBER			Total Number of Risks for which has the latest Audit Evaluation as 'Not Effective' during the Financial Certification Period
INEFFECTIVE_CONTROLS	NUMBER			Total Number of Controls for which has the latest Audit Evaluation as 'Not Effective' during the Financial Certification Period
UNMITIGATED_RISKS_PRCNT	NUMBER			A percentage of the ratio UNMITIGATED_RISKS / RISKS_VERIFIED
INEFFECTIVE_CONTROLS_PRCNT	NUMBER			A percentage of the ratio INEFFECTIVE_CONTROLS /CONTROLS_VERIFIED
TOTAL_NUMBER_OF_SUB_PROCS	NUMBER			Number of Child Process of the Process in Context
NUMBER_OF_SUB_PROCS_CERTIFIED	NUMBER			Number of Child Process Certified of the Process in Context
SUB_PROCS_CERTIFIED_PRCNT	NUMBER			% Ratio of Child Process Certified of the Process in Context
TOTAL_NUMBER_OF_ORG_PROCS	NUMBER			Number of Organization Process of the Process in Context
NUMBER_OF_ORG_PROCS_CERTIFIED	NUMBER			Number of Organization Process Certified of the Process in Context
ORG_PROCS_CERTIFIED_PRCNT	NUMBER			% of Organization Process Certified of the Process in Context
OPEN_FINDINGS	NUMBER			Number of Findings that are still open for the Process in Context
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			Standard WHO column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER			This column is used for optimistic locking
ORGANIZATION_ID	NUMBER		Yes	Oraganization
ACCOUNT_PROCESS_FLAG	VARCHAR2	(1)		Account Process Flag
REVISION_NUMBER	NUMBER			process revision number
PROCESS_ORG_REV_ID	NUMBER			organization process revision id
CERT_OPINION_LOG_ID	NUMBER			opinion log id for a process certification
EVAL_OPINION_LOG_ID	NUMBER			Audit Evaluation History ID for this Procecss
RISKS_VERIFIED	NUMBER			Number of risked evaluated by an Auditor Evaluator
TOTAL_NUMBER_OF_RISKS	NUMBER			Total number of risks within the current finanacial certification
CONTROLS_VERIFIED	NUMBER			the Number of controls within the current financial certification are evaluated by an auditor evaulator
TOTAL_NUMBER_OF_CTRLS	NUMBER			total number of controls within the current financial certification

Query Text

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


SELECT FIN_CERTIFICATION_ID
,      PROCESS_ID
,      CERT_OPINION_ID
,      EVAL_OPINION_ID
,      UNMITIGATED_RISKS
,      INEFFECTIVE_CONTROLS
,      UNMITIGATED_RISKS_PRCNT
,      INEFFECTIVE_CONTROLS_PRCNT
,      TOTAL_NUMBER_OF_SUB_PROCS
,      NUMBER_OF_SUB_PROCS_CERTIFIED
,      SUB_PROCS_CERTIFIED_PRCNT
,      TOTAL_NUMBER_OF_ORG_PROCS
,      NUMBER_OF_ORG_PROCS_CERTIFIED
,      ORG_PROCS_CERTIFIED_PRCNT
,      OPEN_FINDINGS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      ORGANIZATION_ID
,      ACCOUNT_PROCESS_FLAG
,      REVISION_NUMBER
,      PROCESS_ORG_REV_ID
,      CERT_OPINION_LOG_ID
,      EVAL_OPINION_LOG_ID
,      RISKS_VERIFIED
,      TOTAL_NUMBER_OF_RISKS
,      CONTROLS_VERIFIED
,      TOTAL_NUMBER_OF_CTRLS
FROM AMW.AMW_FIN_PROCESS_EVAL_SUM;

Dependencies

[top of page]

AMW.AMW_FIN_PROCESS_EVAL_SUM does not reference any database object

AMW.AMW_FIN_PROCESS_EVAL_SUM is referenced by following:

APPS: AMW_FIN_PROCESS_EVAL_SUM