APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_SYS_DIM_LEVELS_VL

Line 511: ' , BSC_SYS_DIM_LEVELS_VL D '||

507: ' FROM ' ||
508: ' BSC_TABS_VL A '||
509: ' , BSC_TAB_INDICATORS B '||
510: ' , BSC_KPI_DIM_LEVELS_VL C '||
511: ' , BSC_SYS_DIM_LEVELS_VL D '||
512: ' WHERE A.TAB_ID =B.TAB_ID '||
513: ' AND B.INDICATOR =C.INDICATOR '||
514: ' AND C.LEVEL_TABLE_NAME = D.LEVEL_TABLE_NAME '||
515: ' AND D.DIM_LEVEL_ID IN (:1,:2) ' ;

Line 1522: BSC_SYS_DIM_LEVELS_VL B,

1518: SELECT DISTINCT A.INDICATOR Indicator,
1519: A.DIM_SET_ID Dim_Set_Id,
1520: C.short_name
1521: FROM BSC_KPI_DIM_LEVELS_VL A,
1522: BSC_SYS_DIM_LEVELS_VL B,
1523: BSC_KPIS_B C
1524: WHERE A.LEVEL_TABLE_NAME=B.LEVEL_TABLE_NAME
1525: AND C.INDICATOR = A.INDICATOR
1526: AND C.SHARE_FLAG <> 2

Line 1591: FROM BSC_SYS_DIM_LEVELS_VL

1587: , p_dim_lev_id => l_rel_id
1588: )) LOOP
1589: SELECT NAME, SHORT_NAME
1590: INTO l_dim_obj_name, l_dim_obj_sname
1591: FROM BSC_SYS_DIM_LEVELS_VL
1592: WHERE DIM_LEVEL_ID = l_rel_id;
1593:
1594: BSC_UTILITY.Enable_Dimension_Entity(
1595: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT

Line 1615: FROM BSC_SYS_DIM_LEVELS_VL

1611: , p_dim_lev_id => l_rel_id
1612: )) LOOP
1613: SELECT NAME, SHORT_NAME
1614: INTO l_dim_obj_name, l_dim_obj_sname
1615: FROM BSC_SYS_DIM_LEVELS_VL
1616: WHERE DIM_LEVEL_ID = l_rel_id;
1617:
1618: BSC_UTILITY.Enable_Dimension_Entity(
1619: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT

Line 2741: , BSC_SYS_DIM_LEVELS_VL l

2737:
2738: CURSOR c_parent_dim_level_name IS
2739: SELECT l.name name
2740: FROM BSC_SYS_DIM_LEVEL_RELS r
2741: , BSC_SYS_DIM_LEVELS_VL l
2742: WHERE r.dim_level_id = p_dim_obj_id
2743: AND r.parent_dim_level_id = l.dim_level_id;
2744: BEGIN
2745: IF (c_parent_dim_level_name%ISOPEN) THEN

Line 2782: , BSC_SYS_DIM_LEVELS_VL l

2778:
2779: CURSOR c_child_dim_level_name IS
2780: SELECT l.name name
2781: FROM BSC_SYS_DIM_LEVEL_RELS r
2782: , BSC_SYS_DIM_LEVELS_VL l
2783: WHERE r.parent_dim_level_id = p_dim_obj_id
2784: AND r.dim_level_id = l.dim_level_id;
2785: BEGIN
2786: IF (c_child_dim_level_name%ISOPEN) THEN

Line 3717: BSC_SYS_DIM_LEVELS_VL B,

3713:
3714: CURSOR c_Kpi_Dim_Set1 IS
3715: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name, C.short_name
3716: FROM BSC_KPI_DIM_LEVELS_VL A,
3717: BSC_SYS_DIM_LEVELS_VL B,
3718: BSC_KPIS_VL C
3719: WHERE A.LEVEL_TABLE_NAME=B.LEVEL_TABLE_NAME
3720: AND C.INDICATOR = A.INDICATOR
3721: AND C.SHARE_FLAG <> 2

Line 4178: FROM bsc_sys_dim_levels_vl

4174: l_short_name VARCHAR2(32000);
4175:
4176: CURSOR C_SHORT_NAMES_IDS IS
4177: SELECT short_name
4178: FROM bsc_sys_dim_levels_vl
4179: WHERE INSTR(','||p_child_ids ||',',','||dim_level_id||',') > 0;
4180:
4181:
4182:

Line 4230: FROM BSC_SYS_DIM_LEVELS_VL

4226: --DBMS_OUTPUT.PUT_LINE('For present dimension object :- '|| p_dim_obj_id);
4227:
4228: SELECT SHORT_NAME
4229: INTO l_short_name
4230: FROM BSC_SYS_DIM_LEVELS_VL
4231: WHERE DIM_LEVEL_ID = p_dim_obj_id;
4232: --DBMS_OUTPUT.PUT_LINE('For present dimension object shortname :- '|| l_short_name);
4233: BSC_BIS_DIM_OBJ_PUB.Validate_PMF_Views
4234: (