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_TMP_OPT_UI_KPIS

Line 20: bsc_tmp_opt_ui_kpis proc

16: cursor cMissingViews is
17: select distinct sysdim.short_name, sysdim.level_view_name
18: from bsc_sys_dim_levels_b sysdim,
19: bsc_kpi_dim_levels_b kpidim,
20: bsc_tmp_opt_ui_kpis proc
21: where proc.process_id = bsc_metadata_optimizer_pkg.g_ProcessID
22: and proc.indicator=kpidim.indicator
23: and kpidim.level_table_name = sysdim.level_table_name
24: and sysdim.source = 'PMF'

Line 4508: DELETE FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID;

4504: (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = ''OBJECTIVE'')';
4505: -- NOTE NOTE NOTE
4506: -- Change MODE to modified as ALL doesnt make sense anymore
4507: -- as ALL should now exclude KPIs created using report designer
4508: DELETE FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID;
4509: INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)
4510: SELECT INDICATOR, PROTOTYPE_FLAG, BSC_METADATA_OPTIMIZER_PKG.g_processID
4511: FROM BSC_KPIS_VL
4512: where short_name is null OR

Line 4509: INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)

4505: -- NOTE NOTE NOTE
4506: -- Change MODE to modified as ALL doesnt make sense anymore
4507: -- as ALL should now exclude KPIs created using report designer
4508: DELETE FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID;
4509: INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)
4510: SELECT INDICATOR, PROTOTYPE_FLAG, BSC_METADATA_OPTIMIZER_PKG.g_processID
4511: FROM BSC_KPIS_VL
4512: where short_name is null OR
4513: (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = 'OBJECTIVE');

Line 4523: l_stmt := l_stmt || ' where prototype_flag in (2,3) and indicator in (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = '||BSC_METADATA_OPTIMIZER_PKG.g_processID||')';

4519: ELSE
4520: writeTmp('Entire system consists of objectives, no autogenerated reports found', FND_LOG.LEVEL_PROCEDURE, true);
4521: END IF;
4522: ELSE-- Modified or Selected indicators
4523: l_stmt := l_stmt || ' where prototype_flag in (2,3) and indicator in (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = '||BSC_METADATA_OPTIMIZER_PKG.g_processID||')';
4524: END IF;
4525: l_Stmt := l_stmt || ' ORDER BY INDICATOR ';
4526: writeTmp(l_Stmt, FND_LOG.LEVEL_STATEMENT, false);
4527: open cv for l_stmt;

Line 4580: (select indicator from bsc_tmp_opt_ui_kpis where prototype_flag =4 and process_id= :1) ORDER BY INDICATOR';

4576: l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
4577: INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID,
4578: SHARE_FLAG, SOURCE_INDICATOR,
4579: EDW_FLAG FROM BSC_KPIS_VL WHERE INDICATOR in
4580: (select indicator from bsc_tmp_opt_ui_kpis where prototype_flag =4 and process_id= :1) ORDER BY INDICATOR';
4581: open cv for l_stmt using BSC_METADATA_OPTIMIZER_PKG.g_processID;
4582: BSC_METADATA_OPTIMIZER_PKG.logProgress('INIT', 'Indics with non structural changes are');
4583: LOOP
4584: FETCH cv into l_code, l_name, l_action_flag,

Line 4645: l_stmt := l_stmt ||' WHERE INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=:1) ';

4641: l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG, INDICATOR_TYPE,
4642: CONFIG_TYPE, PERIODICITY_ID, SHARE_FLAG, SOURCE_INDICATOR,
4643: EDW_FLAG FROM BSC_KPIS_VL ';
4644: -- added for selected indicators
4645: l_stmt := l_stmt ||' WHERE INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=:1) ';
4646: IF (BSC_METADATA_OPTIMIZER_PKG.gnumIndics > 0) And (BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 > 0) THEN
4647: l_stmt := l_stmt ||' AND (' || strWhereNotInIndics || ') AND ('|| strWhereNotInIndics4 || ')';
4648: ELSIF (BSC_METADATA_OPTIMIZER_PKG.gnumIndics > 0) THEN
4649: l_stmt := l_stmt ||' AND (' || strWhereNotInIndics || ')';

Line 5060: (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')

5056: SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
5057: CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
5058: start with table_name in
5059: (select distinct table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' where indicator in
5060: (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')
5061: )
5062: UNION
5063: SELECT TABLE_NAME FROM BSC_DB_TABLES_RELS
5064: CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME

Line 5067: (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')

5063: SELECT TABLE_NAME FROM BSC_DB_TABLES_RELS
5064: CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
5065: start with table_name in
5066: (select distinct table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' where indicator in
5067: (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')
5068: )
5069: )';
5070: END IF;
5071: CreateCopyTable(TableName, BSC_METADATA_OPTIMIZER_PKG.g_db_tables_last, BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName, l_where_clause);

Line 5080: (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')';

5076: CreateCopyIndexes(TableName, BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last, BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName);
5077: dbms_stats.gather_table_stats(BSC_METADATA_OPTIMIZER_PKG.gBscSchema, BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last);
5078: IF BSC_METADATA_OPTIMIZER_PKG.gGAA_RUN_MODE <>0 AND BSC_METADATA_OPTIMIZER_PKG.gIndicators.count < l_threshold THEN
5079: l_where_clause := ' WHERE indicator in
5080: (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')';
5081: END IF;
5082: TableName := 'BSC_KPI_DATA_TABLES';
5083: --DropTable(TableName||'_LAST');
5084: CreateCopyTable(TableName, BSC_METADATA_OPTIMIZER_PKG.g_kpi_data_last, BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName, l_where_clause);

Line 5421: (select indicator from bsc_tmp_opt_ui_kpis where process_id=:1)

5417: (SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
5418: CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
5419: start with table_name in
5420: (select distinct table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' where indicator in
5421: (select indicator from bsc_tmp_opt_ui_kpis where process_id=:1)
5422: )
5423: )
5424: ORDER BY R.SOURCE_TABLE_NAME';
5425: l_table_name varchar2(300);

Line 6646: AND INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID);*/

6642: SET PROTOTYPE_FLAG = 0
6643: WHERE DATASET_ID IN (
6644: SELECT DATASET_ID FROM BSC_SYS_DATASETS_B
6645: WHERE NVL(SOURCE, 'BSC') = 'PMF')
6646: AND INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID);*/
6647:
6648: WriteInitTable('SYSTEM_STAGE', '2');
6649:
6650: --BSC-MV Note: Store new summarization level into BSC_SYS_INIT

Line 6663: execute immediate 'delete bsc_tmp_opt_ui_kpis where process_id=:1' using BSC_METADATA_OPTIMIZER_PKG.g_processID;

6659:
6660: IF BSC_METADATA_OPTIMIZER_PKG.gSYSTEM_STAGE = 2 THEN
6661: DropAppsTables;
6662: End IF;
6663: execute immediate 'delete bsc_tmp_opt_ui_kpis where process_id=:1' using BSC_METADATA_OPTIMIZER_PKG.g_processID;
6664:
6665: BSC_MO_HELPER_PKG.writeTmp('Completed UpdateFlags'||get_time, FND_LOG.LEVEL_PROCEDURE, true);
6666: EXCEPTION WHEN OTHERS THEN
6667: writeTmp('Exception in UpdateFlags:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);