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]

VIEW: APPS.RG_REPORT_NAME_V

Object Details

Object Name:	RG_REPORT_NAME_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	RG.RG_REPORT_NAME_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application defining column
REPORT_ID	NUMBER	(15)	Yes	Report defining column
NAME	VARCHAR2	(30)	Yes	Name for this report
REPORT_TITLE	VARCHAR2	(240)	Yes	Report title
SECURITY_FLAG	VARCHAR2	(1)	Yes	Reserved for future use
DESCRIPTION	VARCHAR2	(240)		Description of the report
UNIT_OF_MEASURE_ID	VARCHAR2	(30)		Specific unit of measure or currency
PARAMETER_SET_ID	NUMBER	(15)		Parameter set for running this report
REPORT_DISPLAY_SET_ID	NUMBER	(15)		Defining column for the optional report display set for this report
REPORT_DISPLAY_SET	VARCHAR2	(30)		Report display set name
CONTENT_SET_ID	NUMBER	(15)		Defining column for the optional content set for this report
CONTENT_SET	VARCHAR2	(30)		Content set name
ROW_ORDER_ID	NUMBER	(15)		Defining column for the optional row order for this report
ROW_ORDER	VARCHAR2	(30)		Name of this row order
COLUMN_SET_ID	NUMBER	(15)	Yes	Defining column for the column set for this report
COLUMN_SET	VARCHAR2	(30)	Yes	Row set or column set name
ROW_SET_ID	NUMBER	(15)	Yes	Defining column for the row set for this report
ROW_SET	VARCHAR2	(30)	Yes	Row set or column set name
ROUNDING_OPTION	VARCHAR2	(1)	Yes	Report rounding method
ID_FLEX_CODE	VARCHAR2	(4)		GL# or GLAT
STRUCTURE_ID	NUMBER	(15)		Key Flexfield structure defining column
SEGMENT_OVERRIDE	VARCHAR2	(2000)		Values of the segments to override at runtime
OVERRIDE_ALC_LEDGER_CURRENCY	VARCHAR2	(30)
MINIMUM_DISPLAY_LEVEL	NUMBER	(15)
EXCEPTIONS_FLAG	CHAR	(1)
OUTPUT_OPTION	VARCHAR2	(1)	Yes
USE_PRIVILEGE	VARCHAR2	(1)

Query Text

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


SELECT APPLICATION_ID
,      REPORT_ID
,      NAME
,      REPORT_TITLE
,      SECURITY_FLAG
,      DESCRIPTION
,      UNIT_OF_MEASURE_ID
,      PARAMETER_SET_ID
,      REPORT_DISPLAY_SET_ID
,      REPORT_DISPLAY_SET
,      CONTENT_SET_ID
,      CONTENT_SET
,      ROW_ORDER_ID
,      ROW_ORDER
,      COLUMN_SET_ID
,      COLUMN_SET
,      ROW_SET_ID
,      ROW_SET
,      ROUNDING_OPTION
,      ID_FLEX_CODE
,      STRUCTURE_ID
,      SEGMENT_OVERRIDE
,      OVERRIDE_ALC_LEDGER_CURRENCY
,      MINIMUM_DISPLAY_LEVEL
,      EXCEPTIONS_FLAG
,      OUTPUT_OPTION
,      USE_PRIVILEGE
FROM APPS.RG_REPORT_NAME_V;

Dependencies

[top of page]

APPS.RG_REPORT_NAME_V references the following:

APPS: FND_DATA_SECURITY - show dependent code; FND_GLOBAL - show dependent code; RG_LOOKUPS; RG_REPORTS; RG_REPORT_AXIS_SETS; RG_REPORT_CONTENT_SETS; RG_REPORT_DISPLAY_SETS; RG_ROW_ORDERS

APPS.RG_REPORT_NAME_V is not referenced by any database object