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_MO_HELPER_PKG dependencies on BSC_DB_TABLES_COLS

Line 5094: TableName := 'BSC_DB_TABLES_COLS';

5090: (select source_table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last||'
5091: connect by table_name = prior source_table_name
5092: start with table_name in (select table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_data_last||'))';
5093: END IF;
5094: TableName := 'BSC_DB_TABLES_COLS';
5095: CreateCopyTable(TableName, BSC_METADATA_OPTIMIZER_PKG.g_db_tables_cols_last, BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName, l_where_clause);
5096: CreateCopyIndexes(TableName, BSC_METADATA_OPTIMIZER_PKG.g_db_tables_cols_last, BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName);
5097: dbms_stats.gather_table_stats(BSC_METADATA_OPTIMIZER_PKG.gBscSchema, BSC_METADATA_OPTIMIZER_PKG.g_db_tables_cols_last);
5098:

Line 5777: --BSC_DB_TABLES_COLS

5773: l_stmt := 'DELETE FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInTables;
5774: l_stmt := replace(l_stmt, 'UPPER(TABLE_NAME)', 'table_name');
5775: l_stmt := replace(l_stmt, 'UPPER(VALUE_V)', 'value_v');
5776: Execute immediate l_stmt;
5777: --BSC_DB_TABLES_COLS
5778: l_stmt := 'DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInTables;
5779: l_stmt := replace(l_stmt, 'UPPER(TABLE_NAME)', 'table_name');
5780: l_stmt := replace(l_stmt, 'UPPER(VALUE_V)', 'value_v');
5781: Execute immediate l_stmt;

Line 5778: l_stmt := 'DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInTables;

5774: l_stmt := replace(l_stmt, 'UPPER(TABLE_NAME)', 'table_name');
5775: l_stmt := replace(l_stmt, 'UPPER(VALUE_V)', 'value_v');
5776: Execute immediate l_stmt;
5777: --BSC_DB_TABLES_COLS
5778: l_stmt := 'DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInTables;
5779: l_stmt := replace(l_stmt, 'UPPER(TABLE_NAME)', 'table_name');
5780: l_stmt := replace(l_stmt, 'UPPER(VALUE_V)', 'value_v');
5781: Execute immediate l_stmt;
5782: --BSC_DB_CALCULATIONS

Line 6011: FROM bsc_db_tables_cols cols

6007: AND cond.session_id = :2
6008: AND last.column_type = :3
6009: MINUS
6010: SELECT cols.table_name, cols.column_name
6011: FROM bsc_db_tables_cols cols
6012: , bsc_db_tables_rels rels
6013: , bsc_tmp_big_in_cond cond
6014: WHERE cond.value_v = rels.source_table_name
6015: AND rels.table_name = cols.table_name

Line 6054: DELETE bsc_db_tables_cols

6050: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, p_Table_name );
6051: ELSE
6052: writeTmp(p_table_name||'.'||p_column_name||' doesnt exist, so not calling alter table as this was possibly dropped earlier');
6053: END IF;
6054: DELETE bsc_db_tables_cols
6055: WHERE table_name = p_Table_name
6056: AND column_name = p_column_name;
6057: END;
6058:

Line 6349: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);

6345: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES WHERE '||strWhereInCondition;
6346: writeTmp('Deleting entries from BSC_DB_TABLES_RELS '||get_time);
6347: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_RELS');
6348: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInCondition;
6349: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);
6350: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');
6351: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInCondition;
6352: writeTmp('Deleting entries from BSC_DB_CALCULATIONS '||get_time);
6353: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_CALCULATIONS');

Line 6350: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');

6346: writeTmp('Deleting entries from BSC_DB_TABLES_RELS '||get_time);
6347: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_RELS');
6348: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInCondition;
6349: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);
6350: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');
6351: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInCondition;
6352: writeTmp('Deleting entries from BSC_DB_CALCULATIONS '||get_time);
6353: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_CALCULATIONS');
6354: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_CALCULATIONS WHERE '|| strWhereInCondition;

Line 6351: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInCondition;

6347: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_RELS');
6348: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInCondition;
6349: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);
6350: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');
6351: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInCondition;
6352: writeTmp('Deleting entries from BSC_DB_CALCULATIONS '||get_time);
6353: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_CALCULATIONS');
6354: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_CALCULATIONS WHERE '|| strWhereInCondition;
6355: ELSE

Line 6363: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);

6359: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES WHERE table_name IN '||l_drop_these;
6360: writeTmp('Deleting entries from BSC_DB_TABLES_RELS '||get_time);
6361: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_RELS');
6362: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE table_name IN '||l_drop_these;
6363: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);
6364: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');
6365: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE table_name IN '||l_drop_these;
6366: writeTmp('Deleting entries from BSC_DB_CALCULATIONS '||get_time);
6367: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_CALCULATIONS');

Line 6364: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');

6360: writeTmp('Deleting entries from BSC_DB_TABLES_RELS '||get_time);
6361: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_RELS');
6362: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE table_name IN '||l_drop_these;
6363: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);
6364: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');
6365: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE table_name IN '||l_drop_these;
6366: writeTmp('Deleting entries from BSC_DB_CALCULATIONS '||get_time);
6367: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_CALCULATIONS');
6368: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_CALCULATIONS WHERE table_name IN '||l_drop_these;

Line 6365: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE table_name IN '||l_drop_these;

6361: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_RELS');
6362: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE table_name IN '||l_drop_these;
6363: writeTmp('Deleting entries from BSC_DB_TABLES_COLS '||get_time);
6364: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_TABLES_COLS');
6365: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE table_name IN '||l_drop_these;
6366: writeTmp('Deleting entries from BSC_DB_CALCULATIONS '||get_time);
6367: bsc_metadata_optimizer_pkg.logProgress('CLEANUP', 'Deleting entries from BSC_DB_CALCULATIONS');
6368: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_CALCULATIONS WHERE table_name IN '||l_drop_these;
6369: END IF;