958: if p_bucket_rec.range1_name is not null then
959: l_query := get_bucket_query(p_column_name_base,1,p_alias_base,p_total_flag,p_backlog_col);
960: end if;
961: if p_bucket_rec.range2_name is not null then
962: l_query := l_query || fnd_global.newline ||
963: get_bucket_query(p_column_name_base,2,p_alias_base,p_total_flag,p_backlog_col);
964: end if;
965: if p_bucket_rec.range3_name is not null then
966: l_query := l_query || fnd_global.newline ||
962: l_query := l_query || fnd_global.newline ||
963: get_bucket_query(p_column_name_base,2,p_alias_base,p_total_flag,p_backlog_col);
964: end if;
965: if p_bucket_rec.range3_name is not null then
966: l_query := l_query || fnd_global.newline ||
967: get_bucket_query(p_column_name_base,3,p_alias_base,p_total_flag,p_backlog_col);
968: end if;
969: if p_bucket_rec.range4_name is not null then
970: l_query := l_query || fnd_global.newline ||
966: l_query := l_query || fnd_global.newline ||
967: get_bucket_query(p_column_name_base,3,p_alias_base,p_total_flag,p_backlog_col);
968: end if;
969: if p_bucket_rec.range4_name is not null then
970: l_query := l_query || fnd_global.newline ||
971: get_bucket_query(p_column_name_base,4,p_alias_base,p_total_flag,p_backlog_col);
972: end if;
973: if p_bucket_rec.range5_name is not null then
974: l_query := l_query || fnd_global.newline ||
970: l_query := l_query || fnd_global.newline ||
971: get_bucket_query(p_column_name_base,4,p_alias_base,p_total_flag,p_backlog_col);
972: end if;
973: if p_bucket_rec.range5_name is not null then
974: l_query := l_query || fnd_global.newline ||
975: get_bucket_query(p_column_name_base,5,p_alias_base,p_total_flag,p_backlog_col);
976: end if;
977: if p_bucket_rec.range6_name is not null then
978: l_query := l_query || fnd_global.newline ||
974: l_query := l_query || fnd_global.newline ||
975: get_bucket_query(p_column_name_base,5,p_alias_base,p_total_flag,p_backlog_col);
976: end if;
977: if p_bucket_rec.range6_name is not null then
978: l_query := l_query || fnd_global.newline ||
979: get_bucket_query(p_column_name_base,6,p_alias_base,p_total_flag,p_backlog_col);
980: end if;
981: if p_bucket_rec.range7_name is not null then
982: l_query := l_query || fnd_global.newline ||
978: l_query := l_query || fnd_global.newline ||
979: get_bucket_query(p_column_name_base,6,p_alias_base,p_total_flag,p_backlog_col);
980: end if;
981: if p_bucket_rec.range7_name is not null then
982: l_query := l_query || fnd_global.newline ||
983: get_bucket_query(p_column_name_base,7,p_alias_base,p_total_flag,p_backlog_col);
984: end if;
985: if p_bucket_rec.range8_name is not null then
986: l_query := l_query || fnd_global.newline ||
982: l_query := l_query || fnd_global.newline ||
983: get_bucket_query(p_column_name_base,7,p_alias_base,p_total_flag,p_backlog_col);
984: end if;
985: if p_bucket_rec.range8_name is not null then
986: l_query := l_query || fnd_global.newline ||
987: get_bucket_query(p_column_name_base,8,p_alias_base,p_total_flag,p_backlog_col);
988: end if;
989: if p_bucket_rec.range9_name is not null then
990: l_query := l_query || fnd_global.newline ||
986: l_query := l_query || fnd_global.newline ||
987: get_bucket_query(p_column_name_base,8,p_alias_base,p_total_flag,p_backlog_col);
988: end if;
989: if p_bucket_rec.range9_name is not null then
990: l_query := l_query || fnd_global.newline ||
991: get_bucket_query(p_column_name_base,9,p_alias_base,p_total_flag,p_backlog_col);
992: end if;
993: if p_bucket_rec.range10_name is not null then
994: l_query := l_query || fnd_global.newline ||
990: l_query := l_query || fnd_global.newline ||
991: get_bucket_query(p_column_name_base,9,p_alias_base,p_total_flag,p_backlog_col);
992: end if;
993: if p_bucket_rec.range10_name is not null then
994: l_query := l_query || fnd_global.newline ||
995: get_bucket_query(p_column_name_base,10,p_alias_base,p_total_flag,p_backlog_col);
996: end if;
997: return l_query;
998: end get_bucket_outer_query;