APPS.BSC_DBGEN_UTILS SQL Statements

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

Line: 14

 SELECT config_type
 FROM   bsc_kpis_b
 WHERE  short_name =p_short_name;

Line: 62

    SELECT ORACLE_USERNAME
    FROM  fnd_oracle_userid
    WHERE oracle_id=900;

Line: 92

  SELECT data_type, data_length
  FROM all_tab_columns
  where
  (owner = g_bsc_schema or owner = g_apps_schema) and
  table_name=p_table_name and
  column_name=p_column_name;

Line: 133

  DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV('SESSIONID') AND VARIABLE_ID = x_variable_id;

Line: 135

      ' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'')'||
      ' AND VARIABLE_ID = ' || x_variable_id || ')';

Line: 175

  DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV('SESSIONID') AND VARIABLE_ID = x_variable_id;

Line: 177

      ' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'') AND VARIABLE_ID = '||x_variable_id||')';

Line: 204

  SELECT indicator FROM BSC_DBGEN_FACTS
  WHERE source = p_application_source
  AND fact_name = p_fact_name;*/

Line: 299

  SELECT PROPERTY_VALUE
  FROM BSC_KPI_PROPERTIES
  WHERE INDICATOR = p_kpi
  AND PROPERTY_CODE = p_property;

Line: 382

select source_table_name from bsc_db_tables_rels
connect by table_name = prior source_table_name
start with table_name = p_table_name;

Line: 403

select count(1)
from bsc_db_tables tbl,
bsc_db_tables_rels rels
where
rels.table_name = p_table_name
and rels.source_table_name = tbl.table_name
and tbl.table_type = 0;

Line: 416

  SELECT table_type INTO l_table_type FROM BSC_DB_TABLES where table_name = p_table_name;

Line: 418

      SELECT count(1) INTO l_table_type FROM BSC_SYS_DIM_LEVELS_B where level_table_name = p_table_name;

Line: 455

select log_table from all_snapshot_logs where log_owner=p_owner and master = p_table_name;

Line: 542

    select distinct indicator from bsc_kpi_data_tables where
table_name in (
select distinct rels.table_name
from bsc_db_Tables_rels rels
connect by prior table_name=source_table_name
start with rels.source_table_name = p_b_table_name);

Line: 570

    SELECT 1 FROM ALL_TABLES
    WHERE TABLE_NAME = pTableName
    AND OWNER = pOwner;

Line: 606

    SELECT 1 FROM ALL_TABLES
    WHERE TABLE_NAME = pTableName
    AND OWNER = pOwner
    AND TEMPORARY = 'Y';

Line: 683

select table_owner from user_synonyms
where synonym_name=p_table_name;