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_REQUEST_DETAILS

Object Details

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

This table is used to store the concurrent request details so that the user can run an execution report to see what data was affected by the Update Settlement Accounts concurrent program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_CFLOW_REQUEST_DETAILS_U1	NORMAL	UNIQUE	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.
REQUEST_ID	NUMBER	(15)	Yes	Request ID of the Concurrent program that created this row.
PARTY_CODE	VARCHAR2	(7)	Yes	Party Code parameter from the Concurrent Request.
ACCOUNT_NO_FROM	VARCHAR2	(20)	Yes	Current Bank Account parameter from the request.
ACCOUNT_NO_TO	VARCHAR2	(20)	Yes	New Bank Account parameter from the request.
DEAL_TYPE	VARCHAR2	(7)		Deal Type parameter from the request.
DEAL_NUMBER_FROM	NUMBER			Deal Number From parameter from the request.
DEAL_NUMBER_TO	NUMBER			Deal Number To parameter from the request.
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.
STARTING_CFLOW_DATE	DATE		Yes	Starting Cash Flow Date parameter from the concurrent request.
ENDING_CFLOW_DATE	DATE		Yes	Ending Cash Flow Date parameter from the
INCLUDE_JOURNALIZED_FLAG	VARCHAR2	(1)	Yes	Include Journalized Flag parameter from the concurrent request.

Query Text

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


SELECT CASHFLOW_REQUEST_DETAILS_ID
,      REQUEST_ID
,      PARTY_CODE
,      ACCOUNT_NO_FROM
,      ACCOUNT_NO_TO
,      DEAL_TYPE
,      DEAL_NUMBER_FROM
,      DEAL_NUMBER_TO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STARTING_CFLOW_DATE
,      ENDING_CFLOW_DATE
,      INCLUDE_JOURNALIZED_FLAG
FROM XTR.XTR_CFLOW_REQUEST_DETAILS;

Dependencies

[top of page]

XTR.XTR_CFLOW_REQUEST_DETAILS does not reference any database object

XTR.XTR_CFLOW_REQUEST_DETAILS is referenced by following:

APPS: XTR_CFLOW_REQUEST_DETAILS