View: GMS_ENCUMBRANCE_GROUPS_V

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

View Text

SELECT E.ROWID ROW_ID
, E.ENCUMBRANCE_GROUP
, E.ENCUMBRANCE_ENDING_DATE
, E.ENCUMBRANCE_GROUP_STATUS_CODE
, L1.MEANING ENCUMBRANCE_GROUP_STATUS_M
, E.SYSTEM_LINKAGE_FUNCTION
, SL.MEANING SYSTEM_LINKAGE
, E.DESCRIPTION
, E.CONTROL_COUNT
, E.CONTROL_TOTAL_AMOUNT
, E.TRANSACTION_SOURCE
, E.LAST_UPDATE_LOGIN
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, P.FULL_NAME CREATED_BY_EMPLOYEE_NAME
, /* 3362016) */ NVL(P.EMPLOYEE_NUMBER
, P.NPW_NUMBER) CREATED_BY_EMPLOYEE_NUMBER
, TR.USER_TRANSACTION_SOURCE
, TR.ALLOW_ADJUSTMENTS_FLAG
, TR.ALLOW_REVERSAL_FLAG
, E.ORG_ID
FROM PER_PEOPLE_F P
, FND_USER F
, PA_TRANSACTION_SOURCES TR
, PA_SYSTEM_LINKAGES SL
, PA_LOOKUPS L1
, GMS_ENCUMBRANCE_GROUPS E
WHERE E.CREATED_BY = F.USER_ID (+)
AND F.EMPLOYEE_ID = P.PERSON_ID (+)
AND E.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE (+)
AND P.EFFECTIVE_END_DATE (+) /* 3362016
AND P.EMPLOYEE_NUMBER (+) IS NOT NULL */
AND SL.FUNCTION = E.SYSTEM_LINKAGE_FUNCTION
AND L1.LOOKUP_CODE = E.ENCUMBRANCE_GROUP_STATUS_CODE
AND L1.LOOKUP_TYPE = 'EXPENDITURE GROUP STATUS'

Columns