SELECT bv.budget_version_id BUDGET_VERSION_ID, bud.budget_name BUDGET_NAME, bud.ledger_id ledger_id, bud.first_valid_period_name FIRST_VALID_PERIOD_NAME, bud.last_valid_period_name LAST_VALID_PERIOD_NAME 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', 'F')
SELECT BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BUD.BUDGET_NAME BUDGET_NAME
, BUD.LEDGER_ID LEDGER_ID
, BUD.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, BUD.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
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'
, 'F')
|
|
|