166: l_mv_tbl(2).use_grp_id := 'N';
167:
168: l_query := get_sel_clause1 (l_view_by, l_join_tbl)
169: || ' from (
170: ' || poa_dbi_template_pkg.union_all_status_sql
171: (p_mv => l_mv_tbl,
172: p_join_tables => l_join_tbl,
173: p_use_windowing => 'Y',
174: p_paren_count => 3,
176:
177: ELSE
178: l_query := get_sel_clause2 (l_view_by, l_join_tbl)
179: || ' from
180: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv2,
181: p_where_clause => l_where_clause2,
182: p_join_tables => l_join_tbl,
183: p_use_windowing => 'Y',
184: p_col_name => l_col_tbl2,