VIEW: APPS.GL_PERIOD_STATUSES_BUD_UPD_V

Source

View Text - Preformatted

SELECT new.period_name PERIOD_NAME, new.period_year PERIOD_YEAR, new.period_num PERIOD_NUM, old.ledger_id LEDGER_ID, bud.budget_name BUDGET_NAME, bv.budget_version_id BUDGET_VERSION_ID, old.period_year OLD_PERIOD_YEAR FROM gl_budgets bud, gl_budget_versions bv, gl_period_statuses old, gl_period_statuses new WHERE bud.budget_type = 'standard' AND bv.budget_name = bud.budget_name AND bv.budget_type = bud.budget_type AND old.application_id = 101 AND old.ledger_id = bud.ledger_id AND old.period_name = bud.last_valid_period_name AND new.application_id = 101 AND new.ledger_id = old.ledger_id AND new.period_num <= 60 AND new.period_year * 10000 + new.period_num >= old.period_year * 10000 + old.period_num

View Text - HTML Formatted

SELECT NEW.PERIOD_NAME PERIOD_NAME
, NEW.PERIOD_YEAR PERIOD_YEAR
, NEW.PERIOD_NUM PERIOD_NUM
, OLD.LEDGER_ID LEDGER_ID
, BUD.BUDGET_NAME BUDGET_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, OLD.PERIOD_YEAR OLD_PERIOD_YEAR
FROM GL_BUDGETS BUD
, GL_BUDGET_VERSIONS BV
, GL_PERIOD_STATUSES OLD
, GL_PERIOD_STATUSES NEW
WHERE BUD.BUDGET_TYPE = 'STANDARD'
AND BV.BUDGET_NAME = BUD.BUDGET_NAME
AND BV.BUDGET_TYPE = BUD.BUDGET_TYPE
AND OLD.APPLICATION_ID = 101
AND OLD.LEDGER_ID = BUD.LEDGER_ID
AND OLD.PERIOD_NAME = BUD.LAST_VALID_PERIOD_NAME
AND NEW.APPLICATION_ID = 101
AND NEW.LEDGER_ID = OLD.LEDGER_ID
AND NEW.PERIOD_NUM <= 60
AND NEW.PERIOD_YEAR * 10000 + NEW.PERIOD_NUM >= OLD.PERIOD_YEAR * 10000 + OLD.PERIOD_NUM