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.

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 154: l_dim_level_id bsc_sys_dim_levels_b.dim_level_id%TYPE;

150: , x_msg_count OUT NOCOPY NUMBER
151: , x_msg_data OUT NOCOPY VARCHAR2
152: )IS
153: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
154: l_dim_level_id bsc_sys_dim_levels_b.dim_level_id%TYPE;
155: BEGIN
156: SELECT
157: d.dim_level_id
158: INTO

Line 162: bsc_sys_dim_levels_b d

158: INTO
159: l_dim_level_id
160: FROM
161: bsc_kpi_dim_levels_b kd,
162: bsc_sys_dim_levels_b d
163: WHERE
164: kd.indicator = p_indicator
165: AND kd.level_table_name = d.level_table_name
166: AND kd.dim_set_id = p_dim_set_id

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 1171: , BSC_SYS_DIM_LEVELS_B C

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
1175: AND A.Dim_Group_ID = l_dimension_id;

Line 1308: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

1304: ) IS
1305: l_DimObj_ViewBy_Tbl BSC_BIS_KPI_MEAS_PUB.DimObj_Viewby_Tbl_Type;
1306: l_flag BOOLEAN;
1307: l_temp_var VARCHAR2(32000);
1308: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
1309: BEGIN
1310: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Get_PMF_Defaults procedure');
1311: FND_MSG_PUB.Initialize;
1312: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3894: l_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;

3890: ( p_Indicator IN NUMBER
3891: , p_DimSetId IN NUMBER
3892: ) RETURN VARCHAR2
3893: IS
3894: l_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
3895: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
3896: BEGIN
3897: BSC_BIS_KPI_MEAS_PUB.get_Dim_Set_Source_Info
3898: ( p_Indicator => p_Indicator

Line 4086: l_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

4082: l_temp_var VARCHAR2(32000);
4083: l_count NUMBER;
4084: l_alias VARCHAR2(4);
4085:
4086: l_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4087: l_temp_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4088: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
4089: l_dim_obj_short_names VARCHAR2(32000);
4090: l_default_short_names VARCHAR2(32000);

Line 4087: l_temp_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

4083: l_count NUMBER;
4084: l_alias VARCHAR2(4);
4085:
4086: l_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4087: l_temp_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4088: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
4089: l_dim_obj_short_names VARCHAR2(32000);
4090: l_default_short_names VARCHAR2(32000);
4091: l_view_by_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

Line 4091: l_view_by_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

4087: l_temp_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4088: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
4089: l_dim_obj_short_names VARCHAR2(32000);
4090: l_default_short_names VARCHAR2(32000);
4091: l_view_by_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
4092: l_dim_set_id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE;
4093:
4094: l_dim_obj_names VARCHAR2(32000);
4095: l_dim_obj_name VARCHAR2(30);

Line 4381: FROM BSC_SYS_DIM_LEVELS_B

4377: ) LOOP
4378: --dbms_output.PUT_LINE('locking .. '|| l_dim_obj_name);
4379: -- added for Bug#3549057
4380: SELECT COUNT(1) INTO l_Count
4381: FROM BSC_SYS_DIM_LEVELS_B
4382: WHERE SHORT_NAME = l_dim_obj_name;
4383:
4384: IF (l_Count > 0) THEN
4385:

Line 4523: FROM BSC_SYS_DIM_LEVELS_B

4519: l_bsc_dimset_rec.Bsc_Kpi_Id := l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4520: l_bsc_dimset_rec.Bsc_Dim_Set_Id := l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id;
4521: SELECT level_table_name
4522: INTO l_bsc_dimset_rec.Bsc_Level_Name
4523: FROM BSC_SYS_DIM_LEVELS_B
4524: WHERE Short_Name = l_dim_obj_name;
4525: BSC_DIMENSION_SETS_PUB.Update_Dim_Levels
4526: ( p_commit => FND_API.G_FALSE
4527: , p_Dim_Set_Rec => l_bsc_dimset_rec

Line 4561: FROM BSC_SYS_DIM_LEVELS_B

4557: l_bsc_dimset_rec.Bsc_Kpi_Id := l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4558: l_bsc_dimset_rec.Bsc_Dim_Set_Id := l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id;
4559: SELECT level_table_name
4560: INTO l_bsc_dimset_rec.Bsc_Level_Name
4561: FROM BSC_SYS_DIM_LEVELS_B
4562: WHERE Short_Name = l_view_by_name;
4563: BSC_DIMENSION_SETS_PUB.Update_Dim_Levels
4564: ( p_commit => FND_API.G_FALSE
4565: , p_Dim_Set_Rec => l_bsc_dimset_rec

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 7147: FROM BSC_SYS_DIM_LEVELS_B VL ,

7143: ORDER BY B.Dim_Group_Index;
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

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;