DBA Data[Home] [Help]

APPS.FEM_TABLE_REGISTRATION_PKG dependencies on USER_SYNONYMS

Line 2123: FROM user_synonyms

2119: (table_name, owner, db_link)
2120: SELECT table_name,
2121: table_owner,
2122: NULL
2123: FROM user_synonyms
2124: WHERE synonym_name = g_tab_list_tab(k)
2125: UNION
2126: SELECT g_tab_list_tab(k),
2127: g_owner_list_tab(k),

Line 2507: FROM user_synonyms

2503: from_clause := p_tab_name || ' ' || l_tab_alias;
2504:
2505: SELECT table_owner
2506: INTO l_owner
2507: FROM user_synonyms
2508: WHERE synonym_name = p_tab_name;
2509:
2510: l_view_name:=p_view_name;
2511:

Line 2772: FROM user_synonyms

2768: WHERE enabled_flag='Y'
2769: AND di_view_name is null
2770: AND EXISTS(
2771: select 1
2772: FROM user_synonyms
2773: where synonym_name = ftc.table_name);
2774:
2775:
2776: BEGIN