| Non Rollup Group Only | LOV | nvl(gst.segment1_type,'D') in ('D','T') and
nvl(gst.segment2_type,'D') in ('D','T') and
nvl(gst.segment3_type,'D') in ('D','T') and
nvl(gst.segment4_type,'D') in ('D','T') and
nvl(gst.segment5_type,'D') in ('D','T') and
nvl(gst.segment6_type,'D') in ('D','T') and
nvl(gst.segment7_type,'D') in ('D','T') and
nvl(gst.segment8_type,'D') in ('D','T') and
nvl(gst.segment9_type,'D') in ('D','T') and
nvl(gst.segment10_type,'D') in ('D','T') and
nvl(gst.segment11_type,'D') in ('D','T') and
nvl(gst.segment12_type,'D') in ('D','T') and
nvl(gst.segment13_type,'D') in ('D','T') and
nvl(gst.segment14_type,'D') in ('D','T') and
nvl(gst.segment15_type,'D') in ('D','T') and
nvl(gst.segment16_type,'D') in ('D','T') and
nvl(gst.segment17_type,'D') in ('D','T') and
nvl(gst.segment18_type,'D') in ('D','T') and
nvl(gst.segment19_type,'D') in ('D','T') and
nvl(gst.segment20_type,'D') in ('D','T') |
nvl(gst.segment1_type,'D') in ('D','T') and
nvl(gst.segment2_type,'D') in ('D','T') and
nvl(gst.segment3_type,'D') in ('D','T') and
nvl(gst.segment4_type,'D') in ('D','T') and
nvl(gst.segment5_type,'D') in ('D','T') and
nvl(gst.segment6_type,'D') in ('D','T') and
nvl(gst.segment7_type,'D') in ('D','T') and
nvl(gst.segment8_type,'D') in ('D','T') and
nvl(gst.segment9_type,'D') in ('D','T') and
nvl(gst.segment10_type,'D') in ('D','T') and
nvl(gst.segment11_type,'D') in ('D','T') and
nvl(gst.segment12_type,'D') in ('D','T') and
nvl(gst.segment13_type,'D') in ('D','T') and
nvl(gst.segment14_type,'D') in ('D','T') and
nvl(gst.segment15_type,'D') in ('D','T') and
nvl(gst.segment16_type,'D') in ('D','T') and
nvl(gst.segment17_type,'D') in ('D','T') and
nvl(gst.segment18_type,'D') in ('D','T') and
nvl(gst.segment19_type,'D') in ('D','T') and
nvl(gst.segment20_type,'D') in ('D','T') |