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

TABLE: APPLSYS.FND_SEQUENCES

Object Details
Object Name: FND_SEQUENCES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_SEQUENCES
Subobject Name:
Status: VALID


FND_SEQUENCES stores information about the registered sequences
in your applications. Each row includes the sequence name and a
description. Each row also includes the information about the
start value, increment by, minimum value, maximum value, cache
size, cycle flag, and order flag. You need one row for each index
column in each application. Oracle Applications uses this
information when installing and upgrading the database.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_SEQUENCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
ColumnSEQUENCE_ID
ColumnZD_EDITION_NAME
FND_SEQUENCES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSEQUENCE_NAME
ColumnAPPLICATION_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier
SEQUENCE_ID NUMBER (15) Yes Sequence identifier
SEQUENCE_NAME VARCHAR2 (30) Yes Sequence name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
START_VALUE NUMBER
Yes Sequence start value
INCREMENT_BY NUMBER (15) Yes Sequence increment by
MIN_VALUE NUMBER
Yes Sequence minimum value
MAX_VALUE NUMBER
Yes Sequence maximum value
CACHE_SIZE NUMBER (15) Yes Sequence cache size
CYCLE_FLAG VARCHAR2 (1) Yes Sequence cycle flag
ORDER_FLAG VARCHAR2 (1) Yes Sequence order by flag
DESCRIPTION VARCHAR2 (240)
Description
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT APPLICATION_ID
,      SEQUENCE_ID
,      SEQUENCE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      START_VALUE
,      INCREMENT_BY
,      MIN_VALUE
,      MAX_VALUE
,      CACHE_SIZE
,      CYCLE_FLAG
,      ORDER_FLAG
,      DESCRIPTION
,      ZD_EDITION_NAME
FROM APPLSYS.FND_SEQUENCES;

Dependencies

[top of page]

APPLSYS.FND_SEQUENCES does not reference any database object

APPLSYS.FND_SEQUENCES is referenced by following:

SchemaAPPLSYS
ViewFND_SEQUENCES#