DBA Data[Home] [Help]

APPS.AD_MORG dependencies on USER_SYNONYMS

Line 81: from user_synonyms s,

77:
78: select 'table exists',t.owner
79: into l_dummy,
80: O_table_owner
81: from user_synonyms s,
82: dba_tables t
83: where s.synonym_name = upper(X_table_name)
84: and t.owner = s.table_owner
85: and t.table_name = s.table_name

Line 403: , user_synonyms us

399:
400: cursor c_column is
401: select distinct column_name, column_id
402: from all_tab_columns tc
403: , user_synonyms us
404: where us.synonym_name = X_table_name
405: and tc.table_name = us.synonym_name
406: and tc.owner = us.table_owner
407: and tc.column_name <> 'ORG_ID'

Line 521: , user_synonyms us

517:
518: cursor c_column is
519: select distinct column_name, column_id
520: from all_tab_columns tc
521: , user_synonyms us
522: where us.synonym_name = X_table_name
523: and tc.table_name = us.synonym_name
524: and tc.owner = us.table_owner
525: and tc.column_name <> 'ORG_ID'