[Home] [Help]
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
Name |
PERIOD_SET_NAME |
PERIOD_NAME |
PERIOD_TYPE |
FROM_CURRENCY |
TO_CURRENCY |
MAP_DATE_TYPE |
CONVERSION_DATE |
CONVERSION_RATE |
CONVERSION_TYPE |
STATUS_CODE |
UPDATEABLE_FLAG |
DELETEABLE_FLAG |