[Home] [Help]
| Product: | GL - General Ledger |
|---|---|
| Description: | Encumbrance Balances are commitments, obligations, and other planned expenditures. You may only have functional currency encumbrance balances. |
| Implementation/DBA Data: | Not implemented in this database |
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.PERIOD_NAME
, GL_STANDARD_BALANCE.ENCUMBRANCE_TYPE_ID
, GL_ENCUMBRANCE_TYPE.ENCUMBRANCE_TYPE
, 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_BALANCES GL_STANDARD_BALANCE
, GL_LEDGERS GL_LEDGERS
, GL_CODE_COMBINATIONS GCC
, GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPE
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.ENCUMBRANCE_TYPE_ID = GL_ENCUMBRANCE_TYPE.ENCUMBRANCE_TYPE_ID)
AND (GL_STANDARD_BALANCE.ACTUAL_FLAG = 'E')
AND '_SEC:GL:GL_STANDARD_BALANCE.LEDGER_ID
, GL_STANDARD_BALANCE.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY