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

TABLE: AMW.RCI_OPEN_ISSUES_F

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


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


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

identifier for change request
CHANGE_NAME VARCHAR2 (240)
name of change request created
DESCRIPTION VARCHAR2 (2000)
description of change request created
STATUS_TYPE NUMBER

change request status type
STATUS_CODE NUMBER

change request status code
CHANGE_ORDER_TYPE_ID NUMBER

identifier for change order type
CHANGE_MGMT_TYPE_CODE VARCHAR2 (30)
change order type code
INITIATION_DATE DATE

change request initiation date
NEED_BY_DATE DATE

change request need by date
PRIORITY_CODE VARCHAR2 (10)
change request priority code
REASON_CODE VARCHAR2 (10)
change request reason code
CERTIFICATION_ID NUMBER

identifier for process certification
ORGANIZATION_ID NUMBER

identifier for organization
PROCESS_ID NUMBER

identifier for process
OPEN NUMBER

indicate whether change request is open or not
PAST_DUE NUMBER

indicate whether change request is past due or not
AGE NUMBER

column for storing age of the change request
AGE_DISTRIBUTION_1 NUMBER

column for age distribution e.g. 0-1 days
AGE_DISTRIBUTION_2 NUMBER

column for age distribution e.g. 2-5 days
AGE_DISTRIBUTION_3 NUMBER

column for age distribution e.g. 6-10 days
AGE_DISTRIBUTION_4 NUMBER

column for age distribution e.g. >10 days
FIN_CERT_ID NUMBER

identifier for financial statement certification
FIN_CERT_TYPE VARCHAR2 (10)
financial statement certification type
FIN_CERT_STATUS VARCHAR2 (30)
financial statement certification status
PERIOD_YEAR NUMBER (15)
period year for the financial certification period
PERIOD_NUM NUMBER (15)
period number for the financial certification period
QUARTER_NUM NUMBER (15)
quarter number for the financial certification period
ENT_PERIOD_ID NUMBER

enterprise period identifier from fii tbls
ENT_QTR_ID NUMBER

enterprise quarter identifier from fii tbls
ENT_YEAR_ID NUMBER

enterprise year identifier from fii tbls
REPORT_DATE_JULIAN NUMBER

column for storing julian date
OPEN_QTR NUMBER

indicates whether or not this quarter is open
PAST_DUE_QTR NUMBER

indicates whether or not this quarter is past due
AGE_QTR NUMBER

column to store age of the quarter
AGE_DISTRIBUTION1_QTR NUMBER

column to store age distribution for quarter
AGE_DISTRIBUTION2_QTR NUMBER

column to store age distribution for quarter
AGE_DISTRIBUTION3_QTR NUMBER

column to store age distribution for quarter
AGE_DISTRIBUTION4_QTR NUMBER

column to store age distribution for quarter
OPEN_YR NUMBER

indicates whether this current period year is open or not
PAST_DUE_YR NUMBER

indicates whether the request is past due in the current year or not
AGE_YR NUMBER

age of change request in years
AGE_DISTRIBUTION1_YR NUMBER

column to store age distribution of change request in years
AGE_DISTRIBUTION2_YR NUMBER

column to store age distribution of change request in years
AGE_DISTRIBUTION3_YR NUMBER

column to store age distribution of change request in years
AGE_DISTRIBUTION4_YR NUMBER

column to store age distribution of change request in years
OPEN_PER NUMBER

indicates whether change request is open in this period or not
PAST_DUE_PER NUMBER

indicates whether change request is past due in this period or not
AGE_PER NUMBER

age of change request in period
AGE_DISTRIBUTION1_PER NUMBER

column to store age distribution of change request in period
AGE_DISTRIBUTION2_PER NUMBER

column to store age distribution of change request in period
AGE_DISTRIBUTION3_PER NUMBER

column to store age distribution of change request in period
AGE_DISTRIBUTION4_PER NUMBER

column to store age distribution of change request in period
IMPLEMENTATION_DATE DATE

date when change request got implemented
CANCELLATION_DATE DATE

date when change request got cancelled
Query Text

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


SELECT CHANGE_ID
,      CHANGE_NAME
,      DESCRIPTION
,      STATUS_TYPE
,      STATUS_CODE
,      CHANGE_ORDER_TYPE_ID
,      CHANGE_MGMT_TYPE_CODE
,      INITIATION_DATE
,      NEED_BY_DATE
,      PRIORITY_CODE
,      REASON_CODE
,      CERTIFICATION_ID
,      ORGANIZATION_ID
,      PROCESS_ID
,      OPEN
,      PAST_DUE
,      AGE
,      AGE_DISTRIBUTION_1
,      AGE_DISTRIBUTION_2
,      AGE_DISTRIBUTION_3
,      AGE_DISTRIBUTION_4
,      FIN_CERT_ID
,      FIN_CERT_TYPE
,      FIN_CERT_STATUS
,      PERIOD_YEAR
,      PERIOD_NUM
,      QUARTER_NUM
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
,      REPORT_DATE_JULIAN
,      OPEN_QTR
,      PAST_DUE_QTR
,      AGE_QTR
,      AGE_DISTRIBUTION1_QTR
,      AGE_DISTRIBUTION2_QTR
,      AGE_DISTRIBUTION3_QTR
,      AGE_DISTRIBUTION4_QTR
,      OPEN_YR
,      PAST_DUE_YR
,      AGE_YR
,      AGE_DISTRIBUTION1_YR
,      AGE_DISTRIBUTION2_YR
,      AGE_DISTRIBUTION3_YR
,      AGE_DISTRIBUTION4_YR
,      OPEN_PER
,      PAST_DUE_PER
,      AGE_PER
,      AGE_DISTRIBUTION1_PER
,      AGE_DISTRIBUTION2_PER
,      AGE_DISTRIBUTION3_PER
,      AGE_DISTRIBUTION4_PER
,      IMPLEMENTATION_DATE
,      CANCELLATION_DATE
FROM AMW.RCI_OPEN_ISSUES_F;

Dependencies

[top of page]

AMW.RCI_OPEN_ISSUES_F does not reference any database object

AMW.RCI_OPEN_ISSUES_F is referenced by following:

SchemaAPPS
SynonymRCI_OPEN_ISSUES_F