VIEW: APPS.GL_LEDGERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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