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: MSD_CURRENCY_CONVERSIONS 12.2.2

owner MSD·MSD - Demand Planning·13 columns

Fact table that stores the Currency Conversion information.

MSD.MSD_CURRENCY_CONVERSIONS·Explore MSD module →

Table: XLA_RC_UPGRADE_RATES 12.2.2

owner XLA·XLA - Subledger Accounting·14 columns

This table holds the conversion rates used during Secondary or ALC ledger upgrade

XLA.XLA_RC_UPGRADE_RATES·Explore XLA 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 →

Table: PA_MC_UPGRADE_RATES 12.2.2

owner PA·PA - Projects·9 columns

Rate information cached for all Transaction currencies.

PA.PA_MC_UPGRADE_RATES·Explore PA module →

View: GLBV_GL_PERIOD_EXCHANGE_RATES 12.1.1

GL - General Ledger·7 columns

APPS.GLBV_GL_PERIOD_EXCHANGE_RATES·↳ GL_DAILY_RATES·↳ GL_LEDGERS·↳ GL_LOOKUPS·Explore GL module →

View: AS_PERIOD_RATES_V 12.1.1

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: 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 →

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 →

PACKAGE: APPS.QP_ID_TO_VALUE 12.1.1

used by 24

Table: CE_CURRENCY_RATES_TEMP 12.1.1 standalone

owner CE·CE - Cash Management·4 columns

Forecast currency amount staging table

CE.CE_CURRENCY_RATES_TEMP·Explore CE 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 →

View: GLFV_GL_PERIOD_EXCHANGE_RATES 12.1.1

GL - General Ledger·7 columns

General Ledger period exchange rates are average, period-end, and revaluation conversion rates defined between any two currencies.

APPS.GLFV_GL_PERIOD_EXCHANGE_RATES·↳ GL_DAILY_RATES·↳ GL_LEDGERS·↳ GL_LOOKUPS·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: 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: 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_ST_CURRENCY_CONVERSIONS 12.2.2

owner MSD·MSD - Demand Planning·22 columns

Staging table that stores the currency conversion information.

MSD.MSD_ST_CURRENCY_CONVERSIONS·Explore MSD 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_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: 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 →

PACKAGE BODY: APPS.QP_VALUE_TO_ID 12.1.1

used by 36

Table: GL_DAILY_RATES 12.2.2 link

owner GL·GL - General Ledger·28 columns

Daily conversion rates for foreign currency transactions

GL.GL_DAILY_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 →

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 →

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 →

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 →

PACKAGE: APPS.QP_VALIDATE 12.2.2

used by 50

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: AR_LINE_APP_DETAIL_GT 12.2.2