[Home] [Help]
[Dependency Information]
Object Name: | QRM_SAVED_ANALYSES_ROW |
---|---|
Object Type: | TABLE |
Owner: | QRM |
FND Design Data: | ![]() |
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.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QRM_SAVED_ANALYSES_ROW_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
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 |
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;
QRM.QRM_SAVED_ANALYSES_ROW does not reference any database object
QRM.QRM_SAVED_ANALYSES_ROW is referenced by following:
|
|
|