[Home] [Help] [Dependency Information]
Object Name: | CE_ZBA_DEAL_MESSAGES |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.CE_ZBA_DEAL_MESSAGES |
Subobject Name: | |
Status: | VALID |
This table stores the error or warning messages from deal creation process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATEMENT_LINE_ID | NUMBER | (15) | Statement line identifier | |
MESSAGE_NAME | VARCHAR2 | (255) | Message name | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Appliction short name, CE | |
STATEMENT_HEADER_ID | NUMBER | (15) | Yes | Statement header identifier |
DEAL_TYPE | VARCHAR2 | (15) | Deal type | |
DEAL_NUM | NUMBER | Deal number | ||
TRANSACTION_NUM | NUMBER | Transaction number | ||
OFFSET_DEAL_NUM | NUMBER | Offsetting deal number | ||
OFFSET_TRANSACTION_NUM | NUMBER | Offsetting transaction number | ||
DEAL_STATUS_FLAG | VARCHAR2 | (1) | Deal creation status flag | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
CASHPOOL_ID | NUMBER | (15) | Cash pool identifier | |
CASHFLOWS_CREATED_FLAG | VARCHAR2 | (1) | Flag to indicate whether cash flows have been created or not |
Cut, paste (and edit) the following text to query this object:
SELECT STATEMENT_LINE_ID
, MESSAGE_NAME
, CREATION_DATE
, CREATED_BY
, APPLICATION_SHORT_NAME
, STATEMENT_HEADER_ID
, DEAL_TYPE
, DEAL_NUM
, TRANSACTION_NUM
, OFFSET_DEAL_NUM
, OFFSET_TRANSACTION_NUM
, DEAL_STATUS_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CASHPOOL_ID
, CASHFLOWS_CREATED_FLAG
FROM CE.CE_ZBA_DEAL_MESSAGES;
CE.CE_ZBA_DEAL_MESSAGES does not reference any database object
CE.CE_ZBA_DEAL_MESSAGES is referenced by following:
|
|
|