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_SYS_PERIODICITIES

Line 3732: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_PERIODICITIES';

3728: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3729: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3730:
3731: g_num_metadata_tables := g_num_metadata_tables + 1;
3732: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_PERIODICITIES';
3733: g_metadata_tables(g_num_metadata_tables).level := 0;
3734: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3735: g_metadata_tables(g_num_metadata_tables).level_condition := 'NVL(EDW_FLAG, 0) = 0';
3736: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3740: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_PERIODICITIES_TL';

3736: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3737: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3738:
3739: g_num_metadata_tables := g_num_metadata_tables + 1;
3740: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_PERIODICITIES_TL';
3741: g_metadata_tables(g_num_metadata_tables).level := 0;
3742: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3743: g_metadata_tables(g_num_metadata_tables).level_condition := 'PERIODICITY_ID IN ('||
3744: ' SELECT PERIODICITY_ID'||

Line 3745: ' FROM BSC_SYS_PERIODICITIES@'||g_db_link||

3741: g_metadata_tables(g_num_metadata_tables).level := 0;
3742: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3743: g_metadata_tables(g_num_metadata_tables).level_condition := 'PERIODICITY_ID IN ('||
3744: ' SELECT PERIODICITY_ID'||
3745: ' FROM BSC_SYS_PERIODICITIES@'||g_db_link||
3746: ' WHERE NVL(EDW_FLAG, 0) = 0)';
3747: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3748: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3749:

Line 8968: l_Periodicity_Sht_Name bsc_sys_periodicities.short_name%TYPE;

8964: l_Region_Code ak_region_items.region_code%TYPE;
8965: l_Retain_Dim_Att2 BIS_STRING_ARRAY;
8966: l_Actual_Data_Source bis_indicators.actual_data_source%TYPE;
8967: l_sql VARCHAR2(32000);
8968: l_Periodicity_Sht_Name bsc_sys_periodicities.short_name%TYPE;
8969: l_Comparison_Source bis_indicators.comparison_source%TYPE;
8970: l_Enable_Link bis_indicators.enable_link%TYPE;
8971: TYPE c_cur_type IS REF CURSOR;
8972: c_cursor c_cur_type;

Line 9123: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k,bsc_sys_periodicities');

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';
9127:

Line 9149: bsc_sys_periodicities

9145: short_name
9146: INTO
9147: l_Periodicity_Sht_Name
9148: FROM
9149: bsc_sys_periodicities
9150: WHERE
9151: periodicity_id = p_New_Periodicities(i);
9152:
9153: l_New_Attribute2 := l_Calendar_Sht_Name || '+' || l_Periodicity_Sht_Name;

Line 9178: bsc_sys_periodicities_tl tl,

9174: SET
9175: attribute_label_long = (SELECT
9176: tl.name
9177: FROM
9178: bsc_sys_periodicities_tl tl,
9179: bsc_sys_periodicities b
9180: WHERE
9181: b.short_name = l_Periodicity_Sht_Name AND
9182: b.periodicity_id = tl.periodicity_id AND

Line 9179: bsc_sys_periodicities b

9175: attribute_label_long = (SELECT
9176: tl.name
9177: FROM
9178: bsc_sys_periodicities_tl tl,
9179: bsc_sys_periodicities b
9180: WHERE
9181: b.short_name = l_Periodicity_Sht_Name AND
9182: b.periodicity_id = tl.periodicity_id AND
9183: tl.language = ak_item.language)

Line 9208: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_periodicities');

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 ''%+%''';
9212: l_sql := l_sql || ' AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = p.short_name AND d.short_name = p.short_name';