VIEW: APPS.IGI_BUD_HISTORY_ENTRIES_V

Source

View Text - Preformatted

SELECT gjh.ledger_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.ledger_id = gsob.set_of_books_id AND gjl.reference_1 LIKE 'IGIG%' GROUP BY gjh.ledger_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

View Text - HTML Formatted

SELECT GJH.LEDGER_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.LEDGER_ID = GSOB.SET_OF_BOOKS_ID
AND GJL.REFERENCE_1 LIKE 'IGIG%' GROUP BY GJH.LEDGER_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