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_CTRLS_F

Object Details

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

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCI_ORG_CERT_CTRLS_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_DATE_JULIAN

Columns

Name	Datatype	Length	Mandatory	Comments
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
CONTROL_ID	NUMBER			control identifier
CONTROL_REV_ID	NUMBER			control revision indentifier
CONTROL_TYPE	VARCHAR2	(30)		control type
CONTROL_LOCATION	VARCHAR2	(30)		control location
AUTOMATION_TYPE	VARCHAR2	(30)		control automation type
CONTROL_FREQUENCY	NUMBER			control frequency
KEY_CONTROL	VARCHAR2	(2)		indicates whether this control is a key control or not
DISCLOSURE_CONTROL	VARCHAR2	(2)		indicates whether this control is a disclosure control or not
LATEST_REV_NUM	NUMBER			indicates the latest revision number for this control
AUDIT_RESULT_CODE	VARCHAR2	(30)		stores the audit result code for this control
LAST_EVALUATED_BY_ID	NUMBER			stores the last evaluated person id for this control
LAST_EVALUATED_ON	DATE			stores the last evaluated date for this control
OP_EFF_ID	NUMBER			stores the operating effectiveness identifier for this control
DES_EFF_ID	NUMBER			stores the design effectiveness identifier for this control
PERIOD_YEAR	NUMBER	(15)		period year for the financial certification
PERIOD_NUM	NUMBER	(15)		period number for the financial certification
QUARTER_NUM	NUMBER	(15)		quarter number for the financial certification
ENT_PERIOD_ID	NUMBER			enterprise period id for the financial certification from FII tbls.
ENT_QTR_ID	NUMBER			enterprise quarter id for the financial certification from FII tbls.
ENT_YEAR_ID	NUMBER			enterprise year id for the financial certification from FII tbls.
REPORT_DATE_JULIAN	NUMBER			stores the julian date for the 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 FIN_CERTIFICATION_ID
,      CERTIFICATION_ID
,      CERTIFICATION_STATUS
,      CERTIFICATION_TYPE
,      CERTIFICATION_PERIOD_NAME
,      CERTIFICATION_PERIOD_SET_NAME
,      ORGANIZATION_ID
,      PROCESS_ID
,      NATURAL_ACCOUNT_ID
,      CONTROL_ID
,      CONTROL_REV_ID
,      CONTROL_TYPE
,      CONTROL_LOCATION
,      AUTOMATION_TYPE
,      CONTROL_FREQUENCY
,      KEY_CONTROL
,      DISCLOSURE_CONTROL
,      LATEST_REV_NUM
,      AUDIT_RESULT_CODE
,      LAST_EVALUATED_BY_ID
,      LAST_EVALUATED_ON
,      OP_EFF_ID
,      DES_EFF_ID
,      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_CTRLS_F;

Dependencies

[top of page]

AMW.RCI_ORG_CERT_CTRLS_F does not reference any database object

AMW.RCI_ORG_CERT_CTRLS_F is referenced by following:

APPS: RCI_ORG_CERT_CTRLS_F