VIEW: APPS.GMS_ENCUMBRANCE_GROUPS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'