DBA Data[Home] [Help]

APPS.PO_LOG dependencies on ALL_SYNONYMS

Line 1135: -- Use all_synonyms to find the base table / view.

1131: -- and needs to be reworked a bit.
1132: --
1133: -- Ideas for refactoring:
1134: -- Get the current schema via SYS_CONTEXT('USERENV','CURRENT_SCHEMA').
1135: -- Use all_synonyms to find the base table / view.
1136: -- (maybe just use user_synonyms, if login is always APPS, regardless of current_schema)
1137: -- Use all_tab_columns to get column names.
1138: --
1139:

Line 1173: ALL_SYNONYMS syn

1169: l_column_name_tbl
1170: , l_data_type_tbl
1171: FROM
1172: ALL_TAB_COLUMNS tab,
1173: ALL_SYNONYMS syn
1174: WHERE tab.TABLE_NAME = syn.table_name
1175: AND tab.owner=syn.owner
1176: AND tab.owner = l_table_owner
1177: AND syn.synonym_name= l_table_name