[Home] [Help]
View: GL_BUDGETS_CONTROL_BUDGETS_V
View Text
SELECT BV1.BUDGET_NAME BUDGET_NAME
, BV1.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BV2.BUDGET_NAME DETAIL_BUDGET_NAME
, BV2.BUDGET_VERSION_ID DETAIL_BUDGET_VERSION_ID
, BV1.CONTROL_BUDGET_VERSION_ID CONTROL_BUDGET_VERSION_ID
, BUD.LEDGER_ID LEDGER_ID
, BUD.STATUS STATUS
, BUD.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, BUD.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
, BUD.LATEST_OPENED_YEAR LATEST_OPENED_YEAR
FROM GL_BUDGETS BUD
, GL_BUDGET_VERSIONS BV1
, GL_BUDGET_VERSIONS BV2
WHERE BUD.BUDGET_NAME = BV1.BUDGET_NAME AND BV1.BUDGET_VERSION_ID = BV2.CONTROL_BUDGET_VERSION_ID (+)
Columns
Name |
BUDGET_NAME |
BUDGET_VERSION_ID |
DETAIL_BUDGET_NAME |
DETAIL_BUDGET_VERSION_ID |
CONTROL_BUDGET_VERSION_ID |
LEDGER_ID |
STATUS |
FIRST_VALID_PERIOD_NAME |
LAST_VALID_PERIOD_NAME |
LATEST_OPENED_YEAR |