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_IMAGES_MAP_TL

Line 3603: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_IMAGES_MAP_TL';

3599: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE; --blob columns are handled by DMLs as others type of columns
3600: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3601:
3602: g_num_metadata_tables := g_num_metadata_tables + 1;
3603: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_IMAGES_MAP_TL';
3604: g_metadata_tables(g_num_metadata_tables).level := 0;
3605: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3606: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 0';
3607: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3611: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_IMAGES_MAP_TL';

3607: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3608: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3609: --CONDITION CHANGE FOR ENH 5844382, PICK UP SOURCE_TYPE = 3 ALSO
3610: g_num_metadata_tables := g_num_metadata_tables + 1;
3611: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_IMAGES_MAP_TL';
3612: g_metadata_tables(g_num_metadata_tables).level := 1;
3613: g_metadata_tables(g_num_metadata_tables).level_column := 'SOURCE_CODE';
3614: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 1 OR SOURCE_TYPE = 3';
3615: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3619: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_IMAGES_MAP_TL';

3615: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3616: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE; -- Only 1 flag per table
3617:
3618: g_num_metadata_tables := g_num_metadata_tables + 1;
3619: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_IMAGES_MAP_TL';
3620: g_metadata_tables(g_num_metadata_tables).level := 2;
3621: g_metadata_tables(g_num_metadata_tables).level_column := 'SOURCE_CODE';
3622: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 2';
3623: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 9571: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;

9567: l_error_msg VARCHAR2(4000);
9568: l_column_name all_tab_columns.column_name%TYPE;
9569: l_Tl_Table_Column all_tab_columns.column_name%TYPE;
9570: l_condition VARCHAR2(4000);
9571: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9572: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9573: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
9574: h_sql VARCHAR2(3200);
9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;

Line 9572: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;

9568: l_column_name all_tab_columns.column_name%TYPE;
9569: l_Tl_Table_Column all_tab_columns.column_name%TYPE;
9570: l_condition VARCHAR2(4000);
9571: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9572: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9573: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
9574: h_sql VARCHAR2(3200);
9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;
9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;

Line 9592: --BSC_SYS_IMAGES_MAP_TL

9588:
9589: BEGIN
9590: --new tables for simulatio tree objective are
9591: --BSC_SYS_IMAGES
9592: --BSC_SYS_IMAGES_MAP_TL
9593: --BSC_TAB_VIEW_LABELS_B/TL
9594: --BSC_KPI_TREE_NODES_B/TL
9595:
9596: --For existing migration we don't need to handle any thing

Line 9689: IF(l_table_name='BSC_SYS_IMAGES_MAP_TL' AND UPPER(l_arr_columns(i)) = 'IMAGE_ID') THEN

9685: IF i <> 1 THEN
9686: l_sql:= l_sql || ',';
9687: END IF;
9688:
9689: IF(l_table_name='BSC_SYS_IMAGES_MAP_TL' AND UPPER(l_arr_columns(i)) = 'IMAGE_ID') THEN
9690:
9691: SELECT bsc_sys_image_id_s.nextval
9692: INTO l_next_image_id
9693: FROM dual;

Line 9699: ' FROM BSC_SYS_IMAGES_MAP_TL '||'@'||g_db_link ||

9695: l_sql:= l_sql || l_next_image_id || ' AS ' || l_arr_columns(i);
9696: ELSIF(l_table_name='BSC_SYS_IMAGES' AND UPPER(l_arr_columns(i)) = 'IMAGE_ID' )THEN
9697:
9698: h_sql := ' SELECT DISTINCT image_id '||
9699: ' FROM BSC_SYS_IMAGES_MAP_TL '||'@'||g_db_link ||
9700: ' WHERE SOURCE_TYPE =2 AND SOURCE_CODE = '|| p_Src_indicator;
9701:
9702: IF(l_cursor%ISOPEN)THEN
9703: CLOSE l_cursor;

Line 9714: FROM BSC_SYS_IMAGES_MAP_TL

9710: l_condition := l_column_name ||' = ' || l_image_id;
9711:
9712: SELECT distinct image_id
9713: INTO l_image_id
9714: FROM BSC_SYS_IMAGES_MAP_TL
9715: WHERE SOURCE_TYPE =2
9716: AND SOURCE_CODE =p_Trg_indicator;
9717:
9718: l_sql:= l_sql || l_image_id || ' AS ' || l_arr_columns(i);