DBA Data[Home] [Help]

APPS.ETRM_PNAV dependencies on DBA_SYNONYMS

Line 1276: FROM SYS.DBA_SYNONYMS

1272: , c_owner in dba_objects.owner%type) is
1273: SELECT TABLE_OWNER
1274: , TABLE_NAME
1275: , DB_LINK
1276: FROM SYS.DBA_SYNONYMS
1277: where OWNER = c_owner
1278: and SYNONYM_NAME = c_name;
1279:
1280: begin

Line 1286: summary="dba_synonyms information">

1282: for t_rec in cur_synonym(c_name=>c_name, c_owner =>c_owner) loop
1283: htp.p(
1284: '

Synonym Details

1285: 1286: summary="dba_synonyms information">
1287:
Base Object: '
1288: ||t_rec.table_owner||'.'||t_rec.table_name);
1289: if t_rec.db_link is null
1290: then null;