eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: XTR.XTR_CFLOW_UPDATED_RECORDS

Object Details

Object Name:	XTR_CFLOW_UPDATED_RECORDS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_CFLOW_UPDATED_RECORDS
Subobject Name:
Status:	VALID

This table is used to store the details regarding the records that were updated by the Update Settlement Accounts program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_CFLOW_UPDATED_RECORDS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CASHFLOW_REQUEST_DETAILS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CASHFLOW_REQUEST_DETAILS_ID	NUMBER	(15)	Yes	Identifier of the Update Settlement Account Concurrent Request
AMOUNT_DATE	DATE			The amount date of the cashflow.
AMOUNT_TYPE	VARCHAR2	(30)		Code that identifies the purpose of the amounts for a Deal Type.
CASHFLOW_AMOUNT	NUMBER			Cashflow Amount.
DEAL_TYPE	VARCHAR2	(7)		Deal Type of the updated Cashflow record.
DEAL_NUMBER	NUMBER			Deal Number of the updated Cashflow Record.
TRANSACTION_NUMBER	NUMBER			Transaction Number of the updated Cashflow Record.
UPDATED_FLAG	VARCHAR2	(1)		Flag to indicate whether this record was updated or not.
MESSAGE_NAME	VARCHAR2	(30)		Message code to indicate why the record was not updated.
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CASHFLOW_REQUEST_DETAILS_ID
,      AMOUNT_DATE
,      AMOUNT_TYPE
,      CASHFLOW_AMOUNT
,      DEAL_TYPE
,      DEAL_NUMBER
,      TRANSACTION_NUMBER
,      UPDATED_FLAG
,      MESSAGE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM XTR.XTR_CFLOW_UPDATED_RECORDS;

Dependencies

[top of page]

XTR.XTR_CFLOW_UPDATED_RECORDS does not reference any database object

XTR.XTR_CFLOW_UPDATED_RECORDS is referenced by following:

APPS: XTR_CFLOW_UPDATED_RECORDS