VIEW: APPS.HRI_CL_CURRENCY_CONVERT_TO_V

Source

View Text - Preformatted

SELECT fc_tl.currency_code ID , tc_tl.name VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , fc_tl.currency_code from_currency_code , tc_tl.currency_code to_currency_code , fc_tl.name from_currency_name , tc_tl.name to_currency_name , tc.context to_currency_context , tc.symbol to_currency_symbol , tc_tl.description to_currency_description , tc.iso_flag to_currency_iso_flag_code , tc.issuing_territory_code to_currency_issu_trrtry_code , tc.precision to_currency_precision , tc.extended_precision to_currency_extnd_precision , tc.enabled_flag to_currency_enabled_flag_code FROM fnd_currencies_tl fc_tl , fnd_currencies tc , fnd_currencies_tl tc_tl WHERE tc.enabled_flag = 'Y' AND fc_tl.language = USERENV('LANG') AND tc_tl.language = USERENV('LANG') AND tc.currency_code = tc_tl.currency_code

View Text - HTML Formatted

SELECT FC_TL.CURRENCY_CODE ID
, TC_TL.NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, FC_TL.CURRENCY_CODE FROM_CURRENCY_CODE
, TC_TL.CURRENCY_CODE TO_CURRENCY_CODE
, FC_TL.NAME FROM_CURRENCY_NAME
, TC_TL.NAME TO_CURRENCY_NAME
, TC.CONTEXT TO_CURRENCY_CONTEXT
, TC.SYMBOL TO_CURRENCY_SYMBOL
, TC_TL.DESCRIPTION TO_CURRENCY_DESCRIPTION
, TC.ISO_FLAG TO_CURRENCY_ISO_FLAG_CODE
, TC.ISSUING_TERRITORY_CODE TO_CURRENCY_ISSU_TRRTRY_CODE
, TC.PRECISION TO_CURRENCY_PRECISION
, TC.EXTENDED_PRECISION TO_CURRENCY_EXTND_PRECISION
, TC.ENABLED_FLAG TO_CURRENCY_ENABLED_FLAG_CODE
FROM FND_CURRENCIES_TL FC_TL
, FND_CURRENCIES TC
, FND_CURRENCIES_TL TC_TL
WHERE TC.ENABLED_FLAG = 'Y'
AND FC_TL.LANGUAGE = USERENV('LANG')
AND TC_TL.LANGUAGE = USERENV('LANG')
AND TC.CURRENCY_CODE = TC_TL.CURRENCY_CODE