DBA Data[Home] [Help] [Dependency Information]

TABLE: AMW.RCI_COMPL_ENV_CHG_SUMM_F

Object Details
Object Name: RCI_COMPL_ENV_CHG_SUMM_F
Object Type: TABLE
Owner: AMW
FND Design Data: TableAMW.RCI_COMPL_ENV_CHG_SUMM_F
Subobject Name:
Status: VALID


This fact table stores the summary data related to the Compliance Environment Change report


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCI_COMPL_ENV_CHG_SUMM_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_DATE_JULIAN
Columns
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
Query Text

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;

Dependencies

[top of page]

AMW.RCI_COMPL_ENV_CHG_SUMM_F does not reference any database object

AMW.RCI_COMPL_ENV_CHG_SUMM_F is referenced by following:

SchemaAPPS
SynonymRCI_COMPL_ENV_CHG_SUMM_F