VIEW: APPS.OKS_HELP_DESK_V

Source

View Text - Preformatted

SELECT U.ROWID ROW_ID ,U.USER_ID USER_ID ,U.USER_NAME USER_NAME ,EMP.FULL_NAME HELP_DESK_NAME ,EMP.EMAIL_ADDRESS EMAIL_ADDRESS ,RSC.RESOURCE_ID RESOURCE_ID FROM JTF_RS_RESOURCE_EXTNS RSC,FND_USER U,OKX_PER_ALL_PEOPLE_V EMP WHERE RSC.CATEGORY = 'EMPLOYEE' AND EMP.PERSON_ID = RSC.SOURCE_ID AND U.USER_ID = RSC.USER_ID AND EMP.EMAIL_ADDRESS IS NOT NULL

View Text - HTML Formatted

SELECT U.ROWID ROW_ID
, U.USER_ID USER_ID
, U.USER_NAME USER_NAME
, EMP.FULL_NAME HELP_DESK_NAME
, EMP.EMAIL_ADDRESS EMAIL_ADDRESS
, RSC.RESOURCE_ID RESOURCE_ID
FROM JTF_RS_RESOURCE_EXTNS RSC
, FND_USER U
, OKX_PER_ALL_PEOPLE_V EMP
WHERE RSC.CATEGORY = 'EMPLOYEE'
AND EMP.PERSON_ID = RSC.SOURCE_ID
AND U.USER_ID = RSC.USER_ID
AND EMP.EMAIL_ADDRESS IS NOT NULL