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_ANA_ATTS_LOOKUPS

Object Details

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

QRM_ANA_ATTS_LOOKUPS contains the deal attribute properties used to control Risk Analysis behavior. Specifically, these properties control hot to set up analyses and filters and how to calculate analyses results. Each row represents a deal attribute and its properties.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QRM_ANA_ATTS_LOOKUPS_U1	NORMAL	UNIQUE	APPS_TS_SEED	ATTRIBUTE_NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_NAME	VARCHAR2	(30)	Yes	Name of the attribute
TOTAL_AVERAGE	VARCHAR2	(1)	Yes	Indicates if the following actions can be performed on the attribute: summed (T), averaged (A), or neither (N).
AMOUNT	VARCHAR2	(1)	Yes	Indicates what the attribute's formatting type; whether it requires formatting, i.e. as an amount (Y), as an integer (I), as an regular number format (F), or not (N).
DATA_TYPE	VARCHAR2	(1)	Yes	Indicates data type of the attribute is a string (V), date (D), or number (N).
ATTRIBUTE_TYPE	VARCHAR2	(1)	Yes	Indicates if the attribute is an aggregate attribute (A), a measure (M), or a column attribute that cannot be aggregated (L).
APPLIES_TO_GAP	VARCHAR2	(1)	Yes	Indicates if the attribute applies to gap analysis (Y) or not (N).
APPLIES_TO_MAT	VARCHAR2	(1)	Yes	Indicates if the attribute applies to maturity analysis (Y) or not (N).
APPLIES_TO_POS	VARCHAR2	(1)	Yes	Indicates if the attribute applies to position analysis (Y) or not (N).
ORIGIN	VARCHAR2	(1)	Yes	Indicates if the attribute value is selected from QRM_ DEAL_CALCULATIONS table (T), QRM_CURRENT_DEALS_V view, or QRM_TB_CALCULATIONS table (B).
FILTER	VARCHAR2	(1)	Yes	Indicates if the attribute can be used as a filter (Y) or not (N).
CCY_AGGREGATE	VARCHAR2	(1)	Yes	Indicates if the attribute is a currency (Y) or not (N).
SENSITIVITY	VARCHAR2	(1)	Yes	Indicates if the attribute is a sensitivity (Y) or not (N).
MM_FX	VARCHAR2	(1)	Yes	Indicates if the attribute applies to instruments of type Money Market (M), Foreign Exchange (F), or both (A).
SHUTTLE	VARCHAR2	(1)	Yes	Indicates if the attribute visible to the user (Y) or not (N). When defining an analysis, a user can only select those attributes that are visible.
DENOMINATOR	VARCHAR2	(240)		SQL formula for the denominator if attribute requires averaging.
NUMERATOR	VARCHAR2	(240)		SQL formula for the numerator if attribute requires averaging.
ORIGIN_SOURCE	VARCHAR2	(30)	Yes	The source table or view name where the analysis results is derived. These names correspond directly to the ORIGIN column. The sources are QRM_DEAL_CALCULATIONS, QRM_CURRENT_DEALS_V, and QRM_TB_CALCULATIONS.
ORIGIN_SOURCE_ALIAS	VARCHAR2	(5)	Yes	The source table or view alias used to construct dynamic SQL necessary to retrieve the analysis results. These aliases correspond directly to the ORIGIN_SOURCE column. The aliases are DC (or QRM_DEAL_CALCULATION), V (or QRM_CURRENT_DEALS_V), and TB (or QRM_TB_CALCULATIONS).
LABEL_SOURCE	VARCHAR2	(30)		The source table or view where translated or user-defined labels are derived. Some examples are FND_LOOKUPS, XTR_DEAL_TYPES, and XTR_DEAL_SUBTYPES.
LABEL_SOURCE_ALIAS	VARCHAR2	(5)		The source table or view SQL alias where translated or user-defined labels are derived. These aliases directly correspond to the LABEL_SOURCE column. Some examples are 'dt', 'dst', 'ftot', and 'fib'. Since there are multiple FND_LOOKUP types, multiple aliases are necessary to represent them. Those aliases all start with 'f'. For example, 'ftot' corresponds to FND Lookup Type of QRM_TOTAL_LABEL and 'fib' corresponds to QRM_INTEREST_BASIS.
LOOKUP_TYPE	VARCHAR2	(30)		The FND Lookup Type for data that have translatable label.
LABEL_SOURCE_COL	VARCHAR2	(30)		The column name where the user-defined labels are stored for data that have user-defined labels. These column names belong to the tables or views defined in the LABEL_SOURCE column.
DEAL_CURRENCY_COL	VARCHAR2	(30)		Currency ATTRIBUTE_NAME that is pertinent to the data. For example: BUY_AMOUNT's deal currency column is BUY_CCY. These column names belong to the tables or views defined in the ORIGIN_SOURCE column.
RELATION_SWITCHER_COL	VARCHAR2	(30)		Contains the AK Item name for the relation switcher that the filter setup page uses to define different sets of filter relations.
VALUE_SWITCHER_COL	VARCHAR2	(30)		Contains AK Item name for the value switcher that the filter setup page uses to define different types of filter values.
NUM_DENOM_ORIGIN	VARCHAR2	(1)		Indicates the ORIGIN of the given NUMERATOR/ DENOMINATOR formulas: T (0); T and V (1); T and TB (2); and T, V, and TB (3).
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
APPLIES_TO_EQM	VARCHAR2	(1)	Yes	Applies to Equity Market
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ATTRIBUTE_NAME
,      TOTAL_AVERAGE
,      AMOUNT
,      DATA_TYPE
,      ATTRIBUTE_TYPE
,      APPLIES_TO_GAP
,      APPLIES_TO_MAT
,      APPLIES_TO_POS
,      ORIGIN
,      FILTER
,      CCY_AGGREGATE
,      SENSITIVITY
,      MM_FX
,      SHUTTLE
,      DENOMINATOR
,      NUMERATOR
,      ORIGIN_SOURCE
,      ORIGIN_SOURCE_ALIAS
,      LABEL_SOURCE
,      LABEL_SOURCE_ALIAS
,      LOOKUP_TYPE
,      LABEL_SOURCE_COL
,      DEAL_CURRENCY_COL
,      RELATION_SWITCHER_COL
,      VALUE_SWITCHER_COL
,      NUM_DENOM_ORIGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPLIES_TO_EQM
,      ZD_EDITION_NAME
FROM QRM.QRM_ANA_ATTS_LOOKUPS;

Dependencies

[top of page]

QRM.QRM_ANA_ATTS_LOOKUPS does not reference any database object

QRM.QRM_ANA_ATTS_LOOKUPS is referenced by following:

QRM: QRM_ANA_ATTS_LOOKUPS#