Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on GL_JE_HEADERS, GL_JE_LINES, GL_PERIODS and GL_SETS_OF_BOOKS |
Implementation/DBA Data: | APPS.IGI_BUD_HISTORY_ENTRIES_V |
SELECT GJH.SET_OF_BOOKS_ID
, GJH.CURRENCY_CODE
, GJH.BUDGET_VERSION_ID
, GP.PERIOD_YEAR
, GJL.CODE_COMBINATION_ID
, GJL.REFERENCE_1
, GJL.REFERENCE_2
, GJL.REFERENCE_9
, GJL.REFERENCE_10
, MAX(GJH.POSTED_DATE)
, MAX(GJL.REFERENCE_3)
, MAX(GJL.REFERENCE_4)
, MAX(GJL.REFERENCE_5)
, MAX(GJL.REFERENCE_6)
, MAX(GJL.REFERENCE_7)
, SUM(NVL(GJL.ENTERED_DR
, 0) - NVL(GJL.ENTERED_CR
, 0))
, SUM(NVL(GJL.REFERENCE_8
, 0))
FROM GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_PERIODS GP
, GL_SETS_OF_BOOKS GSOB
WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJH.STATUS = 'P'
AND GJH.BUDGET_VERSION_ID IS NOT NULL
AND GP.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME
AND GJH.PERIOD_NAME = GP.PERIOD_NAME
AND GJH.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND GJL.REFERENCE_1 LIKE 'IGIG%' GROUP BY GJH.SET_OF_BOOKS_ID
, GJH.CURRENCY_CODE
, GJH.BUDGET_VERSION_ID
, GP.PERIOD_YEAR
, GJL.CODE_COMBINATION_ID
, GJL.REFERENCE_1
, GJL.REFERENCE_2
, GJL.REFERENCE_9
, GJL.REFERENCE_10