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

Line 150: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL

146: SELECT MAX(NUM) INTO l_count
147: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
148: , SYS_DIM_LEL.Dim_Level_Id
149: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
150: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
151: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
152: AND KPI_GROUP.Indicator = l_Dim_Set_Rec.Bsc_Kpi_Id
153: AND KPI_GROUP.Dim_Set_Id = l_Dim_Set_Rec.Bsc_Dim_Set_Id
154: GROUP BY SYS_DIM_LEL.Dim_Level_Id);

Line 418: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL

414: SELECT MAX(NUM) INTO l_count
415: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
416: , SYS_DIM_LEL.Dim_Level_Id
417: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
418: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
419: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
420: AND KPI_GROUP.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
421: AND KPI_GROUP.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
422: GROUP BY SYS_DIM_LEL.Dim_Level_Id);

Line 581: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

577: AND dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
578:
579: CURSOR c_dim_level_id IS
580: SELECT dim_level_id
581: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
582: WHERE dim_group_id = l_group_id;
583: begin
584: -- Assign all passed values to local record.
585: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1042: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1038: l_cnt number;
1039:
1040: CURSOR c_Dim_Level_Id IS
1041: SELECT DISTINCT DIM_LEVEL_ID
1042: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1043: WHERE DIM_GROUP_ID = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
1044:
1045: begin
1046: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1294: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1290: l_sql varchar2(1000);
1291:
1292: CURSOR c_Dim_Level_Id is
1293: SELECT DISTINCT DIM_LEVEL_ID
1294: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1295: WHERE DIM_GROUP_ID = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
1296:
1297: begin
1298: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1532: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A

1528: , A.No_Items
1529: , A.Total_Flag
1530: , A.Comparison_Flag
1531: , B.Source
1532: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
1533: , BSC_SYS_DIM_LEVELS_VL B
1534: , BSC_SYS_DIM_GROUPS_VL C
1535: WHERE A.Dim_Group_Id = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id
1536: AND C.Dim_Group_Id = A.Dim_Group_Id

Line 1554: , BSC_SYS_DIM_LEVELS_B C -- current

1550: , C.Level_Table_Name
1551: , C.Source
1552: FROM BSC_KPI_DIM_LEVELS_B A -- current
1553: , BSC_KPI_DIM_LEVELS_B B -- parent
1554: , BSC_SYS_DIM_LEVELS_B C -- current
1555: , BSC_SYS_DIM_LEVELS_B D -- parent
1556: , BSC_SYS_DIM_LEVEL_RELS E
1557: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1558: AND A.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id

Line 1555: , BSC_SYS_DIM_LEVELS_B D -- parent

1551: , C.Source
1552: FROM BSC_KPI_DIM_LEVELS_B A -- current
1553: , BSC_KPI_DIM_LEVELS_B B -- parent
1554: , BSC_SYS_DIM_LEVELS_B C -- current
1555: , BSC_SYS_DIM_LEVELS_B D -- parent
1556: , BSC_SYS_DIM_LEVEL_RELS E
1557: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1558: AND A.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1559: AND A.Indicator = B.Indicator

Line 1581: , BSC_SYS_DIM_LEVELS_B C -- current

1577: , C.Level_Table_Name
1578: , C.Source
1579: FROM BSC_KPI_DIM_LEVELS_B A -- current
1580: , BSC_KPI_DIM_LEVELS_B B -- parent
1581: , BSC_SYS_DIM_LEVELS_B C -- current
1582: , BSC_SYS_DIM_LEVELS_B D -- parent
1583: , BSC_SYS_DIM_LEVEL_RELS E
1584: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1585: AND A.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id

Line 1582: , BSC_SYS_DIM_LEVELS_B D -- parent

1578: , C.Source
1579: FROM BSC_KPI_DIM_LEVELS_B A -- current
1580: , BSC_KPI_DIM_LEVELS_B B -- parent
1581: , BSC_SYS_DIM_LEVELS_B C -- current
1582: , BSC_SYS_DIM_LEVELS_B D -- parent
1583: , BSC_SYS_DIM_LEVEL_RELS E
1584: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1585: AND A.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1586: AND A.Indicator = B.Indicator

Line 2063: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A,

2059: SELECT DISTINCT A.DIM_LEVEL_ID
2060: ,B.LEVEL_TABLE_NAME
2061: ,B.LEVEL_PK_COL
2062: ,C.NAME
2063: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A,
2064: BSC_SYS_DIM_LEVELS_B B,
2065: BSC_SYS_DIM_LEVELS_TL C
2066: WHERE A.DIM_GROUP_ID = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id
2067: AND A.DIM_LEVEL_ID = B.DIM_LEVEL_ID

Line 2064: BSC_SYS_DIM_LEVELS_B B,

2060: ,B.LEVEL_TABLE_NAME
2061: ,B.LEVEL_PK_COL
2062: ,C.NAME
2063: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A,
2064: BSC_SYS_DIM_LEVELS_B B,
2065: BSC_SYS_DIM_LEVELS_TL C
2066: WHERE A.DIM_GROUP_ID = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id
2067: AND A.DIM_LEVEL_ID = B.DIM_LEVEL_ID
2068: AND B.DIM_LEVEL_ID = C.DIM_LEVEL_ID;