Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on GL_BUDGET_ENTITIES, GL_BUDGET_VERSIONS, GL_JE_CATEGORIES and IGI_BUD_JOURNAL_HEADERS |
Implementation/DBA Data: | APPS.IGI_BUD_JOURNAL_HEADERS_V |
SELECT JH.ROWID ROW_ID
, JH.BE_BATCH_ID
, JH.BE_HEADER_ID
, JH.BUDGET_ENTITY_ID
, BE.NAME ORGANIZATION_NAME
, JH.BUDGET_VERSION_ID
, BV.BUDGET_NAME
, JH.SET_OF_BOOKS_ID
, JH.CURRENCY_CODE
, JH.JE_CATEGORY_NAME
, JC.USER_JE_CATEGORY_NAME
, JH.NAME
, JH.RUNNING_TOTAL_DR
, JH.RUNNING_TOTAL_CR
, JH.AUTOCOPY_FLAG
, JH.CONTROL_TOTAL
, JH.DEFAULT_REASON_CODE
, JH.DESCRIPTION
, JH.CREATION_DATE
, JH.CREATED_BY
, JH.LAST_UPDATE_DATE
, JH.LAST_UPDATED_BY
, JH.LAST_UPDATE_LOGIN
FROM GL_BUDGET_ENTITIES BE
, GL_BUDGET_VERSIONS BV
, GL_JE_CATEGORIES_TL JC
, IGI_BUD_JOURNAL_HEADERS JH
WHERE JH.JE_CATEGORY_NAME = JC.JE_CATEGORY_NAME
AND JH.BUDGET_ENTITY_ID = BE.BUDGET_ENTITY_ID
AND JH.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND JC.LANGUAGE = USERENV('LANG')