View: EDW_GL_BOOK_MPV

Product:	FII - Financial Intelligence
Description:	EDW_GL_BOOK_MPV is the view for data validity on source side.
Implementation/DBA Data:	APPS.EDW_GL_BOOK_MPV

View Text

SELECT FBC.BOOK_TYPE_CODE||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) ||'-' || 'FA'
, FBC.LAST_UPDATE_DATE
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)
, LAST_UPDATE_DATE
FROM GL_SETS_OF_BOOKS SOB

Columns