APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 347: FROM bsc_sys_dim_level_rels a

343: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
344: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
345: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
346: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
347: FROM bsc_sys_dim_level_rels a
348: WHERE a.dim_level_id = p_dim_level_id
349: AND a.relation_type=1
350: AND a.dim_level_id IN
351: (SELECT dim_level_id

Line 357: FROM bsc_sys_dim_level_rels a

353: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));
354:
355: CURSOR c_childs IS
356: SELECT a.dim_level_id child_dim_level_id
357: FROM bsc_sys_dim_level_rels a
358: WHERE a.parent_dim_level_id = p_dim_level_id
359: AND a.relation_type=1
360: AND a.dim_level_id IN
361: (SELECT dim_level_id

Line 568: FROM bsc_sys_dim_level_rels a

564: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
565: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
566: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
567: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
568: FROM bsc_sys_dim_level_rels a
569: WHERE a.dim_level_id = p_dim_level_id
570: AND a.relation_type=1;
571:
572: CURSOR c_fil_view IS

Line 832: FROM bsc_sys_dim_level_rels a

828: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
829: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
830: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
831: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
832: FROM bsc_sys_dim_level_rels a
833: WHERE a.dim_level_id = p_dim_level_id AND a.relation_type=1 ;
834:
835: CURSOR c_dim_view IS
836: SELECT level_view_name

Line 1104: FROM bsc_sys_dim_level_rels

1100: AND dim_level_id = p_pa_level_id;
1101:
1102: CURSOR c_rel_col is
1103: SELECT relation_col
1104: FROM bsc_sys_dim_level_rels
1105: WHERE dim_level_id = p_ch_level_id AND parent_dim_level_id = p_pa_level_id;
1106:
1107: BEGIN
1108:

Line 1396: FROM bsc_sys_dim_level_rels a

1392: WHERE d.dim_level_id = p_dim_level_id);
1393:
1394: CURSOR c_parents IS
1395: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col
1396: FROM bsc_sys_dim_level_rels a
1397: WHERE a.dim_level_id = p_dim_level_id
1398: AND a.relation_type=1
1399: AND EXISTS ( SELECT indicator
1400: FROM bsc_kpi_dim_level_properties b

Line 1409: FROM bsc_sys_dim_level_rels a

1405: );
1406:
1407: CURSOR c_childs IS
1408: SELECT a.dim_level_id child_dim_level_id
1409: FROM bsc_sys_dim_level_rels a
1410: WHERE a.parent_dim_level_id = p_dim_level_id
1411: AND a.relation_type=1
1412: AND EXISTS (SELECT b.dim_level_id
1413: FROM bsc_kpi_dim_level_properties b

Line 1578: FROM bsc_sys_dim_level_rels a

1574: );
1575:
1576: CURSOR c_parents IS
1577: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col
1578: FROM bsc_sys_dim_level_rels a
1579: WHERE a.dim_level_id = p_parent_level_id
1580: AND a.relation_type=1
1581: AND EXISTS ( SELECT indicator
1582: FROM bsc_kpi_dim_level_properties b

Line 1792: FROM bsc_sys_dim_level_rels a

1788:
1789: CURSOR c_childs IS
1790: SELECT a.dim_level_id child_dim_level_id,
1791: (SELECT b.short_name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.dim_level_id and rownum < 2) child_short_name
1792: FROM bsc_sys_dim_level_rels a
1793: WHERE a.parent_dim_level_id = p_dim_level_id
1794: AND a.relation_type=1
1795: AND a.dim_level_id IN
1796: (SELECT dim_level_id