APPS.EDW_BSC_BRIDGE SQL Statements

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

Line: 50

SELECT DIM_ID
FROM EDW_DIMENSIONS_MD_V
WHERE DIM_NAME = p_object_name;

Line: 55

SELECT
     FACT_ID
   , FACT_NAME
FROM EDW_FACTS_MD_V;

Line: 63

SELECT
    FACT_ID
FROM EDW_FACTS_MD_V
WHERE FACT_NAME = p_fact_name;

Line: 71

SELECT HIER_ID
FROM EDW_HIERARCHIES_MD_V
WHERE
 DIM_ID = v_time_dimension_id
AND HIER_PREFIX = p_hier_prefix;

Line: 79

SELECT
  FACT_FK_COL_NAME
FROM EDW_FACT_DIM_RELATIONS_MD_V
WHERE
    DIM_ID = v_time_dimension_id
    -- use the cached id for better performance,
    -- it is instanciated at the intialization.
AND FACT_NAME = p_fact_name;

Line: 91

SELECT
  FACT_FK_COL_NAME
FROM EDW_FACT_DIM_RELATIONS_MD_V
WHERE
    DIM_ID <> v_time_dimension_id
    -- use the cached id for better performance,
    -- it is instanciated at the intialization.
AND FACT_NAME = p_fact_name;

Line: 102

SELECT
  ATTRIBUTE_ID ,
  ATTRIBUTE_NAME
FROM EDW_FACT_ATTRIBUTES_MD_V
WHERE FACT_NAME = p_fact_name
AND ATTRIBUTE_TYPE = 'MEASURE';

Line: 115

SELECT
  ATTRIBUTE_ID
FROM EDW_FACT_ATTRIBUTES_MD_V
WHERE
    FACT_NAME = p_fact_name
AND ATTRIBUTE_NAME = p_measure_name
AND ATTRIBUTE_TYPE = 'MEASURE';

Line: 127

SELECT
  object_name
FROM
  user_objects
WHERE
    object_name = UPPER(p_fact_name)
AND object_type = 'TABLE';

Line: 138

SELECT
  object_name
FROM
  user_objects
WHERE
    object_name = UPPER(p_fact_name)
AND object_type = 'SYNONYM';

Line: 152

SELECT
  COUNT(TAB.COLUMN_NAME)
FROM
  ALL_TAB_COLUMNS TAB, USER_SYNONYMS SYN
WHERE
    TAB.TABLE_NAME = UPPER(p_tbl_name) AND
    SYN.TABLE_NAME = TAB.TABLE_NAME  AND
    SYN.TABLE_OWNER = TAB.OWNER AND
    TAB.COLUMN_NAME = UPPER(p_col_name);

Line: 601

  SELECT
    USERNAME
   FROM USER_USERS;

Line: 644

  INSERT INTO EDW_CALSUM4_BSC_LOG(CODE, TEXT, INFO, LAST_UPDATE_DATE, CREATION_DATE)
    VALUES(p_code, p_text, p_info, SYSDATE, SYSDATE);

Line: 713

    'INSERT INTO EDW_CALSUM4_BSC(FACT, FACT_ID, MEASURE, MEASURE_ID, TIMEHIER, HIERID, CALSUMMARY, CALSUM_ID, LAST_UPDATE_DATE, CREATION_DATE) ';

Line: 718

    'SELECT DISTINCT'
    || l_calsum_stmt_psudo
    || '''445'''        || ', '
    || GET_TIME_HIER_ID('TIME45')
    || ', DIM.P445_NAME '
    || ', DIM.P445_PERIOD_445_PK_KEY, SYSDATE, SYSDATE'
    || l_calsum_fromwhere_clause
    || ' AND DIM.P445_PERIOD_445_PK_KEY IS NOT NULL'
    || ' AND DIM.P445_PERIOD_445_PK_KEY != 0 '
    || ' AND DIM.P445_PERIOD_445_PK_KEY != -1 ';

Line: 731

    'SELECT DISTINCT'
    || l_calsum_stmt_psudo
    || '''PA'''         || ', '
    || GET_TIME_HIER_ID('TIMEPA')
    || ', DIM.CNAM_CAL_NAME '
    || ', DIM.CNAM_CAL_NAME_PK_KEY  , SYSDATE, SYSDATE'
    || l_calsum_fromwhere_clause
    || ' AND DIM.PPER_PA_PERIOD_PK_KEY IS NOT NULL'
    || ' AND DIM.CNAM_CAL_NAME_PK_KEY IS NOT NULL'
    || ' AND DIM.CNAM_CAL_NAME_PK_KEY != 0 '
    || ' AND DIM.CNAM_CAL_NAME_PK_KEY != -1 ';

Line: 745

    'SELECT DISTINCT'
    || l_calsum_stmt_psudo
    || '''GL'''         || ', '
    || GET_TIME_HIER_ID('TIMEGL')
    || ', DIM.CNAM_CAL_NAME '
    || ', DIM.CNAM_CAL_NAME_PK_KEY  , SYSDATE, SYSDATE'
    || l_calsum_fromwhere_clause
    || ' AND DIM.CNAM_CAL_NAME_PK_KEY IS NOT NULL'
    || ' AND DIM.CNAM_CAL_NAME_PK_KEY != 0 '
    || ' AND DIM.CNAM_CAL_NAME_PK_KEY != -1 ';

Line: 758

    'SELECT DISTINCT'
    || l_calsum_stmt_psudo
    || '''GREGERION'''  || ', '
    || GET_TIME_HIER_ID('TIMEGR')
    || ', DIM.YEAR_NAME '
    || ', DIM.YEAR_YEAR_PK_KEY , SYSDATE, SYSDATE'
    || l_calsum_fromwhere_clause
    || ' AND DIM.YEAR_YEAR_PK_KEY IS NOT NULL'
    || ' AND DIM.YEAR_YEAR_PK_KEY != 0 '
    || ' AND DIM.YEAR_YEAR_PK_KEY != -1 ';

Line: 771

    'SELECT DISTINCT'
    || l_calsum_stmt_psudo
    || '''ENTERPRISE''' || ', '
    || GET_TIME_HIER_ID('TIMEEP')
    || ', DIM.ECNM_CAL_NAME '
    || ', DIM.ECNM_CAL_NAME_PK_KEY  , SYSDATE, SYSDATE'
    || l_calsum_fromwhere_clause
    || ' AND DIM.ECNM_CAL_NAME_PK_KEY IS NOT NULL'
    || ' AND DIM.ECNM_CAL_NAME_PK_KEY != 0 '
    || ' AND DIM.ECNM_CAL_NAME_PK_KEY != -1 ';

Line: 925

  select level_name into l_level_name
  from edw_levels_md_v lvl
  where dim_name = p_dim
  and not exists(
  select 1 from
    edw_hierarchy_level_md_v hier
  where
       hier.dim_name = lvl.dim_name
  and  hier.parent_lvl_id = lvl.level_id);

Line: 943

  select level_name into l_level_name
  from edw_levels_md_v lvl
  where dim_id = p_dim_id
  and not exists(
  select 1 from
    edw_hierarchy_level_md_v hier
  where
       hier.dim_name = lvl.dim_name
  and  hier.parent_lvl_id = lvl.level_id);