VIEW: GL.GL_BUDGET_ASSIGNMENTS#

Source

View Text - Preformatted

select LEDGER_ID LEDGER_ID, BUDGET_ENTITY_ID BUDGET_ENTITY_ID, CURRENCY_CODE CURRENCY_CODE, CODE_COMBINATION_ID CODE_COMBINATION_ID, RANGE_ID RANGE_ID, ENTRY_CODE ENTRY_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, AUTOMATIC_ENCUMBRANCE_FLAG AUTOMATIC_ENCUMBRANCE_FLAG, FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE, ORDERING_VALUE ORDERING_VALUE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, CONTEXT CONTEXT, AMOUNT_TYPE AMOUNT_TYPE, BOUNDARY_CODE BOUNDARY_CODE, FUNDING_BUDGET_VERSION_ID FUNDING_BUDGET_VERSION_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID from "GL"."GL_BUDGET_ASSIGNMENTS"

View Text - HTML Formatted

SELECT LEDGER_ID LEDGER_ID
, BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, CURRENCY_CODE CURRENCY_CODE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, RANGE_ID RANGE_ID
, ENTRY_CODE ENTRY_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, AUTOMATIC_ENCUMBRANCE_FLAG AUTOMATIC_ENCUMBRANCE_FLAG
, FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE
, ORDERING_VALUE ORDERING_VALUE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, CONTEXT CONTEXT
, AMOUNT_TYPE AMOUNT_TYPE
, BOUNDARY_CODE BOUNDARY_CODE
, FUNDING_BUDGET_VERSION_ID FUNDING_BUDGET_VERSION_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
FROM "GL"."GL_BUDGET_ASSIGNMENTS"