Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.GL_STORAGE_PARAMETERS_V |
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