SELECT PIMP.ORG_ID , 'F' ID , VALUE FROM FII_CURRENCIES_V CURR , PA_IMPLEMENTATIONS_ALL PIMP , GL_SETS_OF_BOOKS GSOB WHERE GSOB.SET_OF_BOOKS_ID = PIMP.SET_OF_BOOKS_ID AND GSOB.CURRENCY_CODE = CURR.ID UNION SELECT NULL , 'G' , VALUE FROM FII_CURRENCIES_V WHERE ID = 'FII_GLOBAL1'