VIEW: APPS.GL_STORAGE_PARAMETERS_V

Source

View Text - Preformatted

SELECT s.rowid ROW_ID, s.object_name OBJECT_NAME, s.last_update_date LAST_UPDATE_DATE, s.last_updated_by LAST_UPDATED_BY, s.creation_date CREATION_DATE, s.created_by CREATED_BY, s.last_update_login LAST_UPDATE_LOGIN, s.object_type OBJECT_TYPE, l.meaning OBJECT_TYPE_MEANING, s.tablespace_name TABLESPACE_NAME, s.initial_extent_size_kb INITIAL_EXTENT_SIZE_KB, s.next_extent_size_kb NEXT_EXTENT_SIZE_KB, s.max_extents MAX_EXTENTS, s.pct_increase PCT_INCREASE, s.pct_free PCT_FREE, s.description DESCRIPTION FROM GL_STORAGE_PARAMETERS s, GL_LOOKUPS l WHERE l.lookup_type = 'OBJECT_TYPE' AND l.lookup_code = s.object_type

View Text - HTML Formatted

SELECT S.ROWID ROW_ID
, S.OBJECT_NAME OBJECT_NAME
, S.LAST_UPDATE_DATE LAST_UPDATE_DATE
, S.LAST_UPDATED_BY LAST_UPDATED_BY
, S.CREATION_DATE CREATION_DATE
, S.CREATED_BY CREATED_BY
, S.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, S.OBJECT_TYPE OBJECT_TYPE
, L.MEANING OBJECT_TYPE_MEANING
, S.TABLESPACE_NAME TABLESPACE_NAME
, S.INITIAL_EXTENT_SIZE_KB INITIAL_EXTENT_SIZE_KB
, S.NEXT_EXTENT_SIZE_KB NEXT_EXTENT_SIZE_KB
, S.MAX_EXTENTS MAX_EXTENTS
, S.PCT_INCREASE PCT_INCREASE
, S.PCT_FREE PCT_FREE
, S.DESCRIPTION DESCRIPTION
FROM GL_STORAGE_PARAMETERS S
, GL_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'OBJECT_TYPE'
AND L.LOOKUP_CODE = S.OBJECT_TYPE