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]

VIEW: QRM.QRM_SAVED_ANALYSES_ROW#

Object Details

Object Name:	QRM_SAVED_ANALYSES_ROW#
Object Type:	VIEW
Owner:	QRM
Subobject Name:
Status:	VALID

[View Source]

Columns

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

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# references the following:

QRM: QRM_SAVED_ANALYSES_ROW

QRM.QRM_SAVED_ANALYSES_ROW# is referenced by following:

APPS: QRM_SAVED_ANALYSES_ROW