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.RCI_ORG_CERT_RISKS_F

Object Details

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

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCI_ORG_CERT_RISKS_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_DATE_JULIAN

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER			audit engagement identifier for Risk
FIN_CERTIFICATION_ID	NUMBER		Yes	financial statement certification identifier
CERTIFICATION_ID	NUMBER		Yes	process certification identifier
CERTIFICATION_STATUS	VARCHAR2	(30)		financial statement certification status
CERTIFICATION_TYPE	VARCHAR2	(30)		financial statement certification type
CERTIFICATION_PERIOD_NAME	VARCHAR2	(15)		financial statement certification period name
CERTIFICATION_PERIOD_SET_NAME	VARCHAR2	(15)		financial statement certification period set name
ORGANIZATION_ID	NUMBER		Yes	organization identifier
PROCESS_ID	NUMBER			process identifier
NATURAL_ACCOUNT_ID	NUMBER			natural account identifier
RISK_ID	NUMBER			risk identifier
MATERIAL	VARCHAR2	(2)		indicated whether this risk is a material risk or not
RISK_IMPACT	VARCHAR2	(30)		stores impact value for this risk
LIKELIHOOD	VARCHAR2	(30)		stores risk likelihood code
LAST_EVALUATOR_ID	NUMBER			stores last evaluator person id for this risk
LAST_EVALUATED_ON	DATE			stores last evaluated date for this risk
RISK_REV_ID	NUMBER			risk revision identifier
AUDIT_RESULT_CODE	VARCHAR2	(30)		stores audit result code for this risk
PERIOD_YEAR	NUMBER	(15)		stores the period year for this financial certification
PERIOD_NUM	NUMBER	(15)		stores the period number for this financial certification
QUARTER_NUM	NUMBER	(15)		stores the quarter number for this financial certification
ENT_PERIOD_ID	NUMBER			stores enterprise period identifier for this financial certification from FII tables
ENT_QTR_ID	NUMBER			stores enterprise quarter identifier for this financial certification from FII tables
ENT_YEAR_ID	NUMBER			stores enterprise year identifier for this financial certification from FII tables
REPORT_DATE_JULIAN	NUMBER			stores julian date for this financial certification period
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
,      FIN_CERTIFICATION_ID
,      CERTIFICATION_ID
,      CERTIFICATION_STATUS
,      CERTIFICATION_TYPE
,      CERTIFICATION_PERIOD_NAME
,      CERTIFICATION_PERIOD_SET_NAME
,      ORGANIZATION_ID
,      PROCESS_ID
,      NATURAL_ACCOUNT_ID
,      RISK_ID
,      MATERIAL
,      RISK_IMPACT
,      LIKELIHOOD
,      LAST_EVALUATOR_ID
,      LAST_EVALUATED_ON
,      RISK_REV_ID
,      AUDIT_RESULT_CODE
,      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_ORG_CERT_RISKS_F;

Dependencies

[top of page]

AMW.RCI_ORG_CERT_RISKS_F does not reference any database object

AMW.RCI_ORG_CERT_RISKS_F is referenced by following:

APPS: RCI_ORG_CERT_RISKS_F