eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_OWB_COLLECTION_UTIL dependencies on ALL_TABLES

Line 1811: l_stmt:='select owner from all_tables where table_name=:a '||

1807: l_stmt:='select table_owner from user_synonyms where table_name=:a'; --rkumar:bug#4905343
1808: open cv for l_stmt using p_table;
1809: fetch cv into l_owner;
1810: close cv;
1811: l_stmt:='select owner from all_tables where table_name=:a '||
1812: ' and owner=:b'; --rkumar:bug#4905343
1813: open cv for l_stmt using p_table,l_owner;
1814: fetch cv into l_owner;
1815: close cv;

Line 3549: l_stmt:='select last_analyzed from all_tables where table_name=:a and owner=:b';

3545: cv CurTyp;
3546: l_var date;
3547: Begin
3548: if p_owner is not null then
3549: l_stmt:='select last_analyzed from all_tables where table_name=:a and owner=:b';
3550: open cv for l_stmt using p_table,p_owner;
3551: else
3552: l_stmt:='select table_owner from user_synonyms where table_name=:a';
3553: open cv for l_stmt using p_table;

Line 3556: l_stmt:='select last_analyzed from all_tables where table_name=:a and owner=:b';--rkumar:bug#4905343

3552: l_stmt:='select table_owner from user_synonyms where table_name=:a';
3553: open cv for l_stmt using p_table;
3554: fetch cv into l_table_owner;
3555: close cv;
3556: l_stmt:='select last_analyzed from all_tables where table_name=:a and owner=:b';--rkumar:bug#4905343
3557: open cv for l_stmt using p_table, l_table_owner;
3558: end if;
3559: fetch cv into l_var;
3560: close cv; --bug#4905343

Line 3632: 'all_tables where table_name=:a and owner=:b';

3628: cv CurTyp;
3629: Begin
3630: l_stmt:='select tablespace_name,initial_extent,next_extent,pct_free,pct_used,pct_increase,max_extents,'||
3631: 'avg_row_len from '||
3632: 'all_tables where table_name=:a and owner=:b';
3633: if g_debug then
3634: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_table||','||p_owner);
3635: end if;
3636: open cv for l_stmt using p_table,p_owner;

Line 3652: l_stmt:='select next_extent from all_tables where table_name=:a and owner=:b';

3648: l_stmt varchar2(2000);
3649: TYPE CurTyp IS REF CURSOR;
3650: cv CurTyp;
3651: Begin
3652: l_stmt:='select next_extent from all_tables where table_name=:a and owner=:b';
3653: if g_debug then
3654: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_table||','||p_owner);
3655: end if;
3656: open cv for l_stmt using p_table,p_owner;

Line 6093: l_stmt:='select round(nvl(num_rows,0)) from all_tables where table_name=:a and owner=:b';

6089: end if;
6090: if l_owner is null then
6091: l_owner:=get_table_owner(l_table);
6092: end if;
6093: l_stmt:='select round(nvl(num_rows,0)) from all_tables where table_name=:a and owner=:b';
6094: open cv for l_stmt using l_table,l_owner;
6095: fetch cv into l_res;
6096: close cv;
6097: return l_res;

Line 7133: l_stmt:='select last_analyzed from all_tables where table_name=:1 and owner=:2';

7129: l_owner:=p_owner;
7130: if l_owner is null then
7131: l_owner:=get_table_owner(p_table);
7132: end if;
7133: l_stmt:='select last_analyzed from all_tables where table_name=:1 and owner=:2';
7134: if g_debug then
7135: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_table||','||l_owner);
7136: end if;
7137: open cv for l_stmt using p_table,l_owner;

Line 9126: g_stmt:='select table_name from all_tables where (table_name like '''||l_search_string||'_%_'||

9122: else
9123: l_ilog_table_extn:=p_ilog_table_extn;
9124: end if;
9125: l_search_string:=substr(l_ilog_table,1,instr(l_ilog_table,'_'||l_ilog_table_extn)-1);
9126: g_stmt:='select table_name from all_tables where (table_name like '''||l_search_string||'_%_'||
9127: l_ilog_table_extn||''' or table_name like '''||l_search_string||'_%_'||l_ilog_table_extn||'A'') '||
9128: 'and owner='''||p_bis_owner||'''';
9129: if g_debug then
9130: write_to_log_file_n(g_stmt);

Line 10355: 'tab.dim_col,tab.fstg_col,tab.fact_col from '||l_table4||' tab, all_tables all_tab '||

10351: write_to_log_file_n('Created table4 with '||sql%rowcount||' rows '||get_time);
10352: end if;
10353: g_stmt:='create table '||l_table5||' tablespace '||p_op_tablespace||
10354: ' as select all_tab.NUM_ROWS,tab.table_owner,tab.relation_name,tab.relation_id,'||
10355: 'tab.dim_col,tab.fstg_col,tab.fact_col from '||l_table4||' tab, all_tables all_tab '||
10356: 'where all_tab.table_name=tab.relation_name and all_tab.owner=tab.table_owner '||
10357: 'and tab.table_owner is not null '||
10358: 'union all '||
10359: 'select 0,tab.table_owner,tab.relation_name,tab.relation_id,'||

Line 11008: select table_name from all_tables where table_name like p_pattern and owner=p_owner;

11004: p_num_table in out nocopy number
11005: )return boolean is
11006: --
11007: cursor c1(p_pattern varchar2,p_owner varchar2) is
11008: select table_name from all_tables where table_name like p_pattern and owner=p_owner;
11009: --
11010: Begin
11011: if p_num_table is null then
11012: p_num_table:=0;

Line 11015: write_to_log_file_n('select table_name from all_tables where table_name like '||p_pattern||

11011: if p_num_table is null then
11012: p_num_table:=0;
11013: end if;
11014: if g_debug then
11015: write_to_log_file_n('select table_name from all_tables where table_name like '||p_pattern||
11016: ' and owner='||p_owner);
11017: end if;
11018: open c1(p_pattern,p_owner);
11019: loop

Line 11156: select PARTITIONED from all_tables where table_name=p_table and owner=p_owner;

11152:
11153: function is_table_partitioned(p_table varchar2,p_owner varchar2) return varchar2 is
11154: --
11155: cursor c1(p_table varchar2,p_owner varchar2) is
11156: select PARTITIONED from all_tables where table_name=p_table and owner=p_owner;
11157: --
11158: l_res varchar2(40);
11159: Begin
11160: if g_debug then

Line 11161: write_to_log_file_n('select PARTITIONED from all_tables where table_name='||p_table||' and owner='||

11157: --
11158: l_res varchar2(40);
11159: Begin
11160: if g_debug then
11161: write_to_log_file_n('select PARTITIONED from all_tables where table_name='||p_table||' and owner='||
11162: p_owner);
11163: end if;
11164: open c1(p_table,p_owner);
11165: fetch c1 into l_res;

Line 11250: select table_name from all_tables where table_name like p_string and owner=p_owner;

11246:
11247: function drop_tables_like(p_string varchar2,p_owner varchar2)return boolean is
11248: --
11249: cursor c1(p_string varchar2,p_owner varchar2) is
11250: select table_name from all_tables where table_name like p_string and owner=p_owner;
11251: --
11252: l_table varchar2(100);
11253: l_string varchar2(4000);
11254: --

Line 11261: write_to_log_file_n('In drop_tables_like, select table_name from all_tables where '||

11257: if instr(l_string,'.')>0 then
11258: l_string:=substr(l_string,instr(l_string,'.')+1);
11259: end if;
11260: if g_debug then
11261: write_to_log_file_n('In drop_tables_like, select table_name from all_tables where '||
11262: 'table_name like '||l_string||' and owner='||p_owner);
11263: end if;
11264: open c1(l_string,p_owner);
11265: loop