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_AXES

Object Details

Object Name:	RG_REPORT_AXES
Object Type:	TABLE
Owner:	RG
FND Design Data:	RG.RG_REPORT_AXES
Subobject Name:
Status:	VALID

RG_REPORT_AXES stores information about all the rows and columns currently defined in Financial Statement Generator. Each row includes an axis set identifier to link the row or column to a row set or column set, a name, a currency and a parameter number to link the row or column to a specific budget or encumbrance. Each row also contains customizable formatting options. Each row contains information about one particular row or column currently defined in Financial Statement Generator.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RG_REPORT_AXES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AXIS_SET_ID AXIS_SEQ
RG_REPORT_AXES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AXIS_NAME AXIS_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application defining column
AXIS_SET_ID	NUMBER	(15)	Yes	Axis set defining column for the column set or row set
AXIS_SEQ	NUMBER		Yes	Sequence number for this column or row
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
AXIS_TYPE	VARCHAR2	(1)	Yes	Not currently used
AXIS_NAME	VARCHAR2	(30)		Name of this column or row
AMOUNT_ID	NUMBER	(15)		Amount foreign key
STANDARD_AXIS_ID	NUMBER	(15)		Amount type for this column or row
WIDTH	NUMBER	(15)		No longer used
POSITION	NUMBER	(15)		Position of column (columns only)
STRUCTURE_ID	NUMBER	(15)		No longer used
UNIT_OF_MEASURE_ID	VARCHAR2	(30)		Currency
PARAMETER_NUM	NUMBER	(15)		Control value to tie this column or row to a budget, encumbrance, or currency
PERIOD_OFFSET	NUMBER	(15)		Number of periods or days this row or column value should be offset from the runtime period or day
DESCRIPTION	VARCHAR2	(240)		Description of the column or row
DISPLAY_FLAG	VARCHAR2	(1)		Display flag indicating whether this row or column should be displayed on the report
BEFORE_AXIS_STRING	VARCHAR2	(10)		Character to print on report before this row
AFTER_AXIS_STRING	VARCHAR2	(10)		Character to print on report after this row
NUMBER_CHARACTERS_INDENTED	NUMBER	(15)		Number of characters to indent when printing this row
PAGE_BREAK_AFTER_FLAG	VARCHAR2	(1)		Flag to indicate whether to insert a page break after this row
PAGE_BREAK_BEFORE_FLAG	VARCHAR2	(1)		Flag to indicate whether to insert a page break before this row
NUMBER_LINES_SKIPPED_BEFORE	NUMBER	(15)		Number of lines to skip before displaying this row
NUMBER_LINES_SKIPPED_AFTER	NUMBER	(15)		Number of lines to skip after displaying this row
DISPLAY_LEVEL	NUMBER	(15)		Level of detail for this row or column
DISPLAY_ZERO_AMOUNT_FLAG	VARCHAR2	(1)		Flag indicating whether to display zeros for row or column
CHANGE_SIGN_FLAG	VARCHAR2	(1)		Flag to change sign of all the row or column values displayed on the report
CHANGE_VARIANCE_SIGN_FLAG	VARCHAR2	(1)		Flag to change sign on row or column variances displayed
DISPLAY_UNITS	NUMBER	(15)		Units to display the row or column values on the report (thousands, hundreds, etc.)
DISPLAY_FORMAT	VARCHAR2	(30)		Format string of row or column values indicating number of characters and position of decimal point (eg. 999.99)
CALCULATION_PRECEDENCE_FLAG	VARCHAR2	(1)		Flag to indicate whether row or column calculation overrides
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
PERCENTAGE_DIVISOR_SEQ	NUMBER			Sequence for percentage divisor
TRANSACTION_FLAG	VARCHAR2	(1)		No longer used
FORMAT_BEFORE_TEXT	VARCHAR2	(30)		Character to print in report before the format mask
FORMAT_AFTER_TEXT	VARCHAR2	(30)		Character to print in report after the format mask
FORMAT_MASK_WIDTH	NUMBER	(15)		Width of the display format
DISPLAY_PRECISION	NUMBER	(15)		The precision to display the row or column values on the report
SEGMENT_OVERRIDE_VALUE	VARCHAR2	(60)		Value of segment override
ELEMENT_ID	NUMBER	(15)		Oracle Internal use only - reserved for future use
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
,      AXIS_SET_ID
,      AXIS_SEQ
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      AXIS_TYPE
,      AXIS_NAME
,      AMOUNT_ID
,      STANDARD_AXIS_ID
,      WIDTH
,      POSITION
,      STRUCTURE_ID
,      UNIT_OF_MEASURE_ID
,      PARAMETER_NUM
,      PERIOD_OFFSET
,      DESCRIPTION
,      DISPLAY_FLAG
,      BEFORE_AXIS_STRING
,      AFTER_AXIS_STRING
,      NUMBER_CHARACTERS_INDENTED
,      PAGE_BREAK_AFTER_FLAG
,      PAGE_BREAK_BEFORE_FLAG
,      NUMBER_LINES_SKIPPED_BEFORE
,      NUMBER_LINES_SKIPPED_AFTER
,      DISPLAY_LEVEL
,      DISPLAY_ZERO_AMOUNT_FLAG
,      CHANGE_SIGN_FLAG
,      CHANGE_VARIANCE_SIGN_FLAG
,      DISPLAY_UNITS
,      DISPLAY_FORMAT
,      CALCULATION_PRECEDENCE_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PERCENTAGE_DIVISOR_SEQ
,      TRANSACTION_FLAG
,      FORMAT_BEFORE_TEXT
,      FORMAT_AFTER_TEXT
,      FORMAT_MASK_WIDTH
,      DISPLAY_PRECISION
,      SEGMENT_OVERRIDE_VALUE
,      ELEMENT_ID
,      OVERRIDE_ALC_LEDGER_CURRENCY
FROM RG.RG_REPORT_AXES;

Dependencies

[top of page]

RG.RG_REPORT_AXES does not reference any database object

RG.RG_REPORT_AXES is referenced by following:

APPS: RG_REPORT_AXES