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_MIGRATION dependencies on BSC_KPIS_B

Line 3114: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_KPIS_B';

3110: g_metadata_tables(g_num_metadata_tables).copy_flag := FALSE;
3111: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3112:
3113: g_num_metadata_tables := g_num_metadata_tables + 1;
3114: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_KPIS_B';
3115: g_metadata_tables(g_num_metadata_tables).level := 2;
3116: g_metadata_tables(g_num_metadata_tables).level_column := 'INDICATOR';
3117: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3118: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 4099: ' bsc_kpis_b@'||g_db_link||' k'||

4095: ' FROM bsc_responsibility_vl@'||g_db_link||' r,'||
4096: ' bsc_user_tab_access@'||g_db_link||' rt,'||
4097: ' bsc_user_kpi_access@'||g_db_link||' rk,'||
4098: ' bsc_tab_indicators@'||g_db_link||' tk,'||
4099: ' bsc_kpis_b@'||g_db_link||' k'||
4100: ' WHERE r.responsibility_id = rt.responsibility_id AND'||
4101: ' r.responsibility_id = rk.responsibility_id AND'||
4102: ' rt.tab_id = tk.tab_id AND'||
4103: ' rk.indicator = tk.indicator AND'||

Line 5174: BSC_KPIS_B TGT

5170: 1000000 CONC_REQUEST_ID,
5171: sysdate MIGRATION_DATE
5172: FROM
5173: BSC_KPI_COMMENTS CMT,
5174: BSC_KPIS_B TGT
5175: WHERE
5176: CMT.INDICATOR = TGT.INDICATOR';
5177: e_unexpected_error EXCEPTION;
5178: BEGIN

Line 5196: BSC_KPIS_B TGT,

5192: BEGIN
5193:
5194: l_stmt := 'UPDATE '||c_comments_bak||' set preserve_flag = :1 where indicator in
5195: (SELECT TGT.INDICATOR FROM
5196: BSC_KPIS_B TGT,
5197: BSC_KPIS_B@'||g_db_link||' SRC
5198: WHERE
5199: TGT.INDICATOR = SRC.INDICATOR
5200: AND TGT.CREATION_DATE = SRC.CREATION_DATE)';

Line 5197: BSC_KPIS_B@'||g_db_link||' SRC

5193:
5194: l_stmt := 'UPDATE '||c_comments_bak||' set preserve_flag = :1 where indicator in
5195: (SELECT TGT.INDICATOR FROM
5196: BSC_KPIS_B TGT,
5197: BSC_KPIS_B@'||g_db_link||' SRC
5198: WHERE
5199: TGT.INDICATOR = SRC.INDICATOR
5200: AND TGT.CREATION_DATE = SRC.CREATION_DATE)';
5201: execute immediate l_stmt using 'Y';

Line 5319: BSC_KPIS_B KPIS

5315: CMT.COMMENT_SUBJECT,
5316: CMT.COMMENT_ID
5317: FROM
5318: BSC_KPI_COMMENTS_BAK CMT,
5319: BSC_KPIS_B KPIS
5320: WHERE PRESERVE_FLAG = :1
5321: AND CMT.indicator = kpis.indicator';
5322:
5323: EXECUTE IMMEDIATE l_stmt USING 'Y';

Line 5719: ' FROM bsc_kpis_b'||

5715:
5716: -- Enh#4697749: Migrate AK Metadata and Form Functions of the Reports
5717: FOR h_i IN 1..g_num_mig_kpis LOOP
5718: h_sql := 'SELECT short_name'||
5719: ' FROM bsc_kpis_b'||
5720: ' WHERE indicator = :1';
5721: OPEN h_cursor FOR h_sql USING g_mig_kpis(h_i);
5722: FETCH h_cursor INTO h_short_name;
5723: CLOSE h_cursor;

Line 5818: ' FROM bsc_kpis_b@'||g_db_link||

5814: -- Create MVs for migrated Kpis that has prototype flag 0, 6 or 7
5815: FOR h_i IN 1..g_num_mig_kpis LOOP
5816: -- Get prototype flag and report type
5817: h_sql := 'SELECT prototype_flag, BSC_DBGEN_UTILS.get_Objective_Type(short_name)'||
5818: ' FROM bsc_kpis_b@'||g_db_link||
5819: ' WHERE indicator = :1';
5820: OPEN h_cursor FOR h_sql USING g_mig_kpis(h_i);
5821: FETCH h_cursor INTO h_prototype_flag, h_report_type;
5822: CLOSE h_cursor;

Line 5909: ' from bsc_kpi_dim_levels_vl kd, bsc_kpi_properties kp, bsc_kpis_b k'||

5905: END IF;
5906:
5907: --AW_INTEGRATION: Load all the BSC dimensions used in AW indicators into AW
5908: h_sql := 'select distinct level_table_name'||
5909: ' from bsc_kpi_dim_levels_vl kd, bsc_kpi_properties kp, bsc_kpis_b k'||
5910: ' where kd.indicator = kp.indicator and'||
5911: ' kd.indicator = k.indicator and'||
5912: ' k.prototype_flag IN (0,6,7) and'||
5913: ' kp.property_code = :1 and kp.property_value = :2 and'||

Line 5945: ' from bsc_kpis_b k, bsc_kpi_properties kp'||

5941: CLOSE h_cursor;
5942:
5943: --AW_INTEGRATION: Load calendars used by AW indicators into AW
5944: h_sql := 'select distinct calendar_id'||
5945: ' from bsc_kpis_b k, bsc_kpi_properties kp'||
5946: ' where k.indicator = kp.indicator and'||
5947: ' k.prototype_flag IN (0,6,7) and'||
5948: ' kp.property_code = :1 and kp.property_value = :2';
5949: OPEN h_cursor FOR h_sql USING 'IMPLEMENTATION_TYPE', 2;

Line 5993: ' from bsc_kpis_b k, bsc_kpi_properties kp'||

5989: END IF;
5990:
5991: --AW_INTEGRATION: Now refresh the AW indicators
5992: h_sql := 'select k.indicator'||
5993: ' from bsc_kpis_b k, bsc_kpi_properties kp'||
5994: ' where k.indicator = kp.indicator and'||
5995: ' k.prototype_flag IN (0,6,7) and'||
5996: ' kp.property_code = :1 and kp.property_value = :2';
5997: OPEN h_cursor FOR h_sql USING 'IMPLEMENTATION_TYPE', 2;

Line 8933: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE

8929:
8930:
8931: PROCEDURE Synchronize_AK_BSC_Metadata (
8932: p_commit IN VARCHAR2 := FND_API.G_FALSE
8933: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
8934: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
8935: ,p_short_name IN BSC_KPIS_B.short_name%TYPE
8936: ,p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
8937: ,p_New_Dim_Levels IN FND_TABLE_OF_NUMBER

Line 8934: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE

8930:
8931: PROCEDURE Synchronize_AK_BSC_Metadata (
8932: p_commit IN VARCHAR2 := FND_API.G_FALSE
8933: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
8934: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
8935: ,p_short_name IN BSC_KPIS_B.short_name%TYPE
8936: ,p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
8937: ,p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
8938: ,p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER

Line 8935: ,p_short_name IN BSC_KPIS_B.short_name%TYPE

8931: PROCEDURE Synchronize_AK_BSC_Metadata (
8932: p_commit IN VARCHAR2 := FND_API.G_FALSE
8933: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
8934: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
8935: ,p_short_name IN BSC_KPIS_B.short_name%TYPE
8936: ,p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
8937: ,p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
8938: ,p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
8939: ,p_New_Dim_Groups IN FND_TABLE_OF_NUMBER

Line 8992: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('i,bsc_kpis_b');

8988: -- DataSet Sync Up
8989: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id, i.comparison_source,i.enable_link, ';
8990: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2,i.dataset_id from ak_region_items');
8991: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item, bis_indicators');
8992: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('i,bsc_kpis_b');
8993: l_sql := l_sql || ' k WHERE ak_item.region_code = k.short_name and ak_item.attribute1 = :1 and i.short_name = ak_item.attribute2';
8994: l_sql := l_sql || ' AND k.indicator = :2';
8995:
8996: OPEN c_Default_Node;

Line 9122: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');

9118:
9119: --Periods Sync Up
9120: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,ak_item.attribute2,';
9121: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' p.periodicity_id FROM ak_region_items');
9122: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9123: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k,bsc_sys_periodicities');
9124: l_sql := l_sql || ' p WHERE ak_item.region_code = k.short_name and ak_item.attribute1 = :1 and ak_item.attribute2 LIKE :2';
9125: l_sql := l_sql || ' AND ak_item.attribute2 NOT LIKE :3 AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = p.short_name';
9126: l_sql := l_sql || ' AND k.indicator = :4';

Line 9199: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');

9195:
9196: --Dim Object Sync Up
9197: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,';
9198: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');
9199: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9200: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_dim_levels_b');
9201: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' d , bsc_sys_dim_groups_vl');
9202: l_sql := l_sql || ' g WHERE ak_item.region_code = k.short_name AND ak_item.node_query_flag = ''Y'' AND ak_item.attribute2 LIKE ''%+%''';
9203: l_sql := l_sql || ' AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = d.short_name AND';

Line 9207: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');

9203: l_sql := l_sql || ' AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = d.short_name AND';
9204: l_sql := l_sql || ' SUBSTR(ak_item.attribute2,0,INSTR(ak_item.attribute2,''+'') - 1) = g.short_name AND k.indicator = :1 MINUS';
9205: l_sql := l_sql || ' SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,';
9206: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');
9207: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9208: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_periodicities');
9209: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' p,bsc_sys_dim_levels_b');
9210: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' d,bsc_sys_dim_groups_vl');
9211: l_sql := l_sql || 'g WHERE ak_item.region_code = k.short_name AND ak_item.node_query_flag = ''Y'' AND ak_item.attribute2 LIKE ''%+%''';

Line 9393: ,p_short_name IN BSC_KPIS_B.short_name%TYPE

9389:
9390:
9391: PROCEDURE Copy_AK_Attributes_Metadata (
9392: p_commit IN VARCHAR2 := FND_API.G_FALSE
9393: ,p_short_name IN BSC_KPIS_B.short_name%TYPE
9394: ,x_return_status OUT NOCOPY VARCHAR2
9395: ,x_msg_count OUT NOCOPY NUMBER
9396: ,x_msg_data OUT NOCOPY VARCHAR2
9397: ) IS

Line 9540: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE

9536:
9537: PROCEDURE Migrate_Sim_Data
9538: (
9539: p_commit IN VARCHAR2 := FND_API.G_FALSE
9540: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
9541: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
9542: ,p_Region_Code IN VARCHAR2
9543: ,p_Old_Region_Code IN BSC_KPIS_B.short_name%TYPE
9544: ,p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER

Line 9541: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE

9537: PROCEDURE Migrate_Sim_Data
9538: (
9539: p_commit IN VARCHAR2 := FND_API.G_FALSE
9540: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
9541: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
9542: ,p_Region_Code IN VARCHAR2
9543: ,p_Old_Region_Code IN BSC_KPIS_B.short_name%TYPE
9544: ,p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
9545: ,p_New_Dim_Levels IN FND_TABLE_OF_NUMBER

Line 9543: ,p_Old_Region_Code IN BSC_KPIS_B.short_name%TYPE

9539: p_commit IN VARCHAR2 := FND_API.G_FALSE
9540: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
9541: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
9542: ,p_Region_Code IN VARCHAR2
9543: ,p_Old_Region_Code IN BSC_KPIS_B.short_name%TYPE
9544: ,p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
9545: ,p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
9546: ,p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
9547: ,p_New_Dim_Groups IN FND_TABLE_OF_NUMBER

Line 9823: bsc_kpis_b

9819: END LOOP;
9820:
9821: IF p_Region_Code <> p_Old_Region_Code THEN
9822: UPDATE
9823: bsc_kpis_b
9824: SET
9825: short_name = p_Region_Code
9826: WHERE
9827: indicator = p_Trg_indicator;

Line 9837: SET user_function_name = (SELECT name FROM bsc_kpis_tl k, bsc_kpis_b b

9833: WHERE
9834: indicator = p_Trg_indicator;
9835:
9836: UPDATE fnd_form_functions_tl tl
9837: SET user_function_name = (SELECT name FROM bsc_kpis_tl k, bsc_kpis_b b
9838: WHERE b.indicator = k.indicator AND
9839: b.short_name = p_Region_Code AND k.language = tl.language)
9840: WHERE
9841: function_id = l_new_function_id;