[Home] [Help] [Dependency Information]
Object Name: | XTR_DISC_REVALUATION_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_DISC_REVALUATION_DETAILS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The XTR_DISC_REVALUATION_DETAILS_V view is used for the Discoverer report and is based on the XTR_REVALUATION_DETAILS view. User access to company information is enforced in the XTR_DISC_REVALUATION_DETAILS_V view. Please refer to the full description of XTR_REVALUATION_DETAILS_V for more details.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_CODE | VARCHAR2 | (7) | Refer to base table. | |
COMPANY_CODE | VARCHAR2 | (7) | Refer to base table. | |
CONTRACT_CODE | VARCHAR2 | (30) | Refer to base table. | |
TRANS_CURR | VARCHAR2 | (15) | Refer to base table. | |
CONTRA_CURR | VARCHAR2 | (15) | Refer to base table. | |
REF_NUMBER | VARCHAR2 | (40) | Refer to base table. | |
USER_DEAL_SUBTYPE | VARCHAR2 | (7) | Refer to base table. | |
USER_DEAL_TYPE | VARCHAR2 | (7) | Yes | Refer to base table. |
EFFECTIVE_DATE | DATE | Refer to base table. | ||
EFFECTIVE_DAYS | NUMBER | Refer to base table. | ||
ENTERED_BY | VARCHAR2 | (10) | Yes | Refer to base table. |
ENTERED_ON | DATE | Refer to base table. | ||
FACE_VALUE | NUMBER | Refer to base table. | ||
FXO_SELL_REF_AMOUNT | NUMBER | Refer to base table. | ||
PERIOD_FROM | DATE | Refer to base table. | ||
PERIOD_TO | DATE | Refer to base table. | ||
PORTFOLIO_CODE | VARCHAR2 | (30) | Refer to base table. | |
PRODUCT_TYPE | VARCHAR2 | (10) | Refer to base table. | |
REALISED_PL | NUMBER | Refer to base table. | ||
REVAL_CCY | VARCHAR2 | (15) | Refer to base table. | |
REVAL_RATE | NUMBER | Refer to base table. | ||
TRANSACTION_NO | NUMBER | Refer to base table. | ||
TRANSACTION_PERIOD | NUMBER | Refer to base table. | ||
TRANSACTION_RATE | NUMBER | Refer to base table. | ||
UNREALISED_PL | NUMBER | Refer to base table. | ||
UPDATED_BY | VARCHAR2 | (10) | Yes | Refer to base table. |
UPDATED_ON | DATE | Refer to base table. | ||
YEAR_BASIS | NUMBER | Refer to base table. | ||
CREATED_BY | VARCHAR2 | (10) | Yes | Refer to base table. |
CREATED_ON | DATE | Refer to base table. | ||
REVALUATION_DETAILS_ID | NUMBER | Refer to base table. | ||
BATCH_ID | NUMBER | (15) | Refer to base table. | |
COMPLETE_FLAG | VARCHAR2 | (1) | Refer to base table. | |
OVERWRITE_TYPE | VARCHAR2 | (30) | Refer to base table. | |
OVERWRITE_VALUE | NUMBER | Refer to base table. | ||
OVERWRITE_REASON | VARCHAR2 | (240) | Refer to base table. | |
FAIR_VALUE | NUMBER | Refer to base table. | ||
REALIZED_FLAG | VARCHAR2 | (1) | Refer to base table. | |
CUMM_GAIN_LOSS_AMOUNT | NUMBER | Refer to base table. | ||
CURR_GAIN_LOSS_AMOUNT | NUMBER | Refer to base table. | ||
SOB_FV_GAIN_LOSS_AMOUNT | NUMBER | Refer to base table. | ||
SOB_FAIR_VALUE_AMOUNT | NUMBER | Refer to base table. | ||
REVAL_CURR_FV_AMOUNT | NUMBER | Refer to base table. | ||
CTR_CURR_SOB_CURR_FWD_RATE | NUMBER | Refer to base table. | ||
EXCHANGE_RATE_ONE | NUMBER | Refer to base table. | ||
EXCHANGE_RATE_TWO | NUMBER | Refer to base table. | ||
AMOUNT_TYPE | VARCHAR2 | (7) | Refer to base table. | |
QUANTITY | NUMBER | Refer to base table. | ||
COMPANY_NAME | VARCHAR2 | (50) | Yes | Refer to base table. |
DEAL_SUBTYPE_NAME | VARCHAR2 | (80) | Refer to base table. | |
DEAL_TYPE_NAME | VARCHAR2 | (80) | Yes | Refer to base table. |
PRODUCT_TYPE_DESC | VARCHAR2 | (80) | Refer to base table. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_CODE
, COMPANY_CODE
, CONTRACT_CODE
, TRANS_CURR
, CONTRA_CURR
, REF_NUMBER
, USER_DEAL_SUBTYPE
, USER_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
, COMPANY_NAME
, DEAL_SUBTYPE_NAME
, DEAL_TYPE_NAME
, PRODUCT_TYPE_DESC
FROM APPS.XTR_DISC_REVALUATION_DETAILS_V;
APPS.XTR_DISC_REVALUATION_DETAILS_V is not referenced by any database object
|
|
|