VIEW: GMS.GMS_ENCUMBRANCES_ALL#

Source

View Text - Preformatted

select ENCUMBRANCE_ID ENCUMBRANCE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ENCUMBRANCE_STATUS_CODE ENCUMBRANCE_STATUS_CODE, ENCUMBRANCE_ENDING_DATE ENCUMBRANCE_ENDING_DATE, ENCUMBRANCE_CLASS_CODE ENCUMBRANCE_CLASS_CODE, INCURRED_BY_PERSON_ID INCURRED_BY_PERSON_ID, INCURRED_BY_ORGANIZATION_ID INCURRED_BY_ORGANIZATION_ID, ENCUMBRANCE_GROUP ENCUMBRANCE_GROUP, CONTROL_TOTAL_AMOUNT CONTROL_TOTAL_AMOUNT, ENTERED_BY_PERSON_ID ENTERED_BY_PERSON_ID, DESCRIPTION DESCRIPTION, INITIAL_SUBMISSION_DATE INITIAL_SUBMISSION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, PTE_REFERENCE PTE_REFERENCE, ORG_ID ORG_ID, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, ACCT_RATE_DATE ACCT_RATE_DATE, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, ORIG_ENC_TXN_REFERENCE1 ORIG_ENC_TXN_REFERENCE1, ORIG_ENC_TXN_REFERENCE2 ORIG_ENC_TXN_REFERENCE2, ORIG_ENC_TXN_REFERENCE3 ORIG_ENC_TXN_REFERENCE3, ORIG_USER_ENC_TXN_REFERENCE ORIG_USER_ENC_TXN_REFERENCE, VENDOR_ID VENDOR_ID, OVERRIDING_APPROVER_PERSON_ID OVERRIDING_APPROVER_PERSON_ID, WF_STATUS_CODE WF_STATUS_CODE, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, USER_BATCH_NAME USER_BATCH_NAME from "GMS"."GMS_ENCUMBRANCES_ALL"

View Text - HTML Formatted

SELECT ENCUMBRANCE_ID ENCUMBRANCE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ENCUMBRANCE_STATUS_CODE ENCUMBRANCE_STATUS_CODE
, ENCUMBRANCE_ENDING_DATE ENCUMBRANCE_ENDING_DATE
, ENCUMBRANCE_CLASS_CODE ENCUMBRANCE_CLASS_CODE
, INCURRED_BY_PERSON_ID INCURRED_BY_PERSON_ID
, INCURRED_BY_ORGANIZATION_ID INCURRED_BY_ORGANIZATION_ID
, ENCUMBRANCE_GROUP ENCUMBRANCE_GROUP
, CONTROL_TOTAL_AMOUNT CONTROL_TOTAL_AMOUNT
, ENTERED_BY_PERSON_ID ENTERED_BY_PERSON_ID
, DESCRIPTION DESCRIPTION
, INITIAL_SUBMISSION_DATE INITIAL_SUBMISSION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, PTE_REFERENCE PTE_REFERENCE
, ORG_ID ORG_ID
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, ACCT_RATE_DATE ACCT_RATE_DATE
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, ORIG_ENC_TXN_REFERENCE1 ORIG_ENC_TXN_REFERENCE1
, ORIG_ENC_TXN_REFERENCE2 ORIG_ENC_TXN_REFERENCE2
, ORIG_ENC_TXN_REFERENCE3 ORIG_ENC_TXN_REFERENCE3
, ORIG_USER_ENC_TXN_REFERENCE ORIG_USER_ENC_TXN_REFERENCE
, VENDOR_ID VENDOR_ID
, OVERRIDING_APPROVER_PERSON_ID OVERRIDING_APPROVER_PERSON_ID
, WF_STATUS_CODE WF_STATUS_CODE
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, USER_BATCH_NAME USER_BATCH_NAME
FROM "GMS"."GMS_ENCUMBRANCES_ALL"