[Home] [Help] [Dependency Information]
Object Name: | XTR_REVALUATION_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_REVALUATION_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 |
---|---|---|---|---|
ACTION_CODE | VARCHAR2 | (7) | ||
COMPANY_CODE | VARCHAR2 | (7) | ||
CONTRACT_CODE | VARCHAR2 | (30) | ||
CURRENCYA | VARCHAR2 | (15) | ||
CURRENCYB | VARCHAR2 | (15) | ||
REF_NUMBER | VARCHAR2 | (40) | ||
DEAL_SUBTYPE | VARCHAR2 | (30) | ||
DEAL_TYPE | VARCHAR2 | (7) | ||
EFFECTIVE_DATE | DATE | |||
EFFECTIVE_DAYS | NUMBER | |||
ENTERED_BY | VARCHAR2 | (30) | ||
ENTERED_ON | DATE | |||
FACE_VALUE | NUMBER | |||
FXO_SELL_REF_AMOUNT | NUMBER | |||
PERIOD_FROM | DATE | |||
PERIOD_TO | DATE | |||
PORTFOLIO_CODE | VARCHAR2 | (30) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | ||
REALISED_PL | NUMBER | |||
REVAL_CCY | VARCHAR2 | (15) | ||
REVAL_RATE | NUMBER | |||
TRANSACTION_NO | NUMBER | |||
TRANSACTION_PERIOD | NUMBER | |||
TRANSACTION_RATE | NUMBER | |||
UNREALISED_PL | NUMBER | |||
UPDATED_BY | VARCHAR2 | (30) | ||
UPDATED_ON | DATE | |||
YEAR_BASIS | NUMBER | |||
CREATED_BY | VARCHAR2 | (30) | ||
CREATED_ON | DATE | |||
REVALUATION_DETAILS_ID | NUMBER | |||
BATCH_ID | NUMBER | (15) | ||
COMPLETE_FLAG | VARCHAR2 | (1) | ||
OVERWRITE_TYPE | VARCHAR2 | (30) | ||
OVERWRITE_VALUE | NUMBER | |||
OVERWRITE_REASON | VARCHAR2 | (240) | ||
FAIR_VALUE | NUMBER | |||
REALIZED_FLAG | VARCHAR2 | (1) | ||
CUMM_GAIN_LOSS_AMOUNT | NUMBER | |||
CURR_GAIN_LOSS_AMOUNT | NUMBER | |||
SOB_FV_GAIN_LOSS_AMOUNT | NUMBER | |||
SOB_FAIR_VALUE_AMOUNT | NUMBER | |||
REVAL_CURR_FV_AMOUNT | NUMBER | |||
CTR_CURR_SOB_CURR_FWD_RATE | NUMBER | |||
EXCHANGE_RATE_ONE | NUMBER | |||
EXCHANGE_RATE_TWO | NUMBER | |||
AMOUNT_TYPE | VARCHAR2 | (7) | ||
QUANTITY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_CODE
, COMPANY_CODE
, CONTRACT_CODE
, CURRENCYA
, CURRENCYB
, REF_NUMBER
, DEAL_SUBTYPE
, DEAL_TYPE
, EFFECTIVE_DATE
, EFFECTIVE_DAYS
, ENTERED_BY
, ENTERED_ON
, FACE_VALUE
, FXO_SELL_REF_AMOUNT
, PERIOD_FROM
, PERIOD_TO
, PORTFOLIO_CODE
, PRODUCT_TYPE
, REALISED_PL
, REVAL_CCY
, REVAL_RATE
, TRANSACTION_NO
, TRANSACTION_PERIOD
, TRANSACTION_RATE
, UNREALISED_PL
, UPDATED_BY
, UPDATED_ON
, YEAR_BASIS
, CREATED_BY
, CREATED_ON
, REVALUATION_DETAILS_ID
, BATCH_ID
, COMPLETE_FLAG
, OVERWRITE_TYPE
, OVERWRITE_VALUE
, OVERWRITE_REASON
, FAIR_VALUE
, REALIZED_FLAG
, CUMM_GAIN_LOSS_AMOUNT
, CURR_GAIN_LOSS_AMOUNT
, SOB_FV_GAIN_LOSS_AMOUNT
, SOB_FAIR_VALUE_AMOUNT
, REVAL_CURR_FV_AMOUNT
, CTR_CURR_SOB_CURR_FWD_RATE
, EXCHANGE_RATE_ONE
, EXCHANGE_RATE_TWO
, AMOUNT_TYPE
, QUANTITY
FROM APPS.XTR_REVALUATION_DETAILS_V;
|
|
|