[Home] [Help]
View: GLFV_GL_BUDGET_ORGANIZATIONS
View Text
SELECT GLBO.BUDGET_ENTITY_ID
, GLBO.NAME
, GLBO.LEDGER_ID
, GL_LEDGERS.NAME
, GLBO.START_DATE
, GLBO.END_DATE
, GLBO.DESCRIPTION
, '_LA:GLBO.BUDGET_PASSWORD_REQUIRED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_DF:SQLGL:GL_BUDGET_ENTITIES:GLBO'
FROM GL_BUDGET_ENTITIES GLBO
, GL_LEDGERS GL_LEDGERS
WHERE (GLBO.LEDGER_ID = GL_LEDGERS.LEDGER_ID)
AND '_SEC:GL:GLBO.LEDGER_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| BUDGET_ORGANIZATION_ID |
| BUDGET_ORGANIZATION_NAME |
| LEDGER_ID |
| LEDGER_NAME |
| START_EFFECTIVE_DATE |
| END_EFFECTIVE_DATE |
| DESCRIPTION |
| "_LA:REQUIRE_PASSWORD_FLAG" |
| _DF |