DBA Data[Home] [Help] [Dependency Information]

TABLE: QRM.QRM_SAVED_ANALYSES_ROW

Object Details
Object Name: QRM_SAVED_ANALYSES_ROW
Object Type: TABLE
Owner: QRM
FND Design Data: TableQRM.QRM_SAVED_ANALYSES_ROW
Subobject Name:
Status: VALID


QRM_SAVED_ANALYSES contains data that represents the rows in the analysis results table, except for Table style analysis. Only those analyses that were run and are still listed in the Analysis Manager have their results saved in this table. Each analysis in the Analysis Manager can only have one set of saved data in the table. Moreover, the saved data are saved in the same table format as the actual output to avoid pivoting. Each row corresponds a row in the Analysis Results table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QRM_SAVED_ANALYSES_ROW_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnANALYSIS_NAME
ColumnSEQ_NO
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_NAME VARCHAR2 (20) Yes Name of the analysis.
SEQ_NO NUMBER (5) Yes Row sequence number. The order of rows that are displayed for the analysis results table. Starts from 1.
TYPE NUMBER (5) Yes The type of data saved: -1 = Measure, 1 = Total Level 1, 2 = Total Level 2, ... 16 = Total Level 16. Risk Analysis limits the number of row aggregation levels to 16. 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, this row contains total information stored in column A1. Risk Analysis also uses the type to derive which values in this row corresponds to which results table column.
HIDDEN VARCHAR2 (1) Yes Flag to indicate whether the row is hidden (Y) or not (N).
TOT_CURRENCY VARCHAR2 (20)
Underlying currency for the totals in this row.
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.
A2 VARCHAR2 (20)
Value of attributes that can be aggregated.
A3 VARCHAR2 (20)
Value of attributes that can be aggregated.
A4 VARCHAR2 (20)
Value of attributes that can be aggregated.
A5 VARCHAR2 (20)
Value of attributes that can be aggregated.
A6 VARCHAR2 (20)
Value of attributes that can be aggregated.
A7 VARCHAR2 (20)
Value of attributes that can be aggregated.
A8 VARCHAR2 (20)
Value of attributes that can be aggregated.
A9 VARCHAR2 (20)
Value of attributes that can be aggregated.
A10 VARCHAR2 (20)
Value of attributes that can be aggregated.
A11 VARCHAR2 (20)
Value of attributes that can be aggregated.
A12 VARCHAR2 (20)
Value of attributes that can be aggregated.
A13 VARCHAR2 (20)
Value of attributes that can be aggregated.
A14 VARCHAR2 (20)
Value of attributes that can be aggregated.
A15 VARCHAR2 (20)
Value of attributes that can be aggregated.
A16 VARCHAR2 (20)
Value of attributes that can be aggregated.
M1 NUMBER

Measures
M2 NUMBER

Measures
M3 NUMBER

Measures
M4 NUMBER

Measures
M5 NUMBER

Measures
M6 NUMBER

Measures
M7 NUMBER

Measures
M8 NUMBER

Measures
M9 NUMBER

Measures
M10 NUMBER

Measures
M11 NUMBER

Measures
M12 NUMBER

Measures
M13 NUMBER

Measures
M14 NUMBER

Measures
M15 NUMBER

Measures
M16 NUMBER

Measures
M17 NUMBER

Measures
M18 NUMBER

Measures
M19 NUMBER

Measures
M20 NUMBER

Measures
M21 NUMBER

Measures
M22 NUMBER

Measures
M23 NUMBER

Measures
M24 NUMBER

Measures
M25 NUMBER

Measures
M26 NUMBER

Measures
M27 NUMBER

Measures
M28 NUMBER

Measures
M29 NUMBER

Measures
M30 NUMBER

Measures
M31 NUMBER

Measures
M32 NUMBER

Measures
M33 NUMBER

Measures
M34 NUMBER

Measures
M35 NUMBER

Measures
M36 NUMBER

Measures
M37 NUMBER

Measures
M38 NUMBER

Measures
M39 NUMBER

Measures
M40 NUMBER

Measures
M41 NUMBER

Measures
M42 NUMBER

Measures
M43 NUMBER

Measures
M44 NUMBER

Measures
M45 NUMBER

Measures
M46 NUMBER

Measures
M47 NUMBER

Measures
M48 NUMBER

Measures
M49 NUMBER

Measures
M50 NUMBER

Measures
M51 NUMBER

Measures
M52 NUMBER

Measures
M53 NUMBER

Measures
M54 NUMBER

Measures
M55 NUMBER

Measures
M56 NUMBER

Measures
M57 NUMBER

Measures
M58 NUMBER

Measures
M59 NUMBER

Measures
M60 NUMBER

Measures
M61 NUMBER

Measures
M62 NUMBER

Measures
M63 NUMBER

Measures
M64 NUMBER

Measures
M65 NUMBER

Measures
M66 NUMBER

Measures
M67 NUMBER

Measures
M68 NUMBER

Measures
M69 NUMBER

Measures
M70 NUMBER

Measures
M71 NUMBER

Measures
M72 NUMBER

Measures
M73 NUMBER

Measures
M74 NUMBER

Measures
M75 NUMBER

Measures
M76 NUMBER

Measures
M77 NUMBER

Measures
M78 NUMBER

Measures
M79 NUMBER

Measures
M80 NUMBER

Measures
M81 NUMBER

Measures
M82 NUMBER

Measures
M83 NUMBER

Measures
M84 NUMBER

Measures
M85 NUMBER

Measures
M86 NUMBER

Measures
M87 NUMBER

Measures
M88 NUMBER

Measures
M89 NUMBER

Measures
M90 NUMBER

Measures
M91 NUMBER

Measures
M92 NUMBER

Measures
M93 NUMBER

Measures
M94 NUMBER

Measures
M95 NUMBER

Measures
M96 NUMBER

Measures
M97 NUMBER

Measures
M98 NUMBER

Measures
M99 NUMBER

Measures
M100 NUMBER

Measures
P1 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P2 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P3 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P4 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P5 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P6 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P7 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P8 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P9 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P10 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P11 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P12 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P13 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P14 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P15 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P16 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P17 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P18 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P19 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P20 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P21 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P22 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P23 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P24 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P25 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P26 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P27 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P28 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P29 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P30 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P31 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P32 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P33 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P34 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P35 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P36 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P37 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P38 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P39 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P40 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P41 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P42 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P43 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P44 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P45 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P46 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P47 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P48 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P49 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P50 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P51 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P52 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P53 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P54 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P55 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P56 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P57 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P58 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P59 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P60 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P61 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P62 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P63 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P64 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P65 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P66 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P67 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P68 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P69 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P70 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P71 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P72 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P73 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P74 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P75 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P76 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P77 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P78 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P79 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P80 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P81 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P82 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P83 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P84 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P85 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P86 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P87 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P88 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P89 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P90 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P91 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P92 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P93 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P94 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P95 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P96 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P97 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P98 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P99 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P100 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
CURR1 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR2 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR3 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR4 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR5 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR6 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR7 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR8 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR9 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR10 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR11 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR12 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR13 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR14 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR15 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR16 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR17 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR18 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR19 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR20 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR21 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR22 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR23 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR24 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR25 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR26 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR27 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR28 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR29 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR30 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR31 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR32 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR33 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR34 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR35 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR36 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR37 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR38 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR39 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR40 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR41 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR42 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR43 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR44 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR45 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR46 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR47 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR48 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR49 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR50 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR51 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR52 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR53 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR54 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR55 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR56 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR57 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR58 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR59 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR60 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR61 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR62 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR63 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR64 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR65 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR66 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR67 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR68 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR69 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR70 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR71 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR72 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR73 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR74 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR75 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR76 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR77 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR78 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR79 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR80 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR81 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR82 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR83 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR84 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR85 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR86 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR87 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR88 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR89 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR90 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR91 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR92 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR93 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR94 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR95 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR96 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR97 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR98 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR99 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR100 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
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
,      TYPE
,      HIDDEN
,      TOT_CURRENCY
,      TOT_CURRENCY_LABEL
,      A1
,      A2
,      A3
,      A4
,      A5
,      A6
,      A7
,      A8
,      A9
,      A10
,      A11
,      A12
,      A13
,      A14
,      A15
,      A16
,      M1
,      M2
,      M3
,      M4
,      M5
,      M6
,      M7
,      M8
,      M9
,      M10
,      M11
,      M12
,      M13
,      M14
,      M15
,      M16
,      M17
,      M18
,      M19
,      M20
,      M21
,      M22
,      M23
,      M24
,      M25
,      M26
,      M27
,      M28
,      M29
,      M30
,      M31
,      M32
,      M33
,      M34
,      M35
,      M36
,      M37
,      M38
,      M39
,      M40
,      M41
,      M42
,      M43
,      M44
,      M45
,      M46
,      M47
,      M48
,      M49
,      M50
,      M51
,      M52
,      M53
,      M54
,      M55
,      M56
,      M57
,      M58
,      M59
,      M60
,      M61
,      M62
,      M63
,      M64
,      M65
,      M66
,      M67
,      M68
,      M69
,      M70
,      M71
,      M72
,      M73
,      M74
,      M75
,      M76
,      M77
,      M78
,      M79
,      M80
,      M81
,      M82
,      M83
,      M84
,      M85
,      M86
,      M87
,      M88
,      M89
,      M90
,      M91
,      M92
,      M93
,      M94
,      M95
,      M96
,      M97
,      M98
,      M99
,      M100
,      P1
,      P2
,      P3
,      P4
,      P5
,      P6
,      P7
,      P8
,      P9
,      P10
,      P11
,      P12
,      P13
,      P14
,      P15
,      P16
,      P17
,      P18
,      P19
,      P20
,      P21
,      P22
,      P23
,      P24
,      P25
,      P26
,      P27
,      P28
,      P29
,      P30
,      P31
,      P32
,      P33
,      P34
,      P35
,      P36
,      P37
,      P38
,      P39
,      P40
,      P41
,      P42
,      P43
,      P44
,      P45
,      P46
,      P47
,      P48
,      P49
,      P50
,      P51
,      P52
,      P53
,      P54
,      P55
,      P56
,      P57
,      P58
,      P59
,      P60
,      P61
,      P62
,      P63
,      P64
,      P65
,      P66
,      P67
,      P68
,      P69
,      P70
,      P71
,      P72
,      P73
,      P74
,      P75
,      P76
,      P77
,      P78
,      P79
,      P80
,      P81
,      P82
,      P83
,      P84
,      P85
,      P86
,      P87
,      P88
,      P89
,      P90
,      P91
,      P92
,      P93
,      P94
,      P95
,      P96
,      P97
,      P98
,      P99
,      P100
,      CURR1
,      CURR2
,      CURR3
,      CURR4
,      CURR5
,      CURR6
,      CURR7
,      CURR8
,      CURR9
,      CURR10
,      CURR11
,      CURR12
,      CURR13
,      CURR14
,      CURR15
,      CURR16
,      CURR17
,      CURR18
,      CURR19
,      CURR20
,      CURR21
,      CURR22
,      CURR23
,      CURR24
,      CURR25
,      CURR26
,      CURR27
,      CURR28
,      CURR29
,      CURR30
,      CURR31
,      CURR32
,      CURR33
,      CURR34
,      CURR35
,      CURR36
,      CURR37
,      CURR38
,      CURR39
,      CURR40
,      CURR41
,      CURR42
,      CURR43
,      CURR44
,      CURR45
,      CURR46
,      CURR47
,      CURR48
,      CURR49
,      CURR50
,      CURR51
,      CURR52
,      CURR53
,      CURR54
,      CURR55
,      CURR56
,      CURR57
,      CURR58
,      CURR59
,      CURR60
,      CURR61
,      CURR62
,      CURR63
,      CURR64
,      CURR65
,      CURR66
,      CURR67
,      CURR68
,      CURR69
,      CURR70
,      CURR71
,      CURR72
,      CURR73
,      CURR74
,      CURR75
,      CURR76
,      CURR77
,      CURR78
,      CURR79
,      CURR80
,      CURR81
,      CURR82
,      CURR83
,      CURR84
,      CURR85
,      CURR86
,      CURR87
,      CURR88
,      CURR89
,      CURR90
,      CURR91
,      CURR92
,      CURR93
,      CURR94
,      CURR95
,      CURR96
,      CURR97
,      CURR98
,      CURR99
,      CURR100
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM QRM.QRM_SAVED_ANALYSES_ROW;

Dependencies

[top of page]

QRM.QRM_SAVED_ANALYSES_ROW does not reference any database object

QRM.QRM_SAVED_ANALYSES_ROW is referenced by following:

SchemaQRM
ViewQRM_SAVED_ANALYSES_ROW#