View: GL_LEDGERS_PUBLIC_ALL_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_LEDGERS_PUBLIC_ALL_V

View Text

SELECT LGR.LEDGER_ID LEDGER_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_LEDGER_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
, 'SOURCE'
, 'P'
, 'TARGET'
, 'R'
, 'N') MRC_LEDGER_TYPE_CODE
, 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_CCID
, LGR.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID
, LGR.DAILY_TRANSLATION_RATE_TYPE DAILY_TRANSLATION_RATE_TYPE
, LGR.PERIOD_AVERAGE_RATE_TYPE PERIOD_AVERAGE_RATE_TYPE
, LGR.PERIOD_END_RATE_TYPE PERIOD_END_RATE_TYPE
, LGR.BAL_SEG_VALUE_OPTION_CODE BAL_SEG_VALUE_OPTION_CODE
, LGR.MGT_SEG_VALUE_OPTION_CODE MGT_SEG_VALUE_OPTION_CODE
, LGR.BAL_SEG_VALUE_SET_ID BAL_SEG_VALUE_SET_ID
, LGR.MGT_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID
, LGR.BAL_SEG_COLUMN_NAME BAL_SEG_COLUMN_NAME
, LGR.MGT_SEG_COLUMN_NAME MGT_SEG_COLUMN_NAME
, LGR.IMPLICIT_ACCESS_SET_ID IMPLICIT_ACCESS_SET_ID
, LGR.IMPLICIT_LEDGER_SET_ID IMPLICIT_LEDGER_SET_ID
, LGR.FIRST_LEDGER_PERIOD_NAME FIRST_LEDGER_PERIOD_NAME
, LGR.DESCRIPTION DESCRIPTION
, LGR.LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE
, LGR.CONFIGURATION_ID CONFIGURATION_ID
, 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
FROM GL_LEDGERS LGR
WHERE OBJECT_TYPE_CODE = 'L'

Columns