APPS.BSC_MO_INPUT_TABLE_PKG SQL Statements

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

Line: 9

select measure_group_id from bsc_db_measure_cols_vl
where measure_col = p_field_name;

Line: 22

l_stmt varchar2(1000):='SELECT distinct column_Name, source
 FROM bsc_db_tables_cols
 WHERE column_type = :1
   AND table_name like :2
   AND column_name not like :3';

Line: 53

select measure_group_id from bsc_db_measure_cols_vl
where measure_col = p_measure
and measure_type = 0;

Line: 93

  SELECT table_name  FROM bsc_db_tables_rels
  WHERE source_table_name = l_src  AND table_name LIKE l_tbl;

Line: 97

  SELECT source_column  FROM bsc_db_tables_cols
  WHERE table_name = l_table AND UPPER(column_name) = l_column AND column_type = l_column_type;

Line: 110

      l_stmt := 'SELECT DISTINCT r.source_table_name FROM bsc_db_tables_rels r, bsc_db_tables t
                WHERE r.table_name LIKE  :1  AND
                NOT r.source_table_name LIKE :2  AND
                r.table_name = t.table_name AND
                t.periodicity_id = :3 AND
                r.relation_type = 0';

Line: 129

      l_stmt := 'SELECT DISTINCT table_name AS SOURCE_TABLE_NAME
                FROM bsc_db_tables_cols
                WHERE table_name IN (
                SELECT r.source_table_name
                FROM bsc_db_tables_rels r, bsc_db_tables t
                WHERE r.table_name LIKE :1 AND
                NOT r.source_table_name LIKE :2 AND
                r.table_name = t.table_name AND
                t.periodicity_id = :3 AND
                r.relation_type = 0 ) AND
                column_name IN (' || lstKeys || ') AND
                column_type = ''P''
                GROUP BY table_name
                HAVING COUNT(column_name) = ' || KpiTable.keys.Count;

Line: 151

    l_stmt := 'SELECT DISTINCT r.source_table_name
          FROM bsc_db_tables_rels r, bsc_db_tables t
          WHERE r.table_name LIKE :1 AND
          NOT r.source_table_name LIKE :2 AND
          r.table_name = t.table_name AND
          t.periodicity_id = :3 AND r.relation_type = 0';

Line: 216

SELECT TABLE_NAME, TABLE_TYPE, PERIODICITY_ID, EDW_FLAG, CURRENT_PERIOD, TARGET_FLAG
              FROM BSC_DB_TABLES
              WHERE TABLE_NAME = pTable;

Line: 222

  SELECT COLUMN_TYPE, COLUMN_NAME, SOURCE_COLUMN, SOURCE_FORMULA
         --BSC Autogen
         , SOURCE
         , measure_group_id
    FROM BSC_DB_TABLES_COLS cols, bsc_db_measure_cols_vl dbcols
   WHERE cols.TABLE_NAME = pTable
     AND cols.column_name = dbcols.measure_col(+);

Line: 232

  SELECT SOURCE_TABLE_NAME
  FROM BSC_DB_TABLES_RELS
  WHERE TABLE_NAME = pTable
  AND RELATION_TYPE = 0
  ORDER BY SOURCE_TABLE_NAME;

Line: 240

SELECT SOURCE_TABLE_NAME
        FROM BSC_DB_TABLES_RELS
        WHERE TABLE_NAME = pTable
        AND RELATION_TYPE = 1
        ORDER BY SOURCE_TABLE_NAME;

Line: 605

  SELECT table_name from bsc_db_tables
  where table_name like pStart;

Line: 704

    Tabla_Origin.delete;

Line: 956

    Tabla_originTable.delete;

Line: 2119

            uniqueField.key_combinations.delete;

Line: 2133

              uniqueField.key_combinations.delete;

Line: 2156

              uniqueField_disAggKeys.delete;

Line: 2617

        BSC_MO_LOADER_CONFIG_PKG.InsertOriginTables (bsc_metadata_optimizer_pkg.garrTablesUpgradeT,
                            bsc_metadata_optimizer_pkg.garrTablesUpgrade);

Line: 2637

SELECT column_name
FROM
bsc_db_tables_cols cols
WHERE
cols.table_name = p_table
AND cols.column_type = 'P'
ORDER BY cols.column_name;

Line: 2646

SELECT cols.column_name, nvl(cols.source, 'BSC'), nvl(dbcols.measure_group_id, -1)
FROM
bsc_db_tables_cols cols,
all_tab_columns tabcols,
bsc_sys_measures sysm,
bsc_db_measure_cols_vl dbcols
WHERE
cols.table_name = p_table
AND cols.table_name = tabcols.table_name
and cols.column_name = tabcols.column_name
and tabcols.owner = p_owner
AND cols.column_type = 'A'
AND cols.column_name = sysm.measure_col
AND cols.column_name = dbcols.measure_col
ORDER BY cols.column_name;

Line: 2663

select source_column, nvl(calculation_type, 0) from
bsc_db_Tables_cols cols,
bsc_db_calculations calc
where
cols.table_name = calc.table_name (+)
and cols.table_name = p_table
and cols.column_type = 'P'
and calc.calculation_type (+)= 4
and cols.column_name = p_column;

Line: 2674

SELECT source_table_name FROM
BSC_DB_TABLES_RELS
WHERE table_name=p_table;

Line: 2821

  '  select kpi.indicator, tmp.dim_set_id
       from  bsc_kpis_vl kpi,
          (
             select substr(table_name, instr(table_name, ''_'', 1, 2)+1,
                         instr(table_name, ''_'', 1, 3)-instr(table_name, ''_'', 1, 2)-1) indicator,
                    substr(table_name, instr(table_name, ''_'', 1, 3)+1,
                         instr(table_name, ''_'', 1, 4)-instr(table_name, ''_'', 1, 3)-1) dim_set_id
               from bsc_db_tables_rels
              where table_name like ''BSC_S%''
            connect by prior  table_name = source_table_name
              start with source_table_name = :1
          ) tmp
      where kpi.indicator = tmp.indicator
        and prototype_flag not in (2,3) -- no need for 4 as the B table typically doesnt get dropped for 4
        and kpi.share_flag<>2
        and rownum=1';

Line: 2860

  l_stmt := 'select distinct table_name from bsc_db_tables where (table_name like ''BSC_B%'' or table_name like ''BSC_T%'' ) and table_type=1';