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

TABLE: APPLSYS.FND_DOC_SEQUENCE_USERS

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


FND_DOC_SEQUENCE_USERS stores information about user assigned
document sequence number. Each row includes the document sequence
identifier, the document sequence assignment identifier, the ORACLE
username, and the next value for the document sequence. You need
one row for each document sequence that allows users to assign
numbers to their application documents. Oracle Application Object
Library uses this information to implement user assigned document
sequences.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_DOC_SEQUENCE_USERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_SEQUENCE_ID
ColumnDOC_SEQUENCE_ASSIGNMENT_ID
ColumnUSER_ID
Columns
Name Datatype Length Mandatory Comments
DOC_SEQUENCE_ID NUMBER
Yes Document sequence identifier
DOC_SEQUENCE_ASSIGNMENT_ID NUMBER
Yes Document sequence assignment identifier
USER_ID NUMBER
Yes ORACLE username
NEXTVAL NUMBER
Yes Next valid value
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
GL_DATE DATE

General ledger date
Query Text

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


SELECT DOC_SEQUENCE_ID
,      DOC_SEQUENCE_ASSIGNMENT_ID
,      USER_ID
,      NEXTVAL
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      GL_DATE
FROM APPLSYS.FND_DOC_SEQUENCE_USERS;

Dependencies

[top of page]

APPLSYS.FND_DOC_SEQUENCE_USERS does not reference any database object

APPLSYS.FND_DOC_SEQUENCE_USERS is referenced by following:

SchemaAPPS
SynonymFND_DOC_SEQUENCE_USERS