Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GL_SETS_OF_BOOKS |
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'