VIEW: APPS.GMS_ENCUMBRANCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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