APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on BSC_DB_TABLES

Line 51: -- get indicators without rows in bsc_db_tables

47: bsc_kpis_b kpi,
48: bsc_tmp_opt_kpis_with_measures considerkpi
49: where kpi.indicator = considerkpi.indicator
50: and kpi.prototype_flag <> 2
51: -- get indicators without rows in bsc_db_tables
52: and not exists
53: (select 1 from bsc_db_tables where table_name like ''BSC_S_''||kpi.indicator||''%'')
54: -- skip shared but unfiltered indicators
55: and ( kpi.share_flag in (0,1)

Line 53: (select 1 from bsc_db_tables where table_name like ''BSC_S_''||kpi.indicator||''%'')

49: where kpi.indicator = considerkpi.indicator
50: and kpi.prototype_flag <> 2
51: -- get indicators without rows in bsc_db_tables
52: and not exists
53: (select 1 from bsc_db_tables where table_name like ''BSC_S_''||kpi.indicator||''%'')
54: -- skip shared but unfiltered indicators
55: and ( kpi.share_flag in (0,1)
56: or
57: (kpi.share_flag = 2

Line 73: FROM bsc_db_tables

69: /*
70: bsc_mo_helper_pkg.writeTmp( 'Starting writeTableCounts, System time is '
71: ||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
72: SELECT count(1) INTO l_num
73: FROM bsc_db_tables
74: WHERE table_name like 'BSC_I_%';
75: bsc_mo_helper_pkg.writeTmp('No. of I tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
76: SELECT count(1)INTO l_num
77: FROM bsc_db_tables

Line 77: FROM bsc_db_tables

73: FROM bsc_db_tables
74: WHERE table_name like 'BSC_I_%';
75: bsc_mo_helper_pkg.writeTmp('No. of I tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
76: SELECT count(1)INTO l_num
77: FROM bsc_db_tables
78: WHERE table_name like 'BSC_B_%';
79: bsc_mo_helper_pkg.writeTmp('No. of B tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
80: SELECT count(1)INTO l_num
81: FROM bsc_db_tables

Line 81: FROM bsc_db_tables

77: FROM bsc_db_tables
78: WHERE table_name like 'BSC_B_%';
79: bsc_mo_helper_pkg.writeTmp('No. of B tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
80: SELECT count(1)INTO l_num
81: FROM bsc_db_tables
82: WHERE table_name like 'BSC_T_%';
83: bsc_mo_helper_pkg.writeTmp('No. of T tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
84: SELECT count(1) INTO l_num
85: FROM bsc_db_tables

Line 85: FROM bsc_db_tables

81: FROM bsc_db_tables
82: WHERE table_name like 'BSC_T_%';
83: bsc_mo_helper_pkg.writeTmp('No. of T tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
84: SELECT count(1) INTO l_num
85: FROM bsc_db_tables
86: WHERE table_name like 'BSC_S_%';
87: bsc_mo_helper_pkg.writeTmp('No. of S tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
88: bsc_mo_helper_pkg.writeTmp(bsc_mo_helper_pkg.get_time||' Indicators with no rows in BSC_DB_tables : ', FND_LOG.LEVEL_STATEMENT, true);
89: OPEN cv for l_stmt;

Line 88: bsc_mo_helper_pkg.writeTmp(bsc_mo_helper_pkg.get_time||' Indicators with no rows in BSC_DB_tables : ', FND_LOG.LEVEL_STATEMENT, true);

84: SELECT count(1) INTO l_num
85: FROM bsc_db_tables
86: WHERE table_name like 'BSC_S_%';
87: bsc_mo_helper_pkg.writeTmp('No. of S tables in DB_tables = '||l_num, FND_LOG.LEVEL_STATEMENT, true);
88: bsc_mo_helper_pkg.writeTmp(bsc_mo_helper_pkg.get_time||' Indicators with no rows in BSC_DB_tables : ', FND_LOG.LEVEL_STATEMENT, true);
89: OPEN cv for l_stmt;
90: LOOP
91: FETCH cv INTO l_num;
92: EXIT WHEN cv%NOTFOUND;

Line 283: and not exists (select 1 from bsc_db_tables where instr(table_name, p_pattern)>0);

279: cursor cShared(p_pattern varchar2) is
280: select count(1) from bsc_kpis_vl
281: where indicator=p_objective
282: and share_flag=2
283: and not exists (select 1 from bsc_db_tables where instr(table_name, p_pattern)>0);
284: l_count number;
285: begin
286: open cShared ('BSC_S_'||p_objective||'_') ;
287: fetch cShared into l_count;