[Home] [Help] [Dependency Information]
Object Name: | AX_DOCUMENT_STATUSES |
---|---|
Object Type: | TABLE |
Owner: | AX |
FND Design Data: | AX.AX_DOCUMENT_STATUSES |
Subobject Name: | |
Status: | VALID |
This table stores information about the status of documents.
It contains a row for every relevant document not having status
information stored on its base table.
Each row contains the type, the identifier and the status of the
document.
The status is stored in the reference columns according to the type of
document. By convention, REFERENCE19 and REFERENCE20 always contain
the DOC_SEQUENCE_ID and DOC_SEQUENCE_VALUE of the
document.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AX_DOCUMENT_STATUSES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
SET_OF_BOOKS_ID DOCUMENT_CODE DOCUMENT_ID1 DOCUMENT_ID2 DOCUMENT_ID3 DOCUMENT_ID4 DOCUMENT_ID5 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identifier |
DOCUMENT_CODE | VARCHAR2 | (30) | Yes | Document code |
DOCUMENT_ID1 | VARCHAR2 | (100) | Yes | ID of the document |
DOCUMENT_ID2 | VARCHAR2 | (100) | Yes | ID of the document |
DOCUMENT_ID3 | VARCHAR2 | (100) | Yes | ID of the document |
DOCUMENT_ID4 | VARCHAR2 | (100) | Yes | ID of the document |
DOCUMENT_ID5 | VARCHAR2 | (100) | Yes | ID of the document |
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 | |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
REFERENCE1 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE2 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE3 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE4 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE5 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE6 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE7 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE8 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE9 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE10 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE11 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE12 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE13 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE14 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE15 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE16 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE17 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE18 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE20 | VARCHAR2 | (255) | Status variable of the document | |
REFERENCE19 | VARCHAR2 | (255) | Status variable of the document | |
ORG_ID | NUMBER | Organization identifier | ||
REFERENCE_NUM1 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM2 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM3 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM4 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM5 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM6 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM7 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM8 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM9 | NUMBER | Numeric status variable of the document | ||
REFERENCE_NUM10 | NUMBER | Numeric status variable of the document | ||
REFERENCE_DATE1 | DATE | Date status variable of the document | ||
REFERENCE_DATE2 | DATE | Date status variable of the document | ||
REFERENCE_DATE3 | DATE | Date status variable of the document | ||
REFERENCE_DATE4 | DATE | Date status variable of the document | ||
REFERENCE_DATE5 | DATE | Date status variable of the document | ||
REFERENCE_DATE6 | DATE | Date status variable of the document | ||
REFERENCE_DATE7 | DATE | Date status variable of the document | ||
REFERENCE_DATE8 | DATE | Date status variable of the document | ||
REFERENCE_DATE9 | DATE | Date status variable of the document | ||
REFERENCE_DATE10 | DATE | Date status variable of the document |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, SET_OF_BOOKS_ID
, DOCUMENT_CODE
, DOCUMENT_ID1
, DOCUMENT_ID2
, DOCUMENT_ID3
, DOCUMENT_ID4
, DOCUMENT_ID5
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, REFERENCE11
, REFERENCE12
, REFERENCE13
, REFERENCE14
, REFERENCE15
, REFERENCE16
, REFERENCE17
, REFERENCE18
, REFERENCE20
, REFERENCE19
, ORG_ID
, REFERENCE_NUM1
, REFERENCE_NUM2
, REFERENCE_NUM3
, REFERENCE_NUM4
, REFERENCE_NUM5
, REFERENCE_NUM6
, REFERENCE_NUM7
, REFERENCE_NUM8
, REFERENCE_NUM9
, REFERENCE_NUM10
, REFERENCE_DATE1
, REFERENCE_DATE2
, REFERENCE_DATE3
, REFERENCE_DATE4
, REFERENCE_DATE5
, REFERENCE_DATE6
, REFERENCE_DATE7
, REFERENCE_DATE8
, REFERENCE_DATE9
, REFERENCE_DATE10
FROM AX.AX_DOCUMENT_STATUSES;
AX.AX_DOCUMENT_STATUSES does not reference any database object
AX.AX_DOCUMENT_STATUSES is referenced by following:
|
|
|