[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_TX_XE_COPIES |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_TX_XE_COPIES |
Subobject Name: | |
Status: | VALID |
IBY_FNDCPT_TX_XE_COPIES stores the copy relationship between transaction extension entities. This relationship is many-to-many, since during copy transaction extension, entities may be merged or split.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_FNDCPT_TX_XE_COPIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_TRXN_EXTENSION_ID |
IBY_FNDCPT_TX_XE_COPIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COPY_TRXN_EXTENSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_TRXN_EXTENSION_ID | NUMBER | (15) | Yes | Source of the transaction extension |
COPY_TRXN_EXTENSION_ID | NUMBER | (15) | Yes | Copy transaction extension |
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_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_TRXN_EXTENSION_ID
, COPY_TRXN_EXTENSION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_FNDCPT_TX_XE_COPIES;
IBY.IBY_FNDCPT_TX_XE_COPIES does not reference any database object
IBY.IBY_FNDCPT_TX_XE_COPIES is referenced by following:
|
|
|