[Home] [Help]
View: GL_BUDGETS_REQUIRE_JOURNALS_V
View Text
SELECT BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BUD.BUDGET_NAME BUDGET_NAME
, BUD.LEDGER_ID LEDGER_ID
FROM GL_BUDGETS BUD
, GL_BUDGET_VERSIONS BV
WHERE BUD.BUDGET_NAME = BV.BUDGET_NAME
AND BUD.BUDGET_TYPE = BV.BUDGET_TYPE
AND BUD.STATUS IN ('O'
, 'C')
AND BUD.REQUIRE_BUDGET_JOURNALS_FLAG = 'Y'
Columns
Name |
BUDGET_VERSION_ID |
BUDGET_NAME |
LEDGER_ID |