APPS.BSC_MO_DOC_PKG SQL Statements

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

Line: 22

SELECT periodicity_id, per.name periodicity_name, cal.calendar_id, cal.NAME calendar_name
  FROM BSC_SYS_CALENDARS_VL cal
     , BSC_SYS_PERIODICITIES_VL per
    WHERE per.CALENDAR_ID = cal.calendar_id
    order by periodicity_id;

Line: 108

    SELECT OBJECT_TYPE FROM USER_OBJECTS
    WHERE OBJECT_NAME = objName;

Line: 201

SELECT NAME FROM BSC_SYS_PERIODICITIES_VL
WHERE PERIODICITY_ID = Periodicity;

Line: 232

    SELECT NAME FROM BSC_SYS_CALENDARS_VL
    WHERE CALENDAR_ID = (
        SELECT CALENDAR_ID
        FROM BSC_SYS_PERIODICITIES_VL
        WHERE PERIODICITY_ID = p1);

Line: 395

      WriteLineTextFile(BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'DELETED'));

Line: 528

    SELECT NUM_OF_SUBPERIODS
    FROM BSC_SYS_PERIODICITIES
    WHERE PERIODICITY_ID = Periodicity;

Line: 560

    SELECT NUM_OF_PERIODS
    FROM BSC_SYS_PERIODICITIES
    WHERE PERIODICITY_ID = Periodicity;

Line: 627

   SELECT mview_name
     FROM all_mviews
    WHERE mview_name like p_pattern
      AND owner in (BSC_METADATA_OPTIMIZER_PKG.gBSCSchema,BSC_METADATA_OPTIMIZER_PKG.gAppsSchema);

Line: 634

    SELECT DISTINCT projection_data
    FROM bsc_kpi_data_tables
    WHERE table_name = Tabla.name;*/

Line: 638

    SELECT table_name from all_tables
    WHERE owner = BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
      AND table_name=p_pt_table;

Line: 727

  l_stmt := 'SELECT DISTINCT A.COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, B.SOURCE, A.COLUMN_ID ';

Line: 1067

    SELECT LEVEL_PK_COL
    FROM BSC_KPI_DIM_LEVELS_B
    WHERE INDICATOR = p1
    AND DIM_SET_ID = p2
    AND DIM_LEVEL_INDEX = p3;

Line: 1133

(select distinct to_number(substr(table_name, instr(table_name, ''_'', 1, 2)+1,
 instr(table_name,''_'',1,3)-instr(table_name,''_'',1,2)-1)) indicator
 from
 ( select table_name from bsc_db_tables_rels
    where source_table_name not like ''BSC_S%''
      and table_name like ''BSC_S%''
  connect by source_table_name = prior table_name
    start with source_table_name = :l_table_name)
 where table_name like ''BSC_S%''
)
select indicator from
(
SELECT INDICATOR FROM main_indics
union -- get dependant child indicators after validating filters are same
select kpis.indicator
  from main_indics ind, bsc_kpis_vl kpis
 where ind.indicator = kpis.source_indicator
   and not exists
       (select 1 from bsc_kpi_dim_levels_b master, bsc_kpi_dim_levels_b child
         where master.indicator=kpis.source_indicator
           and child.indicator= ind.indicator
           and master.level_table_name = child.level_table_name
           and master.dim_level_index = child.dim_level_index
           and master.level_view_name <> child.level_view_name)
)';

Line: 1167

      l_stmt := l_stmt ||' where indicator in (select indicator from bsc_tmp_opt_ui_kpis where process_id =:2)';

Line: 1230

    'SELECT TABLE_NAME, TABLE_TYPE, PERIODICITY_ID, EDW_FLAG, TARGET_FLAG
    FROM BSC_DB_TABLES
    WHERE TABLE_TYPE <> 2';

Line: 1250

    SELECT COLUMN_TYPE, COLUMN_NAME, SOURCE
        FROM BSC_DB_TABLES_COLS
        WHERE TABLE_NAME = p1;

Line: 1256

    SELECT SOURCE_TABLE_NAME
    FROM BSC_DB_TABLES_RELS
    WHERE TABLE_NAME = p1
    AND RELATION_TYPE = p2
    ORDER BY SOURCE_TABLE_NAME;

Line: 1264

    SELECT column_name
    FROM all_tab_columns
    WHERE table_name = p1
    AND owner = p2
    ORDER BY column_id;

Line: 1272

    SELECT INDICATOR, DIM_SET_ID, LEVEL_COMB, TABLE_NAME, FILTER_CONDITION
    FROM BSC_KPI_DATA_TABLES_V T
    WHERE TABLE_NAME IS NOT NULL AND
    0 = (
    SELECT PROPERTY_VALUE
    FROM BSC_KPI_PROPERTIES P
    WHERE UPPER(PROPERTY_CODE) = 'DB_TRANSFORM'
    AND P.INDICATOR = T.INDICATOR);

Line: 1302

       SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
      CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
        START WITH table_name in
        (
          select table_name from bsc_db_tables dbtbl, bsc_tmp_opt_ui_kpis
          where dbtbl.table_name like ''BSC_S%''||indicator||''%''
            and indicator in
         (select indicator from bsc_tmp_opt_ui_kpis where process_id=:1)
        )
      UNION -- Get the S tables which are not sources
      SELECT TABLE_NAME FROM BSC_DB_TABLES dbtbl, bsc_tmp_opt_ui_kpis
       where dbtbl.table_name like ''BSC_S_%''||indicator||''%''
         and indicator in
         (select indicator from bsc_tmp_opt_ui_kpis where process_id=:1)
      )';

Line: 1341

    Table_keys.delete;

Line: 1342

    Table_data.delete;

Line: 1443

  l_stmt := 'SELECT INDICATOR, DIM_SET_ID, LEVEL_COMB, TABLE_NAME, FILTER_CONDITION
    FROM BSC_KPI_DATA_TABLES_V T
    WHERE TABLE_NAME IS NOT NULL AND
    0 = (
    SELECT PROPERTY_VALUE
    FROM BSC_KPI_PROPERTIES P
    WHERE UPPER(PROPERTY_CODE) = ''DB_TRANSFORM''
    AND P.INDICATOR = T.INDICATOR)';

Line: 1452

    l_stmt := l_stmt||' and indicator in (select indicator from bsc_tmp_opt_ui_kpis where process_id=:1)';

Line: 1525

    SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
    INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID, SHARE_FLAG,
    SOURCE_INDICATOR, EDW_FLAG FROM BSC_KPIS_VL
    ORDER BY INDICATOR;

Line: 1536

    gDocIndicators.delete;

Line: 1741

    SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE
    FROM ALL_TAB_COLUMNS
    WHERE TABLE_NAME = p1
    AND UPPER(OWNER) = p2
    ORDER BY COLUMN_ID;

Line: 1902

    l_stmt := 'SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE
                FROM USER_TAB_COLUMNS
                WHERE TABLE_NAME = :1 ORDER BY COLUMN_ID';

Line: 1909

    l_stmt := 'SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE
                    FROM ALL_TAB_COLUMNS WHERE OWNER = :1 AND ';