VIEW: APPS.IGI_BUD_PROFILE_PERIODS_V

Source

View Text - Preformatted

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(gp1.period_year) from gl_periods gp1 , gl_period_types gpt ,gl_sets_of_books gsob1 where gp1.period_type = gsob.accounted_period_type and gp1.period_set_name = gsob.period_set_name and gp1.period_num = gpt.number_per_fiscal_year and gp1.period_type = gpt.period_type and gsob1.set_of_books_id=gsob.set_of_books_id and gpt.number_per_fiscal_year = ( select count(period_num) from gl_periods where period_year = gp1.period_year and period_type = gsob.accounted_period_type and period_set_name = gsob.period_set_name ) )

View Text - HTML Formatted

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(GP1.PERIOD_YEAR)
FROM GL_PERIODS GP1
, GL_PERIOD_TYPES GPT
, GL_SETS_OF_BOOKS GSOB1
WHERE GP1.PERIOD_TYPE = GSOB.ACCOUNTED_PERIOD_TYPE
AND GP1.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME
AND GP1.PERIOD_NUM = GPT.NUMBER_PER_FISCAL_YEAR
AND GP1.PERIOD_TYPE = GPT.PERIOD_TYPE
AND GSOB1.SET_OF_BOOKS_ID=GSOB.SET_OF_BOOKS_ID
AND GPT.NUMBER_PER_FISCAL_YEAR = ( SELECT COUNT(PERIOD_NUM)
FROM GL_PERIODS
WHERE PERIOD_YEAR = GP1.PERIOD_YEAR
AND PERIOD_TYPE = GSOB.ACCOUNTED_PERIOD_TYPE
AND PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME ) )