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

TABLE: CE.CE_ZBA_DEAL_MESSAGES

Object Details
Object Name: CE_ZBA_DEAL_MESSAGES
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_ZBA_DEAL_MESSAGES
Subobject Name:
Status: VALID


This table stores the error or warning messages from deal creation process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

CE.CE_ZBA_DEAL_MESSAGES does not reference any database object

CE.CE_ZBA_DEAL_MESSAGES is referenced by following:

SchemaAPPS
SynonymCE_ZBA_DEAL_MESSAGES