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

Line 1903: FROM bsc_sys_dim_levels_tl a, bsc_sys_dim_levels_b b

1899: AND a.attribute2 NOT LIKE 'TIME_COMPARISON_TYPE%'
1900: AND a.attribute1 <> C_COMP_TO_DIM_LEVEL;
1901:
1902: CURSOR c_DimObj_Name IS SELECT a.name
1903: FROM bsc_sys_dim_levels_tl a, bsc_sys_dim_levels_b b
1904: WHERE a.dim_level_id = b.dim_level_id
1905: AND a.language = USERENV('LANG')
1906: AND b.short_name = l_dimension_object;
1907:

Line 2307: l_where_clause BSC_SYS_DIM_LEVELS_BY_GROUP.WHERE_CLAUSE%TYPE;

2303:
2304: l_index NUMBER;
2305: l_total_flag NUMBER;
2306: l_comparison_flag NUMBER;
2307: l_where_clause BSC_SYS_DIM_LEVELS_BY_GROUP.WHERE_CLAUSE%TYPE;
2308: l_dim_group_id NUMBER;
2309: l_dim_level_id NUMBER;
2310: x_return_status VARCHAR2(80);
2311: x_msg_count NUMBER;

Line 2326: bsc_sys_dim_levels_by_group d,

2322: INTO l_total_flag, l_comparison_flag, l_where_clause
2323: FROM bsc_sys_dim_groups_tl a,
2324: bis_dimensions b,
2325: bis_levels c,
2326: bsc_sys_dim_levels_by_group d,
2327: bsc_sys_dim_levels_b e
2328: WHERE c.short_name = p_non_time_dimension_objects(l_index)
2329: AND c.dimension_id = b.dimension_id
2330: AND b.short_name = a.short_name

Line 2327: bsc_sys_dim_levels_b e

2323: FROM bsc_sys_dim_groups_tl a,
2324: bis_dimensions b,
2325: bis_levels c,
2326: bsc_sys_dim_levels_by_group d,
2327: bsc_sys_dim_levels_b e
2328: WHERE c.short_name = p_non_time_dimension_objects(l_index)
2329: AND c.dimension_id = b.dimension_id
2330: AND b.short_name = a.short_name
2331: AND a.language = userenv('LANG')

Line 2341: bsc_sys_dim_levels_by_group d,

2337: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_DIM_REL');
2338: SELECT d.dim_group_id, d.dim_level_id
2339: INTO l_dim_group_id, l_dim_level_id
2340: FROM bsc_sys_dim_groups_tl a,
2341: bsc_sys_dim_levels_by_group d,
2342: bsc_sys_dim_levels_b e
2343: WHERE d.dim_group_id = a.dim_group_id
2344: AND a.short_name = p_dim_object_short_name
2345: AND a.language = userenv('LANG')

Line 2342: bsc_sys_dim_levels_b e

2338: SELECT d.dim_group_id, d.dim_level_id
2339: INTO l_dim_group_id, l_dim_level_id
2340: FROM bsc_sys_dim_groups_tl a,
2341: bsc_sys_dim_levels_by_group d,
2342: bsc_sys_dim_levels_b e
2343: WHERE d.dim_group_id = a.dim_group_id
2344: AND a.short_name = p_dim_object_short_name
2345: AND a.language = userenv('LANG')
2346: AND e.short_name = p_non_time_dimension_objects(l_index)

Line 2350: UPDATE bsc_sys_dim_levels_by_group

2346: AND e.short_name = p_non_time_dimension_objects(l_index)
2347: AND e.dim_level_id = d.dim_level_id;
2348:
2349: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_UPDATE_DIM_REL');
2350: UPDATE bsc_sys_dim_levels_by_group
2351: SET total_flag = l_total_flag,
2352: comparison_flag = l_comparison_flag,
2353: where_clause = l_where_clause
2354: WHERE dim_group_id = l_dim_group_id

Line 3458: p_Short_Name Corresponds to BSC_SYS_DIM_LEVELS_B.Short_Name

3454:
3455: This function assumes the Short_Name passed is valid and exists in
3456: BSC Metadata. It will not be checked from BSC tables due to performance reasons.
3457:
3458: p_Short_Name Corresponds to BSC_SYS_DIM_LEVELS_B.Short_Name
3459: */
3460: FUNCTION is_KPI_EndToEnd_DimObject(p_Short_Name VARCHAR2)
3461: RETURN VARCHAR2 IS
3462: l_Count NUMBER;

Line 4498: l_Where_Clause BSC_SYS_DIM_LEVELS_BY_GROUP.WHERE_CLAUSE%TYPE;

4494: ) IS
4495: l_Index NUMBER;
4496: l_Total_Flag NUMBER;
4497: l_Comparison_Flag NUMBER;
4498: l_Where_Clause BSC_SYS_DIM_LEVELS_BY_GROUP.WHERE_CLAUSE%TYPE;
4499: l_Dim_Obj_Short_Name VARCHAR2(30);
4500:
4501: CURSOR c_Get_Prop_Dim IS
4502: SELECT D.TOTAL_FLAG,

Line 4508: BSC_SYS_DIM_LEVELS_BY_GROUP D,

4504: D.WHERE_CLAUSE
4505: FROM BSC_SYS_DIM_GROUPS_TL A,
4506: BIS_DIMENSIONS B,
4507: BIS_LEVELS C,
4508: BSC_SYS_DIM_LEVELS_BY_GROUP D,
4509: BSC_SYS_DIM_LEVELS_B E
4510: WHERE C.SHORT_NAME = l_Dim_Obj_Short_Name
4511: AND C.DIMENSION_ID = B.DIMENSION_ID
4512: AND B.SHORT_NAME = A.SHORT_NAME

Line 4509: BSC_SYS_DIM_LEVELS_B E

4505: FROM BSC_SYS_DIM_GROUPS_TL A,
4506: BIS_DIMENSIONS B,
4507: BIS_LEVELS C,
4508: BSC_SYS_DIM_LEVELS_BY_GROUP D,
4509: BSC_SYS_DIM_LEVELS_B E
4510: WHERE C.SHORT_NAME = l_Dim_Obj_Short_Name
4511: AND C.DIMENSION_ID = B.DIMENSION_ID
4512: AND B.SHORT_NAME = A.SHORT_NAME
4513: AND A.LANGUAGE = USERENV('LANG')

Line 4520: from bsc_sys_dim_levels_by_group

4516: AND E.DIM_LEVEL_ID = D.DIM_LEVEL_ID;
4517:
4518: /* CURSOR c_temp IS
4519: select dim_group_id, dim_level_id, dim_level_index
4520: from bsc_sys_dim_levels_by_group
4521: where dim_group_id in
4522: (select dim_group_id
4523: from bsc_sys_dim_groups_vl
4524: where short_name = p_Dim_Short_Name);*/

Line 5683: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

5679:
5680: --DBMS_OUTPUT.PUT_LINE('STAGE 13');
5681:
5682: SELECT COUNT(1) INTO l_Count
5683: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
5684: WHERE DIM_GROUP_ID IN
5685: (
5686: SELECT DIM_GROUP_ID
5687: FROM BSC_SYS_DIM_GROUPS_VL

Line 6303: , BSC_SYS_DIM_LEVELS_BY_GROUP DD

6299:
6300: CURSOR c_Dim_Obj_Short_Name IS
6301: SELECT DO.SHORT_NAME
6302: FROM BSC_SYS_DIM_GROUPS_VL DG
6303: , BSC_SYS_DIM_LEVELS_BY_GROUP DD
6304: , BSC_SYS_DIM_LEVELS_B DO
6305: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6306: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6307: AND DG.SHORT_NAME = p_Dim_Short_Name;

Line 6304: , BSC_SYS_DIM_LEVELS_B DO

6300: CURSOR c_Dim_Obj_Short_Name IS
6301: SELECT DO.SHORT_NAME
6302: FROM BSC_SYS_DIM_GROUPS_VL DG
6303: , BSC_SYS_DIM_LEVELS_BY_GROUP DD
6304: , BSC_SYS_DIM_LEVELS_B DO
6305: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6306: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6307: AND DG.SHORT_NAME = p_Dim_Short_Name;
6308:

Line 6384: BSC_SYS_DIM_LEVELS_BY_GROUP DD,

6380: NULL;
6381: SELECT DECODE(COUNT(1), 0, FND_API.G_FALSE, FND_API.G_TRUE)
6382: INTO l_Is_Time_Dim_Obj
6383: FROM BSC_SYS_DIM_GROUPS_VL DG,
6384: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6385: BSC_SYS_DIM_LEVELS_B DO
6386: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6387: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6388: AND ((DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR (DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME))

Line 6385: BSC_SYS_DIM_LEVELS_B DO

6381: SELECT DECODE(COUNT(1), 0, FND_API.G_FALSE, FND_API.G_TRUE)
6382: INTO l_Is_Time_Dim_Obj
6383: FROM BSC_SYS_DIM_GROUPS_VL DG,
6384: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6385: BSC_SYS_DIM_LEVELS_B DO
6386: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6387: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6388: AND ((DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR (DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME))
6389: AND DO.SHORT_NAME = p_Dim_Obj_Short_Name;

Line 6411: BSC_SYS_DIM_LEVELS_BY_GROUP DD,

6407:
6408: SELECT DECODE(COUNT(1), 0, FND_API.G_FALSE, FND_API.G_TRUE)
6409: INTO x_Is_Time_Dim_Obj
6410: FROM BSC_SYS_DIM_GROUPS_VL DG,
6411: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6412: BSC_SYS_DIM_LEVELS_B DO
6413: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6414: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6415: AND ((DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR (DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME))

Line 6412: BSC_SYS_DIM_LEVELS_B DO

6408: SELECT DECODE(COUNT(1), 0, FND_API.G_FALSE, FND_API.G_TRUE)
6409: INTO x_Is_Time_Dim_Obj
6410: FROM BSC_SYS_DIM_GROUPS_VL DG,
6411: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6412: BSC_SYS_DIM_LEVELS_B DO
6413: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6414: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6415: AND ((DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR (DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME))
6416: AND DO.SHORT_NAME = p_Dim_Obj_Short_Name;