[Home] [Help]
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
Name |
ROW_ID |
PROFILE_CODE |
SET_OF_BOOKS_ID |
PERIOD_NUMBER |
PERIOD_RATIO |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
PERIOD_NAME |