APPS.BSC_METADATA_OPTIMIZER_PKG SQL Statements

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

Line: 22

      SELECT distinct k.indicator, k.dim_set_id, k.level_pk_col, k.level_view_name
      FROM BSC_KPI_DIM_LEVELS_B K, BSC_SYS_DIM_LEVELS_B S, bsc_kpis_b kpi
      WHERE
      kpi.share_flag = 2
      and kpi.indicator = k.indicator
      and UPPER(K.LEVEL_TABLE_NAME) = UPPER(S.LEVEL_TABLE_NAME)
      AND K.INDICATOR = kpi.indicator
      --AND K.DIM_SET_ID = dimset.dim_set_id
      AND UPPER(S.LEVEL_VIEW_NAME) <> UPPER(K.LEVEL_VIEW_NAME)
      AND K.STATUS = 2 ';

Line: 45

l_stmt varchar2(4000) := 'select distinct kpi.indicator, kpi.share_flag
from
bsc_kpis_b kpi,
bsc_tmp_opt_kpis_with_measures considerkpi
where kpi.indicator = considerkpi.indicator
and kpi.prototype_flag <> 2
-- get indicators without rows in bsc_db_tables
and not exists
(select 1 from bsc_db_tables where table_name like ''BSC_S_''||kpi.indicator||''%'')
-- skip shared but unfiltered indicators
and ( kpi.share_flag in (0,1)
    or
    (kpi.share_flag = 2
      and exists
     (SELECT 1
      FROM bsc_tmp_opt_filtered_indics fil
      where fil.indicator = kpi.indicator
      )
     )
  )';

Line: 72

  SELECT count(1) INTO l_num
    FROM bsc_db_tables
   WHERE table_name like 'BSC_I_%';

Line: 76

  SELECT count(1)INTO l_num
    FROM bsc_db_tables
   WHERE table_name like 'BSC_B_%';

Line: 80

  SELECT count(1)INTO l_num
    FROM bsc_db_tables
   WHERE table_name like 'BSC_T_%';

Line: 84

  SELECT count(1) INTO l_num
    FROM bsc_db_tables
   WHERE table_name like 'BSC_S_%';

Line: 121

  SELECT value INTO l_dir
  FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';

Line: 176

SELECT userenv('LANG') from dual;

Line: 179

SELECT DISTINCT LANGUAGE_CODE, NLS_LANGUAGE FROM FND_LANGUAGES
WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 225

    l_stmt := 'SELECT WORD FROM BSC_DB_RESERVED_WORDS WHERE WORD IS NOT NULL AND TYPE = 1';

Line: 238

  l_stmt := 'SELECT WORD FROM BSC_DB_RESERVED_WORDS WHERE WORD IS NOT NULL AND TYPE = 2';

Line: 269

  INSERT INTO BSC_TMP_BIG_IN_COND(session_id, VARIABLE_ID, VALUE_N, VALUE_V)
  values   (USERENV('SESSIONID'), -200, g_progressCounter,
  pStage||' '||pMessage||' '||bsc_mo_helper_pkg.get_time);

Line: 280

select count(1) from bsc_kpis_vl
where indicator=p_objective
and share_flag=2
and not exists (select 1 from bsc_db_tables where instr(table_name, p_pattern)>0);

Line: 378

  bsc_mo_helper_pkg.writeTmp('Calling deletePreviousRunTables, system time is '||
    bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);

Line: 380

  logProgress('INIT', 'Starting deletePreviousRunTables');

Line: 381

  bsc_mo_helper_pkg.deletePreviousRunTables;

Line: 382

  logProgress('INIT', 'Completed deletePreviousRunTables');

Line: 383

  bsc_mo_helper_pkg.writeTmp('Done with deletePreviousRunTables, system time is '||
    bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);

Line: 520

    IF NOT bsc_update_dim.create_dbi_dim_tables(l_error) THEN
      logprogress('ERROR', 'Exception in bsc_update_dim.create_dbi_dim_tables');

Line: 522

      BSC_MO_HELPER_PKG.TerminateWithMsg('EXCEPTION in bsc_update_dim.create_dbi_dim_tables : '||l_error, FND_LOG.LEVEL_UNEXPECTED);

Line: 604

  bsc_mo_helper_pkg.writeTmp('Starting UpdateFlags, system time is '||
    bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

Line: 606

  logProgress('MISC', 'Calling UpdateFlags');

Line: 608

  BSC_MO_HELPER_PKG.UpdateFlags;

Line: 609

  logProgress('MISC', 'Completed UpdateFlags');

Line: 610

  bsc_mo_helper_pkg.writeTmp('Done with UpdateFlags, system time is '||
    bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

Line: 780

SELECT KPIS.INDICATOR, KPIS.NAME, KPIS.PROTOTYPE_FLAG , decode(nvl(prop.property_value, 1), 1, 'Summary Tables/MVs', 'Analytical Workspace') impl_type
FROM BSC_KPIS_VL KPIS, BSC_KPI_PROPERTIES prop
WHERE kpis.INDICATOR IN
(SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=g_processID)
AND kpis.indicator=prop.indicator(+)
and prop.property_code(+) = 'IMPLEMENTATION_TYPE'
order by indicator;

Line: 860

    bsc_mo_helper_pkg.writeTmp('Processing selected objectives', FND_LOG.LEVEL_STATEMENT, true);

Line: 863

    bsc_mo_helper_pkg.writeTmp('Processing selected reports', FND_LOG.LEVEL_STATEMENT, true);

Line: 994

  ELSE--selected or inter-related
    FOR i IN (select indicator from bsc_tmp_opt_ui_kpis where process_id = g_processID) LOOP
      logProgress('LOCK', 'Locking '||i.indicator);

Line: 1019

    p_runMode     IN NUMBER, -- 0 ALL, 1 INCREMENTAL, 2 SELECTED , (9 obsolete)
    p_processID		IN NUMBER)
IS

BEGIN
  gGAA_RUN_MODE := p_runMode;

Line: 1027

  delete bsc_tmp_big_in_cond where variable_id = -200;