APPS.BSC_MO_UI_PKG dependencies on BSC_SYS_MEASURES

Line 234: l_stmt := 'SELECT DISTINCT M.MEASURE_COL FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_KPI_V I'

230: i:=i+1;
231: END LOOP;
232:
233: --PMF-BSC Integration: Filter out PMF measures
234: l_stmt := 'SELECT DISTINCT M.MEASURE_COL FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_KPI_V I'
235: || ' WHERE I.MEASURE_ID = M.MEASURE_ID AND ('|| strWhereInIndics ||' )'||
236: ' AND M.TYPE = 0 AND NVL(M.SOURCE, ''BSC'') = ''BSC'' ';
237: OPEN cv FOR l_stmt;
238:

Line 256: ||'FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_KPI_V I '||

252:
253: strWhereNotInIndics := ' NOT ( ' || strWhereInIndics || ')';
254:
255: l_stmt := 'SELECT DISTINCT M.MEASURE_ID, M.MEASURE_COL '
256: ||'FROM BSC_SYS_MEASURES M, BSC_DB_MEASURE_BY_KPI_V I '||
257: ' WHERE I.MEASURE_ID = M.MEASURE_ID AND ('|| strWhereNotInIndics ||' ) '||
258: ' AND M.TYPE = 0 AND NVL(M.SOURCE, ''BSC'') = ''BSC''';
259:
260: OPEN cv FOR l_stmt;

Line 1011: bsc_sys_measures measure, bsc_sys_datasets_vl datasets

1007: cursor cMeasures (l_schema IN VARCHAR2) IS
1008: select datasets.name, cols.column_name
1009: from
1010: all_tab_columns cols,
1011: bsc_sys_measures measure, bsc_sys_datasets_vl datasets
1012: where cols.table_name = pTableName
1013: and cols.owner = l_schema
1014: and cols.column_name not in ('YEAR', 'TYPE', 'PERIOD', 'TIME_FK', 'PERIODICITY_ID', 'PERIOD_TYPE_ID')
1015: and cols.column_name = upper(measure.measure_col(+))