eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.FND_DOC_SEQUENCE_ASSIGNMENTS

Object Details

Object Name:	FND_DOC_SEQUENCE_ASSIGNMENTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_DOC_SEQUENCE_ASSIGNMENTS
Subobject Name:
Status:	VALID

FND_DOC_SEQUENCE_ASSIGNMENTS stores information about
assignments of document sequences to various documents. Each
row includes a document sequence assignment identifier, a
document sequence identifier, an identifier of the application
owning the document, the identifier of the set of books to which
the document belongs, and the category code. Each row also
includes the period during which the assignment should be valid,
and a flag to indicate whether to use automatic or manual
numbering for the assignment. You need one row for each
assignment. Oracle Application Object Library to number
documents sequentially.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_DOC_SEQUENCE_ASSIGN_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_SEQUENCE_ASSIGNMENT_ID
FND_DOC_SEQUENCE_ASSIGN_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOC_SEQUENCE_ID
FND_DOC_SEQUENCE_ASSIGN_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID CATEGORY_CODE SET_OF_BOOKS_ID METHOD_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
DOC_SEQUENCE_ASSIGNMENT_ID	NUMBER		Yes	Document sequence assignment identifier
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
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
DOC_SEQUENCE_ID	NUMBER		Yes	Document sequence identifier
CATEGORY_CODE	VARCHAR2	(30)	Yes	Category code
START_DATE	DATE		Yes	The date when the assignment becomes active
END_DATE	DATE			The date when the assignment becomes inactive
SET_OF_BOOKS_ID	NUMBER			Set of books identifier
METHOD_CODE	VARCHAR2	(30)		Flag to indicate whether the sequence number should be automatically or manually entered
ATTRIBUTE_CATEGORY_DEVELOPER	VARCHAR2	(30)		Attribute category
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

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


SELECT DOC_SEQUENCE_ASSIGNMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      DOC_SEQUENCE_ID
,      CATEGORY_CODE
,      START_DATE
,      END_DATE
,      SET_OF_BOOKS_ID
,      METHOD_CODE
,      ATTRIBUTE_CATEGORY_DEVELOPER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
FROM APPLSYS.FND_DOC_SEQUENCE_ASSIGNMENTS;

Dependencies

[top of page]

APPLSYS.FND_DOC_SEQUENCE_ASSIGNMENTS does not reference any database object

APPLSYS.FND_DOC_SEQUENCE_ASSIGNMENTS is referenced by following:

APPS: FND_DOC_SEQUENCE_ASSIGNMENTS