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_DIM_OBJ_PUB dependencies on BSC_SYS_DIM_LEVELS_VL

Line 941: FROM BSC_SYS_DIM_LEVELS_VL

937: l_temp_var := l_dim_obj_name;
938: WHILE (l_flag) LOOP
939: SELECT COUNT(1) INTO l_count
940: FROM (SELECT COUNT(1) rec_count
941: FROM BSC_SYS_DIM_LEVELS_VL
942: WHERE UPPER(Short_Name) = UPPER(l_temp_var)
943: UNION
944: SELECT COUNT(1) rec_count
945: FROM BIS_LEVELS_VL

Line 1027: FROM BSC_SYS_DIM_LEVELS_VL

1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025: --check for uniqueness of l_dim_obj_name in BSC's metadata
1026: SELECT COUNT(1) INTO l_count
1027: FROM BSC_SYS_DIM_LEVELS_VL
1028: WHERE UPPER(short_name) = UPPER(l_dim_obj_name);
1029: IF (l_count > 0) THEN
1030: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1031: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));

Line 2127: BSC_SYS_DIM_LEVELS_VL B,

2123: CURSOR c_Kpi_Dim_Set1 IS
2124: SELECT DISTINCT A.INDICATOR Indicator,
2125: A.DIM_SET_ID Dim_Set_Id
2126: FROM BSC_KPI_DIM_LEVELS_VL A,
2127: BSC_SYS_DIM_LEVELS_VL B,
2128: BSC_KPIS_B C
2129: WHERE A.LEVEL_TABLE_NAME=B.LEVEL_TABLE_NAME
2130: AND C.INDICATOR = A.INDICATOR
2131: AND C.SHARE_FLAG <> 2

Line 2211: FROM BSC_SYS_DIM_LEVELS_VL

2207: , l_bsc_dim_obj_rec.Bsc_Level_Abbreviation --p_prototype_default_value
2208: , l_bsc_dim_obj_rec.Bsc_Pk_Col --p_table_column
2209: , l_bis_dim_level_rec.Dimension_Level_Name
2210: , l_bsc_dim_obj_rec.Bsc_Level_View_Name
2211: FROM BSC_SYS_DIM_LEVELS_VL
2212: WHERE short_name = l_dim_obj_name;
2213: --check uniqueness of display name
2214: IF (p_display_name IS NOT NULL) THEN
2215: l_pmf_disp_name := p_display_name;

Line 3223: FROM BSC_SYS_DIM_LEVELS_VL

3219: CURSOR c_bsc_levels IS
3220: SELECT dim_level_id
3221: , source
3222: , name
3223: FROM BSC_SYS_DIM_LEVELS_VL
3224: WHERE short_name = p_dim_obj_short_name;
3225: BEGIN
3226: FND_MSG_PUB.Initialize;
3227: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3468: FROM BSC_SYS_DIM_LEVELS_VL

3464: SELECT dim_level_id
3465: , name
3466: INTO l_bsc_dim_id
3467: , l_name
3468: FROM BSC_SYS_DIM_LEVELS_VL
3469: WHERE short_name = p_dim_obj_short_name;
3470:
3471:
3472: -- CAN'T DELETE DIMENSION, validataion one.

Line 3550: l_name BSC_SYS_DIM_LEVELS_VL.Name%TYPE;

3546: p_group_id IN NUMBER
3547: )RETURN VARCHAR2
3548: IS
3549: l_dimension_names VARCHAR2(32000);
3550: l_name BSC_SYS_DIM_LEVELS_VL.Name%TYPE;
3551:
3552: CURSOR c_dimesnion_names IS
3553: SELECT V.NAME
3554: FROM BSC_SYS_DIM_LEVELS_VL V,

Line 3554: FROM BSC_SYS_DIM_LEVELS_VL V,

3550: l_name BSC_SYS_DIM_LEVELS_VL.Name%TYPE;
3551:
3552: CURSOR c_dimesnion_names IS
3553: SELECT V.NAME
3554: FROM BSC_SYS_DIM_LEVELS_VL V,
3555: BSC_SYS_DIM_LEVELS_BY_GROUP B
3556: WHERE V.DIM_LEVEL_ID = B.DIM_LEVEL_ID
3557: AND B.DIM_GROUP_ID = p_group_id
3558: ORDER BY B.DIM_LEVEL_INDEX;

Line 3588: FROM BSC_SYS_DIM_LEVELS_VL A

3584: l_name BSC_SYS_DIM_GROUPS_TL.NAME%TYPE;
3585:
3586: CURSOR c_dimension_obj_name IS
3587: SELECT A.name
3588: FROM BSC_SYS_DIM_LEVELS_VL A
3589: , BSC_SYS_DIM_LEVELS_BY_GROUP B
3590: WHERE A.dim_level_id = B.dim_level_id
3591: AND B.dim_group_id = (SELECT dim_group_id
3592: FROM BSC_SYS_DIM_GROUPS_VL

Line 5542: FROM BSC_SYS_DIM_LEVELS_VL

5538: , disp_key_size
5539: , NVL(source, 'BSC')
5540: , abbreviation
5541: , level_pk_col
5542: FROM BSC_SYS_DIM_LEVELS_VL
5543: WHERE short_name = p_dim_obj_short_name;
5544:
5545: CURSOR c_Dimension_Names IS
5546: SELECT Short_Name

Line 6753: FROM BSC_SYS_DIM_LEVELS_VL SYS,

6749: AND INSTR(','||p_dim_short_names ||',',','||short_name||',') > 0;
6750:
6751: CURSOR C_SOURCE_DIM_OBJS IS
6752: SELECT SYS.SOURCE,SYS.SHORT_NAME,SYS.NAME
6753: FROM BSC_SYS_DIM_LEVELS_VL SYS,
6754: BSC_SYS_DIM_LEVELS_BY_GROUP GRP
6755: WHERE SYS.dim_level_id = GRP.dim_level_id
6756: AND GRP.dim_group_id = l_dim_grp_id;
6757:

Line 6775: FROM BSC_SYS_DIM_LEVELS_VL SYS,

6771: FROM BSC_SYS_DIM_LEVELS_BY_GROUP GRP
6772: WHERE GRP.dim_group_id = l_dim_grp_id;
6773:
6774: SELECT COUNT(1) into l_exist
6775: FROM BSC_SYS_DIM_LEVELS_VL SYS,
6776: BSC_SYS_DIM_LEVELS_BY_GROUP GRP
6777: WHERE SYS.dim_level_id = GRP.dim_level_id
6778: AND GRP.dim_group_id = l_dim_grp_id
6779: AND SYS.SHORT_NAME = p_dim_obj_short_name;

Line 6877: l_maximum_code_size BSC_SYS_DIM_LEVELS_VL.user_key_size%TYPE;

6873: l_child_disp_fm_flag BOOLEAN := FALSE;
6874: l_counter NUMBER;
6875: l_duplicate_flag BOOLEAN;
6876: l_return_flag BOOLEAN := FALSE;
6877: l_maximum_code_size BSC_SYS_DIM_LEVELS_VL.user_key_size%TYPE;
6878: l_maximum_name_size BSC_SYS_DIM_LEVELS_VL.disp_key_size%TYPE;
6879:
6880:
6881: CURSOR c_Old_Dim_Obj_Rec IS

Line 6878: l_maximum_name_size BSC_SYS_DIM_LEVELS_VL.disp_key_size%TYPE;

6874: l_counter NUMBER;
6875: l_duplicate_flag BOOLEAN;
6876: l_return_flag BOOLEAN := FALSE;
6877: l_maximum_code_size BSC_SYS_DIM_LEVELS_VL.user_key_size%TYPE;
6878: l_maximum_name_size BSC_SYS_DIM_LEVELS_VL.disp_key_size%TYPE;
6879:
6880:
6881: CURSOR c_Old_Dim_Obj_Rec IS
6882: SELECT dim_level_id

Line 6889: FROM BSC_SYS_DIM_LEVELS_VL

6885: , disp_key_size
6886: , NVL(source, 'BSC')
6887: , abbreviation
6888: , level_pk_col
6889: FROM BSC_SYS_DIM_LEVELS_VL
6890: WHERE short_name = p_dim_obj_short_name;
6891:
6892: CURSOR c_Kpi_Dim_Set1 IS
6893: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name

Line 7051: l_Dim_Object_Name BSC_SYS_DIM_LEVELS_VL.NAME%TYPE;

7047: , x_return_status OUT NOCOPY VARCHAR2
7048: , x_msg_count OUT NOCOPY NUMBER
7049: , x_msg_data OUT NOCOPY VARCHAR2
7050: ) RETURN VARCHAR2 IS
7051: l_Dim_Object_Name BSC_SYS_DIM_LEVELS_VL.NAME%TYPE;
7052: l_Level_Pk_Col BSC_SYS_DIM_LEVELS_VL.LEVEL_PK_COL%TYPE;
7053: l_temp_var VARCHAR2(1000);
7054: l_alias VARCHAR2(1000);
7055: l_flag BOOLEAN;

Line 7052: l_Level_Pk_Col BSC_SYS_DIM_LEVELS_VL.LEVEL_PK_COL%TYPE;

7048: , x_msg_count OUT NOCOPY NUMBER
7049: , x_msg_data OUT NOCOPY VARCHAR2
7050: ) RETURN VARCHAR2 IS
7051: l_Dim_Object_Name BSC_SYS_DIM_LEVELS_VL.NAME%TYPE;
7052: l_Level_Pk_Col BSC_SYS_DIM_LEVELS_VL.LEVEL_PK_COL%TYPE;
7053: l_temp_var VARCHAR2(1000);
7054: l_alias VARCHAR2(1000);
7055: l_flag BOOLEAN;
7056: l_count NUMBER;

Line 7181: FROM bsc_sys_dim_levels_vl bsc, bis_levels_vl bis

7177: BEGIN
7178:
7179: SELECT bsc.name, bis.LEVEL_VALUES_VIEW_NAME, bsc.source
7180: INTO l_name, l_Dim_Obj_View_Name, l_source
7181: FROM bsc_sys_dim_levels_vl bsc, bis_levels_vl bis
7182: WHERE bsc.short_name = bis.short_name
7183: AND bsc.short_name = p_Dim_Obj_Short_Name;
7184:
7185: IF (l_source = BSC_UTILITY.c_PMF) THEN