[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_V is not referenced by any database object
|
|
|