View: AS_PERIOD_RATES_V

Product:	AS - Sales Foundation
Description:	Provides pseudo period rates for currency conversion.
Implementation/DBA Data:	APPS.AS_PERIOD_RATES_V

View Text

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

Columns