APPS.ETRM_RPT dependencies on DBA_TABLES

Line 184: procedure ls_table(c_name dba_tables.table_name%type

180: return v_return_val;
181: end dba_object_info;
182:
183:
184: procedure ls_table(c_name dba_tables.table_name%type
185: , c_owner dba_tab_columns.owner%type) is
186:
187: CURSOR cur_table_dets(c_name in dba_tables.table_name%type
188: , c_owner in dba_objects.owner%type)

Line 187: CURSOR cur_table_dets(c_name in dba_tables.table_name%type

183:
184: procedure ls_table(c_name dba_tables.table_name%type
185: , c_owner dba_tab_columns.owner%type) is
186:
187: CURSOR cur_table_dets(c_name in dba_tables.table_name%type
188: , c_owner in dba_objects.owner%type)
189: -- List table details
190: IS select tab.table_name
191: , tab.tablespace_name

Line 194: from dba_tables tab

190: IS select tab.table_name
191: , tab.tablespace_name
192: , tab.pct_free
193: , tab.pct_used
194: from dba_tables tab
195: where table_name = c_name
196: order by tab.table_name;
197: --
198:

Line 199: CURSOR cur_comment(c_name in dba_tables.table_name%type

195: where table_name = c_name
196: order by tab.table_name;
197: --
198:
199: CURSOR cur_comment(c_name in dba_tables.table_name%type
200: , c_owner in dba_objects.owner%type)
201: is select comments
202: from dba_tab_comments
203: where owner = c_owner