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_REL_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 74: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

70: --==============================================================
71: TYPE One_To_N_Index_Table IS TABLE OF One_To_N_Index_Type INDEX BY BINARY_INTEGER;
72: --==============================================================
73: TYPE One_To_N_Original_Type IS Record
74: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
75: , p_Parent_Dim_Ids VARCHAR2(32000)
76: , p_Parent_Count NUMBER
77: , p_Refresh_Flag BOOLEAN
78: );

Line 83: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

79: --==============================================================
80: TYPE One_To_N_Org_Table_Type IS TABLE OF One_To_N_Original_Type INDEX BY BINARY_INTEGER;
81: --==============================================================
82: TYPE M_To_N_Original_Type IS Record
83: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
84: , p_Parent_Dim_ID BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE
85: , p_Refresh_Flag BOOLEAN
86: );
87: --==============================================================

Line 91: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

87: --==============================================================
88: TYPE M_To_N_Org_Table_Type IS TABLE OF M_To_N_Original_Type INDEX BY BINARY_INTEGER;
89: --==============================================================
90: TYPE Relation_Original_Type IS Record
91: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
92: , p_Parent_Dim_Id BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE
93: , p_Relation_Type BSC_SYS_DIM_LEVEL_RELS.relation_type%TYPE
94: , p_Refresh_Flag BOOLEAN
95: , p_Refresh_No NUMBER

Line 356: p_dim_level_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

352: AUTHOR : ashankar 25-OCT-2004 BUG 3459282
353: /*******************************************************************/
354: FUNCTION is_Filtered_Applied
355: (
356: p_dim_level_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
357: )RETURN BOOLEAN IS
358: l_count NUMBER;
359: BEGIN
360: SELECT COUNT(0)

Line 394: l_dim_level_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;

390: , x_msg_count OUT NOCOPY NUMBER
391: , x_msg_data OUT NOCOPY VARCHAR2
392: )IS
393:
394: l_dim_level_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;
395: l_common_tabs VARCHAR2(32000);
396: l_par_tab NUMBER;
397: l_child_tab NUMBER;
398: l_Count NUMBER;

Line 450: p_dim_obj_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

446: /*******************************************************************/
447:
448: PROCEDURE Validate_Filtered_Tabs
449: (
450: p_dim_obj_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
451: , p_par_dim_obj_id IN BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE
452: , x_return_status OUT NOCOPY VARCHAR2
453: , x_msg_count OUT NOCOPY NUMBER
454: , x_msg_data OUT NOCOPY VARCHAR2

Line 1463: l_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

1459: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1460:
1461: l_count NUMBER;
1462: l_flag BOOLEAN := TRUE;
1463: l_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
1464:
1465: l_child_ids VARCHAR2(32000);
1466: l_child_rel_type VARCHAR2(32000);
1467: l_child_rel_column VARCHAR2(32000);

Line 1573: FROM BSC_SYS_DIM_LEVELS_B

1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: SELECT COUNT(*) INTO l_count
1573: FROM BSC_SYS_DIM_LEVELS_B
1574: WHERE dim_level_id = p_dim_obj_id;
1575: IF (l_count = 0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

Line 1637: FROM BSC_SYS_DIM_LEVELS_B

1633: SELECT NVL(source, 'BSC')
1634: , short_name
1635: INTO l_bsc_dim_obj_rec.bsc_parent_level_source
1636: , l_bsc_dim_obj_rec.bsc_parent_level_short_name
1637: FROM BSC_SYS_DIM_LEVELS_B
1638: WHERE dim_level_id = p_dim_obj_id;
1639: l_source := l_bsc_dim_obj_rec.bsc_parent_level_source;
1640: -- START: Granular Locking
1641: IF(p_is_not_config) THEN

Line 1810: FROM BSC_SYS_DIM_LEVELS_B

1806: SELECT NVL(source, 'BSC')
1807: , short_name
1808: INTO l_bsc_dim_obj_rec.Bsc_Source,
1809: l_bsc_dim_obj_rec.bsc_level_short_name
1810: FROM BSC_SYS_DIM_LEVELS_B
1811: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
1812: IF ((l_bsc_dim_obj_rec.bsc_relation_type IS NULL) OR
1813: (l_bsc_dim_obj_rec.bsc_relation_type <> 1) AND (l_bsc_dim_obj_rec.bsc_relation_type <> 2)) THEN
1814: l_bsc_dim_obj_rec.bsc_relation_type := 1;

Line 1933: FROM BSC_SYS_DIM_LEVELS_B

1929: SELECT NVL(source, 'BSC')
1930: , short_name
1931: INTO l_bsc_dim_obj_rec.Bsc_Source,
1932: l_bsc_dim_obj_rec.bsc_level_short_name
1933: FROM BSC_SYS_DIM_LEVELS_B
1934: WHERE dim_level_id = p_dim_obj_id;
1935: --DBMS_OUTPUT.PUT_LINE('Assigning Relations II');
1936: --DBMS_OUTPUT.PUT_LINE('BEFORE PARENT IDS');
1937: IF (l_parent_ids IS NOT NULL) THEN

Line 1955: FROM BSC_SYS_DIM_LEVELS_B

1951: SELECT NVL(source, 'BSC')
1952: , short_name
1953: INTO l_bsc_dim_obj_rec.bsc_parent_level_source
1954: , l_bsc_dim_obj_rec.bsc_parent_level_short_name
1955: FROM BSC_SYS_DIM_LEVELS_B
1956: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Parent_Level_Id;
1957: --DBMS_OUTPUT.PUT_LINE('PARENT IDS STAGE1');
1958:
1959: IF ((l_bsc_dim_obj_rec.bsc_relation_type IS NULL) OR

Line 2385: FROM bsc_sys_dim_levels_b

2381: l_is_denorm_deleted := FND_API.G_TRUE;
2382:
2383: SELECT short_name
2384: INTO l_dim_short_name
2385: FROM bsc_sys_dim_levels_b
2386: WHERE dim_level_id = p_dim_obj_id;
2387:
2388: BEGIN
2389: l_Sql := 'BEGIN IF(BSC_PMA_APIS_PUB.sync_dimension_table (:2,:3,:4)) THEN :1 :=FND_API.G_TRUE; ELSE :1:=FND_API.G_FALSE; END IF;END;';

Line 2406: FROM bsc_sys_dim_levels_b

2402: IF (l_source = BSC_UTILITY.c_PMF) THEN
2403:
2404: SELECT short_name
2405: INTO l_dim_short_name
2406: FROM bsc_sys_dim_levels_b
2407: WHERE dim_level_id = p_dim_obj_id;
2408:
2409: BSC_BIS_DIM_OBJ_PUB.Refresh_BSC_PMF_Dim_View
2410: ( p_Short_Name => l_dim_short_name

Line 2431: FROM bsc_sys_dim_levels_b

2427: )) LOOP
2428:
2429: SELECT short_name
2430: INTO l_dim_short_name
2431: FROM bsc_sys_dim_levels_b
2432: WHERE dim_level_id = l_rel_id;
2433:
2434: BSC_BIS_DIM_OBJ_PUB.Refresh_BSC_PMF_Dim_View
2435: ( p_Short_Name => l_dim_short_name

Line 2537: l_dim_obj_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;

2533: , x_msg_count OUT NOCOPY NUMBER
2534: , x_msg_data OUT NOCOPY VARCHAR2
2535: ) IS
2536: l_dim_obj_ids VARCHAR2(32000);
2537: l_dim_obj_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;
2538: l_flag BOOLEAN := TRUE;
2539:
2540: l_parent_ids VARCHAR2(32000);
2541: l_parent_rel_type VARCHAR2(32000);

Line 2939: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;

2935: l_view_name VARCHAR2(30);
2936: l_dummy_table VARCHAR2(30) := 'BSC_B_DUMMY_TABLE';
2937: l_temp_table VARCHAR2(30);
2938:
2939: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;
2940: l_label_table_name BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
2941: l_index_Table BSC_BIS_DIM_REL_PUB.One_To_N_Index_Table;
2942: l_index_Count NUMBER;
2943:

Line 2940: l_label_table_name BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;

2936: l_dummy_table VARCHAR2(30) := 'BSC_B_DUMMY_TABLE';
2937: l_temp_table VARCHAR2(30);
2938:
2939: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;
2940: l_label_table_name BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
2941: l_index_Table BSC_BIS_DIM_REL_PUB.One_To_N_Index_Table;
2942: l_index_Count NUMBER;
2943:
2944: l_alias VARCHAR2(4);

Line 2961: , BSC_SYS_DIM_LEVELS_B B

2957: SELECT A.Parent_Dim_Level_Id
2958: , B.Level_Pk_Col
2959: , B.Level_Table_Name
2960: FROM BSC_SYS_DIM_LEVEL_RELS A
2961: , BSC_SYS_DIM_LEVELS_B B
2962: WHERE A.Dim_Level_Id = p_dim_obj_id
2963: AND B.Dim_Level_Id = A.Parent_Dim_Level_Id
2964: AND A.Relation_Type = 1;
2965: BEGIN

Line 2980: FROM BSC_SYS_DIM_LEVELS_B

2976: END IF;
2977: IF (p_dim_obj_id IS NOT NULL) THEN
2978: -- Bug #3236356
2979: SELECT COUNT(0) INTO l_count
2980: FROM BSC_SYS_DIM_LEVELS_B
2981: WHERE Dim_Level_Id = p_dim_obj_id;
2982:
2983: IF (l_count = 0) THEN
2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');

Line 2994: FROM BSC_SYS_DIM_LEVELS_B

2990: END IF;
2991: --DBMS_OUTPUT.PUT_LINE('2 ');
2992: SELECT level_table_name
2993: INTO l_bsc_dim_obj_rec.Bsc_Level_View_Name
2994: FROM BSC_SYS_DIM_LEVELS_B
2995: WHERE DIM_LEVEL_ID = p_dim_obj_id;
2996: --DBMS_OUTPUT.PUT_LINE('5 ');
2997: l_bsc_dim_obj_rec.Bsc_Level_Id := p_dim_obj_id;
2998: l_master_table := UPPER(l_bsc_dim_obj_rec.Bsc_Level_View_Name);

Line 3301: l_c_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;

3297: l_sql_stmt VARCHAR2(32000);
3298: l_flag BOOLEAN;
3299: l_count NUMBER := 0;
3300:
3301: l_c_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3302: l_c_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3303: l_c_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3305:

Line 3302: l_c_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;

3298: l_flag BOOLEAN;
3299: l_count NUMBER := 0;
3300:
3301: l_c_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3302: l_c_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3303: l_c_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3305:
3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;

Line 3303: l_c_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;

3299: l_count NUMBER := 0;
3300:
3301: l_c_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3302: l_c_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3303: l_c_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3305:
3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3307: l_p_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;

Line 3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;

3300:
3301: l_c_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3302: l_c_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3303: l_c_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3305:
3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3307: l_p_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3308: l_p_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;

Line 3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;

3302: l_c_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3303: l_c_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3305:
3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3307: l_p_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3308: l_p_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3309: l_p_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3310:

Line 3307: l_p_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;

3303: l_c_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3305:
3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3307: l_p_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3308: l_p_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3309: l_p_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3310:
3311: l_master_table VARCHAR2(30);

Line 3308: l_p_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;

3304: l_c_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3305:
3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3307: l_p_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3308: l_p_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3309: l_p_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3310:
3311: l_master_table VARCHAR2(30);
3312: l_input_table VARCHAR2(30);

Line 3309: l_p_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;

3305:
3306: l_p_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
3307: l_p_abbr BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3308: l_p_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_PK_Col%TYPE;
3309: l_p_level_table BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
3310:
3311: l_master_table VARCHAR2(30);
3312: l_input_table VARCHAR2(30);
3313: BEGIN

Line 3329: FROM BSC_SYS_DIM_LEVELS_B

3325: IF (p_dim_obj_id IS NOT NULL) THEN
3326:
3327: -- Bug #3236356
3328: SELECT COUNT(0) INTO l_count
3329: FROM BSC_SYS_DIM_LEVELS_B
3330: WHERE Dim_Level_Id = p_dim_obj_id;
3331:
3332: IF (l_count = 0) THEN
3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');

Line 3370: FROM BSC_SYS_DIM_LEVELS_B WHERE dim_level_id = p_dim_obj_id;

3366: INTO l_c_dim_level_id
3367: , l_c_abbr
3368: , l_c_level_pk_col
3369: , l_c_level_table
3370: FROM BSC_SYS_DIM_LEVELS_B WHERE dim_level_id = p_dim_obj_id;
3371:
3372: SELECT dim_level_id
3373: , abbreviation
3374: , level_pk_col

Line 3380: FROM BSC_SYS_DIM_LEVELS_B WHERE dim_level_id = p_parent_id;

3376: INTO l_p_dim_level_id
3377: , l_p_abbr
3378: , l_p_level_pk_col
3379: , l_p_level_table
3380: FROM BSC_SYS_DIM_LEVELS_B WHERE dim_level_id = p_parent_id;
3381:
3382: IF (l_c_abbr <= l_p_abbr) THEN
3383: l_master_table := 'BSC_D_'||l_c_abbr||'_'||l_p_abbr;
3384: ELSE

Line 3535: l_c_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;

3531:
3532: l_master_table VARCHAR2(50);
3533: l_input_table VARCHAR2(50);
3534:
3535: l_c_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3536: l_p_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3537: BEGIN
3538: SAVEPOINT DropBSCMtoNTabsPMD;
3539: FND_MSG_PUB.Initialize;

Line 3536: l_p_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;

3532: l_master_table VARCHAR2(50);
3533: l_input_table VARCHAR2(50);
3534:
3535: l_c_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3536: l_p_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3537: BEGIN
3538: SAVEPOINT DropBSCMtoNTabsPMD;
3539: FND_MSG_PUB.Initialize;
3540: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3550: FROM BSC_SYS_DIM_LEVELS_B

3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:
3549: SELECT abbreviation INTO l_p_abbre
3550: FROM BSC_SYS_DIM_LEVELS_B
3551: WHERE dim_level_id = p_dim_obj_id;
3552:
3553: SELECT abbreviation INTO l_c_abbre
3554: FROM BSC_SYS_DIM_LEVELS_B

Line 3554: FROM BSC_SYS_DIM_LEVELS_B

3550: FROM BSC_SYS_DIM_LEVELS_B
3551: WHERE dim_level_id = p_dim_obj_id;
3552:
3553: SELECT abbreviation INTO l_c_abbre
3554: FROM BSC_SYS_DIM_LEVELS_B
3555: WHERE dim_level_id = p_parent_id;
3556: --drop tables, needs changes, will be done in IInd release
3557: IF (p_dim_obj_id <= p_parent_id) THEN
3558: l_input_table := 'BSC_DI_'||p_dim_obj_id||'_'||p_parent_id;

Line 3656: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

3652: ) RETURN VARCHAR2 IS
3653: l_Msg_Data VARCHAR2(32000);
3654: l_msg_count NUMBER;
3655:
3656: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3657:
3658: l_par_original_ids VARCHAR2(32000);
3659: l_par_original_types VARCHAR2(32000);
3660: l_par_original_id VARCHAR2(32000);

Line 3688: FROM BSC_SYS_DIM_LEVELS_B

3684: l_par_flag BOOLEAN := FALSE;
3685:
3686: CURSOR c_Source IS
3687: SELECT Source
3688: FROM BSC_SYS_DIM_LEVELS_B
3689: WHERE dim_level_id = p_dim_obj_id;
3690:
3691: CURSOR c_Par_Dim_Ids IS
3692: SELECT Parent_Dim_Level_Id

Line 3707: , BSC_SYS_DIM_LEVELS_B D

3703:
3704: CURSOR c_kpi_dim_set IS
3705: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name, C.short_name
3706: FROM BSC_KPI_DIM_LEVELS_B A
3707: , BSC_SYS_DIM_LEVELS_B D
3708: , BSC_KPIS_VL C
3709: WHERE A.Level_Table_Name = D.Level_Table_Name
3710: AND D.Dim_Level_Id = p_dim_obj_id
3711: AND C.share_flag <> 2