Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT B.ROWID ROW_ID
, B.PRIMARY_SET_OF_BOOKS_ID PRIMARY_SET_OF_BOOKS_ID
, B.REPORTING_SET_OF_BOOKS_ID REPORTING_SET_OF_BOOKS_ID
, SOB.NAME REPORTING_BOOK_NAME
, SOB.SHORT_NAME REPORTING_BOOK_SHORT_NAME
, SOB.CURRENCY_CODE REPORTING_BOOK_CURRENCY_CODE
, B.FIRST_MRC_DATE FIRST_MRC_DATE
, B.FIRST_MRC_PERIOD FIRST_MRC_PERIOD
, B.INIT_CONVERSION_TYPE INIT_CONVERSION_TYPE
, D.USER_CONVERSION_TYPE INIT_USER_CONVERSION_TYPE
, B.INIT_CONVERSION_DATE INIT_CONVERSION_DATE
, B.CONVERSION_OPTION_CODE CONVERSION_OPTION_CODE
, B.EFC_BOOK_FLAG EFC_BOOK_FLAG
, B.PRE_EFC_SELECTED_FLAG PRE_EFC_SELECTED_FLAG
, B.EFC_SELECTED_FLAG EFC_SELECTED_FLAG
, B.EFC_COMPLETED_FLAG EFC_COMPLETED_FLAG
, B.EFC_RUN_ID EFC_RUN_ID
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM GL_SETS_OF_BOOKS SOB
, GL_DAILY_CONVERSION_TYPES D
, GL_MC_BOOK_ASSIGNMENTS B
WHERE SOB.SET_OF_BOOKS_ID = B.REPORTING_SET_OF_BOOKS_ID
AND D.CONVERSION_TYPE (+) = B.INIT_CONVERSION_TYPE