[Home] [Help]
View: IBE_BI_CURRENCY_V
Product: | IBE - iStore |
Description: | This view returns the list of currencies supported by each Mini Site |
Implementation/DBA Data: |
APPS.IBE_BI_CURRENCY_V
|
View Text
SELECT IBMA.MSITE_ID
, IBMA.ORG_ID
, GSOB.CURRENCY_CODE
FROM IBE_BI_MSITEORG_MV IBMA
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, GL_SETS_OF_BOOKS GSOB
WHERE FSP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND FSP.ORG_ID = IBMA.ORG_ID GROUP BY IBMA.MSITE_ID
, IBMA.ORG_ID
, GSOB.CURRENCY_CODE
Columns
Name |
MSITE_ID |
ORG_ID |
CURRENCY_CODE |