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_DBGEN_BSC_READER dependencies on BSC_SYS_MEASURES

Line 115: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I

111: Function get_num_measures(p_indicator IN NUMBER, p_dim_set IN NUMBER) RETURN NUMBER IS
112: l_num_measures number;
113: CURSOR cNumCols IS
114: SELECT COUNT(M.MEASURE_COL) NUM_DATA_COLUMNS
115: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I
116: WHERE I.MEASURE_ID = M.MEASURE_ID
117: AND I.DIM_SET_ID = p_dim_set
118: AND I.INDICATOR = p_indicator
119: AND M.TYPE = 0 AND NVL(M.SOURCE, 'BSC') in ( 'BSC', 'PMF');

Line 138: BSC_SYS_MEASURES sysm

134: --BSC-PMF Integration: Need to filter out PMF measures
135: CURSOR c1 IS
136: SELECT ms.MEASURE_COL, ms.HELP, ms.MEASURE_GROUP_ID, ms.PROJECTION_ID, NVL(ms.MEASURE_TYPE, 1) MTYPE, sysm.source
137: FROM BSC_DB_MEASURE_COLS_VL ms,
138: BSC_SYS_MEASURES sysm
139: WHERE ms.measure_col = sysm.measure_col
140: ORDER BY MEASURE_COL;
141: cRow c1%ROWTYPE;
142:

Line 454: UPDATE BSC_SYS_MEASURES

450:
451: BEGIN
452:
453:
454: UPDATE BSC_SYS_MEASURES
455: SET S_COLOR_FORMULA = BSC_APPS.SET_PROPERTY_VALUE(S_COLOR_FORMULA, propertyName, propertyValue)
456: WHERE UPPER(MEASURE_COL) = upper(dataColumn)
457: AND TYPE = 0 AND NVL(SOURCE, 'BSC') = 'BSC';
458:

Line 481: FROM BSC_SYS_MEASURES

477: SELECT NVL(OPERATION, 'SUM') AS OPER,
478: NVL(BSC_APPS.GET_PROPERTY_VALUE(S_COLOR_FORMULA, p1),'N') AS PAVGL,
479: BSC_APPS.GET_PROPERTY_VALUE(S_COLOR_FORMULA, p2) AS PAVGLTOTAL,
480: BSC_APPS.GET_PROPERTY_VALUE(S_COLOR_FORMULA, p3) AS PAVGLCOUNTER
481: FROM BSC_SYS_MEASURES
482: WHERE UPPER(MEASURE_COL) = UPPER(p4)
483: AND TYPE = 0
484: AND NVL(SOURCE, 'BSC') = 'BSC';
485:

Line 567: FROM BSC_SYS_MEASURES M, BSC_DB_TABLES_COLS C, BSC_DB_MEASURE_COLS_VL COLS

563: NVL(BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :2 ),''N'') AS PAVGL,
564: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :3) AS PAVGLTOTAL,
565: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :4) AS PAVGLCOUNTER,
566: M.MEASURE_ID, nvl(cols.measure_type, 1) measure_type, m.source
567: FROM BSC_SYS_MEASURES M, BSC_DB_TABLES_COLS C, BSC_DB_MEASURE_COLS_VL COLS
568: WHERE M.MEASURE_COL(+) = C.COLUMN_NAME
569: AND COLS.measure_col(+) = c.column_name
570: AND C.COLUMN_TYPE = ''A''
571: AND C.TABLE_NAME LIKE ''BSC_S%'||p_fact||'_'||p_dim_set||'%'||'''

Line 1001: l_stmt := 'SELECT DISTINCT M.MEASURE_COL FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I'

997: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number( 9, l_fact_list(i).fact_id);
998: i:=i+1;
999: END LOOP;
1000: --PMF-BSC Integration: Filter out PMF measures
1001: l_stmt := 'SELECT DISTINCT M.MEASURE_COL FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I'
1002: || ' WHERE I.MEASURE_ID = M.MEASURE_ID AND ('|| strWhereInIndics ||' )'||
1003: ' AND M.TYPE = 0 AND NVL(M.SOURCE, ''BSC'') in (''PMF'', ''BSC'') ';
1004: OPEN cv FOR l_stmt;
1005: LOOP

Line 1017: ||'FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I '||

1013: We need to see in all system measures if there is a formula using that measure.
1014: IF that happen we need to add that measure. Any kpi using that meaure should be flaged too.*/
1015: strWhereNotInIndics := ' NOT ( ' || strWhereInIndics || ')';
1016: l_stmt := 'SELECT DISTINCT M.MEASURE_ID, M.MEASURE_COL '
1017: ||'FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I '||
1018: ' WHERE I.MEASURE_ID = M.MEASURE_ID AND ('|| strWhereNotInIndics ||' ) '||
1019: ' AND M.TYPE = 0 AND NVL(M.SOURCE, ''BSC'') in (''BSC'', ''PMF'')';
1020: OPEN cv FOR l_stmt;
1021: LOOP

Line 1182: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I

1178: NVL(BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :2 ),''N'') AS PAVGL,
1179: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :3) AS PAVGLTOTAL,
1180: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :4) AS PAVGLCOUNTER,
1181: M.source
1182: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I
1183: WHERE I.MEASURE_ID = M.MEASURE_ID
1184: AND I.MEASURE_COL = M.MEASURE_COL
1185: AND I.DIM_SET_ID = :5
1186: AND I.INDICATOR = :6

Line 1369: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I

1365: FUNCTION Get_Measures_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_derived_columns IN BOOLEAN default false) return BSC_DBGEN_STD_METADATA.tab_clsMeasure IS
1366:
1367: CURSOR cMeasureList IS
1368: SELECT M.MEASURE_COL, NVL(M.OPERATION, 'SUM') AS OPER, m.source measure_source
1369: FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_DIM_SET_V I
1370: WHERE I.MEASURE_ID = M.MEASURE_ID
1371: AND I.DIM_SET_ID = p_dim_set
1372: AND I.INDICATOR = to_number(p_fact)
1373: AND M.TYPE = 0

Line 1378: FROM BSC_DB_MEASURE_COLS_VL COLS , BSC_SYS_MEASURES sysm

1374: AND NVL(M.SOURCE, 'BSC') in('PMF', 'BSC');
1375:
1376: CURSOR cProperties(p_col VARCHAR2) IS
1377: SELECT sysm.measure_id, nvl(COLS.MEASURE_GROUP_ID,-1) measure_group_id, nvl(COLS.PROJECTION_ID, 0) projection_id , NVL(COLS.MEASURE_TYPE, 1) MEASURE_TYPE
1378: FROM BSC_DB_MEASURE_COLS_VL COLS , BSC_SYS_MEASURES sysm
1379: WHERE sysm.measure_col = cols.measure_col(+)
1380: AND sysm.measure_col = p_col;
1381: l_measure_row cProperties%ROWTYPE;
1382: ColMeasures BSC_DBGEN_STD_METADATA.tab_clsMeasure;

Line 1910: BSC_SYS_MEASURES sysm

1906: , sysm.MEASURE_ID
1907: From bsc_db_tables_cols s_table,
1908: bsc_db_tables_cols b_table,
1909: BSC_DB_MEASURE_COLS_VL measures,
1910: BSC_SYS_MEASURES sysm
1911: where s_table.table_name = p_s_table
1912: and b_table.table_name = p_base_table
1913: and s_table.column_name = b_table.column_name
1914: and s_table.column_type = 'A'

Line 1926: BSC_SYS_MEASURES sysm

1922: from
1923: bsc_db_tables_cols s_table,
1924: bsc_db_tables_cols b_table,
1925: BSC_DB_MEASURE_COLS_VL measures,
1926: BSC_SYS_MEASURES sysm
1927: where s_table.table_name =p_s_table
1928: and b_table.table_name = p_base_table
1929: and s_table.column_name = b_table.column_name
1930: and s_table.column_type = 'A'

Line 1941: BSC_SYS_MEASURES sysm

1937: from
1938: bsc_db_tables_cols s_table,
1939: bsc_db_tables_cols b_table,
1940: BSC_DB_MEASURE_COLS_VL measures,
1941: BSC_SYS_MEASURES sysm
1942: where s_table.table_name =p_s_table
1943: and b_table.table_name(+) = p_base_table
1944: and s_table.column_name = b_table.column_name(+)
1945: and s_table.column_name like 'BSCIC%'

Line 2504: FROM bsc_sys_measures sysm, bsc_tmp_big_in_cond tmp

2500: l_index number;
2501: l_variable_id number := 1;
2502: CURSOR c1(p_session_id NUMBER, p_variable_id NUMBER) IS
2503: SELECT nvl(sysm.measure_col, tmp.value_v) measure_col
2504: FROM bsc_sys_measures sysm, bsc_tmp_big_in_cond tmp
2505: where tmp.session_id = p_session_id
2506: and tmp.variable_id = p_variable_id
2507: and tmp.value_v = sysm.short_name(+)
2508: order by tmp.value_n;