DBA Data[Home] [Help]

VIEW: GL.GL_BALANCES#

Source

View Text - Preformatted

select LEDGER_ID LEDGER_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, CURRENCY_CODE CURRENCY_CODE, PERIOD_NAME PERIOD_NAME, ACTUAL_FLAG ACTUAL_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, BUDGET_VERSION_ID BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, TRANSLATED_FLAG TRANSLATED_FLAG, REVALUATION_STATUS REVALUATION_STATUS, PERIOD_TYPE PERIOD_TYPE, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, PERIOD_NET_DR PERIOD_NET_DR, PERIOD_NET_CR PERIOD_NET_CR, PERIOD_TO_DATE_ADB PERIOD_TO_DATE_ADB, QUARTER_TO_DATE_DR QUARTER_TO_DATE_DR, QUARTER_TO_DATE_CR QUARTER_TO_DATE_CR, QUARTER_TO_DATE_ADB QUARTER_TO_DATE_ADB, YEAR_TO_DATE_ADB YEAR_TO_DATE_ADB, PROJECT_TO_DATE_DR PROJECT_TO_DATE_DR, PROJECT_TO_DATE_CR PROJECT_TO_DATE_CR, PROJECT_TO_DATE_ADB PROJECT_TO_DATE_ADB, BEGIN_BALANCE_DR BEGIN_BALANCE_DR, BEGIN_BALANCE_CR BEGIN_BALANCE_CR, PERIOD_NET_DR_BEQ PERIOD_NET_DR_BEQ, PERIOD_NET_CR_BEQ PERIOD_NET_CR_BEQ, BEGIN_BALANCE_DR_BEQ BEGIN_BALANCE_DR_BEQ, BEGIN_BALANCE_CR_BEQ BEGIN_BALANCE_CR_BEQ, TEMPLATE_ID TEMPLATE_ID, ENCUMBRANCE_DOC_ID ENCUMBRANCE_DOC_ID, ENCUMBRANCE_LINE_NUM ENCUMBRANCE_LINE_NUM, QUARTER_TO_DATE_DR_BEQ QUARTER_TO_DATE_DR_BEQ, QUARTER_TO_DATE_CR_BEQ QUARTER_TO_DATE_CR_BEQ, PROJECT_TO_DATE_DR_BEQ PROJECT_TO_DATE_DR_BEQ, PROJECT_TO_DATE_CR_BEQ PROJECT_TO_DATE_CR_BEQ from "GL"."GL_BALANCES"
View Text - HTML Formatted

SELECT LEDGER_ID LEDGER_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, CURRENCY_CODE CURRENCY_CODE
, PERIOD_NAME PERIOD_NAME
, ACTUAL_FLAG ACTUAL_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, TRANSLATED_FLAG TRANSLATED_FLAG
, REVALUATION_STATUS REVALUATION_STATUS
, PERIOD_TYPE PERIOD_TYPE
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, PERIOD_NET_DR PERIOD_NET_DR
, PERIOD_NET_CR PERIOD_NET_CR
, PERIOD_TO_DATE_ADB PERIOD_TO_DATE_ADB
, QUARTER_TO_DATE_DR QUARTER_TO_DATE_DR
, QUARTER_TO_DATE_CR QUARTER_TO_DATE_CR
, QUARTER_TO_DATE_ADB QUARTER_TO_DATE_ADB
, YEAR_TO_DATE_ADB YEAR_TO_DATE_ADB
, PROJECT_TO_DATE_DR PROJECT_TO_DATE_DR
, PROJECT_TO_DATE_CR PROJECT_TO_DATE_CR
, PROJECT_TO_DATE_ADB PROJECT_TO_DATE_ADB
, BEGIN_BALANCE_DR BEGIN_BALANCE_DR
, BEGIN_BALANCE_CR BEGIN_BALANCE_CR
, PERIOD_NET_DR_BEQ PERIOD_NET_DR_BEQ
, PERIOD_NET_CR_BEQ PERIOD_NET_CR_BEQ
, BEGIN_BALANCE_DR_BEQ BEGIN_BALANCE_DR_BEQ
, BEGIN_BALANCE_CR_BEQ BEGIN_BALANCE_CR_BEQ
, TEMPLATE_ID TEMPLATE_ID
, ENCUMBRANCE_DOC_ID ENCUMBRANCE_DOC_ID
, ENCUMBRANCE_LINE_NUM ENCUMBRANCE_LINE_NUM
, QUARTER_TO_DATE_DR_BEQ QUARTER_TO_DATE_DR_BEQ
, QUARTER_TO_DATE_CR_BEQ QUARTER_TO_DATE_CR_BEQ
, PROJECT_TO_DATE_DR_BEQ PROJECT_TO_DATE_DR_BEQ
, PROJECT_TO_DATE_CR_BEQ PROJECT_TO_DATE_CR_BEQ
FROM "GL"."GL_BALANCES"