APPS.BIS_DIMS_AND_LEVELS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 64

	    -- Select * from tmp2 order by seq desc;

Line: 100

SELECT
     bi.name KPI_NAME2
   , SUBSTR(NVL(bi.description, '' ''),1,180) KPI_DESCRIPTION1
   , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_level_names(bi.indicator_id), '' ''),1,180) LEVEL_NAMES
   , SUBSTR(NVL(f.application_name, '' ''),1,180) Owning_applicn_name2
FROM
     bis_indicators_vl bi
   , bis_levels_vl bl
   , BIS_IND_TL_LVL_V bitlv
   , bis_application_measures bam
   , fnd_application_vl f
WHERE bitlv.indicator_id = bi.indicator_id
  AND bitlv.level_id = bl.level_id
  AND bi.indicator_id = bam.indicator_id
  AND bam.application_id = f.application_id
'
  || l_where_clause
  || l_group_by
  || ' ORDER BY bi.name,  bi.description ';

Line: 160

     SELECT
       bi.name KPI_NAME2
       ,SUBSTR(NVL(bi.description, '' ''),1,180) KPI_DESCRIPTION1
       ,bi.short_name LEVEL_NAMES
       ,SUBSTR(NVL(f.application_name, '' ''),1,180) Owning_applicn_name2
      FROM
        bis_indicators_vl bi,
        bis_application_measures measures,
        bis_indicators indicators,
        bsc_sys_datasets_vl datasets,
        bsc_sys_measures sys,
        fnd_application_vl f
      WHERE
        bi.indicator_id = measures.indicator_id AND
        measures.application_id = f.application_id(+) AND
        indicators.dataset_id = datasets.dataset_id AND
        datasets.measure_id1 = sys.measure_id AND
        indicators.indicator_id = bi.indicator_id '
        || l_where_clause
        || ' ORDER BY bi.name,  bi.description ';

Line: 218

	-- insert into tmp2 (seq, value) values (temp_seq.nextval, '(<---------------- pname ->'||l_pname||'<-pvalue->'||l_pvalue||'<------------------>)' ); commit;

Line: 263

	    -- Select * from tmp2 order by seq desc;

Line: 308

SELECT
    SUBSTR(bd.name,1,180) Dimension_name2
  , SUBSTR(bl.name,1,180) Level_name2
  , SUBSTR(NVL(bl.description, '' ''),1,180) Level_description2
  , NVL(bl.level_values_view_name, '' '') Level_value_Source_view2
FROM
    Bis_dimensions_vl bd
  , bis_levels_vl bl
  '
  || l_kpi_table_names
  || l_dyn_table ||
  '
WHERE
      bl.dimension_id = bd.dimension_id
  AND NVL(bd.hide_in_design, ''F'') <> ''T''
  AND NVL(bl.hide_in_design, ''F'') <> ''T''
'
|| l_where_clause
|| l_group_by
|| ' ORDER BY bd.name, bl.name ' ;

Line: 370

	-- insert into tmp2 (seq, value) values (temp_seq.nextval, '(<---------------- pname ->'||l_pname||'<-pvalue->'||l_pvalue||'<------------------>)' ); commit;

Line: 405

	    -- Select * from tmp2 order by seq desc;

Line: 437

SELECT
    SUBSTR(bl.name,1,180) Level_name
  , bl.short_name Level_Internal_name
  , aa.attribute_label_long Level_Short_name
  , SUBSTR(NVL(bl.description, '' ''),1,180) Level_description
  , bl.source Level_value_Source_type1
  , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_kpi_names(bl.level_id), '' ''),1,180) Kpi_names
FROM
    bis_levels_vl bl
  , ak_attributes_vl aa
  , bis_dimensions_vl bd
  '
  || l_dyn_table ||
  '
WHERE
     bl.attribute_code = aa.attribute_code
 AND bl.dimension_id = bd.dimension_id
 AND NVL(bd.hide_in_design, ''F'') <> ''T''
 AND NVL(bl.hide_in_design, ''F'') <> ''T''
'
|| l_where_clause
|| l_group_by
|| '
ORDER BY bl.name, bl.short_name, aa.attribute_label_long
     , bl.description, bl.source ' ;

Line: 505

	-- insert into tmp2 (seq, value) values (temp_seq.nextval, '(<---------------- pname ->'||l_pname||'<-pvalue->'||l_pvalue||'<------------------>)' ); commit;

Line: 528

	    -- Select * from tmp2 order by seq desc;

Line: 560

SELECT
     SUBSTR(bd.name,1,180) Dimension_name1
	 , SUBSTR(NVL(bd.description, '' ''),1,180) Dimension_description1
	 , bd.short_name Dimension_short_name1
FROM bis_dimensions_vl bd
'
  || l_dyn_table ||
'
WHERE NVL(bd.hide_in_design, ''F'') <> ''T''
'
|| l_where_clause
|| '
ORDER BY bd.name, bd.description, bd.short_name
';

Line: 592

  SELECT name
  FROM bis_levels_vl bl
     , BIS_IND_TL_LVL_V bitlv
  WHERE bitlv.level_id = bl.level_id
    AND bitlv.indicator_id = kpi_id;

Line: 636

  SELECT DISTINCT name
  FROM bis_indicators_vl bi
     , BIS_IND_TL_LVL_V bitlv
  WHERE bitlv.indicator_id = bi.indicator_id
    AND bitlv.level_id = lvl_id;