[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_CFLOW_REQUEST_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CASHFLOW_REQUEST_DETAILS_ID |
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. |
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;
XTR.XTR_CFLOW_REQUEST_DETAILS does not reference any database object
XTR.XTR_CFLOW_REQUEST_DETAILS is referenced by following:
|
|
|