View: GL_SETS_OF_BOOKS_V

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

View Text

SELECT LGR.ROWID ROW_ID
, LGR.LEDGER_ID SET_OF_BOOKS_ID
, LGR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LGR.LAST_UPDATED_BY LAST_UPDATED_BY
, LGR.CURRENCY_CODE CURRENCY_CODE
, LGR.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, FIFS.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, LGR.NAME NAME
, LGR.PERIOD_SET_NAME PERIOD_SET_NAME
, LGR.SUSPENSE_ALLOWED_FLAG SUSPENSE_ALLOWED_FLAG
, 'N' ALLOW_POSTING_WARNING_FLAG
, LGR.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, GPT.USER_PERIOD_TYPE USER_PERIOD_TYPE
, LGR.SHORT_NAME SHORT_NAME
, LGR.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, LGR.ENABLE_BUDGETARY_CONTROL_FLAG ENABLE_BUDGETARY_CONTROL_FLAG
, LGR.ALLOW_INTERCOMPANY_POST_FLAG ALLOW_INTERCOMPANY_POST_FLAG
, LGR.CREATION_DATE CREATION_DATE
, LGR.CREATED_BY CREATED_BY
, LGR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LGR.LATEST_ENCUMBRANCE_YEAR LATEST_ENCUMBRANCE_YEAR
, NULL EARLIEST_UNTRANS_PERIOD_NAME
, LGR.CUM_TRANS_CODE_COMBINATION_ID CUM_TRANS_CODE_COMBINATION_ID
, LGR.FUTURE_ENTERABLE_PERIODS_LIMIT FUTURE_ENTERABLE_PERIODS_LIMIT
, LGR.LATEST_OPENED_PERIOD_NAME LATEST_OPENED_PERIOD_NAME
, LGR.RET_EARN_CODE_COMBINATION_ID RET_EARN_CODE_COMBINATION_ID
, LGR.RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID
, SUS.CODE_COMBINATION_ID SUSPENSE_CCID
, LGR.NET_INCOME_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID
, LGR.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID
, LGR.ENABLE_AVERAGE_BALANCES_FLAG ENABLE_AVGBAL_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
, LGR.DAILY_TRANSLATION_RATE_TYPE DAILY_TRANSLATION_RATE_TYPE
, 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.ENABLE_AUTOMATIC_TAX_FLAG ENABLE_AUTOMATIC_TAX_FLAG
, LGR.ENABLE_JE_APPROVAL_FLAG ENABLE_JE_APPROVAL_FLAG
, TCAL.NAME TRANSACTION_CALENDAR_NAME
, NET.BAL_SEG_VALUE BALANCING_SEGMENT
, DCT.USER_CONVERSION_TYPE DAILY_USER_TRANSLATION_TYPE
, DECODE(LGR.ALC_LEDGER_TYPE_CODE
, 'TARGET'
, 'R'
, 'SOURCE'
, 'P'
, 'N') MRC_SOB_TYPE_CODE
, LGR.TRACK_ROUNDING_IMBALANCE_FLAG TRACK_ROUNDING_IMBALANCE_FLAG
, LGR.ROUNDING_CODE_COMBINATION_ID ROUNDING_CCID
FROM FND_ID_FLEX_STRUCTURES_TL FIFS
, GL_PERIOD_TYPES GPT
, GL_NET_INCOME_ACCOUNTS NET
, GL_TRANSACTION_CALENDAR TCAL
, GL_DAILY_CONVERSION_TYPES DCT
, GL_SUSPENSE_ACCOUNTS SUS
, GL_LEDGERS LGR
WHERE LGR.OBJECT_TYPE_CODE = 'L'
AND LGR.LE_LEDGER_TYPE_CODE = 'L'
AND NVL(LGR.COMPLETE_FLAG
, 'Y') = 'Y'
AND FIFS.ID_FLEX_NUM = LGR.CHART_OF_ACCOUNTS_ID
AND FIFS.APPLICATION_ID = 101
AND FIFS.ID_FLEX_CODE = 'GL#'
AND FIFS.LANGUAGE = USERENV('LANG')
AND GPT.PERIOD_TYPE = LGR.ACCOUNTED_PERIOD_TYPE
AND SUS.LEDGER_ID(+) = LGR.LEDGER_ID AND SUS.JE_SOURCE_NAME(+) = 'OTHER' AND SUS.JE_CATEGORY_NAME(+) = 'OTHER'
AND TCAL.TRANSACTION_CALENDAR_ID(+) = LGR.TRANSACTION_CALENDAR_ID
AND DCT.CONVERSION_TYPE(+) = LGR.DAILY_TRANSLATION_RATE_TYPE
AND NET.CODE_COMBINATION_ID(+) = LGR.NET_INCOME_CODE_COMBINATION_ID
AND NET.LEDGER_ID(+) = LGR.LEDGER_ID

Columns