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

TABLE: AMW.RCI_PROCESS_DETAIL_F

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


This fact table stores the summary data related to the Process Detail report


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCI_PROCESS_DETAIL_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_DATE_JULIAN
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER

Audit Project Identifier
PROCESS_ORG_REV_ID NUMBER

Process Organization Revision Identifier
FIN_CERTIFICATION_ID NUMBER
Yes Financial Statement Certification identifier
CERTIFICATION_ID NUMBER
Yes Process Certification identifier
CERTIFICATION_STATUS VARCHAR2 (30)
Financial Certification status
CERTIFICATION_TYPE VARCHAR2 (30)
Financial Certification type
CERTIFICATION_PERIOD_NAME VARCHAR2 (15)
Financial Certification Period Name from GL Periods
CERTIFICATION_PERIOD_SET_NAME VARCHAR2 (15)
Financial Certification Period Set Name from GL Periods
ORGANIZATION_ID NUMBER
Yes Organization Identifier
PROCESS_ID NUMBER
Yes Process identifier
NATURAL_ACCOUNT_ID NUMBER

Natural Account Identifier
SIGNIFICANT_PROCESS_FLAG VARCHAR2 (2)
column to indicate whether this is Significant Process
STANDARD_PROCESS_FLAG VARCHAR2 (2)
column to indicate whether this is Standard Process
PROCESS_CATEGORY VARCHAR2 (30)
column to store Process Category
CERTIFICATION_RESULT_CODE VARCHAR2 (30)
column to store Financial Certification certification audit result code
CERTIFIED_BY_ID NUMBER

column to store Financial Certification's certified by person's identifier
CERTIFIED_ON DATE

column to store the date when the Financial Certification was certified
EVALUATION_RESULT_CODE VARCHAR2 (30)
column to store the Financial Certification's evaluation result code
EVALUATED_BY_ID NUMBER

column to store the Financial Certification's evaluated by identifier
LAST_EVALUATED_ON DATE

column to store the Financial Certification's last evaluated date
PERIOD_YEAR NUMBER (15)
column to store the Financial Certification's Period Year
PERIOD_NUM NUMBER (15)
column to store the Financial Certification's Period Number
QUARTER_NUM NUMBER (15)
column to store the Financial Certification's Quarter Number
ENT_PERIOD_ID NUMBER

column to store the Financial Certification's Enterprise Period Identifier from FII tbls
ENT_QTR_ID NUMBER

column to store the Financial Certification's Enterprise Quarter Identifier from FII tbls
ENT_YEAR_ID NUMBER

column to store the Financial Certification's Enterprise Year Identifier from FII tbls
REPORT_DATE_JULIAN NUMBER

column to store the Financial Certification's Julian Date from FII tbls
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 PROJECT_ID
,      PROCESS_ORG_REV_ID
,      FIN_CERTIFICATION_ID
,      CERTIFICATION_ID
,      CERTIFICATION_STATUS
,      CERTIFICATION_TYPE
,      CERTIFICATION_PERIOD_NAME
,      CERTIFICATION_PERIOD_SET_NAME
,      ORGANIZATION_ID
,      PROCESS_ID
,      NATURAL_ACCOUNT_ID
,      SIGNIFICANT_PROCESS_FLAG
,      STANDARD_PROCESS_FLAG
,      PROCESS_CATEGORY
,      CERTIFICATION_RESULT_CODE
,      CERTIFIED_BY_ID
,      CERTIFIED_ON
,      EVALUATION_RESULT_CODE
,      EVALUATED_BY_ID
,      LAST_EVALUATED_ON
,      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_PROCESS_DETAIL_F;

Dependencies

[top of page]

AMW.RCI_PROCESS_DETAIL_F does not reference any database object

AMW.RCI_PROCESS_DETAIL_F is referenced by following:

SchemaAPPS
SynonymRCI_PROCESS_DETAIL_F