DBA Data[Home] [Help]

APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_TAB_COLUMN_PROP

Line 1311: FROM fem_tab_column_prop tcp

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
1311: FROM fem_tab_column_prop tcp
1312: WHERE tcp.table_name = tc.table_name
1313: AND tcp.column_property_code IN
1314: ('MAPPING_UI_INPUT', 'PROCESSING_KEY'))
1315: AND tc.column_name <> 'LEDGER_ID';

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