Table: MSC_CURRENCY_CONV_MV | Oracle EBS ETRM Search

This view specifies the Conversion Rate between two currencies. The fact table underlying this would be populated with the currency conversion rate for the converion type specified in the profile at the planning server level.

APPS.MSD_CURRENCY_CONVERSIONS_V·↳ MSD_CURRENCY_CONVERSIONS·Explore MSD module →

View: MSD_CURRENCY_CONVERSIONS_V 12.2.2

MSD - Demand Planning·4 columns

This view specifies the Conversion Rate between two currencies. The fact table underlying this would be populated with the currency conversion rate for the converion type specified in the profile at the planning server level.

APPS.MSD_CURRENCY_CONVERSIONS_V·↳ MSD_CURRENCY_CONVERSIONS·Explore MSD module →

Table: FII_CURR_CONV_RATES 12.1.1

owner FII·FII - Financial Intelligence·14 columns

This table stores the currency conversion rates.

FII.FII_CURR_CONV_RATES·Explore FII module →

View: GLBV_GL_DAILY_EXCHANGE_RATES 12.1.1

GL - General Ledger·6 columns

APPS.GLBV_GL_DAILY_EXCHANGE_RATES·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_DAILY_RATES·Explore GL module →

View: GLFV_GL_DAILY_EXCHANGE_RATES 12.1.1

GL - General Ledger·7 columns

APPS.GLFV_GL_DAILY_EXCHANGE_RATES·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_DAILY_RATES·Explore GL module →

Table: MSD_ST_CURRENCY_CONVERSIONS 12.1.1

owner MSD·MSD - Demand Planning·22 columns

Staging table that stores the currency conversion information.

MSD.MSD_ST_CURRENCY_CONVERSIONS·Explore MSD module →

Table: MSC_CURRENCY_CONV_MV 12.2.2

MSC - Advanced Supply Chain Planning·4 columns

APPS.MSC_CURRENCY_CONV_MV·Explore MSC module →

View: OKI_DAILY_RATES_V 12.1.1

OKI - Contracts Intelligence·4 columns

Holds information about the conversion rates to be used when converting currencies in OKI.

APPS.OKI_DAILY_RATES_V·↳ OKI_DAILY_RATES·Explore OKI module →

Table: GL_CROSS_RATE_RULE_DTLS 12.2.2 link

owner GL·GL - General Ledger·9 columns

Cross Rate Rule Details

GL.GL_CROSS_RATE_RULE_DTLS·Explore GL module →

Table: FII_RECONV_RATES 12.1.1 standalone

owner FII·FII - Financial Intelligence·11 columns

Current currency conversion rates

FII.FII_RECONV_RATES·Explore FII module →

Table: GL_DAILY_RATES_INTERFACE 12.1.1 link

owner GL·GL - General Ledger·28 columns

Import daily conversion rates

GL.GL_DAILY_RATES_INTERFACE·Explore GL module →

Table: FII_AP_FUNC_RATES_TEMP 12.1.1

owner FII·FII - Financial Intelligence·6 columns

This table is used for storing functional conversion rates.

FII.FII_AP_FUNC_RATES_TEMP·Explore FII module →

Table: AS_PERIOD_RATES 12.1.1 standalone

owner OSM·AS - Sales Foundation·25 columns

Holds currency conversion rates

OSM.AS_PERIOD_RATES·Explore AS module →

Table: MSD_CURRENCY_CONVERSIONS 12.1.1

owner MSD·MSD - Demand Planning·13 columns

Fact table that stores the Currency Conversion information.

MSD.MSD_CURRENCY_CONVERSIONS·Explore MSD module →

Table: GL_MC_UPGRADE_RATES 12.1.1 link

owner GL·GL - General Ledger·8 columns

Exchange rates used for the multiple reporting currency upgrade programs

GL.GL_MC_UPGRADE_RATES·Explore GL module →

Table: PA_MC_UPGRADE_RATES 12.1.1

owner PA·PA - Projects·9 columns

Rate information cached for all Transaction currencies.

PA.PA_MC_UPGRADE_RATES·Explore PA module →

Table: GL_CROSS_RATE_RULE_DTLS 12.1.1 link

owner GL·GL - General Ledger·9 columns

Cross Rate Rule Details

GL.GL_CROSS_RATE_RULE_DTLS·Explore GL module →

View: MSD_SR_CURRENCY_CONVERSIONS_V 12.1.1

MSD - Demand Planning·10 columns

This is the Source View for Currency Conversions. This view would be applied to an Oracle Applications 11i instance from which the Currency Conversion information is to be retrieved.

APPS.MSD_SR_CURRENCY_CONVERSIONS_V·↳ GL_DAILY_RATES·Explore MSD module →

View: MSD_SR_CURRENCY_CONVERSIONS_V 12.2.2

MSD - Demand Planning·10 columns

This is the Source View for Currency Conversions. This view would be applied to an Oracle Applications 11i instance from which the Currency Conversion information is to be retrieved.

APPS.MSD_SR_CURRENCY_CONVERSIONS_V·↳ GL_DAILY_RATES·Explore MSD module →

View: AS_PERIOD_RATES_V 12.2.2

AS - Sales Foundation·12 columns

Provides pseudo period rates for currency conversion.

APPS.AS_PERIOD_RATES_V·↳ AS_MC_TYPE_MAPPINGS·↳ GL_DAILY_RATES·↳ GL_PERIODS·Explore AS module →

Table: GCS_HISTORICAL_RATES 12.1.1 link

owner GCS·GCS - Financial Consolidation Hub·37 columns

GCS historical rates information

GCS.GCS_HISTORICAL_RATES·Explore GCS module →

Table: MSD_ST_CURRENCY_CONVERSIONS 12.2.2

owner MSD·MSD - Demand Planning·22 columns

Staging table that stores the currency conversion information.