[Home] [Help] [Dependency Information]
Object Name: | XTR_DISC_CASHFLOWS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_DISC_CASHFLOWS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The XTR_DISC_CASHFLOWS _V view is used for the Discoverer report and is based on the XTR_CASHFLOWS_V view. User access to company information is enforced in the XTR_DISC_CASHFLOWS _V view. Please refer to the full description of XTR_CASHFLOWS_V for more details.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEAL_NUMBER | NUMBER | Unique number assigned to each deal | ||
DDA_DEAL_TYPE | VARCHAR2 | (7) | Refer to base table. | |
DDA_DEAL_SUBTYPE | VARCHAR2 | (7) | Refer to base table. | |
TRANSACTION_RATE | NUMBER | Refer to base table. | ||
STATUS_CODE | VARCHAR2 | (10) | Refer to base table. | |
CURRENCY_CODE | VARCHAR2 | (15) | Refer to base table. | |
TRX_DATE | DATE | Refer to base table. | ||
AMOUNT | NUMBER | Refer to base table. | ||
COMPANY_CODE | VARCHAR2 | (7) | Refer to base table. | |
COMPANY_ACCOUNT | VARCHAR2 | (20) | Refer to base table. | |
BANK_CODE | VARCHAR2 | (7) | Refer to base table. | |
PRODUCT_TYPE | VARCHAR2 | (10) | Refer to base table. | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Refer to base table. | |
CPARTY_CODE | VARCHAR2 | (7) | Refer to base table. | |
CLIENT_CODE | VARCHAR2 | (7) | Refer to base table. | |
DEAL_TYPE | VARCHAR2 | (7) | Refer to base table. | |
CATEGORY | VARCHAR2 | (2) | Refer to base table. | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Refer to base table. | |
TYPE_OF_AMOUNT | VARCHAR2 | (240) | Refer to base table. | |
AMOUNT_TYPE | VARCHAR2 | (7) | Refer to base table. | |
TRANSACTION_NUMBER | NUMBER | Refer to base table. | ||
DEALER | VARCHAR2 | (10) | Refer to base table. | |
SETTLE | VARCHAR2 | (1) | Refer to base table. | |
CONTRACT_TYPE | VARCHAR2 | (7) | Refer to base table. | |
MULTIPLE_SETTLEMENTS | VARCHAR2 | (1) | Refer to base table. | |
DEAL_TYPE_NAME | VARCHAR2 | (80) | Refer to base table. | |
DEAL_SUBTYPE_NAME | VARCHAR2 | (80) | Refer to base table. | |
COMPANY_FULL_NAME | VARCHAR2 | (50) | Refer to base table. | |
CPARTY_FULL_NAME | VARCHAR2 | (50) | Refer to base table. | |
BANK_NAME | VARCHAR2 | (50) | Refer to base table. | |
AMOUNT_TYPE_NAME | VARCHAR2 | (80) | Refer to base table. |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NUMBER
, DDA_DEAL_TYPE
, DDA_DEAL_SUBTYPE
, TRANSACTION_RATE
, STATUS_CODE
, CURRENCY_CODE
, TRX_DATE
, AMOUNT
, COMPANY_CODE
, COMPANY_ACCOUNT
, BANK_CODE
, PRODUCT_TYPE
, PORTFOLIO_CODE
, CPARTY_CODE
, CLIENT_CODE
, DEAL_TYPE
, CATEGORY
, DEAL_SUBTYPE
, TYPE_OF_AMOUNT
, AMOUNT_TYPE
, TRANSACTION_NUMBER
, DEALER
, SETTLE
, CONTRACT_TYPE
, MULTIPLE_SETTLEMENTS
, DEAL_TYPE_NAME
, DEAL_SUBTYPE_NAME
, COMPANY_FULL_NAME
, CPARTY_FULL_NAME
, BANK_NAME
, AMOUNT_TYPE_NAME
FROM APPS.XTR_DISC_CASHFLOWS_V;
APPS.XTR_DISC_CASHFLOWS_V is not referenced by any database object
|
|
|