[Home] [Help]
View: FIIBV_GL_BOOK_FA_BOOK_LCV
Product: | FII - Financial Intelligence |
Description: | FIIBV_GL_BOOK_FA_BOOK_LCV is the base view for FA Book level of GL Book dimension |
Implementation/DBA Data: |
APPS.FIIBV_GL_BOOK_FA_BOOK_LCV
|
View Text
SELECT FBC.BOOK_TYPE_CODE||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) ||'-' || 'FA'
, TO_CHAR(FBC.SET_OF_BOOKS_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, FBC.BOOK_TYPE_NAME
, FBC.BOOK_TYPE_NAME
, FBC.BOOK_TYPE_NAME
, GSOB.CURRENCY_CODE
, NULL
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, NULL
, FBC.LAST_UPDATE_DATE
, '_DF:OFA:FA_BOOK_CONTROLS:FBC'
, '_DF:JG:JG_FA_BOOK_CONTROLS:FBC'
, '_DF:JG:JG_GL_SETS_OF_BOOKS:GSOB'
, '_DF:SQLGL:GL_SETS_OF_BOOKS:GSOB'
FROM FA_BOOK_CONTROLS FBC
, GL_SETS_OF_BOOKS GSOB
WHERE FBC.BOOK_CLASS = 'CORPORATE'
AND FBC.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID UNION SELECT TO_CHAR(SET_OF_BOOKS_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, TO_CHAR(SET_OF_BOOKS_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, ''
, NAME
, NAME
, CURRENCY_CODE
, ''
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, ''
, LAST_UPDATE_DATE
, '_DF:_DUMMY:OFA:FA_BOOK_CONTROLS:FBC'
, '_DF:_DUMMY:JG:JG_FA_BOOK_CONTROLS:FBC'
, '_DF:JG:JG_GL_SETS_OF_BOOKS:SOB'
, '_DF:SQLGL:GL_SETS_OF_BOOKS:SOB'
FROM GL_SETS_OF_BOOKS SOB
Columns
Name |
FA_BOOK_PK |
BOOK_FK |
BOOK_TYPE_NAME |
NAME |
FA_BOOK |
CURRENCY_CODE |
DEPRE_CALANDAR |
INSTANCE |
PRORATE_CALENDAR |
LAST_UPDATE_DATE |
"_DF:FBK:_EDW" |
"_DF:JBK:_EDW" |
"_DF:JSB:_EDW" |
"_DF:GSB:_EDW" |