DBA Data[Home] [Help] [Dependency Information]

VIEW: APPLSYS.FND_TABLES#

Object Details
Object Name: FND_TABLES#
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes
TABLE_ID NUMBER (15) Yes
TABLE_NAME VARCHAR2 (30) Yes
USER_TABLE_NAME VARCHAR2 (80) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
AUTO_SIZE VARCHAR2 (1) Yes
TABLE_TYPE VARCHAR2 (1) Yes
INITIAL_EXTENT NUMBER (15) Yes
NEXT_EXTENT NUMBER (15) Yes
MIN_EXTENTS NUMBER (15) Yes
MAX_EXTENTS NUMBER (15) Yes
PCT_INCREASE NUMBER (15) Yes
INI_TRANS NUMBER (15) Yes
MAX_TRANS NUMBER (15) Yes
PCT_FREE NUMBER (15) Yes
PCT_USED NUMBER (15) Yes
DESCRIPTION VARCHAR2 (240)
HOSTED_SUPPORT_STYLE VARCHAR2 (30) Yes
IREP_COMMENTS VARCHAR2 (4000)
IREP_ANNOTATIONS VARCHAR2 (4000)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      TABLE_ID
,      TABLE_NAME
,      USER_TABLE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AUTO_SIZE
,      TABLE_TYPE
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENTS
,      MAX_EXTENTS
,      PCT_INCREASE
,      INI_TRANS
,      MAX_TRANS
,      PCT_FREE
,      PCT_USED
,      DESCRIPTION
,      HOSTED_SUPPORT_STYLE
,      IREP_COMMENTS
,      IREP_ANNOTATIONS
,      ZD_EDITION_NAME
FROM APPLSYS.FND_TABLES#;

Dependencies

[top of page]

APPLSYS.FND_TABLES# references the following:

SchemaAPPLSYS
TableFND_TABLES
APPLSYS.FND_TABLES# is referenced by following:

SchemaAPPS
SynonymFND_TABLES
TriggerFND_TABLES+