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: RG.RG_REPORT_REQUESTS

Object Details

Object Name:	RG_REPORT_REQUESTS
Object Type:	TABLE
Owner:	RG
FND Design Data:	RG.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RG_REPORT_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPORT_REQUEST_ID
RG_REPORT_REQUESTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONCURRENT_REQUEST_ID
RG_REPORT_REQUESTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_ID
RG_REPORT_REQUESTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_SET_ID SEQUENCE

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:

APPS: RG_REPORT_REQUESTS