[Home] [Help] [Dependency Information]
Object Name: | RCI_COMPL_ENV_CHG_SUMM_F |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.RCI_COMPL_ENV_CHG_SUMM_F |
Subobject Name: | |
Status: | VALID |
This fact table stores the summary data related to the Compliance Environment Change report
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RCI_COMPL_ENV_CHG_SUMM_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REPORT_DATE_JULIAN |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIN_CERTIFICATION_ID | NUMBER | Identifier for Financial Statement Certification | ||
CERT_STATUS | VARCHAR2 | (30) | Financial Statement Certification Status | |
CERT_TYPE | VARCHAR2 | (30) | Financial Statement Certification Type | |
STATEMENT_GROUP_ID | NUMBER | Identifier for Financial Statement Group import | ||
FINANCIAL_STATEMENT_ID | NUMBER | Identifier for Financial Statement | ||
FINANCIAL_ITEM_ID | NUMBER | Identifier for Financial Item | ||
ACCOUNT_GROUP_ID | NUMBER | Identifier for Financial Account Group | ||
NATURAL_ACCOUNT_ID | NUMBER | Identifier for Natural Account | ||
ORGANIZATION_ID | NUMBER | Identifier for Organization | ||
PROCESS_ID | NUMBER | Process Identifier | ||
REVISION_NUMBER | NUMBER | Process revision number | ||
NEW_REVISIONS_SINCE | NUMBER | Number of new revisions since last load | ||
REVISED_PROCESS | NUMBER | Column to indicate whether the process in this row is revised or not | ||
TOTAL_RISKS | NUMBER | column for total risks associated to the process | ||
NUM_CHANGED_RISKS | NUMBER | column for number of changed risks associated to the process | ||
TOTAL_CONTROLS | NUMBER | column for total controls associated to the process | ||
NUM_CHANGED_CONTROLS | NUMBER | column for number of changed controls associated to the process | ||
LATEST_APPR_REVISION_NUMBER | NUMBER | column to store the latest approved revision number for the process | ||
CERT_PERIOD_NAME | VARCHAR2 | (15) | Certification Period Name from GL Periods | |
CERT_PERIOD_SET_NAME | VARCHAR2 | (15) | Certification Period Set Name from GL Periods | |
SIGNIFICANT_PROCESS | VARCHAR2 | (1) | Column to say whether this process is Significant or not (Yes/No) | |
KEY_CONTROL | VARCHAR2 | (1) | Column to say whether this process is associated to a Key Control or not (Yes/No) | |
PERIOD_YEAR | NUMBER | (15) | column to store Period Year from FII time table | |
PERIOD_NUM | NUMBER | (15) | column to store Period Number from FII time table | |
QUARTER_NUM | NUMBER | (15) | column to store Quarter Number from FII time table | |
ENT_PERIOD_ID | NUMBER | column to store Enterprise Period Id from FII time table | ||
ENT_QTR_ID | NUMBER | column to store Enterprise Quarter Id from FII time table | ||
ENT_YEAR_ID | NUMBER | column to store Enterprise Year Id from FII time table | ||
REPORT_DATE_JULIAN | NUMBER | column to store julian date for the current period end date | ||
CREATION_DATE | DATE | Yes | WHO column | |
CREATED_BY | NUMBER | Yes | WHO column | |
LAST_UPDATE_DATE | DATE | Yes | WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | WHO column | |
LAST_UPDATE_LOGIN | NUMBER | WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT FIN_CERTIFICATION_ID
, CERT_STATUS
, CERT_TYPE
, STATEMENT_GROUP_ID
, FINANCIAL_STATEMENT_ID
, FINANCIAL_ITEM_ID
, ACCOUNT_GROUP_ID
, NATURAL_ACCOUNT_ID
, ORGANIZATION_ID
, PROCESS_ID
, REVISION_NUMBER
, NEW_REVISIONS_SINCE
, REVISED_PROCESS
, TOTAL_RISKS
, NUM_CHANGED_RISKS
, TOTAL_CONTROLS
, NUM_CHANGED_CONTROLS
, LATEST_APPR_REVISION_NUMBER
, CERT_PERIOD_NAME
, CERT_PERIOD_SET_NAME
, SIGNIFICANT_PROCESS
, KEY_CONTROL
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, ENT_PERIOD_ID
, ENT_QTR_ID
, ENT_YEAR_ID
, REPORT_DATE_JULIAN
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM AMW.RCI_COMPL_ENV_CHG_SUMM_F;
AMW.RCI_COMPL_ENV_CHG_SUMM_F does not reference any database object
AMW.RCI_COMPL_ENV_CHG_SUMM_F is referenced by following:
|
|
|