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_KPI_DIM_GROUPS

Line 10276: BSC_KPI_DIM_GROUPS KG,

10272: l_Region_Code BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE;
10273: BEGIN
10274: SELECT G.SHORT_NAME INTO l_Region_Code
10275: FROM BSC_KPIS_B K,
10276: BSC_KPI_DIM_GROUPS KG,
10277: BSC_SYS_DIM_GROUPS_VL G
10278: WHERE K.SHORT_NAME = p_Page_Function_Name
10279: AND KG.INDICATOR = K.INDICATOR
10280: AND G.DIM_GROUP_ID = KG.DIM_GROUP_ID;

Line 10921: , BSC_KPI_DIM_GROUPS KG

10917: BEGIN
10918:
10919: SELECT COUNT(1) INTO l_Count
10920: FROM BSC_KPIS_B K
10921: , BSC_KPI_DIM_GROUPS KG
10922: , BSC_SYS_DIM_GROUPS_VL G
10923: WHERE
10924: K.INDICATOR = p_Kpi_Id
10925: AND G.SHORT_NAME = p_Dimension_Short_Name

Line 11263: BSC_KPI_DIM_GROUPS KG,

11259: ) IS
11260: CURSOR c_Objective_List IS
11261: SELECT KP.NAME || '[' || KP.INDICATOR || ']' NAME
11262: FROM BSC_SYS_DIM_GROUPS_VL GP,
11263: BSC_KPI_DIM_GROUPS KG,
11264: BSC_KPIS_VL KP
11265: WHERE GP.SHORT_NAME = p_Region_Code
11266: AND KG.DIM_GROUP_ID = GP.DIM_GROUP_ID
11267: AND KP.INDICATOR = KG.INDICATOR

Line 11319: BSC_KPI_DIM_GROUPS KG,

11315:
11316: CURSOR c_Objective_List IS
11317: SELECT KP.INDICATOR
11318: FROM BSC_SYS_DIM_GROUPS_VL GP,
11319: BSC_KPI_DIM_GROUPS KG,
11320: BSC_KPIS_VL KP
11321: WHERE GP.SHORT_NAME = p_Region_Code
11322: AND KG.DIM_GROUP_ID = GP.DIM_GROUP_ID
11323: AND KP.INDICATOR = KG.INDICATOR;