View: IGI_BUD_PROFILE_PERIODS_V

Product:	IGI - Public Sector Financials International
Description:	Based on GL_PERIODS, GL_SETS_OF_BOOKS and IGI_BUD_PROFILE_PERIODS
Implementation/DBA Data:	APPS.IGI_BUD_PROFILE_PERIODS_V

View Text

SELECT JE.ROWID
, JE.PROFILE_CODE
, JE.SET_OF_BOOKS_ID
, JE.PERIOD_NUMBER
, JE.PERIOD_RATIO
, JE.CREATION_DATE
, JE.CREATED_BY
, JE.LAST_UPDATE_DATE
, JE.LAST_UPDATED_BY
, JE.LAST_UPDATE_LOGIN
, GP.ENTERED_PERIOD_NAME
FROM GL_PERIODS GP
, GL_SETS_OF_BOOKS GSOB
, IGI_BUD_PROFILE_PERIODS JE
WHERE JE.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND GP.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME
AND GP.PERIOD_TYPE = GSOB.ACCOUNTED_PERIOD_TYPE
AND GP.PERIOD_NUM = JE.PERIOD_NUMBER
AND GP.PERIOD_YEAR = (SELECT MAX(PERIOD_YEAR)
FROM GL_PERIODS
WHERE PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME )

Columns