VIEW: APPS.IGI_BUD_JOURNAL_HEADERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')