Liren Large Software Subsidy 5/05.iso/a/a522/7.ddi/SRW132.REX

OS/2 REXX Batch file | 1990-12-05 | 65.0 KB | 5,527 lines

16   SQL*ReportWriter5    101106    srw132
7    SRW_STE
1    5
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
4    TYPE
1    2
4    NAME
1    1
1    A
5    SCOTT
3    120
2    93
1    6
7    DECIMAL
1    A
5    SCOTT
3    120
2    94
1    6
9    THOUSANDS
1    A
5    SCOTT
3    120
2    95
1    6
8    CURRENCY
1    A
5    SCOTT
3    120
2    96
1    6
6    COPIES
1    A
5    SCOTT
3    120
2    97
1    6
9    DESFORMAT
1    A
5    SCOTT
3    120
2    98
1    6
7    DESNAME
1    A
5    SCOTT
3    120
2    99
1    6
7    DESTYPE
1    A
5    SCOTT
3    120
3    103
1    2
8    Q_REPORT
1    A
5    SCOTT
3    120
3    104
1    3
8    G_REPORT
1    A
5    SCOTT
3    120
3    108
1    4
11   PAGE_HEIGHT
1    A
5    SCOTT
3    120
3    109
1    4
10   PAGE_WIDTH
1    A
5    SCOTT
3    120
3    110
1    4
11   LEFT_MARGIN
1    A
5    SCOTT
3    120
3    111
1    4
12   RIGHT_MARGIN
1    A
5    SCOTT
3    120
3    112
1    4
10   TOP_MARGIN
1    A
5    SCOTT
3    120
3    113
1    4
13   BOTTOM_MARGIN
1    A
5    SCOTT
3    120
3    116
1    4
8    COMMENTS
1    A
5    SCOTT
3    120
3    117
1    4
5    OWNER
1    A
5    SCOTT
3    120
3    118
1    4
8    MODIFIER
1    A
5    SCOTT
3    120
3    119
1    4
11   CREATE_DATE
1    A
5    SCOTT
3    120
3    120
1    4
13   MODIFIED_DATE
1    A
5    SCOTT
3    120
3    121
1    4
11   PARAM_TITLE
1    A
5    SCOTT
3    120
3    122
1    4
10   PARAM_HINT
1    A
5    SCOTT
3    120
3    123
1    4
12   PARAM_STATUS
1    A
5    SCOTT
3    120
3    124
1    6
12   WHICH_REPORT
1    A
5    SCOTT
3    120
3    125
1    2
9    Q_GRANTEE
1    A
5    SCOTT
3    120
3    126
1    3
9    G_GRANTEE
1    A
5    SCOTT
3    120
3    128
1    4
7    GRANTEE
1    A
5    SCOTT
3    120
3    129
1    2
7    Q_QUERY
1    A
5    SCOTT
3    120
3    130
1    3
7    G_QUERY
1    A
5    SCOTT
3    120
3    137
1    4
5    QUERY
1    A
5    SCOTT
3    120
3    138
1    2
12   Q_REPORTHEAD
1    A
5    SCOTT
3    120
3    139
1    3
12   G_REPORTHEAD
1    A
5    SCOTT
3    120
3    143
1    4
4    NAME
1    A
5    SCOTT
3    120
3    145
1    4
8    PARENT_1
1    A
5    SCOTT
3    120
3    152
1    2
7    Q_GROUP
1    A
5    SCOTT
3    120
3    153
1    3
7    G_GROUP
1    A
5    SCOTT
3    120
3    161
1    4
12   LINES_BEFORE
1    A
5    SCOTT
3    120
3    162
1    4
13   SPACES_BEFORE
1    A
5    SCOTT
3    120
3    163
1    4
9    INTER_ROW
1    A
5    SCOTT
3    120
3    164
1    4
11   INTER_FIELD
1    A
5    SCOTT
3    120
3    168
1    4
13   FIELDS_ACROSS
1    A
5    SCOTT
3    120
3    169
1    4
11   MULTI_PANEL
1    A
5    SCOTT
3    120
3    170
1    4
11   MATRIX_FLAG
1    A
5    SCOTT
3    120
3    172
1    4
10   GROUP_NAME
1    A
5    SCOTT
3    120
3    173
1    4
10   QUERY_NAME
1    A
5    SCOTT
3    120
3    177
1    3
9    G_QUERY_G
1    A
5    SCOTT
3    120
3    178
1    4
10   PAGE_BREAK
1    A
5    SCOTT
3    120
3    179
1    4
12   RELATIVE_POS
1    A
5    SCOTT
3    120
3    180
1    4
13   LOCATE_LABELS
1    A
5    SCOTT
3    120
3    181
1    4
12   FIELD_HILITE
1    A
5    SCOTT
3    120
3    182
1    4
12   LABEL_HILITE
1    A
5    SCOTT
3    120
3    183
1    2
7    Q_FIELD
1    A
5    SCOTT
3    120
3    184
1    3
7    G_FIELD
1    A
5    SCOTT
3    120
3    190
1    4
15   TARGET_POSITION
1    A
5    SCOTT
3    120
3    191
1    4
7    COMPUTE
1    A
5    SCOTT
3    120
3    192
1    4
7    HEADING
1    A
5    SCOTT
3    120
3    193
1    4
4    SKIP
1    A
5    SCOTT
3    120
3    195
1    4
11   FORMAT_MASK
1    A
5    SCOTT
3    120
3    196
1    4
5    WIDTH
1    A
5    SCOTT
3    120
3    200
1    4
7    REPRINT
1    A
5    SCOTT
3    120
3    202
1    4
13   LINES_BEFORE2
1    A
5    SCOTT
3    120
3    203
1    4
14   SPACES_BEFORE2
1    A
5    SCOTT
3    120
3    205
1    4
10   FIELD_NAME
1    A
5    SCOTT
3    120
3    206
1    4
11   GROUP_NAME2
1    A
5    SCOTT
3    120
3    207
1    4
11   QUERY_NAME2
1    A
5    SCOTT
3    120
3    208
1    4
11   RESET_GROUP
1    A
5    SCOTT
3    120
3    209
1    3
9    G_GROUP_F
1    A
5    SCOTT
3    120
3    210
1    4
9    DATATYPE2
1    A
5    SCOTT
3    120
3    211
1    4
8    FUNCTION
1    A
5    SCOTT
3    120
3    212
1    4
8    POSITION
1    A
5    SCOTT
3    120
3    213
1    4
9    ALIGNMENT
1    A
5    SCOTT
3    120
3    214
1    2
6    Q_LINK
1    A
5    SCOTT
3    120
3    215
1    3
6    G_LINK
1    A
5    SCOTT
3    120
3    219
1    4
11   LOCAL_TLPOS
1    A
5    SCOTT
3    120
3    224
1    4
9    PARENTC_1
1    A
5    SCOTT
3    120
3    225
1    4
9    PARENTC_2
1    A
5    SCOTT
3    120
3    231
1    2
9    Q_SUMMARY
1    A
5    SCOTT
3    120
3    232
1    3
9    G_SUMMARY
1    A
5    SCOTT
3    120
3    239
1    4
6    WIDTH2
1    A
5    SCOTT
3    120
3    241
1    4
12   FORMAT_MASK2
1    A
5    SCOTT
3    120
3    245
1    4
6    SOURCE
1    A
5    SCOTT
3    120
3    247
1    4
9    DATATYPE3
1    A
5    SCOTT
3    120
3    248
1    4
9    FUNCTION3
1    A
5    SCOTT
3    120
3    249
1    4
12   SUMMARY_NAME
1    A
5    SCOTT
3    120
3    250
1    2
6    Q_TEXT
1    A
5    SCOTT
3    120
3    251
1    3
6    G_TEXT
1    A
5    SCOTT
3    120
3    253
1    4
6    OBJECT
1    A
5    SCOTT
3    120
3    254
1    4
4    TYPE
1    A
5    SCOTT
3    120
3    255
1    4
6    EDITED
1    A
5    SCOTT
3    120
3    257
1    4
13   LINES_BEFORE3
1    A
5    SCOTT
3    120
3    258
1    4
14   SPACES_BEFORE3
1    A
5    SCOTT
3    120
3    259
1    4
6    WIDTH3
1    A
5    SCOTT
3    120
3    263
1    4
13   RELATIVE_POS3
1    A
5    SCOTT
3    120
3    264
1    3
9    G_GROUP_T
1    A
5    SCOTT
3    120
3    274
1    4
4    TEXT
1    A
5    SCOTT
3    120
3    275
1    3
7    G_PANEL
1    A
5    SCOTT
3    120
3    288
1    4
6    REPEAT
1    A
5    SCOTT
3    120
3    289
1    4
5    PANEL
1    A
5    SCOTT
3    120
3    290
1    4
5    ALIGN
1    A
5    SCOTT
3    120
3    291
1    4
8    PRINT_AT
1    A
5    SCOTT
3    120
3    297
1    4
9    FREQUENCY
1    A
5    SCOTT
3    120
3    303
1    5
2    s1
1    A
5    SCOTT
3    120
3    304
1    4
8    RESET_AT
1    A
5    SCOTT
3    120
3    306
1    2
7    Q_PARAM
1    A
5    SCOTT
3    120
3    307
1    3
7    G_PARAM
1    A
5    SCOTT
3    120
3    309
1    4
14   PARAMETER_NAME
1    A
5    SCOTT
3    120
3    311
1    4
6    WIDTH4
1    A
5    SCOTT
3    120
3    312
1    4
13   DEFAULT_VALUE
1    A
5    SCOTT
3    120
3    313
1    4
5    LABEL
1    A
5    SCOTT
3    120
3    314
1    4
10   PARAM_TYPE
1    A
5    SCOTT
3    120
3    315
1    4
10   INPUT_MASK
1    A
5    SCOTT
3    120
3    316
1    4
11   OUTPUT_MASK
1    A
5    SCOTT
3    120
3    317
1    4
5    SKIP2
1    A
5    SCOTT
3    120
3    318
1    4
9    DATATYPE4
1    A
5    SCOTT
3    120
3    325
1    4
7    VERSION
1    A
5    SCOTT
3    120
3    326
1    4
16   MODIFIED_VERSION
1    A
5    SCOTT
3    120
3    328
1    4
15   QUERY_NAME_SKIP
1    A
5    SCOTT
3    120
3    329
1    4
10   REPETITION
1    A
5    SCOTT
3    120
3    330
1    4
11   MATRIX_NAME
1    A
5    SCOTT
3    120
3    332
1    4
11   REPORT_NAME
1    A
5    SCOTT
3    120
3    336
1    3
8    G_HIDE_L
1    A
5    SCOTT
3    120
3    337
1    4
4    NULL
1    A
5    SCOTT
3    120
3    351
1    4
6    APPID6
1    A
5    SCOTT
3    120
3    355
1    4
8    UPMATCH2
1    A
5    SCOTT
3    120
3    382
1    4
5    NULL1
1    A
5    SCOTT
3    120
3    383
1    4
9    NOHL_TEXT
1    A
5    SCOTT
3    120
3    384
1    4
12   LOCAL_ITEMID
1    A
5    SCOTT
3    120
3    385
1    4
11   LOCAL_CNAME
1    A
5    SCOTT
3    120
3    386
1    4
5    APPID
1    A
5    SCOTT
3    120
3    387
1    4
7    QUERYID
1    A
5    SCOTT
3    120
3    388
1    4
8    PARENTID
1    A
5    SCOTT
3    120
3    389
1    4
13   PARENT_ITEMID
1    A
5    SCOTT
3    120
3    390
1    4
13   PARENT1_CNAME
1    A
5    SCOTT
3    120
3    391
1    4
13   PARENT2_CNAME
1    B
8    SRW_FKEY
1    6
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
8    PARENTID
1    2
11   LOCAL_TLPOS
1    2
13   FOREIGN_TLPOS
1    2
1    A
5    SCOTT
3    120
3    103
3    138
1    1
1    2
1    A
5    SCOTT
3    120
3    125
3    103
1    1
1    1
1    A
5    SCOTT
3    120
3    129
3    138
1    2
1    2
1    A
5    SCOTT
3    120
3    152
3    138
1    1
1    2
1    A
5    SCOTT
3    120
3    183
3    138
1    1
1    2
1    A
5    SCOTT
3    120
3    214
3    129
1    4
1    3
1    A
5    SCOTT
3    120
3    214
3    129
1    1
1    2
1    A
5    SCOTT
3    120
3    231
3    138
1    1
1    2
1    A
5    SCOTT
3    120
3    250
3    138
1    1
1    2
1    A
5    SCOTT
3    120
3    306
3    138
1    1
1    2
1    B
9    SRW_GROUP
2    18
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
7    QUERYID
1    2
10   PAGE_BREAK
1    2
11   GROUP_ORDER
1    2
10   REPETITION
1    2
12   LINES_BEFORE
1    2
13   SPACES_BEFORE
1    2
9    INTER_ROW
1    2
11   INTER_FIELD
1    2
12   FIELD_HILITE
1    2
12   LABEL_HILITE
1    2
12   RELATIVE_POS
1    2
13   FIELDS_ACROSS
1    2
11   MULTI_PANEL
1    1
11   MATRIX_FLAG
1    1
13   LOCATE_LABELS
1    2
1    A
5    SCOTT
3    120
3    104
3    103
0
1    2
1    1
1    1
1    0
0
0
0
0
1    1
0
0
0
1    2
1    A
5    SCOTT
3    120
3    126
3    125
0
1    3
1    1
1    2
1    0
0
0
0
0
0
0
0
0
1    2
1    A
5    SCOTT
3    120
3    130
3    129
1    1
1    4
1    1
1    2
1    0
1    2
0
0
0
1    1
0
0
0
1    2
1    A
5    SCOTT
3    120
3    139
3    138
1    2
1    1
1    1
0
0
0
0
0
0
0
0
0
0
1    2
1    A
5    SCOTT
3    120
3    153
3    152
1    1
1    8
1    1
0
1    0
0
0
2    16
1    6
1    1
3    100
0
0
1    2
1    A
5    SCOTT
3    120
3    177
3    152
1    1
1    7
1    1
1    2
1    0
0
0
0
0
1    1
0
0
0
0
1    A
5    SCOTT
3    120
3    184
3    183
1    1
2    10
1    1
0
1    2
0
1    1
0
0
0
0
0
0
1    2
1    A
5    SCOTT
3    120
3    209
3    183
1    1
1    9
1    1
1    2
1    0
1    1
0
0
0
1    1
0
0
0
1    2
1    A
5    SCOTT
3    120
3    215
3    214
0
1    6
1    1
0
1    0
0
0
0
0
1    1
0
0
0
1    2
1    A
5    SCOTT
3    120
3    232
3    231
1    1
2    11
1    1
1    2
1    0
0
0
0
0
1    1
0
0
0
1    2
1    A
5    SCOTT
3    120
3    251
3    250
1    1
2    14
1    1
0
1    0
1    1
0
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    264
3    250
1    1
2    13
1    1
1    2
1    0
1    1
0
0
0
1    1
0
0
0
1    2
1    A
5    SCOTT
3    120
3    275
3    250
0
2    15
1    1
1    2
1    0
1    1
0
0
0
1    1
0
0
0
0
1    A
5    SCOTT
3    120
3    307
3    306
1    1
2    12
1    1
1    2
1    0
0
0
0
0
1    1
0
0
0
0
1    A
5    SCOTT
3    120
3    336
3    214
1    1
1    5
1    1
1    1
1    0
0
0
0
0
1    1
0
0
0
1    2
1    B
9    SRW_PARAM
2    12
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
11   PARAM_ORDER
1    2
8    DATATYPE
1    2
5    WIDTH
1    2
13   DEFAULT_VALUE
1    1
5    LABEL
1    1
10   PARAM_TYPE
1    2
10   INPUT_MASK
1    1
11   OUTPUT_MASK
1    1
4    SKIP
1    1
1    A
5    SCOTT
3    120
3    124
1    1
1    2
2    30
1    %
22   Which Report (or Wild)
1    1
0
0
0
1    A
5    SCOTT
3    120
2    99
1    2
1    2
2    80
6    Screen
26   Screen/Printer/File/Sysout
1    0
0
0
0
1    A
5    SCOTT
3    120
2    98
1    3
1    2
2    80
10   srw132.lis
24   File Name / Spool Device
1    0
0
0
1    X
1    A
5    SCOTT
3    120
2    97
1    4
1    2
2    80
6    dec180
24   Printer Description File
1    0
0
0
1    X
1    A
5    SCOTT
3    120
2    96
1    5
1    1
1    2
1    1
16   Number of Copies
1    0
0
0
1    X
1    A
5    SCOTT
3    120
2    95
1    6
1    2
1    4
1    $
15   Currency Symbol
1    0
0
0
1    X
1    A
5    SCOTT
3    120
2    94
1    7
1    2
1    1
1    .
19   Thousands Separator
1    0
0
0
1    X
1    A
5    SCOTT
3    120
2    93
1    8
1    2
1    1
1    ,
17   Decimal Indicator
1    0
0
0
1    X
1    B
9    SRW_QUERY
1    7
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
8    PARENTID
1    2
15   MATRIX_PARENTID
1    2
11   QUERY_ORDER
1    2
5    QUERY
1    8
1    A
5    SCOTT
3    120
3    103
3    138
0
1    2
368  select  appid, page_height ,
  page_width        ,
  left_margin       ,
  right_margin      ,
  top_margin        ,
  bottom_margin     ,
  version           ,
  modified_version  ,
  comments          ,
  owner             ,
  modifier          ,
  create_date       ,
  modified_date     ,
  param_title       ,
  param_hint        ,
  param_status
from srw_report
1    A
5    SCOTT
3    120
3    125
3    103
0
1    3
36   select * from SRW_GRANTED
order by 2
1    A
5    SCOTT
3    120
3    129
3    138
0
1    4
422  select s.name,
       s.appid upmatch,
       q.itemid,
       query,
       p.name parent_1,
       m.name matrix_name
from srw_query q, srw_ste p, srw_ste s, srw_ste m
where q.appid           = s.appid
  and q.itemid          = s.itemid
  and q.appid           = p.appid  (+)
  and q.parentid        = p.itemid (+)
  and q.appid           = m.appid   (+)
  and q.matrix_parentid = m.itemid (+)
order by query_order asc
1    A
5    SCOTT
3    120
3    138
0
0
1    1
113  select report_name, appid, next_itemid
from srw_report
where report_name like :which_report
order by report_name
1    A
5    SCOTT
3    120
3    152
3    138
0
1    6
1222 select g.appid,
       s.name group_name,
       q.name query_name,
       matrix_flag,
       decode(repetition, 1, 'Down', 2, 'Across', 3, 'Down/Across',
                          4, 'Across/Down', 5, 'Crosstab', '') repetition,
       decode(page_break, 1, 'Conditional', 2, 'Always', '') page_break,
       decode(relative_pos,1,'Below', 2, 'Right', '') relative_pos,
       lines_before,
       spaces_before,
       inter_row,
       inter_field,
       fields_across,
       multi_panel,
       decode(locate_labels, 1, 'Above', 2, 'Left', '') locate_labels,
       decode(field_hilite, 0, 'Normal', 2, 'Underline', 4, 'Reverse',
                           16, 'Bold',   6, 'Und/Rev',  18, 'Und/Bold',
                           20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') field_hilite,

       decode(label_hilite, 0, 'Normal', 2, 'Underline', 4, 'Reverse',
                           16, 'Bold',   6, 'Und/Rev',  18, 'Und/Bold',
                           20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') label_hilite,
       Null NULL_G,
       queryid
from srw_group g, srw_ste s, srw_ste q
where g.appid = s.appid
  and g.itemid = s.itemid
  and g.appid = q.appid
  and g.queryid = q.itemid
order by group_order
1    A
5    SCOTT
3    120
3    183
3    138
0
1    7
1412 select f.appid            ,
       s.name field_name,
       decode(f.groupid,
              1, 'REPORT',
              decode (nvl(g.itemid,0),
                      0, '*Undefined*',
                      g.name)
             ) group_name,
       q.name query_name,
       target_position  ,
       compute          ,
       heading          ,
       skip             ,
       format_mask      ,
       width            ,
       decode(datatype, 1, 'NUM', 2, 'CHAR',
                         3, 'DATE', 4, 'PRT', '') datatype,
       decode(operator, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg',
                   6, '%Total', 7, 'First', 8, 'Last',
                   51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count',
                   55, 'R_Avg', 56, 'R_%Total', '') function,
       r.name reset_group      ,
       reprint          ,
       decode(relative_pos, 1, 'Bel', 2, 'Rgt', 3, 'Pnl', '') position,
       lines_before     ,
       spaces_before    ,
       decode(alignment, 1, 'Lft', 2, 'Rt', 3, 'Cen', 4, 'Wrp',
                    5, 'Var', '') alignment
from srw_field f, srw_ste s, srw_ste q, srw_ste g, srw_ste r
where f.appid = s.appid
  and f.itemid = s.itemid
  and f.appid  = q.appid (+)
  and f.source_query =  q.itemid (+)
  and f.appid  = g.appid (+)
  and f.groupid = g.itemid (+)
  and f.appid   = r.appid (+)
  and f.reset_group = r.itemid (+)
order by field_order
1    A
5    SCOTT
3    120
3    214
3    129
0
1    5
301  select k.appid,
       decode(k.parentid, q.parentid, foreign_tlpos, null) parent_1,
       decode(k.parentid, q.matrix_parentid, foreign_tlpos, null) parent_2,
       k.itemid,
       k.parentid,
       local_tlpos, null
from srw_fkey k, srw_query q
where k.appid = q.appid
  and k.itemid = q.itemid
1    A
5    SCOTT
3    120
3    231
3    138
0
1    8
898  select s.appid, s.itemid,
       n.name summary_name,
       f.name source,
  decode(datatype, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRT', '') datatype,
  decode(operator, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg',
                   6, '%Total', 7, 'First', 8, 'Last',
                   51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count',
                   55, 'R_Avg', 56, 'R_%Total', '') function,
       format_mask,
       width,
       decode(print_at, 1, 'Report', 2, 'Page', p.name) print_at,
       decode(reset_at, 1, 'Report', 2, 'Page', r.name) reset_at
from srw_summary s, srw_ste n, srw_ste f, srw_ste p, srw_ste r
where s.appid    = n.appid
  and s.itemid   = n.itemid
  and s.appid    = f.appid
  and s.fieldid  = f.itemid
  and s.appid    = p.appid  (+)
  and s.print_at = p.itemid (+)
  and s.appid    = r.appid  (+)
  and s.reset_at = r.itemid (+)
order by sum_order
1    A
5    SCOTT
3    120
3    250
3    138
0
2    10
1045 select t.appid,
       t.itemid,
       decode(t.itemid, 1, 'Report', 2, 'Page', s.name) object,
       decode(t.type, 3, 'Title Page', 4, 'Trailer Page', 5, 'Header',
                      6, 'Footer', 7, 'Column Heading', 8, 'Body',
                      9, 'Subfooter', 'Error') type,
       dirty edited,
       decode(t.relative_pos, 1, 'Below', 2, 'Rgt',
                            3, 'Pnl', 4, 'Mar', '') relative_pos,
       t.lines_before,
       t.spaces_before,
       width,
       decode(justification, 1, 'Left', 2, 'Rgt', 3, 'Cent', '') align,
       repeat,
       decode(frequency, 1, 'Report', 2, 'Page', f.name) frequency,
       panel,
       text
from srw_text t, srw_group g, srw_text_long l, srw_ste s, srw_ste f
where t.appid = g.appid (+)
  and t.itemid = g.itemid (+)
  and t.appid = s.appid (+)
  and t.itemid = s.itemid (+)
  and t.appid = l.appid
  and t.itemid = l.itemid
  and t.type = l.type
  and t.appid = f.appid (+)
  and t.frequency = f.itemid (+)
  and t.dirty = 'X'
order by group_order, t.type, panel
1    A
5    SCOTT
3    120
3    306
3    138
0
1    9
426  select p.appid        ,
       name parameter_name,
       decode(datatype, 1, 'NUM', 2, 'CHAR',
                         3, 'DATE', 4, 'PRT', '') datatype,
       width          ,
       default_value  ,
       label          ,
       param_type     ,
       input_mask     ,
       output_mask    ,
       skip
from srw_param p, srw_ste s
where p.appid = s.appid
  and p.itemid = s.itemid
order by param_order
1    E
243  SELECT APPID, PAGE_HEIGHT , PAGE_WIDTH , LEFT_MARGIN , RIGHT_MARGIN , TOP_MARGIN , BOTTOM_MARGIN , VERSION , MODIFIED_VERSION , COMMENTS , OWNER , MODIFIER , CREATE_DATE , MODIFIED_DATE , PARAM_TITLE , PARAM_HINT , PARAM_STATUS FROM SRW_REPORT
2    17
1    0
1    1
1    1
1    1
1    1
1    1
1    1
1    1
1    1
1    1
1    2
1    2
1    2
1    3
1    3
1    2
1    2
1    2
2    11
1    5
1    5
1    5
1    5
1    5
1    5
1    7
1    7
1    0
2    30
2    30
1    9
1    9
2    80
2    80
2    50
1    2
1    2
1    2
1    2
1    2
1    2
1    2
1    2
1    2
1    8
1    1
1    1
2    12
2    12
1    1
1    1
1    1
5    APPID
11   PAGE_HEIGHT
10   PAGE_WIDTH
11   LEFT_MARGIN
12   RIGHT_MARGIN
10   TOP_MARGIN
13   BOTTOM_MARGIN
7    VERSION
16   MODIFIED_VERSION
8    COMMENTS
5    OWNER
8    MODIFIER
11   CREATE_DATE
13   MODIFIED_DATE
11   PARAM_TITLE
10   PARAM_HINT
12   PARAM_STATUS
1    E
55   SELECT  "APPID", "GRANTEE"  FROM SRW_GRANTED ORDER BY 2
1    2
1    0
1    1
1    2
2    17
2    30
1    2
1    1
5    APPID
7    GRANTEE
1    E
326  SELECT S.NAME, S.APPID UPMATCH, Q.ITEMID, QUERY, P.NAME PARENT_1, M.NAME MATRIX_NAME FROM SRW_QUERY Q, SRW_STE P, SRW_STE S, SRW_STE M WHERE Q.APPID = S.APPID AND Q.ITEMID = S.ITEMID AND Q.APPID = P.APPID (+) AND Q.PARENTID = P.ITEMID (+) AND Q.APPID = M.APPID (+) AND Q.MATRIX_PARENTID = M.ITEMID (+) ORDER BY QUERY_ORDER ASC
1    6
1    0
1    2
1    1
1    1
1    2
1    2
1    2
2    80
2    11
2    11
1    0
2    80
2    80
1    1
1    2
1    2
1    8
1    1
1    1
4    NAME
7    UPMATCH
6    ITEMID
5    QUERY
8    PARENT_1
11   MATRIX_NAME
1    E
112  SELECT REPORT_NAME, APPID, NEXT_ITEMID FROM SRW_REPORT WHERE REPORT_NAME LIKE :WHICH_REPORT ORDER BY REPORT_NAME
1    3
1    1
1    2
1    1
1    1
2    80
2    11
2    11
1    1
1    2
1    2
11   REPORT_NAME
5    APPID
11   NEXT_ITEMID
3    124
1    E
944  SELECT G.APPID, S.NAME GROUP_NAME, Q.NAME QUERY_NAME, MATRIX_FLAG, DECODE(REPETITION, 1, 'Down', 2, 'Across', 3, 'Down/Across', 4, 'Across/Down', 5, 'Crosstab', '') REPETITION, DECODE(PAGE_BREAK, 1, 'Conditional', 2, 'Always', '') PAGE_BREAK, DECODE(RELATIVE_POS,1,'Below', 2, 'Right', '') RELATIVE_POS, LINES_BEFORE, SPACES_BEFORE, INTER_ROW, INTER_FIELD, FIELDS_ACROSS, MULTI_PANEL, DECODE(LOCATE_LABELS, 1, 'Above', 2, 'Left', '') LOCATE_LABELS, DECODE(FIELD_HILITE, 0, 'Normal', 2, 'Underline', 4, 'Reverse', 16, 'Bold', 6, 'Und/Rev', 18, 'Und/Bold', 20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') FIELD_HILITE, DECODE(LABEL_HILITE, 0, 'Normal', 2, 'Underline', 4, 'Reverse', 16, 'Bold', 6, 'Und/Rev', 18, 'Und/Bold', 20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') LABEL_HILITE, NULL NULL_G, QUERYID FROM SRW_GROUP G, SRW_STE S, SRW_STE Q WHERE G.APPID = S.APPID AND G.ITEMID = S.ITEMID AND G.APPID = Q.APPID AND G.QUERYID = Q.ITEMID ORDER BY GROUP_ORDER
2    18
1    0
1    1
1    2
1    2
1    2
1    2
1    2
1    2
1    1
1    1
1    1
1    1
1    1
1    2
1    2
1    2
1    2
1    2
1    1
2    11
2    80
2    80
1    1
2    11
2    11
1    5
1    5
1    5
1    5
1    5
1    5
1    1
1    5
2    12
2    12
1    0
2    11
1    2
1    1
1    1
1    1
1    1
1    1
1    1
1    2
1    2
1    2
1    2
1    2
1    1
1    1
1    1
1    1
1    1
1    2
5    APPID
10   GROUP_NAME
10   QUERY_NAME
11   MATRIX_FLAG
10   REPETITION
10   PAGE_BREAK
12   RELATIVE_POS
12   LINES_BEFORE
13   SPACES_BEFORE
9    INTER_ROW
11   INTER_FIELD
13   FIELDS_ACROSS
11   MULTI_PANEL
13   LOCATE_LABELS
12   FIELD_HILITE
12   LABEL_HILITE
6    NULL_G
7    QUERYID
1    E
1004 SELECT F.APPID , S.NAME FIELD_NAME, DECODE(F.GROUPID, 1, 'REPORT', DECODE (NVL(G.ITEMID,0), 0, '*Undefined*', G.NAME) ) GROUP_NAME, Q.NAME QUERY_NAME, TARGET_POSITION , COMPUTE , HEADING , SKIP , FORMAT_MASK , WIDTH , DECODE(DATATYPE, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRT', '') DATATYPE, DECODE(OPERATOR, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg', 6, '%Total', 7, 'First', 8, 'Last', 51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count', 55, 'R_Avg', 56, 'R_%Total', '') FUNCTION, R.NAME RESET_GROUP , REPRINT , DECODE(RELATIVE_POS, 1, 'Bel', 2, 'Rgt', 3, 'Pnl', '') POSITION, LINES_BEFORE , SPACES_BEFORE , DECODE(ALIGNMENT, 1, 'Lft', 2, 'Rt', 3, 'Cen', 4, 'Wrp', 5, 'Var', '') ALIGNMENT FROM SRW_FIELD F, SRW_STE S, SRW_STE Q, SRW_STE G, SRW_STE R WHERE F.APPID = S.APPID AND F.ITEMID = S.ITEMID AND F.APPID = Q.APPID (+) AND F.SOURCE_QUERY = Q.ITEMID (+) AND F.APPID = G.APPID (+) AND F.GROUPID = G.ITEMID (+) AND F.APPID = R.APPID (+) AND F.RESET_GROUP = R.ITEMID (+) ORDER BY FIELD_ORDER
2    18
1    0
1    1
1    2
1    2
1    2
1    1
1    2
1    2
1    2
1    2
1    1
1    2
1    2
1    2
1    2
1    2
1    1
1    1
1    2
2    11
2    80
2    80
2    80
1    5
3    240
3    240
1    1
2    40
1    5
1    4
1    8
2    80
1    1
1    3
1    5
1    5
1    3
1    2
1    1
1    1
1    1
1    2
1    1
1    1
1    1
1    1
1    2
1    1
1    1
1    1
1    1
1    1
1    2
1    2
1    1
5    APPID
10   FIELD_NAME
10   GROUP_NAME
10   QUERY_NAME
15   TARGET_POSITION
7    COMPUTE
7    HEADING
4    SKIP
11   FORMAT_MASK
5    WIDTH
8    DATATYPE
8    FUNCTION
11   RESET_GROUP
7    REPRINT
8    POSITION
12   LINES_BEFORE
13   SPACES_BEFORE
9    ALIGNMENT
1    E
263  SELECT K.APPID, DECODE(K.PARENTID, Q.PARENTID, FOREIGN_TLPOS, NULL) PARENT_1, DECODE(K.PARENTID, Q.MATRIX_PARENTID, FOREIGN_TLPOS, NULL) PARENT_2, K.ITEMID, K.PARENTID, LOCAL_TLPOS, NULL FROM SRW_FKEY K, SRW_QUERY Q WHERE K.APPID = Q.APPID AND K.ITEMID = Q.ITEMID
1    7
1    0
1    1
1    1
1    1
1    1
1    1
1    1
1    2
2    11
2    40
2    40
2    11
2    11
1    5
1    0
1    2
1    2
1    2
1    2
1    2
1    2
1    1
5    APPID
8    PARENT_1
8    PARENT_2
6    ITEMID
8    PARENTID
11   LOCAL_TLPOS
4    NULL
1    E
762  SELECT S.APPID, S.ITEMID, N.NAME SUMMARY_NAME, F.NAME SOURCE, DECODE(DATATYPE, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRT', '') DATATYPE, DECODE(OPERATOR, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg', 6, '%Total', 7, 'First', 8, 'Last', 51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count', 55, 'R_Avg', 56, 'R_%Total', '') FUNCTION, FORMAT_MASK, WIDTH, DECODE(PRINT_AT, 1, 'Report', 2, 'Page', P.NAME) PRINT_AT, DECODE(RESET_AT, 1, 'Report', 2, 'Page', R.NAME) RESET_AT FROM SRW_SUMMARY S, SRW_STE N, SRW_STE F, SRW_STE P, SRW_STE R WHERE S.APPID = N.APPID AND S.ITEMID = N.ITEMID AND S.APPID = F.APPID AND S.FIELDID = F.ITEMID AND S.APPID = P.APPID (+) AND S.PRINT_AT = P.ITEMID (+) AND S.APPID = R.APPID (+) AND S.RESET_AT = R.ITEMID (+) ORDER BY SUM_ORDER
2    10
1    0
1    1
1    1
1    2
1    2
1    2
1    2
1    2
1    1
1    2
1    2
2    11
2    11
2    80
2    80
1    4
1    8
2    40
1    5
2    80
2    80
1    2
1    2
1    1
1    1
1    1
1    1
1    1
1    2
1    1
1    1
5    APPID
6    ITEMID
12   SUMMARY_NAME
6    SOURCE
8    DATATYPE
8    FUNCTION
11   FORMAT_MASK
5    WIDTH
8    PRINT_AT
8    RESET_AT
1    E
860  SELECT T.APPID, T.ITEMID, DECODE(T.ITEMID, 1, 'Report', 2, 'Page', S.NAME) OBJECT, DECODE(T.TYPE, 3, 'Title Page', 4, 'Trailer Page', 5, 'Header', 6, 'Footer', 7, 'Column Heading', 8, 'Body', 9, 'Subfooter', 'Error') TYPE, DIRTY EDITED, DECODE(T.RELATIVE_POS, 1, 'Below', 2, 'Rgt', 3, 'Pnl', 4, 'Mar', '') RELATIVE_POS, T.LINES_BEFORE, T.SPACES_BEFORE, WIDTH, DECODE(JUSTIFICATION, 1, 'Left', 2, 'Rgt', 3, 'Cent', '') ALIGN, REPEAT, DECODE(FREQUENCY, 1, 'Report', 2, 'Page', F.NAME) FREQUENCY, PANEL, TEXT FROM SRW_TEXT T, SRW_GROUP G, SRW_TEXT_LONG L, SRW_STE S, SRW_STE F WHERE T.APPID = G.APPID (+) AND T.ITEMID = G.ITEMID (+) AND T.APPID = S.APPID (+) AND T.ITEMID = S.ITEMID (+) AND T.APPID = L.APPID AND T.ITEMID = L.ITEMID AND T.TYPE = L.TYPE AND T.APPID = F.APPID (+) AND T.FREQUENCY = F.ITEMID (+) AND T.DIRTY = 'X' ORDER BY GROUP_ORDER, T.TYPE, PANEL
2    14
1    0
1    1
1    1
1    2
1    2
1    2
1    2
1    1
1    1
1    1
1    2
1    2
1    2
1    1
1    2
2    11
2    11
2    80
2    14
1    1
1    5
1    5
1    5
1    5
1    4
1    1
2    80
1    4
1    0
1    2
1    2
1    1
1    1
1    1
1    1
1    2
1    2
1    2
1    1
1    1
1    1
1    2
1    8
5    APPID
6    ITEMID
6    OBJECT
4    TYPE
6    EDITED
12   RELATIVE_POS
12   LINES_BEFORE
13   SPACES_BEFORE
5    WIDTH
5    ALIGN
6    REPEAT
9    FREQUENCY
5    PANEL
4    TEXT
1    E
284  SELECT P.APPID , NAME PARAMETER_NAME, DECODE(DATATYPE, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRT', '') DATATYPE, WIDTH , DEFAULT_VALUE , LABEL , PARAM_TYPE , INPUT_MASK , OUTPUT_MASK , SKIP FROM SRW_PARAM P, SRW_STE S WHERE P.APPID = S.APPID AND P.ITEMID = S.ITEMID ORDER BY PARAM_ORDER
2    10
1    0
1    1
1    2
1    2
1    1
1    2
1    2
1    1
1    2
1    2
1    2
2    11
2    80
1    4
1    5
3    240
3    240
1    4
2    40
2    40
1    1
1    2
1    1
1    1
1    2
1    1
1    1
1    2
1    1
1    1
1    1
5    APPID
14   PARAMETER_NAME
8    DATATYPE
5    WIDTH
13   DEFAULT_VALUE
5    LABEL
10   PARAM_TYPE
10   INPUT_MASK
11   OUTPUT_MASK
4    SKIP
1    B
10   SRW_REPORT
2    19
5    APPID
1    2
11   NEXT_ITEMID
1    2
11   REPORT_NAME
1    1
11   PAGE_HEIGHT
1    2
10   PAGE_WIDTH
1    2
11   LEFT_MARGIN
1    2
12   RIGHT_MARGIN
1    2
10   TOP_MARGIN
1    2
13   BOTTOM_MARGIN
1    2
7    VERSION
1    2
16   MODIFIED_VERSION
1    2
8    COMMENTS
1    8
5    OWNER
1    1
8    MODIFIER
1    1
11   CREATE_DATE
2    12
13   MODIFIED_DATE
2    12
11   PARAM_TITLE
1    1
10   PARAM_HINT
1    1
12   PARAM_STATUS
1    1
1    A
3    120
3    392
6    srw132
2    60
3    132
1    0
1    0
1    0
1    2
4    1108
4    1110
1142 This report provides a complete listing of a SQL*ReportWriter report.

It is designed to run on printers supporting line lengths of at least 132
characters, such as the LN03 running with form=landscape.

A number of tricks are used to format this report which may be of interest:

* The Relative Position of the body and footer of the access list are set
  to Margin to move them "within" the report level info.
* A duplicate query of the srw_report table allows the report info, queries,
  groups, fields, summaries, and parameters could all be placed at the left
  margin.
* The queries that retrieve the names of reset and print groups employ outer
  joins so that even if the reset group wasn't a group per se, the record
  would still show with a decoded value of "Page" or "Report".
* A group containing only a single null field was created so that so that
  blank lines could separate the groups in one query from those in another
  without creating a traditional break report appearance.
* User exits translate the target list position of expressions in queries
  and also remove the highlighting information from text objects.
5    SCOTT
5    SCOTT
14   19891023123920
14   19900612154325
16    Report Listing
25    Press Accept to continue
0
1    B
9    SRW_FIELD
2    20
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
7    GROUPID
1    2
12   SOURCE_QUERY
1    2
15   TARGET_POSITION
1    2
7    COMPUTE
1    1
7    HEADING
1    1
4    SKIP
1    1
11   FIELD_ORDER
1    2
11   FORMAT_MASK
1    1
5    WIDTH
1    2
8    DATATYPE
1    2
8    OPERATOR
1    2
11   RESET_GROUP
1    2
7    REPRINT
1    1
12   RELATIVE_POS
1    2
12   LINES_BEFORE
1    2
13   SPACES_BEFORE
1    2
9    ALIGNMENT
1    2
1    A
5    SCOTT
3    120
3    108
3    104
3    103
1    2
0
6    Height
0
1    3
0
1    5
1    1
0
0
0
1    1
1    4
1    5
0
1    A
5    SCOTT
3    120
3    112
3    104
3    103
1    6
0
6    Top
0
1    4
0
1    5
1    1
0
0
0
0
0
1    5
0
1    A
5    SCOTT
3    120
3    121
3    104
3    103
2    15
0
7    Title
0
1    5
0
2    55
1    2
0
0
0
0
0
1    5
0
1    A
5    SCOTT
3    120
3    109
3    104
3    103
1    3
0
6    Width
0
1    6
0
1    5
1    1
0
0
0
1    1
0
1    5
0
1    A
5    SCOTT
3    120
3    113
3    104
3    103
1    7
0
6    Bottom
0
1    7
0
1    5
1    1
0
0
0
0
0
1    5
0
1    A
5    SCOTT
3    120
3    122
3    104
3    103
2    16
0
7    Hint
0
1    8
0
2    55
1    2
0
0
0
0
0
1    5
0
1    A
5    SCOTT
3    120
3    110
3    104
3    103
1    4
0
6    Left
0
1    9
0
1    5
1    1
0
0
0
1    1
0
2    22
0
1    A
5    SCOTT
3    120
3    123
3    104
3    103
2    17
0
7    Status
0
2    10
0
2    55
1    2
0
0
0
0
0
1    5
0
1    A
5    SCOTT
3    120
3    111
3    104
3    103
1    5
0
6    Right
0
2    11
0
1    5
1    1
0
0
0
1    1
0
2    22
0
1    A
5    SCOTT
3    120
3    116
3    104
3    103
2    10
0
0
0
2    12
0
2    76
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    117
3    104
3    103
2    11
0
9     Created:
0
2    13
0
2    29
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    119
3    104
3    103
2    13
0
0
0
2    14
9    DD-Mon-YY
1    9
1    3
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    118
3    104
3    103
2    12
0
9    Modified:
0
2    15
0
2    29
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    120
3    104
3    103
2    14
0
0
0
2    16
9    DD-Mon-YY
1    9
1    3
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    325
3    104
3    103
1    8
0
0
0
2    17
0
1    7
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    326
3    104
3    103
1    9
0
0
0
2    18
0
1    7
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    128
3    126
3    125
1    2
0
0
0
2    19
0
2    27
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    143
3    130
3    129
1    1
0
10   Query Name
0
2    20
0
2    25
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    137
3    130
3    129
1    4
0
5    Query
0
2    21
0
3    104
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    145
3    130
3    129
1    5
0
8    Parent 1
0
2    22
0
2    23
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    330
3    130
3    129
1    6
0
0
0
2    23
0
2    23
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    355
3    130
3    129
1    2
0
7    Upmatch
0
2    24
0
2    11
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    332
3    139
3    138
1    1
0
11   Report Name
0
1    1
0
2    30
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    351
3    139
3    138
1    2
0
5    Appid
0
1    2
0
2    11
1    1
0
0
0
0
0
0
1    1
1    A
5    SCOTT
3    120
3    172
3    153
3    152
1    2
0
10   Group Name
0
2    37
0
2    25
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    173
3    153
3    152
1    3
0
10   Query Name
0
2    38
0
2    25
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    170
3    153
3    152
1    4
0
6    Matrix
0
2    39
0
1    4
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    329
3    153
3    152
1    5
0
10   Repetition
0
2    40
0
2    11
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    178
3    153
3    152
1    6
0
10   Page Break
0
2    41
0
2    11
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    179
3    153
3    152
1    7
0
3    Pos
0
2    42
0
1    6
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    161
3    153
3    152
1    8
0
6    Before
0
2    43
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    162
3    153
3    152
1    9
0
6    Before
0
2    44
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    163
3    153
3    152
2    10
0
3    Row
0
2    45
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    164
3    153
3    152
2    11
0
5    Field
0
2    46
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    168
3    153
3    152
2    12
0
13   Fields Across
0
2    47
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    169
3    153
3    152
2    13
0
5    Panel
0
2    48
0
1    5
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    180
3    153
3    152
2    14
0
6    Labels
0
2    49
0
1    5
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    181
3    153
3    152
2    15
0
6    Field
0
2    50
0
2    11
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    182
3    153
3    152
2    16
0
6    Label
0
2    51
0
2    11
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    386
3    153
3    152
1    1
0
5    Appid
0
2    52
0
2    11
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    387
3    153
3    152
2    18
0
7    Queryid
0
2    53
0
2    11
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    382
3    177
3    152
2    17
0
0
0
2    35
0
1    1
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    328
3    177
3    152
1    3
0
0
1    X
2    36
0
2    80
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    205
3    184
3    183
1    2
0
10   Field Name
0
2    55
0
2    14
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    190
3    184
3    183
1    5
0
6    Expr #
0
2    56
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    191
3    184
3    183
1    6
0
7    Compute
0
2    57
0
2    13
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    207
3    184
3    183
1    4
0
5    Query
0
2    58
0
2    15
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    192
3    184
3    183
1    7
0
7    Heading
0
2    59
0
2    10
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    210
3    184
3    183
2    11
0
4    Type
0
2    60
0
1    4
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    196
3    184
3    183
2    10
0
5    Width
0
2    61
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    195
3    184
3    183
1    9
0
6    Format
0
2    62
0
1    9
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    212
3    184
3    183
2    15
0
8    Position
0
2    63
0
1    3
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    202
3    184
3    183
2    16
0
3    Bef
0
2    64
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    203
3    184
3    183
2    17
0
3    Bef
0
2    65
0
1    3
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    213
3    184
3    183
2    18
0
5    Align
0
2    66
0
1    3
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    193
3    184
3    183
1    8
0
4    Skip
0
2    67
0
1    1
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    200
3    184
3    183
2    14
0
3    Rep
0
2    68
0
1    3
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    211
3    184
3    183
2    12
0
8    Function
0
2    69
0
1    4
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    208
3    184
3    183
2    13
0
5    Group
0
2    70
0
1    9
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    206
3    209
3    183
1    3
0
0
0
2    54
0
2    12
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    384
3    215
3    214
1    4
0
0
1    X
2    26
0
2    11
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    389
3    215
3    214
1    5
0
0
1    X
2    27
0
2    11
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    219
3    215
3    214
1    6
0
0
1    X
2    28
0
2    26
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    385
3    215
1    0
1    0
53   #RWEGSC LOCAL_CNAME APPID6 LOCAL_ITEMID LOCAL_TLPOS 0
0
0
2    29
0
2    29
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    224
3    215
3    214
1    2
0
0
1    X
2    30
0
2    17
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    225
3    215
3    214
1    3
0
0
1    X
2    31
0
2    17
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    390
3    215
1    0
1    0
54   #RWEGSC PARENT1_CNAME APPID6 PARENT_ITEMID PARENTC_1 0
0
0
2    32
0
2    34
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    391
3    215
1    0
1    0
54   #RWEGSC PARENT2_CNAME APPID6 PARENT_ITEMID PARENTC_2 0
0
0
2    33
0
2    34
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    388
3    215
3    214
1    5
0
0
0
2    34
0
2    11
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    249
3    232
3    231
1    3
0
12   Summary Name
0
2    71
0
2    20
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    245
3    232
3    231
1    4
0
6    Source
0
2    72
0
2    20
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    247
3    232
3    231
1    5
0
8    Datatype
0
2    73
0
1    7
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    239
3    232
3    231
1    8
0
5    Width
0
2    74
0
1    5
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    241
3    232
3    231
1    7
0
11   Format Mask
0
2    75
0
1    7
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    248
3    232
3    231
1    6
0
8    Function
0
2    76
0
1    8
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    291
3    232
3    231
1    9
0
8    Print At
0
2    77
0
2    20
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    304
3    232
3    231
2    10
0
8    Reset At
0
2    78
0
2    20
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    254
3    251
3    250
1    4
0
0
0
2    89
0
2    14
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    255
3    251
3    250
1    5
0
0
0
2    90
0
1    1
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    257
3    251
3    250
1    7
0
0
0
2    91
0
1    5
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    258
3    251
3    250
1    8
0
0
0
2    92
0
1    5
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    259
3    251
3    250
1    9
0
0
0
2    93
0
1    5
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    263
3    251
3    250
1    6
0
0
0
2    94
0
1    6
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    288
3    251
3    250
2    11
0
0
0
2    95
0
1    1
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    290
3    251
3    250
2    10
0
0
0
2    96
0
1    6
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    297
3    251
3    250
2    12
0
0
0
2    97
0
2    16
1    2
1    3
3    251
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    253
3    264
3    250
1    3
0
0
0
2    88
0
2    16
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    289
3    275
3    250
2    13
0
5    Panel
0
2    98
0
1    4
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    274
3    275
3    250
2    14
0
4    Text
1    X
2    99
0
3    130
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    383
3    275
1    0
1    0
22   #RWERTH TEXT NOHL_TEXT
4    Text
0
3    100
0
3    130
1    2
0
0
0
0
0
0
1    4
1    A
5    SCOTT
3    120
3    309
3    307
3    306
1    2
0
14   Parameter Name
0
2    79
0
2    20
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    318
3    307
3    306
1    3
0
8    Datatype
0
2    80
0
1    4
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    311
3    307
3    306
1    4
0
5    Width
0
2    81
0
1    5
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    312
3    307
3    306
1    5
0
13   Default Value
0
2    82
0
2    20
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    313
3    307
3    306
1    6
0
5    Label
0
2    83
0
2    30
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    315
3    307
3    306
1    8
0
10   Input Mask
0
2    84
0
2    12
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    316
3    307
3    306
1    9
0
11   Output Mask
0
2    85
0
2    12
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    317
3    307
3    306
2    10
0
4    Skip
0
2    86
0
1    1
1    2
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    314
3    307
3    306
1    7
0
10   Param Type
0
2    87
0
1    4
1    1
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    337
3    336
3    214
1    7
0
0
0
2    25
0
2    10
1    2
0
0
0
0
0
0
0
1    B
11   SRW_SUMMARY
2    11
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
7    FIELDID
1    2
9    SUM_ORDER
1    2
8    OPERATOR
1    2
5    WIDTH
1    2
8    DATATYPE
1    2
11   FORMAT_MASK
1    1
8    PRINT_AT
1    2
8    RESET_AT
1    2
1    A
5    SCOTT
3    120
3    303
3    205
1    2
1    4
1    5
1    1
0
3    184
3    184
1    B
8    SRW_TEXT
2    12
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
4    TYPE
1    2
5    DIRTY
1    1
12   RELATIVE_POS
1    2
12   LINES_BEFORE
1    2
13   SPACES_BEFORE
1    2
6    REPEAT
1    1
13   JUSTIFICATION
1    2
9    FREQUENCY
1    2
5    WIDTH
1    2
1    A
5    SCOTT
3    120
1    1
1    3
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
1    1
1    4
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
1    1
1    5
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
1    1
1    6
1    X
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
1    2
1    5
1    X
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
1    2
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    104
1    5
0
0
0
0
0
1    3
0
0
1    A
5    SCOTT
3    120
3    104
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    104
1    7
0
0
0
0
1    X
1    1
1    1
0
1    A
5    SCOTT
3    120
3    104
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    126
1    5
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    126
1    6
1    X
1    4
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    126
1    7
0
0
0
0
1    X
1    1
3    104
0
1    A
5    SCOTT
3    120
3    126
1    8
1    X
1    4
1    7
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    130
1    5
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    130
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    130
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    130
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    139
1    5
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    139
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    139
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    139
1    8
1    X
0
0
0
1    X
1    3
0
0
1    A
5    SCOTT
3    120
3    153
1    5
0
0
1    2
0
0
1    3
0
0
1    A
5    SCOTT
3    120
3    153
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    153
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    153
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    177
1    5
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    177
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    177
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    177
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    184
1    5
0
0
0
0
0
1    3
0
0
1    A
5    SCOTT
3    120
3    184
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    184
1    7
0
0
1    1
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    184
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    209
1    5
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    209
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    209
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    209
1    8
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    215
1    5
0
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    215
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    215
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    215
1    8
1    X
0
0
2    28
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    232
1    5
0
0
0
0
0
1    3
0
0
1    A
5    SCOTT
3    120
3    232
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    232
1    7
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    232
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    251
1    5
0
0
0
0
0
0
0
0
1    A
5    SCOTT
3    120
3    251
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    251
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    251
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    264
1    5
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    264
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    264
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    264
1    8
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    275
1    5
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    275
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    275
1    7
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    275
1    8
1    X
1    4
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    307
1    5
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    307
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    307
1    7
1    X
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    307
1    8
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    336
1    5
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    336
1    6
0
0
0
0
0
1    1
0
0
1    A
5    SCOTT
3    120
3    336
1    7
0
0
0
0
1    X
1    1
0
0
1    A
5    SCOTT
3    120
3    336
1    8
1    X
0
0
2    28
1    X
1    1
0
0
1    B
13   SRW_TEXT_LONG
1    6
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
4    TYPE
1    2
5    PANEL
1    2
4    TEXT
1    8
1    A
5    SCOTT
3    120
1    1
1    6
1    1
1    1
3    144
132  ===================================================  END OF REPORT DEFINITION LISTING  =============================================
1    A
5    SCOTT
3    120
1    2
1    5
1    1
1    1
3    128
203  Page &PAGE                                                                                                          &DATE

                                                      Report Definition Listing

1    A
5    SCOTT
3    120
3    104
1    8
1    1
1    2
3    144
115  ====================================================  REPORT LEVEL INFORMATION  ===================================
3    128
1255

 ---  Page  --- --  Margin  -- -------------------------------  Parameter Form  -----------------------------------
| Height &PAGE_HEIGHT | Top    &TOP_MARGIN | Title  &PARAM_TITLE                     |
| Width  &PAGE_WIDTH | Bottom &BOTTOM_MARGIN | Hint   &PARAM_HINT                     |
|              | Left   &LEFT_MARGIN | Status &PARAM_STATUS                     |
|              | Right  &RIGHT_MARGIN |                                                                                    |
 --------  Access List  -----------------------------------------  History  ---------------------------------------|
                              |          By                                               Date          Version    |
                              |                                                                                    |
                              | Created:  &OWNER                 &CREATE_DATE     &VERSION      |
                              | Modified: &MODIFIER                 &MODIFIED_DATE     &MODIFIED_VERSION      |
                              -----------------------------------  Comments  --------------------------------------
                                &COMMENTS

1    A
5    SCOTT
3    120
3    126
1    6
1    1
1    1
3    128
31    -----------------------------

1    A
5    SCOTT
3    120
3    126
1    8
1    1
1    1
3    128
12   | &GRANTEE |
1    A
5    SCOTT
3    120
3    130
1    5
1    1
1    2
3    144
128  ========================================================  QUERY INFORMATION  ===================================================
3    128
163
Query Name                  Query
-------------------------   ----------------------------------------------------------------------------------------------------
1    A
5    SCOTT
3    120
3    130
1    8
1    1
1    1
3    128
14   &NAME   &QUERY
1    A
5    SCOTT
3    120
3    139
1    8
1    1
1    1
3    128
78                           Report Name:  &REPORT_NAME
            Appid:  &APPID6
1    A
5    SCOTT
3    120
3    153
1    8
1    1
1    1
3    128
186  &GROUP_NAME &QUERY_NAME &MATRIX_FLAG &PAGE_BREAK &RELATIVE_POS &LINES_BEFORE &SPACES_BEFORE &INTER_ROW &INTER_FIELD &FIELDS_ACROSS &MULTI_PANEL &LOCATE_LABELS &FIELD_HILITE &LABEL_HILITE
1    A
5    SCOTT
3    120
3    177
1    5
1    1
1    2
3    144
132  ========================================================  GROUP INFORMATION  ======================================================
3    128
395
                                                         Page        Rel    Lin Sp  -Spac-  Fld Multi Label ----  Highlight  ------
Group Name                Query Name                Mtrx Break       Pos    Bef Bef Rec Fld Acr Panel Pos     Field        Label
------------------------- ------------------------- ---- ----------- ------ --- --- --- --- --- ----- ----- ----------- -----------
1    A
5    SCOTT
3    120
3    177
1    8
1    1
1    1
3    128
6    &NULL1
1    A
5    SCOTT
3    120
3    184
1    8
1    1
1    1
3    128
183  &FIELD_NAME &TARGET_POSITION &COMPUTE &QUERY_NAME2 &HEADING &DATATYPE2 &WIDTH &FORMAT_MASK   &POSITION &LINES_BEFORE2 &SPACES_BEFORE2 &ALIGNMENT &SKIP &REPRINT  &FUNCTION &RESET_GROUP
1    A
5    SCOTT
3    120
3    209
1    5
1    1
1    2
3    144
131  =========================================================  FIELD INFORMATION  =====================================================
3    128
620
                                                                                                               S
                                                                                                               k Rep
                             Exp                                                               Rel Lin Sp      i  On       Reset
Group         Field Name       # Compute       Query           Heading    Type Wid Format      Pos Bef Bef Aln p  Pg Fctn  Group
------------  -------------- --- ------------- --------------- ---------- ---- --- ----------- --- --- --- --- - --- ----- --------
1    A
5    SCOTT
3    120
3    209
1    8
1    1
1    1
3    128
12   &GROUP_NAME2
1    A
5    SCOTT
3    120
3    215
1    8
1    1
1    1
3    128
42   &LOCAL_CNAME &PARENT1_CNAME &PARENT2_CNAME
1    A
5    SCOTT
3    120
3    232
1    7
1    1
1    2
3    144
129  =======================================================  SUMMARY INFORMATION  ===================================================
3    128
246

Summary Name          Source                Datatype  Width  Format Mask  Function  Print At              Reset At
--------------------  --------------------  --------  -----  -----------  --------  --------------------  -----------------------
1    A
5    SCOTT
3    120
3    232
1    8
1    1
1    1
3    128
97   &SUMMARY_NAME  &SOURCE  &DATATYPE3   &WIDTH2  &FORMAT_MASK2      &FUNCTION3  &PRINT_AT  &RESET_AT
1    A
5    SCOTT
3    120
3    251
1    8
1    1
1    1
3    128
134    &TYPE  &EDITED &LINES_BEFORE3  &SPACES_BEFORE3  &WIDTH3  &RELATIVE_POS3                             &REPEAT       &ALIGN  &FREQUENCY
1    A
5    SCOTT
3    120
3    264
1    5
1    1
1    2
3    144
132  =========================================================  TEXT INFORMATION  =======================================================
3    128
252

Object            Type            Edited  Lines Before  Spaces Before  Width  Relative Pos  Repeat  Align   Frequency
----------------  --------------  ------  ------------  -------------  -----  ------------  ------  ------  ------------------------
1    A
5    SCOTT
3    120
3    264
1    8
1    1
1    1
3    128
7    &OBJECT
1    A
5    SCOTT
3    120
3    275
1    7
1    1
0
1    A
5    SCOTT
3    120
3    275
1    8
1    1
1    1
3    128
163  Panel:  &PANEL
Text
------------------------------------------------------------------------------------------------------------------------------------
&NOHL_TEXT
1    A
5    SCOTT
3    120
3    307
1    7
1    1
1    2
3    144
129  ======================================================  PARAMETER INFORMATION  ==================================================
3    128
387
                                                                                                                           Param
Parameter Name        Type  Width  Default Value         Label                           Input Mask    Output Mask   Skip  Type
--------------------  ----  -----  --------------------  ------------------------------  ------------  ------------  ----  ------
1    A
5    SCOTT
3    120
3    307
1    8
1    1
1    1
3    128
108  &PARAMETER_NAME  &DATATYPE4  &WIDTH4  &DEFAULT_VALUE  &LABEL  &INPUT_MASK  &OUTPUT_MASK  &SKIP2  &PARAM_TYPE
1    A
5    SCOTT
3    120
3    336
1    8
1    1
1    1
3    128
206  Parent-Child Information: &NULL
Current Query                 Parent 1:  &PARENT_1 Parent 2:  &MATRIX_NAME
----------------------------- ---------------------------------- ----------------------------------
1    D