View: GL_PERIOD_STATUSES_BUD_UPD_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_PERIOD_STATUSES_BUD_UPD_V

View Text

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

Columns