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: QRM.QRM_SAVED_ANALYSES_COL

Object Details

Object Name:	QRM_SAVED_ANALYSES_COL
Object Type:	TABLE
Owner:	QRM
FND Design Data:	QRM.QRM_SAVED_ANALYSES_COL
Subobject Name:
Status:	VALID

QRM_SAVED_ANALYSES_COL contains information necessary for Risk Analysis to retrieve the relevant information stored in QRM_SAVED_ANALYSES_ROW. By iterating through all the rows in QRM_SAVED_ANALYSES_COL, Risk Analysis dynamically generates a SQL statement that retrieves the applicable rows information from QRM_SAVED_ANALYSES_ROW such that the results of that SQL statement resembles the final analysis results table.This table contains information to determine the column header names of the analysis results table, column data types, whether certain columns are to be displayed in the results table, and others. Each row in this table represents a column in the analysis results table, at least for those rows where the HIDDEN flag is not set to Y.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QRM_SAVED_ANALYSES_COL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ANALYSIS_NAME SEQ_NO

Columns

Name	Datatype	Length	Mandatory	Comments
ANALYSIS_NAME	VARCHAR2	(20)	Yes	Name of the analysis
SEQ_NO	NUMBER	(5)	Yes	Column sequence number. The order of columns displayed in the analysis results.
SEQ_NO_KEY	VARCHAR2	(255)		Foreign key to help determine which column sequence number is associated with data in QRM_SAVED_ANALYSES_ROW. This only applies to Crosstab style analyses. SEQ_NO_KEY stores either the attribute names for those attributes that are part of the row aggregation, or the physical column names that are part of the column aggregation. This column cannot be null for Cross-Tab style.
COL_NAME_MAP	VARCHAR2	(7)	Yes	Column name of QRM_SAVED_ANALYSES_ROW that this SEQ_NO (column) corresponds to. For example, if SEQ_NO is 2 and COL_NAME_MAP is A2, it means the second column in the analysis results table derives its values from column A2 in QRM_SAVED_ANALYSES_ROW.
TYPE	NUMBER	(5)	Yes	The type of data saved: -2 = Column Header, -1 = Measure, 1 = Total Level 1. Risk Analysis limits the number of column aggregation levels to 1. The total level represents the level of aggregation for which the sum was calculated. This level is derived from the ORDER column in QRM_ANALYSIS_SETTINGS. For example, if the type is 1, that column contains total information stored in column A1.
HIDDEN	VARCHAR2	(1)	Yes	Flag to indicate whether the column is hidden (Y) or not (N).
TOT_CURRENCY	VARCHAR2	(20)		Underlying currency for the total of the particular column.
TOT_CURRENCY_LABEL	VARCHAR2	(25)		Currency label that appends to the "Total" label to complete the summation labels. For example, if TOT_CURRENCY is 'USD', then the currency label will be ' (USD)'. At run time, the string 'Total' is appended to this label to form 'Total (USD)'.
A1	VARCHAR2	(20)		Value of attributes that can be aggregated.
START_DATE	DATE			Date when the time bucket starts.
END_DATE	DATE			Date when the time bucket ends.
PERCENT_COL_NAME_MAP	VARCHAR2	(7)		Specifies the corresponding column name in QRM_SAVED_ANALYSES_ROW that stores the percentage. For example, a value of P2 means the percentage value for this column in the analysis results table is stored in column P2 in QRM_SAVED_ANLAYSES_ROW. In general, the percentage for column M1 in QRM_SAVED_ANALYSES_ROW is stored in column P1 in QRM_SAVED_ANALYSES_ROW.
CURR_COL_NAME_MAP	VARCHAR2	(7)		Specifies the corresponding column name QRM_SAVED_ANALYSES_ROW that stores the underlying currency. For example, a value of CURR2 means the underlying currency for this column in the analysis results is stored in column CURR2 in QRM_SAVED_ANALYSES_ROW. In general, the underlying currency for column M1 in QRM_SAVED_ANALYSES_ROW is stored in column CURR1 in QRM_SAVED_ANALYSES_ROW.
TB_LABEL	VARCHAR2	(20)		User defined labels for the time buckets. The labels are stored in the LABEL column in QRM_TIME_INTERVALS.
COL_PERCENT_LEVEL	NUMBER	(5)		Level of aggregate that the percentage of the measures is based on. This value is analogous to the Total Level concept with the TYPE column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT ANALYSIS_NAME
,      SEQ_NO
,      SEQ_NO_KEY
,      COL_NAME_MAP
,      TYPE
,      HIDDEN
,      TOT_CURRENCY
,      TOT_CURRENCY_LABEL
,      A1
,      START_DATE
,      END_DATE
,      PERCENT_COL_NAME_MAP
,      CURR_COL_NAME_MAP
,      TB_LABEL
,      COL_PERCENT_LEVEL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM QRM.QRM_SAVED_ANALYSES_COL;

Dependencies

[top of page]

QRM.QRM_SAVED_ANALYSES_COL does not reference any database object

QRM.QRM_SAVED_ANALYSES_COL is referenced by following:

APPS: QRM_SAVED_ANALYSES_COL