VIEW: APPS.CSM_FND_USER_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.USER_ID , B.USER_NAME , B.START_DATE , B.END_DATE , B.DESCRIPTION , B.EMPLOYEE_ID , B.EMAIL_ADDRESS , B.FAX , B.CUSTOMER_ID FROM FND_USER B , CSM_FND_USER_ACC ACC WHERE B.USER_ID = ACC.USER_ID_PK AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.USER_ID
, B.USER_NAME
, B.START_DATE
, B.END_DATE
, B.DESCRIPTION
, B.EMPLOYEE_ID
, B.EMAIL_ADDRESS
, B.FAX
, B.CUSTOMER_ID
FROM FND_USER B
, CSM_FND_USER_ACC ACC
WHERE B.USER_ID = ACC.USER_ID_PK
AND ACC.USER_ID = ASG_BASE.GET_USER_ID