View: GMS_ENCUMBRANCES_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_ENCUMBRANCES_V

View Text

SELECT E.ROWID ROW_ID
, E.ENCUMBRANCE_ID
, E.ENCUMBRANCE_STATUS_CODE
, E.ENCUMBRANCE_ENDING_DATE
, E.ENCUMBRANCE_CLASS_CODE
, E.INCURRED_BY_PERSON_ID
, P.FULL_NAME INCURRED_BY_EMPLOYEE_NAME
, /* 3362016 */ NVL(P.EMPLOYEE_NUMBER
, P.NPW_NUMBER) INCURRED_BY_EMPLOYEE_NUMBER
, E.INCURRED_BY_ORGANIZATION_ID
, O.NAME ORGANIZATION_NAME
, E.ENCUMBRANCE_GROUP
, E.CONTROL_TOTAL_AMOUNT
, E.ENTERED_BY_PERSON_ID
, E.DESCRIPTION
, E.INITIAL_SUBMISSION_DATE
, E.DENOM_CURRENCY_CODE
, E.ACCT_CURRENCY_CODE
, E.ACCT_RATE_DATE
, E.ACCT_RATE_TYPE
, E.ACCT_EXCHANGE_RATE
, E.LAST_UPDATE_LOGIN
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.ORIG_ENC_TXN_REFERENCE1
, E.ORIG_USER_ENC_TXN_REFERENCE
, E.VENDOR_ID
, E.ORIG_ENC_TXN_REFERENCE2
, E.ORIG_ENC_TXN_REFERENCE3
, E.OVERRIDING_APPROVER_PERSON_ID
, E.WF_STATUS_CODE
, E.TRANSFER_STATUS_CODE
, E.USER_BATCH_NAME
, E.ORG_ID
FROM HR_ORGANIZATION_UNITS O
, PER_PEOPLE_F P
, GMS_ENCUMBRANCES E
WHERE E.INCURRED_BY_PERSON_ID = P.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE (+)
AND P.EFFECTIVE_END_DATE (+) /* 3362016
AND P.EMPLOYEE_NUMBER (+) IS NOT NULL */
AND E.INCURRED_BY_ORGANIZATION_ID = O.ORGANIZATION_ID

Columns