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.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_SVIEW_COLUMNS

Line 470: DELETE FROM FEM_SVIEW_COLUMNS WHERE view_name = l_di_view_name;

466: IF l_di_view_name is NOT NULL THEN
467:
468: BEGIN
469:
470: DELETE FROM FEM_SVIEW_COLUMNS WHERE view_name = l_di_view_name;
471:
472: EXECUTE IMMEDIATE 'DROP VIEW '||l_di_view_name;
473:
474: EXCEPTION

Line 2551: DELETE FROM FEM_SVIEW_COLUMNS WHERE view_name=l_view_name;

2547: AND dtc.table_name = p_tab_name
2548: ORDER BY NVL(ftcv.dimension_id, -1) asc;
2549:
2550:
2551: DELETE FROM FEM_SVIEW_COLUMNS WHERE view_name=l_view_name;
2552:
2553: --First loop through all columns and prepare select list and populate fem_sview_columns
2554: FOR i IN 1..gs_col_name_tab.COUNT LOOP
2555:

Line 2553: --First loop through all columns and prepare select list and populate fem_sview_columns

2549:
2550:
2551: DELETE FROM FEM_SVIEW_COLUMNS WHERE view_name=l_view_name;
2552:
2553: --First loop through all columns and prepare select list and populate fem_sview_columns
2554: FOR i IN 1..gs_col_name_tab.COUNT LOOP
2555:
2556:
2557: l_tmp_string_id := get_view_col_alias(gs_col_name_tab(i),'ID');

Line 2561: insert into fem_sview_columns (view_name,tbl_column_name,dimension_id,disp_code_column, disp_name_column) values(l_view_name,l_tmp_string_id,null,l_tmp_string_id,l_tmp_string_id);

2557: l_tmp_string_id := get_view_col_alias(gs_col_name_tab(i),'ID');
2558:
2559: select_list := select_list || ',' || l_tab_alias || '.' ||gs_col_name_tab(i)||' '|| l_tmp_string_id;
2560:
2561: insert into fem_sview_columns (view_name,tbl_column_name,dimension_id,disp_code_column, disp_name_column) values(l_view_name,l_tmp_string_id,null,l_tmp_string_id,l_tmp_string_id);
2562:
2563: END LOOP;
2564:
2565: --Again loop and update fem_sview_columns..this is to avoid duplicate columns name in View.

Line 2565: --Again loop and update fem_sview_columns..this is to avoid duplicate columns name in View.

2561: insert into fem_sview_columns (view_name,tbl_column_name,dimension_id,disp_code_column, disp_name_column) values(l_view_name,l_tmp_string_id,null,l_tmp_string_id,l_tmp_string_id);
2562:
2563: END LOOP;
2564:
2565: --Again loop and update fem_sview_columns..this is to avoid duplicate columns name in View.
2566:
2567: FOR i IN 1..gs_col_name_tab.COUNT LOOP
2568:
2569: IF gs_dim_id_tab(i) <> -1 OR (gs_col_name_tab(i) NOT IN ('LAST_UPDATED_BY_OBJECT_ID',

Line 2607: UPDATE fem_sview_columns SET dimension_id = gs_dim_id_tab(i), disp_code_column = l_tmp_string_dc, disp_name_column = l_tmp_string_dn

2603:
2604: select_list := select_list || ',' || l_vl_tab_alias || '.' || metadata_rec.member_name_col ||' '||l_tmp_string_dn ;
2605:
2606:
2607: UPDATE fem_sview_columns SET dimension_id = gs_dim_id_tab(i), disp_code_column = l_tmp_string_dc, disp_name_column = l_tmp_string_dn
2608: WHERE view_name = l_view_name
2609: AND tbl_column_name = gs_col_name_tab(i);
2610:
2611:

Line 2617: insert into fem_sview_columns (view_name,tbl_column_name, dimension_id, disp_code_column, disp_name_column)

2613: /*IF check_dim_rec(gs_dim_id_tab(i)) OR (check_mem_dc_rec(metadata_rec.member_display_code_col)) OR (gs_col_name_tab(i) = metadata_rec.member_display_code_col) THEN
2614: select_list := select_list || ',' || l_vl_tab_alias || '.' || metadata_rec.member_display_code_col || ' ' || SUBSTR(gs_col_name_tab(i),1,27) || '_DC';
2615: select_list := select_list || ',' || l_vl_tab_alias || '.' || metadata_rec.member_name_col || ' ' || SUBSTR(gs_col_name_tab(i),1,27) || '_DN';
2616:
2617: insert into fem_sview_columns (view_name,tbl_column_name, dimension_id, disp_code_column, disp_name_column)
2618: values(l_view_name,gs_col_name_tab(i),gs_dim_id_tab(i),
2619: SUBSTR(gs_col_name_tab(i),1,27) || '_DC',SUBSTR(gs_col_name_tab(i),1,27) || '_DN');
2620:
2621: ELSE

Line 2626: insert into fem_sview_columns (view_name,tbl_column_name, dimension_id, disp_code_column, disp_name_column)

2622: select_list := select_list || ',' || l_vl_tab_alias || '.' || metadata_rec.member_display_code_col;
2623: select_list := select_list || ',' || l_vl_tab_alias || '.' || metadata_rec.member_name_col ;
2624:
2625:
2626: insert into fem_sview_columns (view_name,tbl_column_name, dimension_id, disp_code_column, disp_name_column)
2627: values(l_view_name,gs_col_name_tab(i),gs_dim_id_tab(i),
2628: metadata_rec.member_display_code_col,metadata_rec.member_name_col);
2629: END IF;*/
2630: