View: OKL_GL_SETS_OF_BOOKS_UV

View Text

SELECT SOB.ROWID ROW_ID
, SOB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SOB.LAST_UPDATED_BY LAST_UPDATED_BY
, SOB.CURRENCY_CODE CURRENCY_CODE
, SOB.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, SOB.SUSPENSE_ALLOWED_FLAG SUSPENSE_ALLOWED_FLAG
, SOB.ALLOW_POSTING_WARNING_FLAG ALLOW_POSTING_WARNING_FLAG
, SOB.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, SOB.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, SOB.ENABLE_BUDGETARY_CONTROL_FLAG ENABLE_BUDGETARY_CONTROL_FLAG
, SOB.ALLOW_INTERCOMPANY_POST_FLAG ALLOW_INTERCOMPANY_POST_FLAG
, SOB.CREATION_DATE CREATION_DATE
, SOB.CREATED_BY CREATED_BY
, SOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SOB.LATEST_ENCUMBRANCE_YEAR LATEST_ENCUMBRANCE_YEAR
, SOB.EARLIEST_UNTRANS_PERIOD_NAME EARLIEST_UNTRANS_PERIOD_NAME
, SOB.CUM_TRANS_CODE_COMBINATION_ID CUM_TRANS_CODE_COMBINATION_ID
, SOB.LATEST_OPENED_PERIOD_NAME LATEST_OPENED_PERIOD_NAME
, SOB.RET_EARN_CODE_COMBINATION_ID RET_EARN_CODE_COMBINATION_ID
, SOB.RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID
, SUS.CODE_COMBINATION_ID SUSPENSE_CCID
, SOB.NET_INCOME_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID
, SOB.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID
, SOB.ENABLE_AVERAGE_BALANCES_FLAG ENABLE_AVGBAL_FLAG
, SOB.CONSOLIDATION_SOB_FLAG CONSOLIDATION_SOB_FLAG
, SOB.TRANSLATE_EOD_FLAG TRANSLATE_EOD_FLAG
, SOB.TRANSLATE_QATD_FLAG TRANSLATE_QATD_FLAG
, SOB.TRANSLATE_YATD_FLAG TRANSLATE_YATD_FLAG
, SOB.DAILY_TRANSLATION_RATE_TYPE DAILY_TRANSLATION_RATE_TYPE
, SOB.ATTRIBUTE1 ATTRIBUTE1
, SOB.ATTRIBUTE2 ATTRIBUTE2
, SOB.ATTRIBUTE3 ATTRIBUTE3
, SOB.ATTRIBUTE4 ATTRIBUTE4
, SOB.ATTRIBUTE5 ATTRIBUTE5
, SOB.ATTRIBUTE6 ATTRIBUTE6
, SOB.ATTRIBUTE7 ATTRIBUTE7
, SOB.ATTRIBUTE8 ATTRIBUTE8
, SOB.ATTRIBUTE9 ATTRIBUTE9
, SOB.ATTRIBUTE10 ATTRIBUTE10
, SOB.ATTRIBUTE11 ATTRIBUTE11
, SOB.ATTRIBUTE12 ATTRIBUTE12
, SOB.ATTRIBUTE13 ATTRIBUTE13
, SOB.ATTRIBUTE14 ATTRIBUTE14
, SOB.ATTRIBUTE15 ATTRIBUTE15
, SOB.CONTEXT CONTEXT
, SOB.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, SOB.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, SOB.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, SOB.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, SOB.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, SOB.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, SOB.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, SOB.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, SOB.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, SOB.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, SOB.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, SOB.ENABLE_AUTOMATIC_TAX_FLAG ENABLE_AUTOMATIC_TAX_FLAG
, SOB.ENABLE_JE_APPROVAL_FLAG ENABLE_JE_APPROVAL_FLAG
, NET.BAL_SEG_VALUE BALANCING_SEGMENT
, DCT.USER_CONVERSION_TYPE DAILY_USER_TRANSLATION_TYPE
, SOB.MRC_SOB_TYPE_CODE MRC_SOB_TYPE_CODE
, SOB.TRACK_ROUNDING_IMBALANCE_FLAG TRACK_ROUNDING_IMBALANCE_FLAG
, SOB.ROUNDING_CODE_COMBINATION_ID ROUNDING_CCID
, SOB.NAME NAME
, SOB.SHORT_NAME SHORT_NAME
, SOB.DESCRIPTION DESCRIPTION
, FIFS.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, FCT.NAME CURRENCY
, SOB.PERIOD_SET_NAME PERIOD_SET_NAME
, SOB.FUTURE_ENTERABLE_PERIODS_LIMIT FUTURE_ENTERABLE_PERIODS_LIMIT
, GPT.USER_PERIOD_TYPE USER_PERIOD_TYPE
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(SOB.RET_EARN_CODE_COMBINATION_ID) RET_EAR_ACCOUNT
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(SOB.CUM_TRANS_CODE_COMBINATION_ID) TRAN_ADJ_ACCOUNT
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.ALLOW_INTERCOMPANY_POST_FLAG
, 0
, 0) BAL_INT_CO_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.ENABLE_JE_APPROVAL_FLAG
, 0
, 0) JE_APPROVAL_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.ENABLE_AUTOMATIC_TAX_FLAG
, 0
, 0) JOURNAL_ENTRY_TAX
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(SUS.CODE_COMBINATION_ID) SUSPENSE_ACCOUNT
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(SOB.ROUNDING_CODE_COMBINATION_ID) ROUNDING_DIFF_ACCOUNT
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.ENABLE_AVERAGE_BALANCES_FLAG
, 0
, 0) AVE_BAL_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.CONSOLIDATION_SOB_FLAG
, 0
, 0) CON_SOB_FLAG
, DCT.USER_CONVERSION_TYPE TRAN_RATE_TYPE
, TCAL.NAME TRANSACTION_CALENDAR_NAME
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(SOB.NET_INCOME_CODE_COMBINATION_ID) NET_INCOME_ACCOUNT
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.TRANSLATE_EOD_FLAG
, 0
, 0) TRAN_EOD_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.TRANSLATE_QATD_FLAG
, 0
, 0) TRAN_QATD_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.TRANSLATE_YATD_FLAG
, 0
, 0) TRAN_YATD_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.ENABLE_BUDGETARY_CONTROL_FLAG
, 0
, 0) BUD_CONTROL_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, SOB.REQUIRE_BUDGET_JOURNALS_FLAG
, 0
, 0) REQ_BUD_JOURNALS_FLAG
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(SOB.RES_ENCUMB_CODE_COMBINATION_ID) RES_ENCUMB_ACCOUNT
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_MRC_SET_OF_BOOKS_TYPE'
, SOB.MRC_SOB_TYPE_CODE ) MRC_SOB_TYPE
FROM FND_CURRENCIES_TL FCT
, FND_ID_FLEX_STRUCTURES_TL FIFS
, GL_PERIOD_TYPES GPT
, GL_NET_INCOME_ACCOUNTS NET
, GL_TRANSACTION_CALENDAR TCAL
, GL_DAILY_CONVERSION_TYPES DCT
, GL_SUSPENSE_ACCOUNTS SUS
, GL_SETS_OF_BOOKS SOB
WHERE FIFS.ID_FLEX_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FIFS.APPLICATION_ID = 101
AND FIFS.ID_FLEX_CODE = 'GL#'
AND FIFS.LANGUAGE = USERENV('LANG')
AND GPT.PERIOD_TYPE = SOB.ACCOUNTED_PERIOD_TYPE
AND SUS.SET_OF_BOOKS_ID(+) = SOB.SET_OF_BOOKS_ID
AND SUS.JE_SOURCE_NAME(+) = 'OTHER'
AND SUS.JE_CATEGORY_NAME(+) = 'OTHER'
AND TCAL.TRANSACTION_CALENDAR_ID(+) = SOB.TRANSACTION_CALENDAR_ID
AND DCT.CONVERSION_TYPE(+) = SOB.DAILY_TRANSLATION_RATE_TYPE
AND NET.CODE_COMBINATION_ID(+) = SOB.NET_INCOME_CODE_COMBINATION_ID
AND NET.SET_OF_BOOKS_ID(+) = SOB.SET_OF_BOOKS_ID
AND FCT.CURRENCY_CODE = SOB.CURRENCY_CODE
AND FCT.LANGUAGE = USERENV('LANG')

Columns