View: PJI_CURRENCY_TYPES_V

Product:	PJI - Project Intelligence
Description:	This is an internal summarization view.
Implementation/DBA Data:	APPS.PJI_CURRENCY_TYPES_V

View Text

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'

Columns