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


TABLE: RG.RG_REPORT_REQUESTS

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


RG_REPORT_REQUESTS stores information about the reports in a report set in Financial Statement Generator. It also tracks information about the report submissions.
Each row includes a report identifier, a row set identifier, a column set identifier, and a sequence number for a report in a report set. Financial Statement Generator uses this information to join all of the report components together for creating financial statements.
The report request may belong to, and be submitted for, analysis as part of a report set, or the report request may be submitted as an independent request.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RG_REPORT_REQUESTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_REQUEST_ID
RG_REPORT_REQUESTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONCURRENT_REQUEST_ID
RG_REPORT_REQUESTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_ID
RG_REPORT_REQUESTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_SET_ID
ColumnSEQUENCE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application defining column
REPORT_REQUEST_ID NUMBER (15) Yes Primary key for table
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
ACCOUNTING_DATE DATE

Accounting date for which report is to be run
REPORT_ID NUMBER (15) Yes Report defining column
SEQUENCE NUMBER

Report sequence in the report set
FORM_SUBMISSION_FLAG VARCHAR2 (1)
Flag used to indicate whether the request has been submitted by the form
CONCURRENT_REQUEST_ID NUMBER (15)
System generated id used to monitor job using concurrent manager
REPORT_SET_ID NUMBER (15)
Report set defining column
CONTENT_SET_ID NUMBER (15)
Content set defining column
ROW_ORDER_ID NUMBER (15)
Row order defining column
EXCEPTIONS_FLAG VARCHAR2 (1)
Display only exception rows flag
ROUNDING_OPTION VARCHAR2 (1)
Rounding method
LEDGER_ID NUMBER (15)
Ledger defining column
REPORT_DISPLAY_SET_ID NUMBER (15)
Report display set defining column
ID_FLEX_CODE_11I VARCHAR2 (4)
Obsolete
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
SEGMENT_OVERRIDE_11I VARCHAR2 (2000)
Obsolete
PERIOD_NAME VARCHAR2 (15)
Period for which report is to be run
UNIT_OF_MEASURE_ID_11I VARCHAR2 (30)
Obsolete
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
RUNTIME_OPTION_CONTEXT VARCHAR2 (30)
RG_RUNTIME_OPTION descriptive flexfield structure defining column
OUTPUT_OPTION VARCHAR2 (1)
Output option
ID_FLEX_CODE VARCHAR2 (4)
GLLE
SEGMENT_OVERRIDE VARCHAR2 (2000)
Segment override value
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Currency
ALC_LEDGER_CURRENCY VARCHAR2 (30)
Reporting ledger currency
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_REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ACCOUNTING_DATE
,      REPORT_ID
,      SEQUENCE
,      FORM_SUBMISSION_FLAG
,      CONCURRENT_REQUEST_ID
,      REPORT_SET_ID
,      CONTENT_SET_ID
,      ROW_ORDER_ID
,      EXCEPTIONS_FLAG
,      ROUNDING_OPTION
,      LEDGER_ID
,      REPORT_DISPLAY_SET_ID
,      ID_FLEX_CODE_11I
,      STRUCTURE_ID
,      SEGMENT_OVERRIDE_11I
,      PERIOD_NAME
,      UNIT_OF_MEASURE_ID_11I
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RUNTIME_OPTION_CONTEXT
,      OUTPUT_OPTION
,      ID_FLEX_CODE
,      SEGMENT_OVERRIDE
,      UNIT_OF_MEASURE_ID
,      ALC_LEDGER_CURRENCY
,      OVERRIDE_ALC_LEDGER_CURRENCY
FROM RG.RG_REPORT_REQUESTS;

Dependencies

[top of page]

RG.RG_REPORT_REQUESTS does not reference any database object

RG.RG_REPORT_REQUESTS is referenced by following:

SchemaAPPS
SynonymRG_REPORT_REQUESTS