VIEW: OSM.AS_PERIOD_RATES#

Source

View Text - Preformatted

select PERIOD_RATE_ID PERIOD_RATE_ID, FROM_CURRENCY FROM_CURRENCY, TO_CURRENCY TO_CURRENCY, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_DATE CONVERSION_DATE, CONVERSION_RATE CONVERSION_RATE, NUMERATOR_RATE NUMERATOR_RATE, DENOMINATOR_RATE DENOMINATOR_RATE, PRECISION PRECISION, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, CONVERSION_STATUS_FLAG CONVERSION_STATUS_FLAG, PERIOD_TYPE PERIOD_TYPE, PERIOD_NAME PERIOD_NAME, PERIOD_SET_NAME PERIOD_SET_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "OSM"."AS_PERIOD_RATES"

View Text - HTML Formatted

SELECT PERIOD_RATE_ID PERIOD_RATE_ID
, FROM_CURRENCY FROM_CURRENCY
, TO_CURRENCY TO_CURRENCY
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_DATE CONVERSION_DATE
, CONVERSION_RATE CONVERSION_RATE
, NUMERATOR_RATE NUMERATOR_RATE
, DENOMINATOR_RATE DENOMINATOR_RATE
, PRECISION PRECISION
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, CONVERSION_STATUS_FLAG CONVERSION_STATUS_FLAG
, PERIOD_TYPE PERIOD_TYPE
, PERIOD_NAME PERIOD_NAME
, PERIOD_SET_NAME PERIOD_SET_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "OSM"."AS_PERIOD_RATES"