DBA Data[Home] [Help]

APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 2793: fem_xdim_dimensions xd, fem_global_vs_combo_defs gv

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
2797: AND tc.table_name = cv_fact_table

Line 2908: -- FEM_ALLOC_BR_DIMENSIONS, FEM_TAB_COLUMNS_B, and FEM_XDIM_DIMENSIONS

2904: -- set all parameters to NULL.
2905: --
2906: -- If mapping rule type is By Dimension and preview group is Source,
2907: -- then get the parameter values from these tables:
2908: -- FEM_ALLOC_BR_DIMENSIONS, FEM_TAB_COLUMNS_B, and FEM_XDIM_DIMENSIONS
2909: --
2910: -------------------------------------------------------------------------------
2911: PROCEDURE GetByDimParams(
2912: p_preview_obj_def_id IN NUMBER,

Line 2946: fem_xdim_dimensions xd

2942: decode(xd.member_data_type_code,'NUMBER',abd.dimension_value,
2943: abd.dimension_value_char)
2944: INTO x_by_dimension_column, x_by_dimension_id, x_by_dimension_value
2945: FROM fem_alloc_br_dimensions abd, fem_tab_columns_b tc,
2946: fem_xdim_dimensions xd
2947: WHERE abd.object_definition_id = p_map_obj_def_id
2948: AND abd.function_cd = C_BYDIM_FUNCIONCD
2949: AND tc.table_name = p_fact_table_name
2950: AND abd.alloc_dim_col_name = tc.column_name