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

TABLE: IBY.IBY_TRXN_DOCUMENTS

Object Details
Object Name: IBY_TRXN_DOCUMENTS
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_TRXN_DOCUMENTS
Subobject Name:
Status: VALID


Table used to store XML documents associated with a particular transaction.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_TRXN_DOCUMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRXN_DOCUMENT_ID
IBY_TRXN_DOCUMENTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRXNMID
ColumnDOCTYPE
SYS_IL0000195185C00003$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
IBY_TRXN_DOCUMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_INSTRUCTION_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

IBY.IBY_TRXN_DOCUMENTS does not reference any database object

IBY.IBY_TRXN_DOCUMENTS is referenced by following:

SchemaIBY
ViewIBY_TRXN_DOCUMENTS#