VIEW: APPS.PJI_CURRENCY_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'