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_ANALYSIS_ATTS

Object Details

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

QRM_ANALYSIS_ATTS contains the setup data for analyses. Each row corresponds to a deal attribute. This table contains both saved and current attributes for analyses. Risk analysis displays results based on the saved analysis but bases its calculations on the current one. Each row has a corresponding row in QRM_ANALYSIS_SETTINGS indexed by the ANALYSIS_NAME, which represents the settings for the analysis.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QRM_ANALYSIS_ATTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_NAME ANALYSIS_NAME HISTORY_FLAG ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_NAME	VARCHAR2	(20)	Yes	Name of the deal attribute
ANALYSIS_NAME	VARCHAR2	(20)	Yes	Name of parent analysis.
HISTORY_FLAG	VARCHAR2	(1)	Yes	Indicates if analysis attribute is current (C) or saved (S).
TYPE	VARCHAR2	(1)	Yes	Type of attribute: Measure 'M', List 'L', Aggregate 'A', Column, 'C', Row 'R'
ATT_ORDER	NUMBER			The order in which the attribute is displayed or aggregated, depending on what the user selected when the analysis was set up.
TOTAL_AVERAGE	VARCHAR2	(1)		Indicates if attribute is averaged or summed: Average 'A', Sum 'T'
TOTAL_IND	VARCHAR2	(1)		Indicates if users wishes to see totals on an attribute that can be aggregated.
PERCENTAGE	VARCHAR2	(1)		Indicates if the user wishes to see percentage on am attribute that can be aggregated.
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
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ATTRIBUTE_NAME
,      ANALYSIS_NAME
,      HISTORY_FLAG
,      TYPE
,      ATT_ORDER
,      TOTAL_AVERAGE
,      TOTAL_IND
,      PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM QRM.QRM_ANALYSIS_ATTS;

Dependencies

[top of page]

QRM.QRM_ANALYSIS_ATTS does not reference any database object

QRM.QRM_ANALYSIS_ATTS is referenced by following:

QRM: QRM_ANALYSIS_ATTS#