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

TABLE: RG.RG_REPORTS

Object Details
Object Name: RG_REPORTS
Object Type: TABLE
Owner: RG
FND Design Data: TableRG.RG_REPORTS
Subobject Name:
Status: VALID


RG_REPORTS stores information about all of the reports currently defined in Financial Statement Generator, including the row and column sets associated with the report, any content set and row order that Financial Statement Generator uses, units of measure, and the budgets or encumbrances associated with the report. Each row includes a name, row set identifier, column set identifier, content set identifier, row order identifier and the unit of measure (currency) that each report uses. Each row contains information about one report defined in Financial Statement Generator.
Financial Statement Generator uses this information to link a row, a column, and an optional content set and row order together into one report that you can submit for a report request. If a budget or encumbrance amount type is assigned to a row or column in a row set or column set, a budget or encumbrance must also be linked to the report.
If a currency is assigned to particular rows or columns in a row set or column set, the currency assigned to the report that contains that row set and/or column set overrides the currencies in the rows or columns.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RG_REPORTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_ID
RG_REPORTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnAPPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application defining column
REPORT_ID NUMBER (15) Yes Report defining column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
NAME VARCHAR2 (30) Yes Name for this report
COLUMN_SET_ID NUMBER (15) Yes Defining column for the column set for this report
ROW_SET_ID NUMBER (15) Yes Defining column for the row set for this report
ROUNDING_OPTION VARCHAR2 (1) Yes Report rounding method
OUTPUT_OPTION VARCHAR2 (1) Yes Output option
REPORT_TITLE VARCHAR2 (240) Yes Report title
REPORT_DISPLAY_SET_ID NUMBER (15)
Defining column for the optional report display set for this report
CONTENT_SET_ID NUMBER (15)
Defining column for the optional content set for this report
ROW_ORDER_ID NUMBER (15)
Defining column for the optional row order for this report
PARAMETER_SET_ID NUMBER (15)
Parameter set for running this report
UNIT_OF_MEASURE_ID_11I VARCHAR2 (30)
Obsolete
ID_FLEX_CODE_11I VARCHAR2 (4)
Obsolete
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
SEGMENT_OVERRIDE_11I VARCHAR2 (2000)
Obsolete
PERIOD_SET_NAME VARCHAR2 (15)
No longer used
MINIMUM_DISPLAY_LEVEL NUMBER (15)
Level of detail to run this predefined report at
DESCRIPTION VARCHAR2 (240)
Description of the report
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ID_FLEX_CODE VARCHAR2 (4)
GLLE
SEGMENT_OVERRIDE VARCHAR2 (2000)
Values of the segments to override at runtime
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Currency
SECURITY_FLAG VARCHAR2 (1) Yes Security flag
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
Override reporting ledger currency
Query Text

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


SELECT APPLICATION_ID
,      REPORT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      NAME
,      COLUMN_SET_ID
,      ROW_SET_ID
,      ROUNDING_OPTION
,      OUTPUT_OPTION
,      REPORT_TITLE
,      REPORT_DISPLAY_SET_ID
,      CONTENT_SET_ID
,      ROW_ORDER_ID
,      PARAMETER_SET_ID
,      UNIT_OF_MEASURE_ID_11I
,      ID_FLEX_CODE_11I
,      STRUCTURE_ID
,      SEGMENT_OVERRIDE_11I
,      PERIOD_SET_NAME
,      MINIMUM_DISPLAY_LEVEL
,      DESCRIPTION
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ID_FLEX_CODE
,      SEGMENT_OVERRIDE
,      UNIT_OF_MEASURE_ID
,      SECURITY_FLAG
,      OVERRIDE_ALC_LEDGER_CURRENCY
FROM RG.RG_REPORTS;

Dependencies

[top of page]

RG.RG_REPORTS does not reference any database object

RG.RG_REPORTS is referenced by following:

SchemaAPPS
SynonymRG_REPORTS