APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_TAB_COLUMNS_V

Line 1306: FROM fem_tab_columns_v tc

1302: SELECT p_preview_obj_def_id, p_preview_row_group, tc.column_name,
1303: substr('FEM'||rownum||'_'||p_request_id, 1, 30),
1304: p_request_id, p_preview_obj_id,
1305: p_request_id, p_preview_obj_id
1306: FROM fem_tab_columns_v tc
1307: WHERE tc.table_name = p_fact_table_name
1308: AND tc.fem_data_type_code = 'DIMENSION'
1309: AND tc.column_name IN
1310: (SELECT tcp.column_name

Line 2036: FROM fem_tab_column_prop o, fem_tab_columns_v m

2032:
2033: CURSOR c_match_cols (cv_fact_table VARCHAR2, cv_match_fact_table VARCHAR2,
2034: cv_map_obj_def_id NUMBER, cv_function_cd VARCHAR) IS
2035: SELECT o.column_name output_col, m.column_name match_col
2036: FROM fem_tab_column_prop o, fem_tab_columns_v m
2037: WHERE o.table_name = cv_fact_table
2038: AND o.column_property_code = 'PROCESSING_KEY'
2039: AND m.table_name = cv_match_fact_table
2040: AND o.column_name = m.column_name

Line 2792: FROM fem_alloc_preview_maps pm, fem_tab_columns_v tc,

2788: cv_global_vs_combo_id NUMBER) IS
2789: SELECT pm.dim_member_column_name, pm.dim_name_column_name,
2790: xd.member_name_col, xd.member_vl_object_name, xd.member_col,
2791: gv.value_set_id
2792: FROM fem_alloc_preview_maps pm, fem_tab_columns_v tc,
2793: fem_xdim_dimensions xd, fem_global_vs_combo_defs gv
2794: WHERE pm.preview_obj_def_id = cv_preview_obj_def_id
2795: AND pm.preview_row_group = cv_preview_row_group
2796: AND pm.dim_member_column_name = tc.column_name