DBA Data[Home] [Help]

APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_TAB_INFO_GT

Line 2112: DELETE fem_tab_info_gt;

2108:
2109:
2110: IF g_tab_list_tab.EXISTS(1) AND NOT l_db_link AND NOT l_union_flag THEN
2111:
2112: DELETE fem_tab_info_gt;
2113:
2114: DELETE fem_tab_indx_info_gt;
2115:
2116:

Line 2118: INSERT INTO fem_tab_info_gt

2114: DELETE fem_tab_indx_info_gt;
2115:
2116:
2117: FORALL k IN 1..g_tab_list_tab.COUNT
2118: INSERT INTO fem_tab_info_gt
2119: (table_name, owner, db_link)
2120: SELECT table_name,
2121: table_owner,
2122: NULL

Line 2140: fem_tab_info_gt ftig

2136: aic.column_position
2137: FROM all_ind_columns aic,
2138: all_indexes ai,
2139: all_updatable_columns uuc,
2140: fem_tab_info_gt ftig
2141: WHERE ai.index_name = aic.index_name
2142: AND ai.table_name = aic.table_name
2143: AND ai.uniqueness = 'UNIQUE'
2144: AND ai.index_type = 'NORMAL'