[Home] [Help]
[Dependency Information]
| Object Name: | XTR_FX_ROLL_PRE_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XTR.XTR_FX_ROLL_PRE_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REF_NUMBER | NUMBER | Yes | ||
| COMPANY_CODE | VARCHAR2 | (7) | Yes | |
| CPARTY_CODE | VARCHAR2 | (7) | Yes | |
| DEAL_NO | NUMBER | Yes | ||
| CURRENCY_BUY | VARCHAR2 | (15) | Yes | |
| CURRENCY_SELL | VARCHAR2 | (15) | Yes | |
| BUY_AMOUNT | NUMBER | Yes | ||
| SELL_AMOUNT | NUMBER | Yes | ||
| TRANS_RATE | NUMBER | Yes | ||
| BASE_RATE | NUMBER | Yes | ||
| VALUE_DATE | DATE | Yes | ||
| MULTIPLE_TRANS_YN | VARCHAR2 | (3) | Yes | |
| DEAL_DATE | DATE | Yes | ||
| SETTLED_CURRENT | VARCHAR2 | (1) | Yes | |
| ROLL_PRE | VARCHAR2 | (3) | ||
| ROLL_PRE_ON | DATE | |||
| PREV_DEAL_NO | NUMBER | |||
| PORTFOLIO_CODE | VARCHAR2 | (7) | ||
| CLIENT_CODE | VARCHAR2 | (7) | ||
| DEALER_CODE | VARCHAR2 | (10) | ||
| SETTLEMENT_PARTY | VARCHAR2 | (7) | ||
| SETTLEMENT_PARTY_ACCT | VARCHAR2 | (20) | ||
| COMP_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
| LIMIT_CODE | VARCHAR2 | (7) |
Cut, paste (and edit) the following text to query this object:
SELECT REF_NUMBER
, COMPANY_CODE
, CPARTY_CODE
, DEAL_NO
, CURRENCY_BUY
, CURRENCY_SELL
, BUY_AMOUNT
, SELL_AMOUNT
, TRANS_RATE
, BASE_RATE
, VALUE_DATE
, MULTIPLE_TRANS_YN
, DEAL_DATE
, SETTLED_CURRENT
, ROLL_PRE
, ROLL_PRE_ON
, PREV_DEAL_NO
, PORTFOLIO_CODE
, CLIENT_CODE
, DEALER_CODE
, SETTLEMENT_PARTY
, SETTLEMENT_PARTY_ACCT
, COMP_SETTLEMENT_ACCT
, LIMIT_CODE
FROM APPS.XTR_FX_ROLL_PRE_DETAILS_V;
APPS
XTR_FX_ROLL_PRE_DETAILS
APPS.XTR_FX_ROLL_PRE_DETAILS_V is not referenced by any database object
|
|
|
|