eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GL_BC_PACKETS_V

Source

View Text - Preformatted


SELECT b.rowid ROW_ID, b.packet_id PACKET_ID, b.ledger_id SET_OF_BOOKS_ID, b.je_source_name JE_SOURCE_NAME, b.je_category_name JE_CATEGORY_NAME, b.code_combination_id CODE_COMBINATION_ID, b.actual_flag ACTUAL_FLAG, b.period_name PERIOD_NAME, b.period_year PERIOD_YEAR, b.period_num PERIOD_NUM, b.quarter_num QUARTER_NUM, b.currency_code CURRENCY_CODE, b.status_code STATUS_CODE, b.last_update_date LAST_UPDATE_DATE, b.last_updated_by LAST_UPDATED_BY, b.budget_version_id BUDGET_VERSION_ID, b.encumbrance_type_id ENCUMBRANCE_TYPE_ID, b.template_id TEMPLATE_ID, b.entered_dr ENTERED_DR, b.entered_cr ENTERED_CR, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.accounted_dr,0)) ,NULL))) ACCOUNTED_DR, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.accounted_cr,0)) ,NULL))) ACCOUNTED_CR, b.ussgl_transaction_code USSGL_TRANSACTION_CODE, b.account_segment_value ACCOUNT_SEGMENT_VALUE, b.automatic_encumbrance_flag AUTOMATIC_ENCUMBRANCE_FLAG, b.funding_budget_version_id FUNDING_BUDGET_VERSION_ID, b.funds_check_level_code FUNDS_CHECK_LEVEL_CODE, b.amount_type AMOUNT_TYPE, b.boundary_code BOUNDARY_CODE, b.tolerance_percentage TOLERANCE_PERCENTAGE, b.tolerance_amount TOLERANCE_AMOUNT, b.override_amount OVERRIDE_AMOUNT, b.dr_cr_code DR_CR_CODE, b.account_type ACCOUNT_TYPE, b.account_category_code ACCOUNT_CATEGORY_CODE, b.effect_on_funds_code EFFECT_ON_FUNDS_CODE, b.result_code RESULT_CODE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.budget_posted_balance,0)) ,NULL))) BUDGET_POSTED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.actual_posted_balance,0)) ,NULL))) ACTUAL_POSTED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.encumbrance_posted_balance,0)) ,NULL))) ENC_POSTED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.budget_approved_balance,0)) ,NULL))) BUDGET_APPROVED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.actual_approved_balance,0)) ,NULL))) ACTUAL_APPROVED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.encumbrance_approved_balance,0)) ,NULL))) ENC_APPROVED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.budget_pending_balance,0)) ,NULL))) BUDGET_PENDING_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.actual_pending_balance,0)) ,NULL))) ACTUAL_PENDING_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.encumbrance_pending_balance,0)) ,NULL))) ENC_PENDING_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.budget_posted_balance,0)+ nvl(b.budget_approved_balance,0)+ nvl(b.budget_pending_balance,0)) ,NULL))) BUDGET_TOTAL_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.encumbrance_posted_balance,0)+ nvl(b.encumbrance_approved_balance,0)+ nvl(b.encumbrance_pending_balance,0)) ,NULL))) ENC_TOTAL_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, nvl(b.actual_posted_balance,0)+ nvl(b.actual_approved_balance,0)+ nvl(b.actual_pending_balance,0)) ,NULL))) ACTUAL_TOTAL_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, DECODE(b.account_category_code,'B', nvl(actual_posted_balance,0), nvl(b.budget_posted_balance,0) - nvl(b.encumbrance_posted_balance,0) - nvl(b.actual_posted_balance,0))) ,NULL))) AVAIL_POSTED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, DECODE(b.account_category_code,'B', nvl(actual_approved_balance,0), nvl(b.budget_approved_balance,0)- nvl(b.encumbrance_approved_balance,0) - nvl(b.actual_approved_balance,0))) ,NULL))) AVAIL_APPROVED_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, DECODE(b.account_category_code,'B', nvl(actual_pending_balance,0), nvl(b.budget_pending_balance,0)- nvl(b.encumbrance_pending_balance,0) - nvl(b.actual_pending_balance,0))) ,NULL))) AVAIL_PENDING_BALANCE, DECODE(b.status_code,'C',NULL, 'P',NULL, DECODE(nvl(b.funds_check_level_code,'N'),'N',NULL, DECODE(b.effect_on_funds_code,'D', DECODE(b.result_code,'P01',NULL, 'P02',NULL, 'P03',NULL, 'P04',NULL, 'P05',NULL, 'P06',NULL, 'P07',NULL, 'P08',NULL, 'P09',NULL, 'F20',NULL, 'F21',NULL, 'F22',NULL, 'F23',NULL, 'F24',NULL, 'F25',NULL, 'F26',NULL, 'F27',NULL, 'F28',NULL, 'F29',NULL, DECODE(b.account_category_code,'B', (nvl(b.actual_posted_balance,0)+ nvl(b.actual_approved_balance,0)+ nvl(b.actual_pending_balance,0)), (nvl(b.budget_posted_balance,0)+ nvl(b.budget_approved_balance,0)+ nvl(b.budget_pending_balance,0)) - (nvl(b.encumbrance_posted_balance,0)+ nvl(b.encumbrance_approved_balance,0)+ nvl(b.encumbrance_pending_balance,0)) - (nvl(b.actual_posted_balance,0)+ nvl(b.actual_approved_balance,0)+ nvl(b.actual_pending_balance,0)))) ,NULL))) AVAIL_TOTAL_BALANCE, b.reference1 REFERENCE1, b.reference2 REFERENCE2, b.reference3 REFERENCE3, b.reference4 REFERENCE4, b.reference5 REFERENCE5, b.je_batch_name JE_BATCH_NAME, b.je_batch_id JE_BATCH_ID, b.je_header_id JE_HEADER_ID, b.je_line_num JE_LINE_NUM, b.je_line_description JE_LINE_DESCRIPTION, c.user_je_category_name USER_JE_CATEGORY_NAME, s.user_je_source_name USER_JE_SOURCE_NAME, nvl(b.accounted_dr,0) - nvl(b.accounted_cr,0) TRANSACTION_AMOUNT, l1.description ACTUAL_FLAG_MEANING, bv1.budget_name BUDGET_NAME, et.encumbrance_type ENCUMBRANCE_TYPE, l2.meaning STATUS_CODE_MEANING, l3.description RESULT_CODE_MEANING, bv2.budget_name FUNDING_BUDGET_NAME, l4.meaning AMOUNT_TYPE_MEANING, l5.meaning BOUNDARY_MEANING, gls.concatenated_description TEMPLATE, l6.meaning LEVEL_MEANING, l7.description ACCOUNT_TYPE_MEANING, l8.meaning EFFECT_ON_FUNDS_MEANING, jeb.name BATCH_NAME, jeh.name HEADER_NAME FROM GL_JE_HEADERS jeh, GL_JE_BATCHES jeb, GL_LOOKUPS l8, GL_LOOKUPS l7, GL_LOOKUPS l6, GL_SUMMARY_TEMPLATES gls, GL_JE_CATEGORIES c, GL_JE_SOURCES s, GL_LOOKUPS l5, GL_LOOKUPS l4, GL_BUDGET_VERSIONS bv2, GL_LOOKUPS l3, GL_LOOKUPS l2, GL_ENCUMBRANCE_TYPES et, GL_BUDGET_VERSIONS bv1, GL_LOOKUPS l1, GL_BC_PACKETS b WHERE jeb.je_batch_id(+) = b.je_batch_id AND jeh.je_header_id(+) = b.je_header_id AND l8.lookup_type(+) = 'EFFECT_ON_FUNDS_CODE' AND l8.lookup_code(+) = b.effect_on_funds_code AND l7.lookup_type(+) = 'ACCOUNT TYPE' AND l7.lookup_code(+) = b.account_type AND l6.lookup_type(+) = 'FUNDS_CHECK_LEVEL' AND l6.lookup_code(+) = b.funds_check_level_code AND gls.template_id(+) = b.template_id AND c.je_category_name = b.je_category_name AND s.je_source_name = b.je_source_name AND l5.lookup_type(+) = 'BOUNDARY_TYPE' AND l5.lookup_code(+) = b.boundary_code AND l4.lookup_type(+) = 'PTD_YTD' AND l4.lookup_code(+) = b.amount_type AND bv2.budget_version_id(+) = b.funding_budget_version_id AND l3.lookup_type(+) = 'FUNDS_CHECK_RESULT_CODE' AND l3.lookup_code(+) = b.result_code AND l2.lookup_type = 'FUNDS_CHECK_STATUS_CODE' AND l2.lookup_code = b.status_code AND et.encumbrance_type_id(+) = b.encumbrance_type_id AND bv1.budget_version_id(+) = b.budget_version_id AND l1.lookup_type = 'BATCH_TYPE' AND l1.lookup_code = b.actual_flag

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PACKET_ID PACKET_ID
, B.LEDGER_ID SET_OF_BOOKS_ID
, B.JE_SOURCE_NAME JE_SOURCE_NAME
, B.JE_CATEGORY_NAME JE_CATEGORY_NAME
, B.CODE_COMBINATION_ID CODE_COMBINATION_ID
, B.ACTUAL_FLAG ACTUAL_FLAG
, B.PERIOD_NAME PERIOD_NAME
, B.PERIOD_YEAR PERIOD_YEAR
, B.PERIOD_NUM PERIOD_NUM
, B.QUARTER_NUM QUARTER_NUM
, B.CURRENCY_CODE CURRENCY_CODE
, B.STATUS_CODE STATUS_CODE
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, B.TEMPLATE_ID TEMPLATE_ID
, B.ENTERED_DR ENTERED_DR
, B.ENTERED_CR ENTERED_CR
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ACCOUNTED_DR
, 0))
, NULL))) ACCOUNTED_DR
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ACCOUNTED_CR
, 0))
, NULL))) ACCOUNTED_CR
, B.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, B.ACCOUNT_SEGMENT_VALUE ACCOUNT_SEGMENT_VALUE
, B.AUTOMATIC_ENCUMBRANCE_FLAG AUTOMATIC_ENCUMBRANCE_FLAG
, B.FUNDING_BUDGET_VERSION_ID FUNDING_BUDGET_VERSION_ID
, B.FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE
, B.AMOUNT_TYPE AMOUNT_TYPE
, B.BOUNDARY_CODE BOUNDARY_CODE
, B.TOLERANCE_PERCENTAGE TOLERANCE_PERCENTAGE
, B.TOLERANCE_AMOUNT TOLERANCE_AMOUNT
, B.OVERRIDE_AMOUNT OVERRIDE_AMOUNT
, B.DR_CR_CODE DR_CR_CODE
, B.ACCOUNT_TYPE ACCOUNT_TYPE
, B.ACCOUNT_CATEGORY_CODE ACCOUNT_CATEGORY_CODE
, B.EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE
, B.RESULT_CODE RESULT_CODE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.BUDGET_POSTED_BALANCE
, 0))
, NULL))) BUDGET_POSTED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ACTUAL_POSTED_BALANCE
, 0))
, NULL))) ACTUAL_POSTED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ENCUMBRANCE_POSTED_BALANCE
, 0))
, NULL))) ENC_POSTED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.BUDGET_APPROVED_BALANCE
, 0))
, NULL))) BUDGET_APPROVED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ACTUAL_APPROVED_BALANCE
, 0))
, NULL))) ACTUAL_APPROVED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ENCUMBRANCE_APPROVED_BALANCE
, 0))
, NULL))) ENC_APPROVED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.BUDGET_PENDING_BALANCE
, 0))
, NULL))) BUDGET_PENDING_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ACTUAL_PENDING_BALANCE
, 0))
, NULL))) ACTUAL_PENDING_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ENCUMBRANCE_PENDING_BALANCE
, 0))
, NULL))) ENC_PENDING_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.BUDGET_POSTED_BALANCE
, 0)+ NVL(B.BUDGET_APPROVED_BALANCE
, 0)+ NVL(B.BUDGET_PENDING_BALANCE
, 0))
, NULL))) BUDGET_TOTAL_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ENCUMBRANCE_POSTED_BALANCE
, 0)+ NVL(B.ENCUMBRANCE_APPROVED_BALANCE
, 0)+ NVL(B.ENCUMBRANCE_PENDING_BALANCE
, 0))
, NULL))) ENC_TOTAL_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, NVL(B.ACTUAL_POSTED_BALANCE
, 0)+ NVL(B.ACTUAL_APPROVED_BALANCE
, 0)+ NVL(B.ACTUAL_PENDING_BALANCE
, 0))
, NULL))) ACTUAL_TOTAL_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, DECODE(B.ACCOUNT_CATEGORY_CODE
, 'B'
, NVL(ACTUAL_POSTED_BALANCE
, 0)
, NVL(B.BUDGET_POSTED_BALANCE
, 0) - NVL(B.ENCUMBRANCE_POSTED_BALANCE
, 0) - NVL(B.ACTUAL_POSTED_BALANCE
, 0)))
, NULL))) AVAIL_POSTED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, DECODE(B.ACCOUNT_CATEGORY_CODE
, 'B'
, NVL(ACTUAL_APPROVED_BALANCE
, 0)
, NVL(B.BUDGET_APPROVED_BALANCE
, 0)- NVL(B.ENCUMBRANCE_APPROVED_BALANCE
, 0) - NVL(B.ACTUAL_APPROVED_BALANCE
, 0)))
, NULL))) AVAIL_APPROVED_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, DECODE(B.ACCOUNT_CATEGORY_CODE
, 'B'
, NVL(ACTUAL_PENDING_BALANCE
, 0)
, NVL(B.BUDGET_PENDING_BALANCE
, 0)- NVL(B.ENCUMBRANCE_PENDING_BALANCE
, 0) - NVL(B.ACTUAL_PENDING_BALANCE
, 0)))
, NULL))) AVAIL_PENDING_BALANCE
, DECODE(B.STATUS_CODE
, 'C'
, NULL
, 'P'
, NULL
, DECODE(NVL(B.FUNDS_CHECK_LEVEL_CODE
, 'N')
, 'N'
, NULL
, DECODE(B.EFFECT_ON_FUNDS_CODE
, 'D'
, DECODE(B.RESULT_CODE
, 'P01'
, NULL
, 'P02'
, NULL
, 'P03'
, NULL
, 'P04'
, NULL
, 'P05'
, NULL
, 'P06'
, NULL
, 'P07'
, NULL
, 'P08'
, NULL
, 'P09'
, NULL
, 'F20'
, NULL
, 'F21'
, NULL
, 'F22'
, NULL
, 'F23'
, NULL
, 'F24'
, NULL
, 'F25'
, NULL
, 'F26'
, NULL
, 'F27'
, NULL
, 'F28'
, NULL
, 'F29'
, NULL
, DECODE(B.ACCOUNT_CATEGORY_CODE
, 'B'
, (NVL(B.ACTUAL_POSTED_BALANCE
, 0)+ NVL(B.ACTUAL_APPROVED_BALANCE
, 0)+ NVL(B.ACTUAL_PENDING_BALANCE
, 0))
, (NVL(B.BUDGET_POSTED_BALANCE
, 0)+ NVL(B.BUDGET_APPROVED_BALANCE
, 0)+ NVL(B.BUDGET_PENDING_BALANCE
, 0)) - (NVL(B.ENCUMBRANCE_POSTED_BALANCE
, 0)+ NVL(B.ENCUMBRANCE_APPROVED_BALANCE
, 0)+ NVL(B.ENCUMBRANCE_PENDING_BALANCE
, 0)) - (NVL(B.ACTUAL_POSTED_BALANCE
, 0)+ NVL(B.ACTUAL_APPROVED_BALANCE
, 0)+ NVL(B.ACTUAL_PENDING_BALANCE
, 0))))
, NULL))) AVAIL_TOTAL_BALANCE
, B.REFERENCE1 REFERENCE1
, B.REFERENCE2 REFERENCE2
, B.REFERENCE3 REFERENCE3
, B.REFERENCE4 REFERENCE4
, B.REFERENCE5 REFERENCE5
, B.JE_BATCH_NAME JE_BATCH_NAME
, B.JE_BATCH_ID JE_BATCH_ID
, B.JE_HEADER_ID JE_HEADER_ID
, B.JE_LINE_NUM JE_LINE_NUM
, B.JE_LINE_DESCRIPTION JE_LINE_DESCRIPTION
, C.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, S.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, NVL(B.ACCOUNTED_DR
, 0) - NVL(B.ACCOUNTED_CR
, 0) TRANSACTION_AMOUNT
, L1.DESCRIPTION ACTUAL_FLAG_MEANING
, BV1.BUDGET_NAME BUDGET_NAME
, ET.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE
, L2.MEANING STATUS_CODE_MEANING
, L3.DESCRIPTION RESULT_CODE_MEANING
, BV2.BUDGET_NAME FUNDING_BUDGET_NAME
, L4.MEANING AMOUNT_TYPE_MEANING
, L5.MEANING BOUNDARY_MEANING
, GLS.CONCATENATED_DESCRIPTION TEMPLATE
, L6.MEANING LEVEL_MEANING
, L7.DESCRIPTION ACCOUNT_TYPE_MEANING
, L8.MEANING EFFECT_ON_FUNDS_MEANING
, JEB.NAME BATCH_NAME
, JEH.NAME HEADER_NAME
FROM GL_JE_HEADERS JEH
, GL_JE_BATCHES JEB
, GL_LOOKUPS L8
, GL_LOOKUPS L7
, GL_LOOKUPS L6
, GL_SUMMARY_TEMPLATES GLS
, GL_JE_CATEGORIES C
, GL_JE_SOURCES S
, GL_LOOKUPS L5
, GL_LOOKUPS L4
, GL_BUDGET_VERSIONS BV2
, GL_LOOKUPS L3
, GL_LOOKUPS L2
, GL_ENCUMBRANCE_TYPES ET
, GL_BUDGET_VERSIONS BV1
, GL_LOOKUPS L1
, GL_BC_PACKETS B
WHERE JEB.JE_BATCH_ID(+) = B.JE_BATCH_ID
AND JEH.JE_HEADER_ID(+) = B.JE_HEADER_ID
AND L8.LOOKUP_TYPE(+) = 'EFFECT_ON_FUNDS_CODE'
AND L8.LOOKUP_CODE(+) = B.EFFECT_ON_FUNDS_CODE
AND L7.LOOKUP_TYPE(+) = 'ACCOUNT TYPE'
AND L7.LOOKUP_CODE(+) = B.ACCOUNT_TYPE
AND L6.LOOKUP_TYPE(+) = 'FUNDS_CHECK_LEVEL'
AND L6.LOOKUP_CODE(+) = B.FUNDS_CHECK_LEVEL_CODE
AND GLS.TEMPLATE_ID(+) = B.TEMPLATE_ID
AND C.JE_CATEGORY_NAME = B.JE_CATEGORY_NAME
AND S.JE_SOURCE_NAME = B.JE_SOURCE_NAME
AND L5.LOOKUP_TYPE(+) = 'BOUNDARY_TYPE'
AND L5.LOOKUP_CODE(+) = B.BOUNDARY_CODE
AND L4.LOOKUP_TYPE(+) = 'PTD_YTD'
AND L4.LOOKUP_CODE(+) = B.AMOUNT_TYPE
AND BV2.BUDGET_VERSION_ID(+) = B.FUNDING_BUDGET_VERSION_ID
AND L3.LOOKUP_TYPE(+) = 'FUNDS_CHECK_RESULT_CODE'
AND L3.LOOKUP_CODE(+) = B.RESULT_CODE
AND L2.LOOKUP_TYPE = 'FUNDS_CHECK_STATUS_CODE'
AND L2.LOOKUP_CODE = B.STATUS_CODE
AND ET.ENCUMBRANCE_TYPE_ID(+) = B.ENCUMBRANCE_TYPE_ID
AND BV1.BUDGET_VERSION_ID(+) = B.BUDGET_VERSION_ID
AND L1.LOOKUP_TYPE = 'BATCH_TYPE'
AND L1.LOOKUP_CODE = B.ACTUAL_FLAG