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: GMO.GMO_DOCUMENT_NUMBERS

Object Details

Object Name:	GMO_DOCUMENT_NUMBERS
Object Type:	TABLE
Owner:	GMO
FND Design Data:	GMO.GMO_DOCUMENT_NUMBERS
Subobject Name:
Status:	VALID

Holds generated document numbers for a given organization and transaction type

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMO_DOCUMENT_NUMBERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_ID
GMO_DOCUMENT_NUMBERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID TRANSACTION_TYPE
GMO_DOCUMENT_NUMBERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
DOC_ID	NUMBER		Yes	The primary key of the table
ORGANIZATION_ID	NUMBER			The organization ID
TRANSACTION_TYPE	VARCHAR2	(240)	Yes	The transaction type
DOC_TYPE	VARCHAR2	(1)	Yes	The document number type
DOC_PREFIX	VARCHAR2	(10)		The document number prefix
DOC_SUFFIX	VARCHAR2	(10)		The document number suffix
DOC_SEPARATOR	VARCHAR2	(1)		The separator symbol
DOC_START	NUMBER			The starting sequence of the document number
DOC_LENGTH	NUMBER			The maximum allowed length of the sequence
DOC_INCREMENT	NUMBER			The value by which sequence is to be incremented each time.
DOC_CURRENTVAL	NUMBER			The current value of the sequence
DOC_ZERO_PAD	VARCHAR2	(1)		Whether zero padding is required
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT DOC_ID
,      ORGANIZATION_ID
,      TRANSACTION_TYPE
,      DOC_TYPE
,      DOC_PREFIX
,      DOC_SUFFIX
,      DOC_SEPARATOR
,      DOC_START
,      DOC_LENGTH
,      DOC_INCREMENT
,      DOC_CURRENTVAL
,      DOC_ZERO_PAD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM GMO.GMO_DOCUMENT_NUMBERS;

Dependencies

[top of page]

GMO.GMO_DOCUMENT_NUMBERS does not reference any database object

GMO.GMO_DOCUMENT_NUMBERS is referenced by following:

APPS: GMO_DOCUMENT_NUMBERS