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_OPEN_REMEDIATIONS_F

Object Details

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

This fact table stores the summary data related to the Open Remediations report

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCI_OPEN_REMEDIATIONS_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_DATE_JULIAN

Columns

Name	Datatype	Length	Comments
FINDING_ID	NUMBER		identifier column for Finding
REMEDIATION_ID	NUMBER		identifier column for Remediation
ORGANIZATION_ID	NUMBER		identifier column for Organization
PROCESS_ID	NUMBER		identifier column for Process
PRIORITY_CODE	VARCHAR2	(10)	this column stores Priority Code
REASON_CODE	VARCHAR2	(10)	this column stores Reason Code
PHASE_CODE	VARCHAR2	(10)	this column stores Phase Code
AGE_IN_DAYS	NUMBER		column to store the age of remediation
AGE_BUCKET_1	NUMBER		column to store Remediations number of open days -- age bucket 1 (e.g. 0-1 day)
AGE_BUCKET_2	NUMBER		column to store Remediations number of open days -- age bucket 1 (e.g. 2-3 days)
AGE_BUCKET_3	NUMBER		column to store Remediations number of open days -- age bucket 1 (e.g. 4-10 days)
AGE_BUCKET_4	NUMBER		column to store Remediations number of open days -- age bucket 1 (e.g. > 10 days)
NEED_BY_DATE	DATE		column to store Remediations need by date
COMPLETION_DATE	DATE		column to store Remediations completion date
OPEN	NUMBER	(1)	column to store whether Remediation is open or not
PAST_DUE	NUMBER	(1)	column to store whether the Open Remediation is past due date or not
PERIOD_YEAR	NUMBER	(15)	column for year from FII time tables
PERIOD_NUM	NUMBER	(15)	column for period number from FII time tables
QUARTER_NUM	NUMBER	(15)	column for quarter number from FII time tables
ENT_PERIOD_ID	NUMBER		column for enterprise period identifier from FII time tables
ENT_QTR_ID	NUMBER		column for enterprise quarter identifier from FII time tables
ENT_YEAR_ID	NUMBER		column for enterprise year identifier from FII time tables
REPORT_DATE_JULIAN	NUMBER		column to store julian date for certification period end date
CREATED_BY	NUMBER		WHO column
LAST_UPDATE_LOGIN	NUMBER		WHO column
CREATION_DATE	DATE		WHO column
LAST_UPDATED_BY	NUMBER		WHO column
LAST_UPDATE_DATE	DATE		WHO column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FINDING_ID
,      REMEDIATION_ID
,      ORGANIZATION_ID
,      PROCESS_ID
,      PRIORITY_CODE
,      REASON_CODE
,      PHASE_CODE
,      AGE_IN_DAYS
,      AGE_BUCKET_1
,      AGE_BUCKET_2
,      AGE_BUCKET_3
,      AGE_BUCKET_4
,      NEED_BY_DATE
,      COMPLETION_DATE
,      OPEN
,      PAST_DUE
,      PERIOD_YEAR
,      PERIOD_NUM
,      QUARTER_NUM
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
,      REPORT_DATE_JULIAN
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM AMW.RCI_OPEN_REMEDIATIONS_F;

Dependencies

[top of page]

AMW.RCI_OPEN_REMEDIATIONS_F does not reference any database object

AMW.RCI_OPEN_REMEDIATIONS_F is referenced by following:

APPS: RCI_OPEN_REMEDIATIONS_F