VIEW: GMS.GMS_ENCUMBRANCE_ITEMS_ALL#

Source

View Text - Preformatted

select ENCUMBRANCE_ITEM_ID ENCUMBRANCE_ITEM_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ENCUMBRANCE_ID ENCUMBRANCE_ID, TASK_ID TASK_ID, ENCUMBRANCE_ITEM_DATE ENCUMBRANCE_ITEM_DATE, ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE, ENC_DISTRIBUTED_FLAG ENC_DISTRIBUTED_FLAG, OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORGANIZATION_ID, ADJUSTED_ENCUMBRANCE_ITEM_ID ADJUSTED_ENCUMBRANCE_ITEM_ID, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG, TRANSFERRED_FROM_ENC_ITEM_ID TRANSFERRED_FROM_ENC_ITEM_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE, TRANSACTION_SOURCE TRANSACTION_SOURCE, PROJECT_ID PROJECT_ID, SOURCE_ENCUMBRANCE_ITEM_ID SOURCE_ENCUMBRANCE_ITEM_ID, JOB_ID JOB_ID, ORG_ID ORG_ID, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, 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, ACCT_EXCHANGE_ROUNDING_LIMIT ACCT_EXCHANGE_ROUNDING_LIMIT, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE, DENOM_TP_CURRENCY_CODE DENOM_TP_CURRENCY_CODE, DENOM_TRANSFER_PRICE DENOM_TRANSFER_PRICE, PROJACCT_TRANSFER_PRICE PROJACCT_TRANSFER_PRICE, AMOUNT AMOUNT, ENCUMBRANCE_COMMENT ENCUMBRANCE_COMMENT, IND_COMPILED_SET_ID IND_COMPILED_SET_ID, PA_DATE PA_DATE, GL_DATE GL_DATE, LINE_NUM LINE_NUM, BURDEN_SUM_DEST_RUN_ID BURDEN_SUM_DEST_RUN_ID, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID, DENOM_RAW_AMOUNT DENOM_RAW_AMOUNT, INCURRED_BY_PERSON_ID INCURRED_BY_PERSON_ID, PERSON_ID PERSON_ID, ACCT_RAW_COST ACCT_RAW_COST, ADJUSTMENT_TYPE ADJUSTMENT_TYPE from "GMS"."GMS_ENCUMBRANCE_ITEMS_ALL"

View Text - HTML Formatted

SELECT ENCUMBRANCE_ITEM_ID ENCUMBRANCE_ITEM_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ENCUMBRANCE_ID ENCUMBRANCE_ID
, TASK_ID TASK_ID
, ENCUMBRANCE_ITEM_DATE ENCUMBRANCE_ITEM_DATE
, ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE
, ENC_DISTRIBUTED_FLAG ENC_DISTRIBUTED_FLAG
, OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORGANIZATION_ID
, ADJUSTED_ENCUMBRANCE_ITEM_ID ADJUSTED_ENCUMBRANCE_ITEM_ID
, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_ENC_ITEM_ID TRANSFERRED_FROM_ENC_ITEM_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, PROJECT_ID PROJECT_ID
, SOURCE_ENCUMBRANCE_ITEM_ID SOURCE_ENCUMBRANCE_ITEM_ID
, JOB_ID JOB_ID
, ORG_ID ORG_ID
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, 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
, ACCT_EXCHANGE_ROUNDING_LIMIT ACCT_EXCHANGE_ROUNDING_LIMIT
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
, DENOM_TP_CURRENCY_CODE DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE DENOM_TRANSFER_PRICE
, PROJACCT_TRANSFER_PRICE PROJACCT_TRANSFER_PRICE
, AMOUNT AMOUNT
, ENCUMBRANCE_COMMENT ENCUMBRANCE_COMMENT
, IND_COMPILED_SET_ID IND_COMPILED_SET_ID
, PA_DATE PA_DATE
, GL_DATE GL_DATE
, LINE_NUM LINE_NUM
, BURDEN_SUM_DEST_RUN_ID BURDEN_SUM_DEST_RUN_ID
, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID
, DENOM_RAW_AMOUNT DENOM_RAW_AMOUNT
, INCURRED_BY_PERSON_ID INCURRED_BY_PERSON_ID
, PERSON_ID PERSON_ID
, ACCT_RAW_COST ACCT_RAW_COST
, ADJUSTMENT_TYPE ADJUSTMENT_TYPE
FROM "GMS"."GMS_ENCUMBRANCE_ITEMS_ALL"