VIEW: GL.GL_BC_PACKETS#

Source

View Text - Preformatted

select PACKET_ID PACKET_ID, LEDGER_ID LEDGER_ID, JE_SOURCE_NAME JE_SOURCE_NAME, JE_CATEGORY_NAME JE_CATEGORY_NAME, CODE_COMBINATION_ID CODE_COMBINATION_ID, ACTUAL_FLAG ACTUAL_FLAG, PERIOD_NAME PERIOD_NAME, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, QUARTER_NUM QUARTER_NUM, CURRENCY_CODE CURRENCY_CODE, STATUS_CODE STATUS_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, BUDGET_VERSION_ID BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, TEMPLATE_ID TEMPLATE_ID, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, ORIGINATING_ROWID ORIGINATING_ROWID, ACCOUNT_SEGMENT_VALUE ACCOUNT_SEGMENT_VALUE, AUTOMATIC_ENCUMBRANCE_FLAG AUTOMATIC_ENCUMBRANCE_FLAG, FUNDING_BUDGET_VERSION_ID FUNDING_BUDGET_VERSION_ID, FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE, AMOUNT_TYPE AMOUNT_TYPE, BOUNDARY_CODE BOUNDARY_CODE, TOLERANCE_PERCENTAGE TOLERANCE_PERCENTAGE, TOLERANCE_AMOUNT TOLERANCE_AMOUNT, OVERRIDE_AMOUNT OVERRIDE_AMOUNT, DR_CR_CODE DR_CR_CODE, ACCOUNT_TYPE ACCOUNT_TYPE, ACCOUNT_CATEGORY_CODE ACCOUNT_CATEGORY_CODE, EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE, RESULT_CODE RESULT_CODE, BUDGET_POSTED_BALANCE BUDGET_POSTED_BALANCE, ACTUAL_POSTED_BALANCE ACTUAL_POSTED_BALANCE, ENCUMBRANCE_POSTED_BALANCE ENCUMBRANCE_POSTED_BALANCE, BUDGET_APPROVED_BALANCE BUDGET_APPROVED_BALANCE, ACTUAL_APPROVED_BALANCE ACTUAL_APPROVED_BALANCE, ENCUMBRANCE_APPROVED_BALANCE ENCUMBRANCE_APPROVED_BALANCE, BUDGET_PENDING_BALANCE BUDGET_PENDING_BALANCE, ACTUAL_PENDING_BALANCE ACTUAL_PENDING_BALANCE, ENCUMBRANCE_PENDING_BALANCE ENCUMBRANCE_PENDING_BALANCE, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, JE_BATCH_NAME JE_BATCH_NAME, JE_BATCH_ID JE_BATCH_ID, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, JE_LINE_DESCRIPTION JE_LINE_DESCRIPTION, REFERENCE6 REFERENCE6, REFERENCE7 REFERENCE7, REFERENCE8 REFERENCE8, REFERENCE9 REFERENCE9, REFERENCE10 REFERENCE10, REFERENCE11 REFERENCE11, REFERENCE12 REFERENCE12, REFERENCE13 REFERENCE13, REFERENCE14 REFERENCE14, REFERENCE15 REFERENCE15, REQUEST_ID REQUEST_ID, USSGL_PARENT_ID USSGL_PARENT_ID, USSGL_LINK_TO_PARENT_ID USSGL_LINK_TO_PARENT_ID, EVENT_ID EVENT_ID, AE_HEADER_ID AE_HEADER_ID, AE_LINE_NUM AE_LINE_NUM, BC_DATE BC_DATE, SOURCE_DISTRIBUTION_TYPE SOURCE_DISTRIBUTION_TYPE, SOURCE_DISTRIBUTION_ID_CHAR_1 SOURCE_DISTRIBUTION_ID_CHAR_1, SOURCE_DISTRIBUTION_ID_CHAR_2 SOURCE_DISTRIBUTION_ID_CHAR_2, SOURCE_DISTRIBUTION_ID_CHAR_3 SOURCE_DISTRIBUTION_ID_CHAR_3, SOURCE_DISTRIBUTION_ID_CHAR_4 SOURCE_DISTRIBUTION_ID_CHAR_4, SOURCE_DISTRIBUTION_ID_CHAR_5 SOURCE_DISTRIBUTION_ID_CHAR_5, SOURCE_DISTRIBUTION_ID_NUM_1 SOURCE_DISTRIBUTION_ID_NUM_1, SOURCE_DISTRIBUTION_ID_NUM_2 SOURCE_DISTRIBUTION_ID_NUM_2, SOURCE_DISTRIBUTION_ID_NUM_3 SOURCE_DISTRIBUTION_ID_NUM_3, SOURCE_DISTRIBUTION_ID_NUM_4 SOURCE_DISTRIBUTION_ID_NUM_4, SOURCE_DISTRIBUTION_ID_NUM_5 SOURCE_DISTRIBUTION_ID_NUM_5, SESSION_ID SESSION_ID, SERIAL_ID SERIAL_ID, APPLICATION_ID APPLICATION_ID, ENTITY_ID ENTITY_ID, GROUP_ID GROUP_ID from "GL"."GL_BC_PACKETS"

View Text - HTML Formatted

SELECT PACKET_ID PACKET_ID
, LEDGER_ID LEDGER_ID
, JE_SOURCE_NAME JE_SOURCE_NAME
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, ACTUAL_FLAG ACTUAL_FLAG
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, QUARTER_NUM QUARTER_NUM
, CURRENCY_CODE CURRENCY_CODE
, STATUS_CODE STATUS_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, TEMPLATE_ID TEMPLATE_ID
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, ORIGINATING_ROWID ORIGINATING_ROWID
, ACCOUNT_SEGMENT_VALUE ACCOUNT_SEGMENT_VALUE
, AUTOMATIC_ENCUMBRANCE_FLAG AUTOMATIC_ENCUMBRANCE_FLAG
, FUNDING_BUDGET_VERSION_ID FUNDING_BUDGET_VERSION_ID
, FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE
, AMOUNT_TYPE AMOUNT_TYPE
, BOUNDARY_CODE BOUNDARY_CODE
, TOLERANCE_PERCENTAGE TOLERANCE_PERCENTAGE
, TOLERANCE_AMOUNT TOLERANCE_AMOUNT
, OVERRIDE_AMOUNT OVERRIDE_AMOUNT
, DR_CR_CODE DR_CR_CODE
, ACCOUNT_TYPE ACCOUNT_TYPE
, ACCOUNT_CATEGORY_CODE ACCOUNT_CATEGORY_CODE
, EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE
, RESULT_CODE RESULT_CODE
, BUDGET_POSTED_BALANCE BUDGET_POSTED_BALANCE
, ACTUAL_POSTED_BALANCE ACTUAL_POSTED_BALANCE
, ENCUMBRANCE_POSTED_BALANCE ENCUMBRANCE_POSTED_BALANCE
, BUDGET_APPROVED_BALANCE BUDGET_APPROVED_BALANCE
, ACTUAL_APPROVED_BALANCE ACTUAL_APPROVED_BALANCE
, ENCUMBRANCE_APPROVED_BALANCE ENCUMBRANCE_APPROVED_BALANCE
, BUDGET_PENDING_BALANCE BUDGET_PENDING_BALANCE
, ACTUAL_PENDING_BALANCE ACTUAL_PENDING_BALANCE
, ENCUMBRANCE_PENDING_BALANCE ENCUMBRANCE_PENDING_BALANCE
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, JE_BATCH_NAME JE_BATCH_NAME
, JE_BATCH_ID JE_BATCH_ID
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, JE_LINE_DESCRIPTION JE_LINE_DESCRIPTION
, REFERENCE6 REFERENCE6
, REFERENCE7 REFERENCE7
, REFERENCE8 REFERENCE8
, REFERENCE9 REFERENCE9
, REFERENCE10 REFERENCE10
, REFERENCE11 REFERENCE11
, REFERENCE12 REFERENCE12
, REFERENCE13 REFERENCE13
, REFERENCE14 REFERENCE14
, REFERENCE15 REFERENCE15
, REQUEST_ID REQUEST_ID
, USSGL_PARENT_ID USSGL_PARENT_ID
, USSGL_LINK_TO_PARENT_ID USSGL_LINK_TO_PARENT_ID
, EVENT_ID EVENT_ID
, AE_HEADER_ID AE_HEADER_ID
, AE_LINE_NUM AE_LINE_NUM
, BC_DATE BC_DATE
, SOURCE_DISTRIBUTION_TYPE SOURCE_DISTRIBUTION_TYPE
, SOURCE_DISTRIBUTION_ID_CHAR_1 SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2 SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3 SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4 SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5 SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_ID_NUM_1 SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2 SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3 SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4 SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5 SOURCE_DISTRIBUTION_ID_NUM_5
, SESSION_ID SESSION_ID
, SERIAL_ID SERIAL_ID
, APPLICATION_ID APPLICATION_ID
, ENTITY_ID ENTITY_ID
, GROUP_ID GROUP_ID
FROM "GL"."GL_BC_PACKETS"