VIEW: APPS.BSC_KPI_DATA_TABLES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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