[Home] [Help] [Dependency Information]
Object Name: | CE_LEVELING_MESSAGES |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.CE_LEVELING_MESSAGES |
Subobject Name: | |
Status: | VALID |
This tables stores the errors generated as a result of the cash leveling process as well as the nformation about the deals generated as a result of the cash leveling process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_LEVELING_MESSAGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LEVELING_MESSAGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVELING_MESSAGE_ID | NUMBER | (15) | Yes | System-assigned cash leveling message identifier |
REQUEST_ID | NUMBER | (15) | Yes | Request identifier of the Generate Cash Leveling Fund Transfers concurrent request |
SUB_ACCOUNT_ID | NUMBER | (15) | Yes | Sub account identifier |
CONC_ACCOUNT_ID | NUMBER | (15) | Yes | Concentration bank account identifier |
TRANSFER_AMOUNT | NUMBER | Transfer amount | ||
MESSAGE_NAME | VARCHAR2 | (30) | Error message name | |
MESSAGE_TEXT | VARCHAR2 | (2000) | Error message text | |
DEAL_TYPE | VARCHAR2 | (7) | Deal type | |
DEAL_NO | NUMBER | Deal number | ||
TRX_NUMBER | NUMBER | Transaction number | ||
OFFSET_DEAL_NO | NUMBER | Offsetting deal number | ||
OFFSET_TRX_NUMBER | NUMBER | Offsetting transaction number | ||
SUCCESS_FLAG | VARCHAR2 | (1) | Flag to indicate whether this record represents a successful deal or an error message | |
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 | |
CASHPOOL_ID | NUMBER | (15) | Cash pool identifier |
Cut, paste (and edit) the following text to query this object:
SELECT LEVELING_MESSAGE_ID
, REQUEST_ID
, SUB_ACCOUNT_ID
, CONC_ACCOUNT_ID
, TRANSFER_AMOUNT
, MESSAGE_NAME
, MESSAGE_TEXT
, DEAL_TYPE
, DEAL_NO
, TRX_NUMBER
, OFFSET_DEAL_NO
, OFFSET_TRX_NUMBER
, SUCCESS_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CASHPOOL_ID
FROM CE.CE_LEVELING_MESSAGES;
CE.CE_LEVELING_MESSAGES does not reference any database object
CE.CE_LEVELING_MESSAGES is referenced by following:
|
|
|