DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.XTR_TMP_FX_EXPOSURE_V

Object Details
Object Name: XTR_TMP_FX_EXPOSURE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_TMP_FX_EXPOSURE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIQUE_REF_NUMBER NUMBER
Yes
COMPANY VARCHAR2 (7) Yes
CURRENCY VARCHAR2 (15) Yes
CREATED_BY VARCHAR2 (10) Yes
CREATED_ON DATE
Yes
BASE_CURRENCY VARCHAR2 (15)
SELECTED_BASE_CURRENCY VARCHAR2 (15)
SELECTED_CCY VARCHAR2 (15)
SELECTED_PORTFOLIO VARCHAR2 (7)
YIELD_CURVE NUMBER

PORTFOLIO VARCHAR2 (7)
INCL_FX_OPTIONS VARCHAR2 (1)
INCL_INDIC_EXPOSURES VARCHAR2 (1)
DISCOUNT_RATE NUMBER

FX_ORIGINAL_REVAL_RATE NUMBER

PERIOD_NAME VARCHAR2 (20)
PERIOD_DESC VARCHAR2 (20)
FX_PERCENT_MAX NUMBER

FX_PERCENT_MIN NUMBER

FX_AMOUNT NUMBER

EXP_AMOUNT NUMBER

NET_EXPOSURE NUMBER

COVER_TO_FORECAST NUMBER

MAX_AMOUNT NUMBER

MIN_AMOUNT NUMBER

PERIOD_FROM DATE

PERIOD_TO DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UNIQUE_REF_NUMBER
,      COMPANY
,      CURRENCY
,      CREATED_BY
,      CREATED_ON
,      BASE_CURRENCY
,      SELECTED_BASE_CURRENCY
,      SELECTED_CCY
,      SELECTED_PORTFOLIO
,      YIELD_CURVE
,      PORTFOLIO
,      INCL_FX_OPTIONS
,      INCL_INDIC_EXPOSURES
,      DISCOUNT_RATE
,      FX_ORIGINAL_REVAL_RATE
,      PERIOD_NAME
,      PERIOD_DESC
,      FX_PERCENT_MAX
,      FX_PERCENT_MIN
,      FX_AMOUNT
,      EXP_AMOUNT
,      NET_EXPOSURE
,      COVER_TO_FORECAST
,      MAX_AMOUNT
,      MIN_AMOUNT
,      PERIOD_FROM
,      PERIOD_TO
FROM APPS.XTR_TMP_FX_EXPOSURE_V;

Dependencies

[top of page]

APPS.XTR_TMP_FX_EXPOSURE_V references the following:

SchemaAPPS
SynonymXTR_TMP_FX_EXPOSURE

APPS.XTR_TMP_FX_EXPOSURE_V is not referenced by any database object