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.

VIEW: QRM.QRM_ANA_ATTS_LOOKUPS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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