Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ENCUMBRANCE_ITEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, ENCUMBRANCE_ID
, TASK_ID
, ENCUMBRANCE_ITEM_DATE
, ENCUMBRANCE_TYPE
, ENC_DISTRIBUTED_FLAG
, JOB_ID
, OVERRIDE_TO_ORGANIZATION_ID
, ADJUSTED_ENCUMBRANCE_ITEM_ID
, NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_ENC_ITEM_ID
, LAST_UPDATE_LOGIN
, REQUEST_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ORIG_TRANSACTION_REFERENCE
, TRANSACTION_SOURCE
, PROJECT_ID
, SOURCE_ENCUMBRANCE_ITEM_ID
, ORG_ID
, SYSTEM_LINKAGE_FUNCTION
, DENOM_CURRENCY_CODE
, DENOM_RAW_AMOUNT
, ACCT_EXCHANGE_ROUNDING_LIMIT
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE
, AMOUNT
, ENCUMBRANCE_COMMENT
, PERSON_ID
, INCURRED_BY_PERSON_ID
, IND_COMPILED_SET_ID
, PA_DATE
, GL_DATE
, LINE_NUM
, BURDEN_SUM_DEST_RUN_ID
, BURDEN_SUM_SOURCE_RUN_ID
FROM GMS_ENCUMBRANCE_ITEMS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)