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_DIMENSION_PUB dependencies on BSC_KPI_DIM_GROUPS

Line 240: FROM BSC_KPI_DIM_GROUPS

236: l_Count NUMBER := 0;
237: BEGIN
238:
239: SELECT COUNT(1) INTO l_Count
240: FROM BSC_KPI_DIM_GROUPS
241: WHERE DIM_GROUP_ID= p_dim_group_id;
242: IF (l_Count = 0) THEN
243: RETURN FALSE;
244: ELSE

Line 723: FROM BSC_KPI_DIM_GROUPS A

719: CURSOR c_dim_set_kpi IS
720: SELECT DISTINCT A.indicator INDICATOR
721: , A.dim_set_id DIM_SET_ID
722: , A.Dim_Group_Index
723: FROM BSC_KPI_DIM_GROUPS A
724: , BSC_KPIS_B B
725: WHERE A.INDICATOR = B.INDICATOR
726: AND B.share_flag <> 2
727: AND A.dim_group_id = p_dim_group_id

Line 2875: FROM BSC_KPI_DIM_GROUPS

2871: l_count NUMBER;
2872:
2873: CURSOR c_indicators IS
2874: SELECT DISTINCT indicator
2875: FROM BSC_KPI_DIM_GROUPS
2876: WHERE dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
2877: -- END Granular Locking Declaration added by Aditya
2878: BEGIN
2879: -- START Granular Locking added by Aditya

Line 3134: FROM BSC_KPI_DIM_GROUPS grp,

3130: WHERE dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id);
3131:
3132: CURSOR cr_indicdimset_for_dimgrp IS
3133: SELECT grp.indicator , grp.dim_set_id,count(kpi.dim_level_index)
3134: FROM BSC_KPI_DIM_GROUPS grp,
3135: BSC_KPI_DIM_LEVELS_B kpi
3136: WHERE kpi.indicator = grp.indicator
3137: AND kpi.dim_set_id = grp.dim_set_id
3138: AND grp.dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id

Line 3453: FROM BSC_KPI_DIM_GROUPS

3449:
3450: IF (l_delete) THEN
3451: -- START: Granular Locking to Lock Dimension Group when it is being deleted.
3452: SELECT COUNT(1) INTO l_count
3453: FROM BSC_KPI_DIM_GROUPS
3454: WHERE dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
3455: IF (l_count <> 0) THEN
3456: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIMENSIONS');
3457: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);

Line 4004: FROM BSC_KPI_DIM_GROUPS A

4000: ORDER BY B.Dim_Level_Index;
4001:
4002: CURSOR c_dim_set_kpi IS
4003: SELECT DISTINCT B.Name||'['||B.Indicator||']' INDICATOR
4004: FROM BSC_KPI_DIM_GROUPS A
4005: , BSC_KPIS_VL B
4006: , BSC_SYS_DIM_GROUPS_VL C
4007: WHERE A.INDICATOR = B.INDICATOR
4008: AND B.share_flag <> 2

Line 4154: FROM BSC_KPI_DIM_GROUPS A

4150:
4151: CURSOR cr_kpidimset_dim IS
4152: SELECT A. INDICATOR
4153: , A.DIM_SET_ID
4154: FROM BSC_KPI_DIM_GROUPS A
4155: , BSC_SYS_DIM_GROUPS_VL B
4156: WHERE A.DIM_GROUP_ID = B.DIM_GROUP_ID
4157: AND B.SHORT_NAME = p_Dim_Short_Name;
4158:

Line 4449: FROM BSC_KPI_DIM_GROUPS A

4445: CURSOR c_dim_set_kpi IS
4446: SELECT DISTINCT A.indicator INDICATOR
4447: , A.dim_set_id DIM_SET_ID
4448: , A.Dim_Group_Index
4449: FROM BSC_KPI_DIM_GROUPS A
4450: , BSC_KPIS_B B
4451: WHERE A.INDICATOR = B.INDICATOR
4452: AND B.share_flag <> 2
4453: AND A.dim_group_id = l_dim_group_id

Line 4611: FROM BSC_KPI_DIM_GROUPS KG,

4607: l_retval VARCHAR2(1) := 'T'; --be protective, set to true by default
4608: l_count NUMBER;
4609: BEGIN
4610: SELECT COUNT(1) INTO l_count
4611: FROM BSC_KPI_DIM_GROUPS KG,
4612: BSC_SYS_DIM_GROUPS_VL G
4613: WHERE KG.DIM_GROUP_ID = G.DIM_GROUP_ID
4614: AND G.SHORT_NAME = p_dim_short_name;
4615: