DBA Data[Home] [Help]

APPS.FEM_INTF_DIM_VALIDATION_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 47: vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,

43: TYPE xdim_info_rec IS RECORD
44: (
45: int_disp_code_col FEM_INT_COLUMN_MAP.interface_column_name%TYPE,
46: vs_required_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE,
47: vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,
48: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
49: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
50: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
51: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,

Line 1310: fem_global_vs_combo_defs gv

1306: BULK COLLECT INTO pv_xdim_info_tbl
1307: FROM fem_tab_columns_v tc,
1308: fem_int_column_map cm,
1309: fem_xdim_dimensions xd,
1310: fem_global_vs_combo_defs gv
1311: WHERE tc.table_name = pv_table_name
1312: AND tc.fem_data_type_code = 'DIMENSION'
1313: AND tc.column_name NOT IN
1314: ('CREATED_BY_OBJECT_ID','LAST_UPDATED_BY_OBJECT_ID',