eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DBGEN_BSC_READER dependencies on BSC_SYS_DIM_LEVELS_B

Line 643: FROM bsc_sys_dim_level_rels rels, bsc_sys_dim_levels_b childlvl, bsc_sys_dim_levels_b parentlvl

639: (
640: SELECT childlvl.level_Table_name child_lvl
641: , parentlvl.level_Table_name parent_lvl
642: , LEVEL lvl
643: FROM bsc_sys_dim_level_rels rels, bsc_sys_dim_levels_b childlvl, bsc_sys_dim_levels_b parentlvl
644: WHERE rels.parent_dim_level_id = parentlvl.dim_level_id
645: AND rels.dim_level_id = childlvl.dim_level_id
646: START WITH parent_dim_level_id = parentlvl.dim_level_id
647: AND parentlvl.level_table_name = p_parent_level

Line 684: FROM BSC_SYS_DIM_LEVELS_B child_lvl, BSC_SYS_DIM_LEVELS_B parent_lvl, BSC_SYS_DIM_LEVEL_RELS Rels

680: Function is_parent_1N(p_child_level IN VARCHAR2, p_parent_level IN VARCHAR2 ) RETURN boolean IS
681:
682: CURSOR cParent is
683: SELECT count(1)
684: FROM BSC_SYS_DIM_LEVELS_B child_lvl, BSC_SYS_DIM_LEVELS_B parent_lvl, BSC_SYS_DIM_LEVEL_RELS Rels
685: WHERE
686: child_lvl.LEVEL_TABLE_NAME = p_child_level
687: AND parent_lvl.level_table_name= p_parent_level
688: AND child_lvl.DIM_LEVEL_ID = Rels.DIM_LEVEL_ID

Line 715: FROM BSC_SYS_DIM_LEVELS_B child_lvl, BSC_SYS_DIM_LEVELS_B parent_lvl, BSC_SYS_DIM_LEVEL_RELS Rels

711: --***************************************************************************
712: Function is_parent_MN(p_child_level IN VARCHAR2, p_parent_level IN VARCHAR2 ) RETURN boolean IS
713: CURSOR cParent IS
714: SELECT count(1)
715: FROM BSC_SYS_DIM_LEVELS_B child_lvl, BSC_SYS_DIM_LEVELS_B parent_lvl, BSC_SYS_DIM_LEVEL_RELS Rels
716: WHERE
717: child_lvl.LEVEL_TABLE_NAME = p_child_level
718: AND parent_lvl.level_table_name= p_parent_level
719: AND child_lvl.DIM_LEVEL_ID = Rels.DIM_LEVEL_ID

Line 1523: ' , sysdim.dim_level_id, kpidim.parent_level_rel FROM BSC_KPI_DIM_LEVELS_VL kpidim, BSC_SYS_DIM_LEVELS_B sysdim

1519: l_level_null BSC_DBGEN_STD_METADATA.clsLevel;
1520:
1521: BEGIN
1522: l_stmt := 'SELECT DISTINCT kpidim.DIM_LEVEL_INDEX, kpidim.LEVEL_TABLE_NAME, kpidim.LEVEL_PK_COL, kpidim.NAME, NVL(kpidim.TARGET_LEVEL,1) AS TAR_LEVEL' ||
1523: ' , sysdim.dim_level_id, kpidim.parent_level_rel FROM BSC_KPI_DIM_LEVELS_VL kpidim, BSC_SYS_DIM_LEVELS_B sysdim
1524: WHERE
1525: kpidim.level_table_name = sysdim.level_table_name
1526: AND kpidim.INDICATOR = :1 AND kpidim.DIM_SET_ID = :2 AND kpidim.STATUS = 2';
1527:

Line 1629: bsc_sys_dim_levels_b lvl,

1625: CURSOR cParents IS
1626: select parent_lvl.level_table_name parent_level, lvl.level_table_name child_level, 'CODE' parent_pk, parent_lvl.level_pk_col child_fk, level
1627: from
1628: bsc_sys_dim_level_rels rels,
1629: bsc_sys_dim_levels_b lvl,
1630: bsc_sys_dim_levels_b parent_lvl
1631: where
1632: lvl.dim_level_id = rels.dim_level_id and
1633: rels.parent_dim_level_id = parent_lvl.dim_level_id and

Line 1630: bsc_sys_dim_levels_b parent_lvl

1626: select parent_lvl.level_table_name parent_level, lvl.level_table_name child_level, 'CODE' parent_pk, parent_lvl.level_pk_col child_fk, level
1627: from
1628: bsc_sys_dim_level_rels rels,
1629: bsc_sys_dim_levels_b lvl,
1630: bsc_sys_dim_levels_b parent_lvl
1631: where
1632: lvl.dim_level_id = rels.dim_level_id and
1633: rels.parent_dim_level_id = parent_lvl.dim_level_id and
1634: rels.relation_type <> 2 and

Line 1640: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)

1636: connect by rels.dim_level_id= PRIOR rels.parent_dim_level_id
1637: and rels.relation_type<>2
1638: and rels.dim_level_id <> rels.parent_dim_level_id
1639: start with rels.dim_level_id in
1640: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)
1641: order by level;
1642:
1643: l_lvl_rel BSC_DBGEN_STD_METADATA.ClsLevelRelationship;
1644: l_tab_rels BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

Line 1670: bsc_sys_dim_levels_b lvl,

1666: CURSOR cChildren IS
1667: select parent_lvl.level_table_name parent_level, lvl.level_table_name child_level, 'CODE' parent_pk, rels.relation_col child_fk, level
1668: from
1669: bsc_sys_dim_level_rels rels,
1670: bsc_sys_dim_levels_b lvl,
1671: bsc_sys_dim_levels_b parent_lvl
1672: where
1673: lvl.dim_level_id = rels.dim_level_id and
1674: rels.parent_dim_level_id = parent_lvl.dim_level_id and

Line 1671: bsc_sys_dim_levels_b parent_lvl

1667: select parent_lvl.level_table_name parent_level, lvl.level_table_name child_level, 'CODE' parent_pk, rels.relation_col child_fk, level
1668: from
1669: bsc_sys_dim_level_rels rels,
1670: bsc_sys_dim_levels_b lvl,
1671: bsc_sys_dim_levels_b parent_lvl
1672: where
1673: lvl.dim_level_id = rels.dim_level_id and
1674: rels.parent_dim_level_id = parent_lvl.dim_level_id and
1675: rels.relation_type <> 2 and

Line 1680: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)

1676: level <= p_num_levels
1677: connect by PRIOR rels.dim_level_id||rels.relation_type = rels.parent_dim_level_id||1
1678: and rels.dim_level_id <> rels.parent_dim_level_id
1679: start with rels.parent_dim_level_id in
1680: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)
1681: order by level;
1682: l_lvl_rel BSC_DBGEN_STD_METADATA.ClsLevelRelationship;
1683: l_tab_rels BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
1684: BEGIN

Line 1705: FROM bsc_sys_dim_levels_b

1701: ) return BSC_DBGEN_STD_METADATA.clsLevel is
1702: l_level BSC_DBGEN_STD_METADATA.clsLevel ;
1703: CURSOR c_level IS
1704: SELECT dim_level_id , level_pk_col
1705: FROM bsc_sys_dim_levels_b
1706: WHERE level_table_name = p_level;
1707: Begin
1708: l_level.Level_Name := p_level;
1709: OPEN c_level;

Line 1819: select distinct dim_level_id, level_table_name, level_pk_col from bsc_db_tables_cols cols, bsc_sys_dim_levels_b lvl

1815: p_table_name varchar2,
1816: p_table_type VARCHAR2) return BSC_DBGEN_STD_METADATA.tab_clsLevel is
1817: l_level BSC_DBGEN_STD_METADATA.clsLevel ;
1818: cursor cLevels(p_s_table VARCHAR2) IS
1819: select distinct dim_level_id, level_table_name, level_pk_col from bsc_db_tables_cols cols, bsc_sys_dim_levels_b lvl
1820: where
1821: cols.table_name like p_s_table
1822: and cols.column_type='P'
1823: and cols.column_name = lvl.level_pk_col;

Line 2064: bsc_sys_dim_levels_b a,

2060: cursor c1(p_kpi number) is
2061: select
2062: a.DIM_LEVEL_ID,a.LEVEL_TABLE_NAME,a.level_pk_col
2063: from
2064: bsc_sys_dim_levels_b a,
2065: (select a.LEVEL_TABLE_NAME,0 RELATION_TYPE
2066: from
2067: bsc_kpi_dim_levels_b a
2068: where

Line 2076: bsc_sys_dim_levels_b c,

2072: select a.LEVEL_TABLE_NAME,e.RELATION_TYPE
2073: from
2074: bsc_kpi_dim_levels_b a,
2075: bsc_kpi_dim_levels_b b,
2076: bsc_sys_dim_levels_b c,
2077: bsc_sys_dim_levels_b d,
2078: bsc_sys_dim_level_rels e
2079: where
2080: a.indicator=p_kpi

Line 2077: bsc_sys_dim_levels_b d,

2073: from
2074: bsc_kpi_dim_levels_b a,
2075: bsc_kpi_dim_levels_b b,
2076: bsc_sys_dim_levels_b c,
2077: bsc_sys_dim_levels_b d,
2078: bsc_sys_dim_level_rels e
2079: where
2080: a.indicator=p_kpi
2081: and b.indicator=p_kpi

Line 2156: bsc_sys_dim_levels_b sysdim,

2152: l_stmt VARCHAR2(1000);
2153: CURSOR cFilter IS
2154: select sysdim.dim_level_id, source_type, source_code
2155: from bsc_kpi_dim_levels_b kpidim,
2156: bsc_sys_dim_levels_b sysdim,
2157: bsc_sys_filters_views filters
2158: where
2159: kpidim.level_table_name = sysdim.level_table_name
2160: and kpidim.level_view_name <> sysdim.level_view_name

Line 2485: FROM bsc_sys_dim_levels_b

2481: function get_dimension_level_short_name(p_dim_level_table_name IN VARCHAR2) return VARCHAR2
2482: IS
2483: CURSOR cShortName IS
2484: SELECT short_name
2485: FROM bsc_sys_dim_levels_b
2486: WHERE level_table_name = p_dim_level_table_name;
2487: l_short_name VARCHAR2(100);
2488: BEGIN
2489: OPEN cShortName;

Line 2543: FROM bsc_sys_dim_levels_b sysd, bsc_tmp_big_in_cond tmp

2539: l_index number;
2540: l_variable_id number := 1;
2541: CURSOR c1(p_session_id NUMBER, p_variable_id NUMBER) IS
2542: SELECT nvl(sysd.level_table_name, tmp.value_v) level_table_name
2543: FROM bsc_sys_dim_levels_b sysd, bsc_tmp_big_in_cond tmp
2544: where tmp.session_id = p_session_id
2545: and tmp.variable_id = p_variable_id
2546: and tmp.value_v = sysd.short_name(+)
2547: order by tmp.value_n;

Line 2681: bsc_sys_dim_levels_b lvl,

2677: parent_lvl.level_pk_col child_fk,
2678: level
2679: from
2680: bsc_sys_dim_level_rels rels,
2681: bsc_sys_dim_levels_b lvl,
2682: bsc_sys_dim_levels_b parent_lvl
2683: where
2684: lvl.dim_level_id = rels.dim_level_id and
2685: rels.parent_dim_level_id = parent_lvl.dim_level_id and

Line 2682: bsc_sys_dim_levels_b parent_lvl

2678: level
2679: from
2680: bsc_sys_dim_level_rels rels,
2681: bsc_sys_dim_levels_b lvl,
2682: bsc_sys_dim_levels_b parent_lvl
2683: where
2684: lvl.dim_level_id = rels.dim_level_id and
2685: rels.parent_dim_level_id = parent_lvl.dim_level_id and
2686: rels.relation_type <> 2 and

Line 2692: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)

2688: connect by rels.dim_level_id= PRIOR rels.parent_dim_level_id
2689: and rels.relation_type<>2
2690: and rels.dim_level_id <> rels.parent_dim_level_id
2691: start with rels.dim_level_id in
2692: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)
2693: order by level;
2694:
2695: l_lvl_rel BSC_DBGEN_STD_METADATA.ClsLevelRelationship;
2696: l_tab_rels BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;

Line 2727: bsc_sys_dim_levels_b lvl,

2723: CURSOR cChildren IS
2724: select parent_lvl.level_table_name parent_level, lvl.level_table_name child_level, 'CODE' parent_pk, rels.relation_col child_fk, level
2725: from
2726: bsc_sys_dim_level_rels rels,
2727: bsc_sys_dim_levels_b lvl,
2728: bsc_sys_dim_levels_b parent_lvl
2729: where
2730: lvl.dim_level_id = rels.dim_level_id and
2731: rels.parent_dim_level_id = parent_lvl.dim_level_id and

Line 2728: bsc_sys_dim_levels_b parent_lvl

2724: select parent_lvl.level_table_name parent_level, lvl.level_table_name child_level, 'CODE' parent_pk, rels.relation_col child_fk, level
2725: from
2726: bsc_sys_dim_level_rels rels,
2727: bsc_sys_dim_levels_b lvl,
2728: bsc_sys_dim_levels_b parent_lvl
2729: where
2730: lvl.dim_level_id = rels.dim_level_id and
2731: rels.parent_dim_level_id = parent_lvl.dim_level_id and
2732: rels.relation_type <> 2 and

Line 2737: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)

2733: level <= p_num_levels
2734: connect by PRIOR rels.dim_level_id||rels.relation_type = rels.parent_dim_level_id||1
2735: and rels.dim_level_id <> rels.parent_dim_level_id
2736: start with rels.parent_dim_level_id in
2737: (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)
2738: order by level;
2739: l_lvl_rel BSC_DBGEN_STD_METADATA.ClsLevelRelationship;
2740: l_tab_rels BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship;
2741: BEGIN