VIEW: APPS.AS_PERIOD_RATES_V

Source

View Text - Preformatted

SELECT periods.period_set_name, periods.period_name, periods.period_type, rates.from_currency, rates.to_currency, 'S', periods.start_date, rates.conversion_rate, rates.conversion_type, rates.status_code, maps.updateable_flag, maps.deleteable_flag FROM gl_periods periods, gl_daily_rates rates, as_mc_type_mappings maps WHERE periods.start_date = rates.conversion_date(+) AND periods.period_set_name = maps.period_set_name AND periods.period_type = maps.period_type AND maps.conversion_type = rates.conversion_type UNION SELECT periods.period_set_name, periods.period_name, periods.period_type, rates.from_currency, rates.to_currency, 'E', periods.end_date, rates.conversion_rate, rates.conversion_type, rates.status_code, maps.updateable_flag, maps.deleteable_flag FROM gl_periods periods, gl_daily_rates rates, as_mc_type_mappings maps WHERE periods.end_date = rates.conversion_date(+) AND periods.period_set_name = maps.period_set_name AND periods.period_type = maps.period_type AND maps.conversion_type = rates.conversion_type

View Text - HTML Formatted

SELECT PERIODS.PERIOD_SET_NAME
, PERIODS.PERIOD_NAME
, PERIODS.PERIOD_TYPE
, RATES.FROM_CURRENCY
, RATES.TO_CURRENCY
, 'S'
, PERIODS.START_DATE
, RATES.CONVERSION_RATE
, RATES.CONVERSION_TYPE
, RATES.STATUS_CODE
, MAPS.UPDATEABLE_FLAG
, MAPS.DELETEABLE_FLAG
FROM GL_PERIODS PERIODS
, GL_DAILY_RATES RATES
, AS_MC_TYPE_MAPPINGS MAPS
WHERE PERIODS.START_DATE = RATES.CONVERSION_DATE(+)
AND PERIODS.PERIOD_SET_NAME = MAPS.PERIOD_SET_NAME
AND PERIODS.PERIOD_TYPE = MAPS.PERIOD_TYPE
AND MAPS.CONVERSION_TYPE = RATES.CONVERSION_TYPE UNION SELECT PERIODS.PERIOD_SET_NAME
, PERIODS.PERIOD_NAME
, PERIODS.PERIOD_TYPE
, RATES.FROM_CURRENCY
, RATES.TO_CURRENCY
, 'E'
, PERIODS.END_DATE
, RATES.CONVERSION_RATE
, RATES.CONVERSION_TYPE
, RATES.STATUS_CODE
, MAPS.UPDATEABLE_FLAG
, MAPS.DELETEABLE_FLAG
FROM GL_PERIODS PERIODS
, GL_DAILY_RATES RATES
, AS_MC_TYPE_MAPPINGS MAPS
WHERE PERIODS.END_DATE = RATES.CONVERSION_DATE(+)
AND PERIODS.PERIOD_SET_NAME = MAPS.PERIOD_SET_NAME
AND PERIODS.PERIOD_TYPE = MAPS.PERIOD_TYPE
AND MAPS.CONVERSION_TYPE = RATES.CONVERSION_TYPE