/* DAILY RATES DLD PROFESSIONAL LOAD (DATE RANGES )
Written by Daniel North,  ORAFINAPPS Limited 2007
Extracts specific daily rates in a dataload professional file format .FLD 
To be used in conjunction with a predefined .fld file
(Tested on Vision 11.5.10.2  June 2007 ) */
SELECT
	  GLR.FROM_CURRENCY
,	  GLR.TO_CURRENCY
,	  GLR.CONVERSION_DATE"FROM"
,	  GLR.CONVERSION_DATE"TO"
,	  RT.USER_CONVERSION_TYPE
,	  GLR.SHOW_CONVERSION_RATE "FROM > TO"
,	  GLR.SHOW_INVERSE_CON_RATE " TO > FROM(INVERSE)"
FROM GL_DAILY_RATES_V GLR, FND_CURRENCIES C, GL_DAILY_CONVERSION_TYPES RT
WHERE GLR.FROM_CURRENCY = C.CURRENCY_CODE
AND GLR.CONVERSION_TYPE = RT.CONVERSION_TYPE
AND RT.USER_CONVERSION_TYPE LIKE 'CORPORATE'
--AND CONVERSION_DATE > TO_DATE('30-NOV-2002','DD-MON-YYYY')
--AND CONVERSION_DATE > TO_DATE('31-AUG-2006','DD-MON-YYYY')
--AND SUBSTR(GLR.CONVERSION_DATE,1,2) = '01'
--AND FROM_CURRENCY IN ('GBP')
--AND TO_CURRENCY NOT IN ('GBP')
--AND RT.USER_CONVERSION_TYPE LIKE 'THAI%'
ORDER BY 1,GLR.CONVERSION_DATE