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.

[Home] [Help]

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_SYS_DIM_GROUPS_VL

Line 631: , BSC_SYS_DIM_GROUPS_VL B

627: SELECT A.Dim_Group_Id
628: , A.Dim_Group_Index
629: , B.Short_Name
630: FROM BSC_KPI_DIM_GROUPS A
631: , BSC_SYS_DIM_GROUPS_VL B
632: WHERE A.Indicator = p_kpi_id
633: AND A.Dim_Set_Id = p_dim_set_id
634: AND A.Dim_Group_ID = B.Dim_Group_ID
635: ORDER BY A.Dim_Group_Index;

Line 1169: FROM BSC_SYS_DIM_GROUPS_VL A

1165: AND Indicator = p_Kpi_Id;
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

Line 1196: FROM BSC_SYS_DIM_GROUPS_VL

1192: END LOOP;
1193: IF (l_flag) THEN
1194: --first delete the remove dimension from dimension set and indicator combination
1195: SELECT short_name INTO l_temp_var
1196: FROM BSC_SYS_DIM_GROUPS_VL
1197: WHERE dim_group_id = l_dimension_id;
1198: -- START Granular Locking
1199: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
1200: ( p_Kpi_Id => p_Kpi_Id

Line 1985: SELECT short_name FROM BSC_SYS_DIM_GROUPS_VL

1981: l_count NUMBER := 0;
1982: l_meaning VARCHAR(60);
1983:
1984: CURSOR p_unassign_dim_names IS
1985: SELECT short_name FROM BSC_SYS_DIM_GROUPS_VL
1986: WHERE dim_group_id IN (SELECT dim_group_id
1987: FROM BSC_KPI_DIM_GROUPS
1988: WHERE dim_set_id = p_dim_set_id
1989: AND indicator = p_kpi_id);

Line 2683: FROM BSC_SYS_DIM_GROUPS_VL

2679: WHILE (is_more( p_dim_short_names => l_temp_var
2680: , p_dim_short_name => l_dim_short_name)
2681: ) LOOP
2682: SELECT COUNT(*) INTO l_count
2683: FROM BSC_SYS_DIM_GROUPS_VL
2684: WHERE short_name = l_dim_short_name;
2685: IF (l_count = 0) THEN
2686: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
2687: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dim_short_name);

Line 2694: WHERE dim_group_id = (SELECT dim_group_id FROM BSC_SYS_DIM_GROUPS_VL WHERE Short_Name = l_dim_short_name)

2690: END IF;
2691:
2692: SELECT COUNT(*) INTO l_count
2693: FROM BSC_KPI_DIM_GROUPS
2694: WHERE dim_group_id = (SELECT dim_group_id FROM BSC_SYS_DIM_GROUPS_VL WHERE Short_Name = l_dim_short_name)
2695: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
2696: AND indicator = l_bsc_dimset_rec.Bsc_Kpi_Id;
2697: IF (l_count = 0) THEN
2698: IF (l_dim_short_names IS NULL) THEN

Line 3143: , BSC_SYS_DIM_GROUPS_VL B

3139:
3140: CURSOR c_dim_index IS
3141: SELECT B.Short_Name
3142: FROM BSC_KPI_DIM_GROUPS A
3143: , BSC_SYS_DIM_GROUPS_VL B
3144: WHERE A.Indicator = p_kpi_id
3145: AND A.Dim_Set_Id = p_dim_set_id
3146: AND A.Dim_Group_ID = B.Dim_Group_ID
3147: ORDER BY A.Dim_Group_Index;

Line 3216: FROM BSC_SYS_DIM_GROUPS_VL A

3212: WHILE (Is_More( p_dim_short_names => l_dim_short_names
3213: , p_dim_short_name => l_dim_short_name)
3214: ) LOOP
3215: SELECT COUNT(*) INTO l_count
3216: FROM BSC_SYS_DIM_GROUPS_VL A
3217: , BSC_KPI_DIM_GROUPS B
3218: WHERE A.short_name = l_dim_short_name
3219: AND A.Dim_Group_Id = B.Dim_Group_Id
3220: AND B.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id

Line 3225: FROM BSC_SYS_DIM_GROUPS_VL

3221: AND B.Dim_Set_Id = p_dim_set_id;
3222: IF (l_count <> 0) THEN
3223: SELECT dim_group_id
3224: INTO l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id
3225: FROM BSC_SYS_DIM_GROUPS_VL
3226: WHERE short_name = l_dim_short_name;
3227: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id <'||l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id||'>');
3228: l_kpi_flag_change := TRUE;
3229: BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset

Line 3270: FROM BSC_SYS_DIM_GROUPS_VL A

3266: WHILE (Is_More( p_dim_short_names => l_dim_short_names
3267: , p_dim_short_name => l_dim_short_name)
3268: ) LOOP
3269: SELECT COUNT(*) INTO l_count
3270: FROM BSC_SYS_DIM_GROUPS_VL A
3271: , BSC_KPI_DIM_GROUPS B
3272: WHERE A.short_name = l_dim_short_name
3273: AND A.Dim_Group_Id = B.Dim_Group_Id
3274: AND B.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id

Line 3279: FROM BSC_SYS_DIM_GROUPS_VL

3275: AND B.Dim_Set_Id = p_dim_set_id;
3276: IF (l_count <> 0) THEN
3277: SELECT dim_group_id
3278: INTO l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id
3279: FROM BSC_SYS_DIM_GROUPS_VL
3280: WHERE short_name = l_dim_short_name;
3281: -- START Granular Locking
3282: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
3283: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id

Line 3495: , BSC_SYS_DIM_GROUPS_VL B

3491: , p_dim_short_name => l_dim_short_name)
3492: ) LOOP
3493: SELECT COUNT(*) INTO l_count
3494: FROM BSC_KPI_DIM_GROUPS A
3495: , BSC_SYS_DIM_GROUPS_VL B
3496: WHERE A.Dim_Group_Id = B.Dim_Group_Id
3497: AND A.Indicator = l_bsc_dimset_rec.bsc_kpi_id
3498: AND A.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
3499: AND B.Short_Name = l_dim_short_name;

Line 3512: FROM BSC_SYS_DIM_GROUPS_VL

3508: AND dim_set_id = l_bsc_dimset_rec.bsc_dim_set_id;
3509:
3510: SELECT dim_group_id
3511: INTO l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id
3512: FROM BSC_SYS_DIM_GROUPS_VL
3513: WHERE short_name = l_dim_short_name;
3514: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id <'||l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id||'>');
3515: -- START : Granular Locking
3516: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP

Line 4417: FROM BSC_SYS_DIM_GROUPS_VL;

4413:
4414: IF (l_dim_obj_short_names IS NOT NULL) THEN
4415: --dbms_output.PUT_LINE('Create A Unique Dimension Group Short_Name As Well As Display Name');
4416: SELECT NVL(MAX(dim_group_id) + 1, 0) INTO l_count
4417: FROM BSC_SYS_DIM_GROUPS_VL;
4418:
4419: l_dim_short_name := l_dim_short_name||l_count;
4420: l_temp_var := l_dim_short_name;
4421: l_alias := NULL;

Line 4425: FROM BSC_SYS_DIM_GROUPS_VL

4421: l_alias := NULL;
4422: l_count := 0;
4423: WHILE (l_count <> 0) LOOP
4424: SELECT COUNT(*) INTO l_count
4425: FROM BSC_SYS_DIM_GROUPS_VL
4426: WHERE UPPER(short_name) = l_temp_var
4427: OR UPPER(name) = l_temp_var;
4428: IF (l_count = 0) THEN
4429: l_dim_short_name := l_temp_var;

Line 5589: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.DIM_GROUP_ID%TYPE;

5585: ) IS
5586: l_count NUMBER;
5587: l_tab_id NUMBER;
5588: l_regions VARCHAR2(32000);
5589: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.DIM_GROUP_ID%TYPE;
5590: l_dim_shortName BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE;
5591:
5592: CURSOR c_dim_group_id IS
5593: SELECT

Line 5590: l_dim_shortName BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE;

5586: l_count NUMBER;
5587: l_tab_id NUMBER;
5588: l_regions VARCHAR2(32000);
5589: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.DIM_GROUP_ID%TYPE;
5590: l_dim_shortName BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE;
5591:
5592: CURSOR c_dim_group_id IS
5593: SELECT
5594: dim_group_id

Line 5605: BSC_SYS_DIM_GROUPS_VL

5601: CURSOR c_dim_short_name(p_dim_group_id NUMBER) IS
5602: SELECT
5603: short_name
5604: FROM
5605: BSC_SYS_DIM_GROUPS_VL
5606: WHERE
5607: dim_group_id = p_dim_group_id;
5608:
5609:

Line 6340: , BSC_SYS_DIM_GROUPS_VL B

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;
6344: BEGIN

Line 6958: FROM BSC_SYS_DIM_GROUPS_VL A

6954:
6955: CURSOR c_Old_Dimensions IS
6956: SELECT A.Short_Name
6957: , B.Dim_Group_Index
6958: FROM BSC_SYS_DIM_GROUPS_VL A
6959: , BSC_KPI_DIM_GROUPS B
6960: WHERE A.Dim_Group_Id = B.Dim_Group_Id
6961: AND B.Indicator = p_Kpi_ID
6962: AND B.Dim_Set_ID = p_Dim_Set_ID

Line 7138: FROM BSC_SYS_DIM_GROUPS_VL A

7134: l_msg_count NUMBER;
7135:
7136: CURSOR cr_Old_Dimensions IS
7137: SELECT A.Short_Name
7138: FROM BSC_SYS_DIM_GROUPS_VL A
7139: , BSC_KPI_DIM_GROUPS B
7140: WHERE A.Dim_Group_Id = B.Dim_Group_Id
7141: AND B.Indicator = p_Kpi_ID
7142: AND B.Dim_Set_ID = p_Dim_Set_ID

Line 7149: BSC_SYS_DIM_GROUPS_VL TL

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;
7153:

Line 7205: BSC_SYS_DIM_GROUPS_VL vl

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 );
7209: IF(l_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIM) THEN

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;