APPS.AD_ZD dependencies on DBA_DATA_FILES

Line 339: from dba_data_files

335: select df.bytes allocated_bytes,
336: sum(fs.bytes) free_bytes
337: from dba_free_space fs,
338: (select sum(bytes) bytes
339: from dba_data_files
340: where tablespace_name = p_tablespace ) df
341: where fs.tablespace_name = p_tablespace
342: group by df.bytes;
343:

Line 361: from dba_data_files

357: -- check each tablespace for required freespace
358: for i in 1..ts_count loop
359:
360: select count(*) into v_count
361: from dba_data_files
362: where tablespace_name = ts_names(i)
363: and autoextensible = 'yes';
364:
365: if (v_count = 0) then