VIEW: APPS.GL_SETS_OF_BOOKS

Source

View Text - Preformatted

SELECT lgr.LEDGER_ID SET_OF_BOOKS_ID, lgr.NAME NAME, lgr.SHORT_NAME SHORT_NAME, lgr.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, lgr.CURRENCY_CODE CURRENCY_CODE, lgr.PERIOD_SET_NAME PERIOD_SET_NAME, lgr.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE, lgr.SUSPENSE_ALLOWED_FLAG SUSPENSE_ALLOWED_FLAG, lgr.ALLOW_INTERCOMPANY_POST_FLAG ALLOW_INTERCOMPANY_POST_FLAG, lgr.TRACK_ROUNDING_IMBALANCE_FLAG TRACK_ROUNDING_IMBALANCE_FLAG, lgr.ENABLE_AVERAGE_BALANCES_FLAG ENABLE_AVERAGE_BALANCES_FLAG, lgr.ENABLE_BUDGETARY_CONTROL_FLAG ENABLE_BUDGETARY_CONTROL_FLAG, lgr.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG, lgr.ENABLE_JE_APPROVAL_FLAG ENABLE_JE_APPROVAL_FLAG, lgr.ENABLE_AUTOMATIC_TAX_FLAG ENABLE_AUTOMATIC_TAX_FLAG, lgr.CONSOLIDATION_LEDGER_FLAG CONSOLIDATION_SOB_FLAG, lgr.TRANSLATE_EOD_FLAG TRANSLATE_EOD_FLAG, lgr.TRANSLATE_QATD_FLAG TRANSLATE_QATD_FLAG, lgr.TRANSLATE_YATD_FLAG TRANSLATE_YATD_FLAG, decode(lgr.alc_ledger_type_code, 'TARGET', 'R', 'SOURCE', 'P', 'N') MRC_SOB_TYPE_CODE, 'N' ALLOW_POSTING_WARNING_FLAG, lgr.LAST_UPDATE_DATE LAST_UPDATE_DATE, lgr.LAST_UPDATED_BY LAST_UPDATED_BY, lgr.CREATION_DATE CREATION_DATE, lgr.CREATED_BY CREATED_BY, lgr.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, lgr.FUTURE_ENTERABLE_PERIODS_LIMIT FUTURE_ENTERABLE_PERIODS_LIMIT, lgr.LATEST_OPENED_PERIOD_NAME LATEST_OPENED_PERIOD_NAME, lgr.LATEST_ENCUMBRANCE_YEAR LATEST_ENCUMBRANCE_YEAR, lgr.RET_EARN_CODE_COMBINATION_ID RET_EARN_CODE_COMBINATION_ID, lgr.CUM_TRANS_CODE_COMBINATION_ID CUM_TRANS_CODE_COMBINATION_ID, lgr.RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID, lgr.NET_INCOME_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID, lgr.ROUNDING_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID, lgr.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID, lgr.DAILY_TRANSLATION_RATE_TYPE DAILY_TRANSLATION_RATE_TYPE, NULL EARLIEST_UNTRANS_PERIOD_NAME, lgr.DESCRIPTION DESCRIPTION, lgr.ATTRIBUTE1 ATTRIBUTE1, lgr.ATTRIBUTE2 ATTRIBUTE2, lgr.ATTRIBUTE3 ATTRIBUTE3, lgr.ATTRIBUTE4 ATTRIBUTE4, lgr.ATTRIBUTE5 ATTRIBUTE5, lgr.ATTRIBUTE6 ATTRIBUTE6, lgr.ATTRIBUTE7 ATTRIBUTE7, lgr.ATTRIBUTE8 ATTRIBUTE8, lgr.ATTRIBUTE9 ATTRIBUTE9, lgr.ATTRIBUTE10 ATTRIBUTE10, lgr.ATTRIBUTE11 ATTRIBUTE11, lgr.ATTRIBUTE12 ATTRIBUTE12, lgr.ATTRIBUTE13 ATTRIBUTE13, lgr.ATTRIBUTE14 ATTRIBUTE14, lgr.ATTRIBUTE15 ATTRIBUTE15, lgr.CONTEXT CONTEXT, NULL GLOBAL_ATTRIBUTE_CATEGORY, NULL GLOBAL_ATTRIBUTE1, NULL GLOBAL_ATTRIBUTE2, NULL GLOBAL_ATTRIBUTE3, NULL GLOBAL_ATTRIBUTE4, NULL GLOBAL_ATTRIBUTE5, NULL GLOBAL_ATTRIBUTE6, NULL GLOBAL_ATTRIBUTE7, NULL GLOBAL_ATTRIBUTE8, NULL GLOBAL_ATTRIBUTE9, NULL GLOBAL_ATTRIBUTE10, lgr.SLA_LEDGER_CASH_BASIS_FLAG SLA_LEDGER_CASH_BASIS_FLAG FROM gl_ledgers lgr WHERE object_type_code = 'L' AND nvl(complete_flag, 'Y') = 'Y'

View Text - HTML Formatted

SELECT LGR.LEDGER_ID SET_OF_BOOKS_ID
, LGR.NAME NAME
, LGR.SHORT_NAME SHORT_NAME
, LGR.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, LGR.CURRENCY_CODE CURRENCY_CODE
, LGR.PERIOD_SET_NAME PERIOD_SET_NAME
, LGR.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, LGR.SUSPENSE_ALLOWED_FLAG SUSPENSE_ALLOWED_FLAG
, LGR.ALLOW_INTERCOMPANY_POST_FLAG ALLOW_INTERCOMPANY_POST_FLAG
, LGR.TRACK_ROUNDING_IMBALANCE_FLAG TRACK_ROUNDING_IMBALANCE_FLAG
, LGR.ENABLE_AVERAGE_BALANCES_FLAG ENABLE_AVERAGE_BALANCES_FLAG
, LGR.ENABLE_BUDGETARY_CONTROL_FLAG ENABLE_BUDGETARY_CONTROL_FLAG
, LGR.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, LGR.ENABLE_JE_APPROVAL_FLAG ENABLE_JE_APPROVAL_FLAG
, LGR.ENABLE_AUTOMATIC_TAX_FLAG ENABLE_AUTOMATIC_TAX_FLAG
, LGR.CONSOLIDATION_LEDGER_FLAG CONSOLIDATION_SOB_FLAG
, LGR.TRANSLATE_EOD_FLAG TRANSLATE_EOD_FLAG
, LGR.TRANSLATE_QATD_FLAG TRANSLATE_QATD_FLAG
, LGR.TRANSLATE_YATD_FLAG TRANSLATE_YATD_FLAG
, DECODE(LGR.ALC_LEDGER_TYPE_CODE
, 'TARGET'
, 'R'
, 'SOURCE'
, 'P'
, 'N') MRC_SOB_TYPE_CODE
, 'N' ALLOW_POSTING_WARNING_FLAG
, LGR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LGR.LAST_UPDATED_BY LAST_UPDATED_BY
, LGR.CREATION_DATE CREATION_DATE
, LGR.CREATED_BY CREATED_BY
, LGR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LGR.FUTURE_ENTERABLE_PERIODS_LIMIT FUTURE_ENTERABLE_PERIODS_LIMIT
, LGR.LATEST_OPENED_PERIOD_NAME LATEST_OPENED_PERIOD_NAME
, LGR.LATEST_ENCUMBRANCE_YEAR LATEST_ENCUMBRANCE_YEAR
, LGR.RET_EARN_CODE_COMBINATION_ID RET_EARN_CODE_COMBINATION_ID
, LGR.CUM_TRANS_CODE_COMBINATION_ID CUM_TRANS_CODE_COMBINATION_ID
, LGR.RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID
, LGR.NET_INCOME_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID
, LGR.ROUNDING_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID
, LGR.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID
, LGR.DAILY_TRANSLATION_RATE_TYPE DAILY_TRANSLATION_RATE_TYPE
, NULL EARLIEST_UNTRANS_PERIOD_NAME
, LGR.DESCRIPTION DESCRIPTION
, LGR.ATTRIBUTE1 ATTRIBUTE1
, LGR.ATTRIBUTE2 ATTRIBUTE2
, LGR.ATTRIBUTE3 ATTRIBUTE3
, LGR.ATTRIBUTE4 ATTRIBUTE4
, LGR.ATTRIBUTE5 ATTRIBUTE5
, LGR.ATTRIBUTE6 ATTRIBUTE6
, LGR.ATTRIBUTE7 ATTRIBUTE7
, LGR.ATTRIBUTE8 ATTRIBUTE8
, LGR.ATTRIBUTE9 ATTRIBUTE9
, LGR.ATTRIBUTE10 ATTRIBUTE10
, LGR.ATTRIBUTE11 ATTRIBUTE11
, LGR.ATTRIBUTE12 ATTRIBUTE12
, LGR.ATTRIBUTE13 ATTRIBUTE13
, LGR.ATTRIBUTE14 ATTRIBUTE14
, LGR.ATTRIBUTE15 ATTRIBUTE15
, LGR.CONTEXT CONTEXT
, NULL GLOBAL_ATTRIBUTE_CATEGORY
, NULL GLOBAL_ATTRIBUTE1
, NULL GLOBAL_ATTRIBUTE2
, NULL GLOBAL_ATTRIBUTE3
, NULL GLOBAL_ATTRIBUTE4
, NULL GLOBAL_ATTRIBUTE5
, NULL GLOBAL_ATTRIBUTE6
, NULL GLOBAL_ATTRIBUTE7
, NULL GLOBAL_ATTRIBUTE8
, NULL GLOBAL_ATTRIBUTE9
, NULL GLOBAL_ATTRIBUTE10
, LGR.SLA_LEDGER_CASH_BASIS_FLAG SLA_LEDGER_CASH_BASIS_FLAG
FROM GL_LEDGERS LGR
WHERE OBJECT_TYPE_CODE = 'L'
AND NVL(COMPLETE_FLAG
, 'Y') = 'Y'