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

Line 387: , BSC_SYS_DIM_LEVELS_BY_GROUP SLG

383: FROM BSC_TAB_INDICATORS TI
384: , BSC_KPIS_B KB
385: , BSC_KPI_DIM_LEVELS_VL KL
386: , BSC_KPI_DIM_GROUPS KG
387: , BSC_SYS_DIM_LEVELS_BY_GROUP SLG
388: , BSC_SYS_DIM_LEVELS_VL SL
389: WHERE TI.TAB_ID = p_Tab_Id
390: AND KB.INDICATOR = TI.INDICATOR
391: AND KB.PROTOTYPE_FLAG <> 2

Line 456: BSC_SYS_DIM_LEVELS_BY_GROUP SLG,

452: FROM BSC_TAB_INDICATORS TI,
453: BSC_KPIS_B KB,
454: BSC_KPI_DIM_SETS_VL KDS,
455: BSC_KPI_DIM_GROUPS KDG,
456: BSC_SYS_DIM_LEVELS_BY_GROUP SLG,
457: BSC_SYS_DIM_LEVELS_B SL
458: WHERE TI.TAB_ID = p_Tab_Id
459: AND KB.INDICATOR = TI.INDICATOR
460: AND KB.PROTOTYPE_FLAG <> 2

Line 457: BSC_SYS_DIM_LEVELS_B SL

453: BSC_KPIS_B KB,
454: BSC_KPI_DIM_SETS_VL KDS,
455: BSC_KPI_DIM_GROUPS KDG,
456: BSC_SYS_DIM_LEVELS_BY_GROUP SLG,
457: BSC_SYS_DIM_LEVELS_B SL
458: WHERE TI.TAB_ID = p_Tab_Id
459: AND KB.INDICATOR = TI.INDICATOR
460: AND KB.PROTOTYPE_FLAG <> 2
461: AND KDS.INDICATOR = KB.INDICATOR

Line 609: FROM BSC_SYS_DIM_LEVELS_B SL,

605: CL.DIM_LEVEL_INDEX,
606: CL.PARENT_LEVEL_INDEX,
607: CL.DIM_LEVEL_ID,
608: CL.PARENT_DIM_LEVEL_ID
609: FROM BSC_SYS_DIM_LEVELS_B SL,
610: BSC_SYS_COM_DIM_LEVELS CL
611: WHERE CL.TAB_ID = p_Tab_Id
612: AND SL.DIM_LEVEL_ID (+) = CL.DIM_LEVEL_ID
613: ORDER BY CL.DIM_LEVEL_INDEX;