[Home] [Help] [Dependency Information]
Object Name: | AMW_FIN_ORG_EVAL_SUM |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.AMW_FIN_ORG_EVAL_SUM |
Subobject Name: | |
Status: | VALID |
Holds Summarized data on Audit Evaluation of Organizations that have business Processes which has an impact on the Financial Items and Natural Accounts found in a Financial Certification
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMW_FIN_ORG_EVAL_SUM_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
FIN_CERTIFICATION_ID
ORGANIZATION_ID |
AMW_FIN_ORG_EVAL_SUM_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | EVAL_OPINION_LOG_ID |
AMW_FIN_ORG_EVAL_SUM_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CERT_OPINION_LOG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIN_CERTIFICATION_ID | NUMBER | Yes | Financial Certification ID | |
ORGANIZATION_ID | NUMBER | Yes | Organization that has a Business Processes which has an impact on the Financial Items and Natural Accounts found in a Financial Certification | |
EVAL_OPINION_ID | NUMBER | Opinion ID to Link to Evaluation | ||
PROC_PENDING_CERTIFICATION | NUMBER | Total Number of Processes for which a Certification is not recorded in the given financial certification period | ||
TOTAL_NUMBER_OF_PROCS | NUMBER | Total Number of Processes Associated with the Key Accounts or Financial item in context of the Organization and Financial Statement under the current certification | ||
PROC_CERTIFIED_WITH_ISSUES | NUMBER | Total Number of Processes Associated with the Key Accounts or Financial item in context of the Organization and Financial Statement under the current certification, which is Certified as Not Effective | ||
PROC_VERIFIED | NUMBER | Total Number of Processes for which an Audit Evaluation is completed during a period which Associated with the Key Accounts or Financial item in context of the Organization and Financial Statement under the current certification | ||
PROC_WITH_INEFFECTIVE_CONTROLS | NUMBER | Total Number of Processes for which has the latest Audit Evaluation as 'Not Effective' during the Financial Certification Period | ||
UNMITIGATED_RISKS | NUMBER | Total Number of Risks for which has the latest Audit Evaluation as 'Not Effective' during the Financial Certification Period | ||
RISKS_VERIFIED | NUMBER | Total Number of Risks for which an Audit Evaluation is completed during a period | ||
INEFFECTIVE_CONTROLS | NUMBER | Total Number of Controls for which has the latest Audit Evaluation as 'Not Effective' during the Financial Certification Period | ||
CONTROLS_VERIFIED | NUMBER | Total Number of Controls for which an Audit Evaluation is completed during a period | ||
PROC_PENDING_CERT_PRCNT | NUMBER | A percentage of the ratio PROC_PENDING_CERTIFICATION / TOTAL_NUMBER_OF_PROCESSES | ||
PROCESSES_WITH_ISSUES_PRCNT | NUMBER | A percentage of the ratio PROC_CERTIFIED_WITH_ISSUES/ PROCS_FOR_CERT_DONE | ||
PROC_WITH_INEFF_CONTROLS_PRCNT | NUMBER | A percentage of the ratio PROC_WITH_INEFFECTIVE_CONTROLS/ PROC_EVALUATED | ||
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 | ||
OPEN_FINDINGS | NUMBER | Total numer of open findings | ||
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 | ||
SUBSIDIARY_VS | VARCHAR2 | (150) | Yes | Subsidiary of the Auditable Unit |
SUBSIDIARY_CODE | VARCHAR2 | (150) | Yes | Subsidiary of the Auditable Unit |
LOB_VS | VARCHAR2 | (150) | Line of Business to which the Auditable Unit Belongs to | |
LOB_CODE | VARCHAR2 | (150) | Line of Business to which the Auditable Unit Belongs to | |
CERT_OPINION_ID | NUMBER | opinion id for an organization certification | ||
EVAL_OPINION_LOG_ID | NUMBER | opinion log id for an organization evaluation | ||
CERT_OPINION_LOG_ID | NUMBER | opinion log id for an organization certification | ||
PROC_CERTIFIED | NUMBER | Number of Processes for which an Audit Evaluation is certified during a period which Associated with the Key Accounts or Financial item in context of the Organization and Financial Statement under the current certification | ||
TOTAL_NUMBER_OF_RISKS | NUMBER | Total Number of Risks which Associated with the Key Accounts or Financial item in context of the Organization and Financial Statement under the current certification | ||
TOTAL_NUMBER_OF_CTRLS | NUMBER | Total Number of Controls which Associated with the Key Accounts or Financial item in context of the Organization and Financial Statement under the current certification |
Cut, paste (and edit) the following text to query this object:
SELECT FIN_CERTIFICATION_ID
, ORGANIZATION_ID
, EVAL_OPINION_ID
, PROC_PENDING_CERTIFICATION
, TOTAL_NUMBER_OF_PROCS
, PROC_CERTIFIED_WITH_ISSUES
, PROC_VERIFIED
, PROC_WITH_INEFFECTIVE_CONTROLS
, UNMITIGATED_RISKS
, RISKS_VERIFIED
, INEFFECTIVE_CONTROLS
, CONTROLS_VERIFIED
, PROC_PENDING_CERT_PRCNT
, PROCESSES_WITH_ISSUES_PRCNT
, PROC_WITH_INEFF_CONTROLS_PRCNT
, UNMITIGATED_RISKS_PRCNT
, INEFFECTIVE_CONTROLS_PRCNT
, OPEN_FINDINGS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, SUBSIDIARY_VS
, SUBSIDIARY_CODE
, LOB_VS
, LOB_CODE
, CERT_OPINION_ID
, EVAL_OPINION_LOG_ID
, CERT_OPINION_LOG_ID
, PROC_CERTIFIED
, TOTAL_NUMBER_OF_RISKS
, TOTAL_NUMBER_OF_CTRLS
FROM AMW.AMW_FIN_ORG_EVAL_SUM;
AMW.AMW_FIN_ORG_EVAL_SUM does not reference any database object
AMW.AMW_FIN_ORG_EVAL_SUM is referenced by following:
|
|
|