View: GL_LEDGERS_V

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

View Text

SELECT LEDGER.ROWID ROW_ID
, LEDGER.LEDGER_ID LEDGER_ID
, LEDGER.NAME NAME
, LEDGER.SHORT_NAME SHORT_NAME
, LEDGER.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, FIFS.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, LEDGER.CURRENCY_CODE CURRENCY_CODE
, LEDGER.PERIOD_SET_NAME PERIOD_SET_NAME
, GPT.USER_PERIOD_TYPE USER_PERIOD_TYPE
, LEDGER.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, LEDGER.FIRST_LEDGER_PERIOD_NAME FIRST_LEDGER_PERIOD_NAME
, LEDGER.RET_EARN_CODE_COMBINATION_ID RET_EARN_CODE_COMBINATION_ID
, LEDGER.SUSPENSE_ALLOWED_FLAG SUSPENSE_ALLOWED_FLAG
, SUS.CODE_COMBINATION_ID SUSPENSE_CCID
, LEDGER.ALLOW_INTERCOMPANY_POST_FLAG ALLOW_INTERCOMPANY_POST_FLAG
, LEDGER.ENABLE_AVERAGE_BALANCES_FLAG ENABLE_AVGBAL_FLAG
, LEDGER.ENABLE_BUDGETARY_CONTROL_FLAG ENABLE_BUDGETARY_CONTROL_FLAG
, LEDGER.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, LEDGER.ENABLE_JE_APPROVAL_FLAG ENABLE_JE_APPROVAL_FLAG
, LEDGER.ENABLE_AUTOMATIC_TAX_FLAG ENABLE_AUTOMATIC_TAX_FLAG
, LEDGER.CONSOLIDATION_LEDGER_FLAG CONSOLIDATION_LEDGER_FLAG
, LEDGER.TRANSLATE_EOD_FLAG TRANSLATE_EOD_FLAG
, LEDGER.TRANSLATE_QATD_FLAG TRANSLATE_QATD_FLAG
, LEDGER.TRANSLATE_YATD_FLAG TRANSLATE_YATD_FLAG
, LEDGER.AUTOMATICALLY_CREATED_FLAG AUTOMATICALLY_CREATED_FLAG
, LEDGER.TRACK_ROUNDING_IMBALANCE_FLAG TRACK_ROUNDING_IMBALANCE_FLAG
, LEDGER.ALC_LEDGER_TYPE_CODE ALC_LEDGER_TYPE_CODE
, LEDGER.LE_LEDGER_TYPE_CODE LE_LEDGER_TYPE_CODE
, LEDGER.BAL_SEG_VALUE_OPTION_CODE BAL_SEG_VALUE_OPTION_CODE
, LEDGER.BAL_SEG_COLUMN_NAME BAL_SEG_COLUMN_NAME
, LEDGER.BAL_SEG_VALUE_SET_ID BAL_SEG_VALUE_SET_ID
, LEDGER.MGT_SEG_VALUE_OPTION_CODE MGT_SEG_VALUE_OPTION_CODE
, LEDGER.MGT_SEG_COLUMN_NAME MGT_SEG_COLUMN_NAME
, LEDGER.MGT_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID
, LEDGER.IMPLICIT_ACCESS_SET_ID
, LEDGER.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LEDGER.LAST_UPDATED_BY LAST_UPDATED_BY
, LEDGER.CREATION_DATE CREATION_DATE
, LEDGER.CREATED_BY CREATED_BY
, LEDGER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LEDGER.IMPLICIT_LEDGER_SET_ID
, LEDGER.DESCRIPTION DESCRIPTION
, LEDGER.FUTURE_ENTERABLE_PERIODS_LIMIT FUTURE_ENTERABLE_PERIODS_LIMIT
, LEDGER.LATEST_OPENED_PERIOD_NAME LATEST_OPENED_PERIOD_NAME
, LEDGER.LATEST_ENCUMBRANCE_YEAR LATEST_ENCUMBRANCE_YEAR
, LEDGER.CUM_TRANS_CODE_COMBINATION_ID CUM_TRANS_CODE_COMBINATION_ID
, LEDGER.RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID
, LEDGER.NET_INCOME_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID
, NET.BAL_SEG_VALUE BALANCING_SEGMENT
, LEDGER.ROUNDING_CODE_COMBINATION_ID ROUNDING_CCID
, LEDGER.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID
, TCAL.NAME TRANSACTION_CALENDAR_NAME
, LEDGER.DAILY_TRANSLATION_RATE_TYPE DAILY_TRANSLATION_RATE_TYPE
, DCT1.USER_CONVERSION_TYPE DAILY_USER_TRANSLATION_TYPE
, LEDGER.PERIOD_AVERAGE_RATE_TYPE PERIOD_AVERAGE_RATE_TYPE
, DCT2.USER_CONVERSION_TYPE PERIOD_AVERAGE_USER_RATE_TYPE
, LEDGER.PERIOD_END_RATE_TYPE PERIOD_END_RATE_TYPE
, DCT3.USER_CONVERSION_TYPE PERIOD_END_USER_RATE_TYPE
, LEDGER.CONTEXT CONTEXT
, LEDGER.ATTRIBUTE1 ATTRIBUTE1
, LEDGER.ATTRIBUTE2 ATTRIBUTE2
, LEDGER.ATTRIBUTE3 ATTRIBUTE3
, LEDGER.ATTRIBUTE4 ATTRIBUTE4
, LEDGER.ATTRIBUTE5 ATTRIBUTE5
, LEDGER.ATTRIBUTE6 ATTRIBUTE6
, LEDGER.ATTRIBUTE7 ATTRIBUTE7
, LEDGER.ATTRIBUTE8 ATTRIBUTE8
, LEDGER.ATTRIBUTE9 ATTRIBUTE9
, LEDGER.ATTRIBUTE10 ATTRIBUTE10
, LEDGER.ATTRIBUTE11 ATTRIBUTE11
, LEDGER.ATTRIBUTE12 ATTRIBUTE12
, LEDGER.ATTRIBUTE13 ATTRIBUTE13
, LEDGER.ATTRIBUTE14 ATTRIBUTE14
, LEDGER.ATTRIBUTE15 ATTRIBUTE15
, LEDGER.NET_CLOSING_BAL_FLAG
, LEDGER.AUTOMATE_SEC_JRNL_REV_FLAG
FROM FND_ID_FLEX_STRUCTURES_TL FIFS
, GL_PERIOD_TYPES GPT
, GL_NET_INCOME_ACCOUNTS NET
, GL_TRANSACTION_CALENDAR TCAL
, GL_DAILY_CONVERSION_TYPES DCT1
, GL_DAILY_CONVERSION_TYPES DCT2
, GL_DAILY_CONVERSION_TYPES DCT3
, GL_SUSPENSE_ACCOUNTS SUS
, GL_LEDGERS LEDGER
WHERE FIFS.ID_FLEX_NUM = LEDGER.CHART_OF_ACCOUNTS_ID
AND FIFS.APPLICATION_ID = 101
AND FIFS.ID_FLEX_CODE = 'GL#'
AND FIFS.LANGUAGE = USERENV('LANG')
AND GPT.PERIOD_TYPE = LEDGER.ACCOUNTED_PERIOD_TYPE
AND SUS.LEDGER_ID(+) = LEDGER.LEDGER_ID
AND SUS.JE_SOURCE_NAME(+) = 'OTHER'
AND SUS.JE_CATEGORY_NAME(+) = 'OTHER'
AND TCAL.TRANSACTION_CALENDAR_ID(+) = LEDGER.TRANSACTION_CALENDAR_ID
AND DCT1.CONVERSION_TYPE(+) = LEDGER.DAILY_TRANSLATION_RATE_TYPE
AND DCT2.CONVERSION_TYPE(+) = LEDGER.PERIOD_AVERAGE_RATE_TYPE
AND DCT3.CONVERSION_TYPE(+) = LEDGER.PERIOD_END_RATE_TYPE
AND NET.CODE_COMBINATION_ID(+) = LEDGER.NET_INCOME_CODE_COMBINATION_ID
AND NET.LEDGER_ID(+) = LEDGER.LEDGER_ID
AND LEDGER.OBJECT_TYPE_CODE = 'L' ORDER BY LEDGER.NAME

Columns