APPS.BSC_MO_INPUT_TABLE_PKG dependencies on BSC_DB_MEASURE_COLS_VL

Line 9: select measure_group_id from bsc_db_measure_cols_vl

5:
6:
7: FUNCTION get_measure_group(p_field_name IN VARCHAR2, p_source IN VARCHAR2) return NUMBER IS
8: cursor cMeasureGroup IS
9: select measure_group_id from bsc_db_measure_cols_vl
10: where measure_col = p_field_name;
11: --and measure_type = 0;
12: l_measure_group number;
13: l_temp number;

Line 53: select measure_group_id from bsc_db_measure_cols_vl

49:
50: l_obj_measures BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
51: l_table_measures BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
52: cursor cMeasureGroup(p_measure VARCHAR2) IS
53: select measure_group_id from bsc_db_measure_cols_vl
54: where measure_col = p_measure
55: and measure_type = 0;
56: l_measure_group number;
57: BEGIN

Line 226: FROM BSC_DB_TABLES_COLS cols, bsc_db_measure_cols_vl dbcols

222: SELECT COLUMN_TYPE, COLUMN_NAME, SOURCE_COLUMN, SOURCE_FORMULA
223: --BSC Autogen
224: , SOURCE
225: , measure_group_id
226: FROM BSC_DB_TABLES_COLS cols, bsc_db_measure_cols_vl dbcols
227: WHERE cols.TABLE_NAME = pTable
228: AND cols.column_name = dbcols.measure_col(+);
229: cColsRow cCols%ROWTYPE;
230:

Line 2651: bsc_db_measure_cols_vl dbcols

2647: FROM
2648: bsc_db_tables_cols cols,
2649: all_tab_columns tabcols,
2650: bsc_sys_measures sysm,
2651: bsc_db_measure_cols_vl dbcols
2652: WHERE
2653: cols.table_name = p_table
2654: AND cols.table_name = tabcols.table_name
2655: and cols.column_name = tabcols.column_name