View: BSC_KPI_DATA_TABLES_V

Product:	BSC - Balanced Scorecard
Description:
Implementation/DBA Data:	APPS.BSC_KPI_DATA_TABLES_V

View Text

SELECT T.INDICATOR
, T.PERIODICITY_ID
, T.DIM_SET_ID
, T.LEVEL_COMB
, DECODE(K.EDW_FLAG
, 1
, SUBSTR(T.TABLE_NAME
, 1
, LENGTH(T.TABLE_NAME)-2)
, T.TABLE_NAME) AS TABLE_NAME
, T.FILTER_CONDITION
FROM BSC_KPI_DATA_TABLES T
, BSC_KPIS_B K
WHERE T.INDICATOR = K.INDICATOR

Columns