DBA Data[Home] [Help]

APPS.BSC_MO_INPUT_TABLE_PKG dependencies on BSC_SYS_MEASURES

Line 579: BSC_MO_HELPER_PKG.writeTmp('Measure '||p_BTTables(i).Data(0).fieldName||', source=' ||p_BTTables(i).Data(0).source||' does not exist in the list of measures in bsc_sys_measures.', FND_LOG.LEVEL_STATEMENT, true);

575: EXCEPTION WHEN OTHERS THEN
576: l_error := sqlerrm;
577: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in get_matching_tables : '||l_error, FND_LOG.LEVEL_UNEXPECTED);
578: IF (l_temp=-1) THEN
579: BSC_MO_HELPER_PKG.writeTmp('Measure '||p_BTTables(i).Data(0).fieldName||', source=' ||p_BTTables(i).Data(0).source||' does not exist in the list of measures in bsc_sys_measures.', FND_LOG.LEVEL_STATEMENT, true);
580: END IF;
581: raise;
582: End ;
583:

Line 2650: bsc_sys_measures sysm,

2646: SELECT cols.column_name, nvl(cols.source, 'BSC'), nvl(dbcols.measure_group_id, -1)
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