DBA Data[Home] [Help]

APPS.ISC_EDW_BACKLOG_SUM1_F_C dependencies on V$DATABASE

Line 78: from v$database;

74: -- Findwarehouse database name
75: -- ----------------------------
76: select name
77: into l_db_name1
78: from v$database;
79:
80:
81: -- --------------------------------------------------------
82: -- Loop the complete set of instances

Line 132: THEN l_stmt := 'SELECT name '||'FROM v$database@'||g_rec(i).db_link;

128: -- ----------------------------
129: -- Check if same instance
130: -- ----------------------------
131: IF g_rec(i).valid
132: THEN l_stmt := 'SELECT name '||'FROM v$database@'||g_rec(i).db_link;
133:
134: EDW_LOG.Debug_Line('');
135: EDW_LOG.Debug_Line(l_stmt);
136: EXECUTE IMMEDIATE l_stmt INTO l_db_name2;