APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

Line 1170: , BSC_SYS_DIM_LEVELS_BY_GROUP B

1166:
1167: CURSOR cr_bsc_dim IS
1168: SELECT C.Source Source
1169: FROM BSC_SYS_DIM_GROUPS_VL A
1170: , BSC_SYS_DIM_LEVELS_BY_GROUP B
1171: , BSC_SYS_DIM_LEVELS_B C
1172: WHERE A.Dim_Group_ID = B.Dim_Group_ID
1173: AND C.Dim_Level_ID = B.Dim_Level_ID
1174: AND A.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim

Line 6339: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A

6335: ORDER BY Dim_Group_Index;
6336:
6337: CURSOR c_dim_level_id IS
6338: SELECT A.Dim_Level_Id Dim_Level_Id
6339: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
6340: , BSC_SYS_DIM_GROUPS_VL B
6341: WHERE A.Dim_Group_Id = l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id
6342: AND A.Dim_Group_ID = B.Dim_Group_ID
6343: AND B.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

Line 6392: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL

6388: SELECT MAX(NUM) INTO l_count
6389: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
6390: , SYS_DIM_LEL.Dim_Level_Id
6391: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
6392: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
6393: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
6394: AND KPI_GROUP.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
6395: AND KPI_GROUP.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
6396: GROUP BY SYS_DIM_LEL.Dim_Level_Id);

Line 6508: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL

6504: SELECT MAX(NUM) INTO l_count
6505: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
6506: , SYS_DIM_LEL.Dim_Level_Id
6507: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
6508: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
6509: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
6510: AND KPI_GROUP.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
6511: AND KPI_GROUP.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
6512: GROUP BY SYS_DIM_LEL.Dim_Level_Id);

Line 6675: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

6671: ORDER BY Dim_Group_Index;
6672:
6673: CURSOR c_dim_level_id IS
6674: SELECT dim_level_id
6675: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
6676: WHERE dim_group_id = l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id;
6677: BEGIN
6678: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet procedure');
6679: FND_MSG_PUB.Initialize;

Line 7148: BSC_SYS_DIM_LEVELS_BY_GROUP DG ,

7144:
7145: CURSOR cr_dim_objs_in_dimset IS
7146: SELECT VL.SHORT_NAME
7147: FROM BSC_SYS_DIM_LEVELS_B VL ,
7148: BSC_SYS_DIM_LEVELS_BY_GROUP DG ,
7149: BSC_SYS_DIM_GROUPS_VL TL
7150: WHERE VL.DIM_LEVEL_ID = DG.DIM_LEVEL_ID
7151: AND DG.dim_group_id = TL.DIM_GROUP_ID
7152: AND INSTR(l_final_dim_names,','||TL.SHORT_NAME||',') > 0;

Line 7204: FROM BSC_SYS_DIM_LEVELS_BY_GROUP b,

7200: l_final_dim_names := ','||l_final_dim_names;
7201: --dbms_output.PUT_LINE('FINAL DIMS ARE '||l_final_dim_names);
7202:
7203: SELECT COUNT(b.dim_level_id) INTO l_count
7204: FROM BSC_SYS_DIM_LEVELS_BY_GROUP b,
7205: BSC_SYS_DIM_GROUPS_VL vl
7206: WHERE b.dim_group_id = vl.dim_group_id
7207: AND INSTR(l_final_dim_names,','||vl.short_name ||',')>0 ;
7208: --dbms_output.PUT_LINE('THE COUNT OF DIMOBJECTS :- '||l_count );

Line 8083: FROM bsc_sys_dim_levels_by_group dim_lvl, bsc_sys_dim_groups_vl dim

8079: SELECT 1
8080: FROM bsc_sys_com_dim_levels
8081: WHERE tab_id = p_tab_id
8082: AND dim_level_id IN ( SELECT dim_level_id
8083: FROM bsc_sys_dim_levels_by_group dim_lvl, bsc_sys_dim_groups_vl dim
8084: WHERE dim.short_name = p_dim
8085: AND dim.dim_group_id = dim_lvl.dim_group_id
8086: );
8087: l_common_dim NUMBER;