View: GL_BC_PACKETS_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_BC_PACKETS_V

View Text

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

Columns