[Home] [Help]
| Product: | GL - General Ledger |
|---|---|
| Description: | 10SC ONLY |
| Implementation/DBA Data: | Not implemented in this database |
SELECT BA.LEDGER_ID LEDGER_ID
, BA.BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, BA.CODE_COMBINATION_ID CODE_COMBINATION_ID
, BA.CURRENCY_CODE CURRENCY_CODE
, BA.ENTRY_CODE ENTRY_CODE
, BA.ORDERING_VALUE ORDERING_VALUE
, BA.AUTOMATIC_ENCUMBRANCE_FLAG AUTOMATIC_ENCUMBRANCE_FLAG
, BA.FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE
, BA.AMOUNT_TYPE AMOUNT_TYPE
, BA.BOUNDARY_CODE BOUNDARY_CODE
, BA.FUNDING_BUDGET_VERSION_ID FUNDING_BUDGET_VERSION_ID
, BR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BR.PERIOD_YEAR PERIOD_YEAR
, BR.START_PERIOD_NAME START_PERIOD_NAME
, BR.START_PERIOD_NUM START_PERIOD_NUM
, BR.END_PERIOD_NAME END_PERIOD_NAME
, BR.END_PERIOD_NUM END_PERIOD_NUM
, BR.OPEN_FLAG OPEN_FLAG
FROM GL_BUDGET_ASSIGNMENTS BA
, GL_BUDGET_PERIOD_RANGES BR