APPS.BSC_DBGEN_BSC_READER dependencies on BSC_SYS_DIM_LEVEL_RELS

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 1628: bsc_sys_dim_level_rels rels,

1624: ) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship IS
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

Line 1669: bsc_sys_dim_level_rels rels,

1665: ) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship IS
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

Line 2078: bsc_sys_dim_level_rels e

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
2082: and a.PARENT_LEVEL_INDEX=b.DIM_LEVEL_INDEX

Line 2680: bsc_sys_dim_level_rels rels,

2676: --rels.relation_col child_fk,
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

Line 2726: bsc_sys_dim_level_rels rels,

2722: ) RETURN BSC_DBGEN_STD_METADATA.tab_ClsLevelRelationship IS
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