VIEW: APPS.HRI_CL_CURRENCY_V

Source

View Text - Preformatted

SELECT cur.currency_code ID , cur_tl.name VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , cur_tl.name ORDER_BY , cur.context context , cur.symbol symbol , cur_tl.description description , cur.iso_flag iso_flag_code , cur.issuing_territory_code issuing_territory_code , cur.precision precision , cur.extended_precision extended_precision , cur.enabled_flag enabled_flag_code FROM fnd_currencies cur , fnd_currencies_tl cur_tl WHERE cur.enabled_flag = 'Y' AND cur_tl.language = USERENV('LANG') AND cur.currency_code = cur_tl.currency_code UNION ALL SELECT 'NA_EDW' , null , to_date(null) , to_date(null) , ' ' , null , null , null , null , null , to_number(null) , to_number(null) , null FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT CUR.CURRENCY_CODE ID
, CUR_TL.NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, CUR_TL.NAME ORDER_BY
, CUR.CONTEXT CONTEXT
, CUR.SYMBOL SYMBOL
, CUR_TL.DESCRIPTION DESCRIPTION
, CUR.ISO_FLAG ISO_FLAG_CODE
, CUR.ISSUING_TERRITORY_CODE ISSUING_TERRITORY_CODE
, CUR.PRECISION PRECISION
, CUR.EXTENDED_PRECISION EXTENDED_PRECISION
, CUR.ENABLED_FLAG ENABLED_FLAG_CODE
FROM FND_CURRENCIES CUR
, FND_CURRENCIES_TL CUR_TL
WHERE CUR.ENABLED_FLAG = 'Y'
AND CUR_TL.LANGUAGE = USERENV('LANG')
AND CUR.CURRENCY_CODE = CUR_TL.CURRENCY_CODE UNION ALL SELECT 'NA_EDW'
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, ' '
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM DUAL WITH READ ONLY