DBA Data[Home] [Help]

APPS.FND_XDF_UTIL_PKG dependencies on ALL_TABLES

Line 31: FROM ALL_TABLES WHERE TABLE_NAME=p_tablename AND OWNER=p_owner;

27: NVL(PARTITIONED, 'NO') || NVL(FREELISTS, 0) ||
28: NVL(FREELIST_GROUPS, 0) ||
29: NVL(DECODE(LTRIM(DEGREE), 'DEFAULT', 65536, DEGREE) , 0) ||
30: LOGGING|| CACHE|| IOT_TYPE || ROW_MOVEMENT into tmp_str
31: FROM ALL_TABLES WHERE TABLE_NAME=p_tablename AND OWNER=p_owner;
32:
33: for x in ( select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE,
34: DATA_PRECISION, DATA_SCALE, DATA_DEFAULT from all_tab_columns where
35: table_name =p_tablename and owner = p_owner order by column_name)