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

TABLE: FUN.FUN_SEQ_VERSIONS

Object Details
Object Name: FUN_SEQ_VERSIONS
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_SEQ_VERSIONS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_SEQ_VERSIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEQ_VERSION_ID
FUN_SEQ_VERSIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEQ_HEADER_ID
ColumnVERSION_NAME
FUN_SEQ_VERSIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_NAME
FUN_SEQ_VERSIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVERSION_NAME
Columns
Name Datatype Length Mandatory Comments
SEQ_VERSION_ID NUMBER
Yes
SEQ_HEADER_ID NUMBER
Yes
VERSION_NAME VARCHAR2 (120) Yes
HEADER_NAME VARCHAR2 (120) Yes
INITIAL_VALUE NUMBER
Yes
START_DATE DATE
Yes
END_DATE DATE

CURRENT_VALUE NUMBER

USE_STATUS_CODE VARCHAR2 (30) Yes
DB_SEQUENCE_NAME VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER
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)
Query Text

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


SELECT SEQ_VERSION_ID
,      SEQ_HEADER_ID
,      VERSION_NAME
,      HEADER_NAME
,      INITIAL_VALUE
,      START_DATE
,      END_DATE
,      CURRENT_VALUE
,      USE_STATUS_CODE
,      DB_SEQUENCE_NAME
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM FUN.FUN_SEQ_VERSIONS;

Dependencies

[top of page]

FUN.FUN_SEQ_VERSIONS does not reference any database object

FUN.FUN_SEQ_VERSIONS is referenced by following:

SchemaAPPS
SynonymFUN_SEQ_VERSIONS