View: GLBV_BUDGET_BALANCES

View Text

SELECT GL_STANDARD_BALANCE.LEDGER_ID
, GL_LEDGERS.NAME
, GL_STANDARD_BALANCE.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, '_LA:DECODE(GL_STANDARD_BALANCE.TEMPLATE_ID
, NULL
, ''DTL''
, ''SUM''):GL_LOOKUPS:SUMMARY_FLAG:MEANING'
, GL_STANDARD_BALANCE.CURRENCY_CODE
, LK.MEANING
, GL_STANDARD_BALANCE.PERIOD_NAME
, GL_STANDARD_BALANCE.BUDGET_VERSION_ID
, GL_BUDGET_VERSION.BUDGET_NAME
, GL_STANDARD_BALANCE.PERIOD_NET_DR
, GL_STANDARD_BALANCE.PERIOD_NET_CR
, (GL_STANDARD_BALANCE.QUARTER_TO_DATE_DR + GL_STANDARD_BALANCE.PERIOD_NET_DR)
, (GL_STANDARD_BALANCE.QUARTER_TO_DATE_CR + GL_STANDARD_BALANCE.PERIOD_NET_CR)
, (GL_STANDARD_BALANCE.BEGIN_BALANCE_DR + GL_STANDARD_BALANCE.PERIOD_NET_DR)
, (GL_STANDARD_BALANCE.BEGIN_BALANCE_CR + GL_STANDARD_BALANCE.PERIOD_NET_CR)
, (GL_STANDARD_BALANCE.PROJECT_TO_DATE_DR + GL_STANDARD_BALANCE.PERIOD_NET_DR)
, (GL_STANDARD_BALANCE.PROJECT_TO_DATE_CR + GL_STANDARD_BALANCE.PERIOD_NET_CR)
, GL_STANDARD_BALANCE.BEGIN_BALANCE_DR
, GL_STANDARD_BALANCE.BEGIN_BALANCE_CR
FROM GL_LOOKUPS LK
, GL_BALANCES GL_STANDARD_BALANCE
, GL_LEDGERS GL_LEDGERS
, GL_CODE_COMBINATIONS GCC
, GL_BUDGET_VERSIONS GL_BUDGET_VERSION
WHERE (GL_STANDARD_BALANCE.LEDGER_ID = GL_LEDGERS.LEDGER_ID)
AND (GL_STANDARD_BALANCE.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID)
AND (GL_STANDARD_BALANCE.BUDGET_VERSION_ID = GL_BUDGET_VERSION.BUDGET_VERSION_ID)
AND (GL_STANDARD_BALANCE.ACTUAL_FLAG = 'B')
AND LK.LOOKUP_TYPE = 'CURRENCY_TYPE'
AND LK.LOOKUP_CODE = DECODE( GL_STANDARD_BALANCE.CURRENCY_CODE
, 'STAT'
, 'STAT'
, DECODE( GL_STANDARD_BALANCE.TRANSLATED_FLAG
, 'R'
, 'FE'
, 'N'
, 'FT'
, 'Y'
, 'FT'
, DECODE( GL_STANDARD_BALANCE.CURRENCY_CODE
, GL_LEDGERS.CURRENCY_CODE
, 'FUNC'
, 'FT' ) ) )
AND '_SEC:GL:GL_STANDARD_BALANCE.LEDGER_ID
, GL_STANDARD_BALANCE.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY

Columns