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

VIEW: APPS.XTR_MASTER_CURRENCIES_V

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

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
CURRENCY VARCHAR2 (15) Yes Currency code
NAME VARCHAR2 (20) Yes Currency description
AUTHORISED VARCHAR2 (1) Yes Flag to indicate if the currency is authorized for use (Y), or not (N)
DIVIDE_OR_MULTIPLY VARCHAR2 (1) Yes Flag that determines whether the spot rate calculation of a forward foreign exchange rate should be division (/) or multiplication (*)
YEAR_BASIS NUMBER
Yes Number of days in a year used in calculations (for example, 360 and 365)
ROUNDING_FACTOR NUMBER (1)
Maximum number of digits to the right of decimal point
CREATED_BY VARCHAR2 (30) Yes User who created this record
CREATED_ON DATE
Yes Date this record was created
UPDATED_BY VARCHAR2 (30)
User who last updated this record
UPDATED_ON DATE

Date this record was last updated
MINIMUM_BAND NUMBER

Minimum foreign exchange coverage percentage
MAXIMUM_BAND NUMBER

Maximum foreign exchange coverage percentage
IR_SEQ_NO NUMBER

Sequence number that determines the currency ordering in the LOVs of money market forms
FX_SEQ_NO NUMBER

Sequence number that determines the currency ordering in the LOV's of foreign exchange forms
NET_FX_EXPOSURE NUMBER

Foreign exchange exposure limit
MAX_DAYS_CONTRACT NUMBER

Not currently used
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
CALCULATE_HOLS_YEARS NUMBER

Number of years forward to calculate holiday dates
LAST_TRANSACTION_CHANGED DATE

Date on which a currency combination monitor status is changed
CURRENT_SPOT_RATE NUMBER

Current spot rate
HCE_RATE NUMBER

Conversion rate to the reporting currency
USD_QUOTED_SPOT NUMBER

Spot rate against the US dollar
SPOT_DATE DATE

Date the conversion rate to reporting currency was last updated
USD_BASE_CURR_BID_RATE NUMBER

Foreign exchange rate bid price against the US dollar
USD_BASE_CURR_OFFER_RATE NUMBER

Foreign exchange rate offer price against the US dollar
RATE_DATE DATE

Date the rate is based on
UTILISED_AMOUNT NUMBER

Total amount that deal transactions have applied to the limit
IG_YEAR_BASIS VARCHAR2 (15)
Currency year basis
GL_CALENDAR_NAME VARCHAR2 (25)
Specifies the GL calendar for determining weekends
GL_NO_UPLOAD VARCHAR2 (1)
Query Text

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


SELECT CURRENCY
,      NAME
,      AUTHORISED
,      DIVIDE_OR_MULTIPLY
,      YEAR_BASIS
,      ROUNDING_FACTOR
,      CREATED_BY
,      CREATED_ON
,      UPDATED_BY
,      UPDATED_ON
,      MINIMUM_BAND
,      MAXIMUM_BAND
,      IR_SEQ_NO
,      FX_SEQ_NO
,      NET_FX_EXPOSURE
,      MAX_DAYS_CONTRACT
,      AUDIT_INDICATOR
,      CALCULATE_HOLS_YEARS
,      LAST_TRANSACTION_CHANGED
,      CURRENT_SPOT_RATE
,      HCE_RATE
,      USD_QUOTED_SPOT
,      SPOT_DATE
,      USD_BASE_CURR_BID_RATE
,      USD_BASE_CURR_OFFER_RATE
,      RATE_DATE
,      UTILISED_AMOUNT
,      IG_YEAR_BASIS
,      GL_CALENDAR_NAME
,      GL_NO_UPLOAD
FROM APPS.XTR_MASTER_CURRENCIES_V;

Dependencies

[top of page]

APPS.XTR_MASTER_CURRENCIES_V references the following:

SchemaAPPS
SynonymFND_CURRENCIES
SynonymXTR_MASTER_CURRENCIES
APPS.XTR_MASTER_CURRENCIES_V is referenced by following:

SchemaAPPS
Package BodyQRM_PA_CALCULATION_P - show dependent code
Package BodyXTR_ACCOUNT_BAL_MAINT_P - show dependent code
Package BodyXTR_ACCRUAL_PROCESS_P - show dependent code
Package BodyXTR_AUTO_RECONCILIATION - show dependent code
TriggerXTR_BIU_MARKET_PRICES_T
Package BodyXTR_CALCULATION_P - show dependent code
Package BodyXTR_CALC_P - show dependent code
Package BodyXTR_COF_P - show dependent code
Package BodyXTR_EXP_SUMM_P - show dependent code
Package BodyXTR_EXP_TRANSFERS_PKG - show dependent code
Package BodyXTR_FPS1_P - show dependent code
Package BodyXTR_FPS2_P - show dependent code
Package BodyXTR_FPS3_P - show dependent code
Package BodyXTR_FX_TRANSFERS_PKG - show dependent code
Package BodyXTR_HEDGE_PROCESS_P - show dependent code
PL/SQL PackageXTR_IG_TRANSFERS_PKG - show dependent code
Package BodyXTR_IG_TRANSFERS_PKG - show dependent code
Package BodyXTR_LIMITS_P - show dependent code
Package BodyXTR_MAINTAIN_DDA_P - show dependent code
Package BodyXTR_MARKET_DATA_INTERFACE_P - show dependent code
Package BodyXTR_MISC_P - show dependent code
Package BodyXTR_NI_TRANSFERS_PKG - show dependent code
Package BodyXTR_RATE_CHANGE - show dependent code
Package BodyXTR_REPLICATE_BANK_BALANCES - show dependent code
Package BodyXTR_RESET_BOND_RATE - show dependent code
Package BodyXTR_REVAL_PROCESS_P - show dependent code
Package BodyXTR_STOCK_PKG - show dependent code
Package BodyXTR_STOCK_POSITION_P - show dependent code
Package BodyXTR_WRAPPER_API_P - show dependent code
Package BodyXTR_XTRCCYGL_XMLP_PKG - show dependent code
Package BodyXTR_XTROHINS_XMLP_PKG - show dependent code