[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 |