[Home] [Help]
View: FIIBV_GL_BOOK_BOOK_LCV
Product: | FII - Financial Intelligence |
Description: | FIIBV_GL_BOOK_BOOK_LCV is the base view for GL Book level of GL Book dimension |
Implementation/DBA Data: |
APPS.FIIBV_GL_BOOK_BOOK_LCV
|
View Text
SELECT TO_CHAR(SET_OF_BOOKS_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, 'ALL'
, ACCOUNTED_PERIOD_TYPE
, CHART_OF_ACCOUNTS_ID
, CURRENCY_CODE
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, NULL
, NAME
, NAME
, PERIOD_SET_NAME
, TO_CHAR(TRANSACTION_CALENDAR_ID)
, LAST_UPDATE_DATE
, '_DF:JG:JG_GL_SETS_OF_BOOKS:SOB'
, '_DF:SQLGL:GL_SETS_OF_BOOKS:SOB'
FROM GL_SETS_OF_BOOKS SOB
Columns
Name |
BOOK_PK |
ALL_FK |
ACCT_PERIOD_TYPE |
CHART_OF_ACCTS_ID |
CURRENCY_CODE |
INSTANCE |
MRC_SOB_TYPE_CODE |
NAME |
GL_BOOK |
PERIOD_SET_NAME |
TRX_CALENDAR |
LAST_UPDATE_DATE |
"_DF:JBK:_EDW" |
"_DF:GBK:_EDW" |