[Home] [Help] [Dependency Information]
Object Name: | IBY_TRXN_DOCUMENTS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_TRXN_DOCUMENTS |
Subobject Name: | |
Status: | VALID |
Table used to store XML documents associated with a particular transaction.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_TRXN_DOCUMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRXN_DOCUMENT_ID |
IBY_TRXN_DOCUMENTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRXNMID
DOCTYPE |
SYS_IL0000195185C00003$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
IBY_TRXN_DOCUMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYMENT_INSTRUCTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRXNMID | NUMBER | Column is a foreign key into table IBY_TRXN_SUMMARIES_ALL . Indicates which transaction | ||
DOCTYPE | NUMBER | Yes | Column holds an application defined number indicating what type of document this is. | |
DOCUMENT | CLOB | (4000) | Column holds the actual XML document. | |
FROZEN_FLAG | VARCHAR2 | (1) | Oracle Internal use only - reserved for future use | |
TO_BE_PURGED_FLAG | VARCHAR2 | (1) | Oracle Internal use only - reserved for future use | |
OBJECT_VERSION_NUMBER | NUMBER | (5) | This column is used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
TRXN_DOCUMENT_ID | NUMBER | Yes | System generated Primary Key | |
REQUEST_ID | NUMBER | (15) | Request Identifier | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Application Identifier of last concurrent program to update record | |
PROGRAM_ID | NUMBER | (15) | Identifier of last concurrent program to update record | |
PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
DOCUMENT_PURGED_FLAG | VARCHAR2 | (1) | Oracle Internal use only - reserved for future use | |
DOCUMENT_PURGED_DATE | DATE | Oracle Internal use only - reserved for future use | ||
PAYMENT_INSTRUCTION_ID | NUMBER | Payment instruction for the transaction |
Cut, paste (and edit) the following text to query this object:
SELECT TRXNMID
, DOCTYPE
, DOCUMENT
, FROZEN_FLAG
, TO_BE_PURGED_FLAG
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, TRXN_DOCUMENT_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DOCUMENT_PURGED_FLAG
, DOCUMENT_PURGED_DATE
, PAYMENT_INSTRUCTION_ID
FROM IBY.IBY_TRXN_DOCUMENTS;
IBY.IBY_TRXN_DOCUMENTS does not reference any database object
IBY.IBY_TRXN_DOCUMENTS is referenced by following:
|
|
|