[Home] [Help]
View: FII_BIS_FA_BOOKS_V
Product: | FII - Financial Intelligence |
Description: | Internal view used for Asset SetofBooks LOV in PM Viewer Reports |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT BC.BOOK_TYPE_CODE
, BC.BOOK_TYPE_CODE
, BC.SET_OF_BOOKS_ID
, GSOB.CURRENCY_CODE
FROM FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GSOB
WHERE BC.BOOK_CLASS='CORPORATE'
AND GSOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID
Columns
Name |
ID |
VALUE |
SET_OF_BOOKS_ID |
CURRENCY_CODE |