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