VIEW: APPS.JTM_ASG_USER_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, U.RESOURCE_ID, U.USER_ID, U.USER_NAME, U.CLIENT_NUMBER, U.ENABLED, U.LANGUAGE, U.ORG_ID, U.LAST_SYNCH_MODE, U.LAST_SYNCH_DATE_START, U.LAST_SYNCH_DATE_END, U.ONAIR_FLAG, U.COOKIE, U.LAST_WIRELESS_CONTACT_DATE, U.NEW_DATA_FLAG, U.NEW_DATA_DATE, U.CREATION_DATE, U.CREATED_BY, U.LAST_UPDATE_DATE, U.LAST_UPDATED_BY, U.SECURITY_GROUP_ID FROM asg_user U, JTM_ASG_USER_ACC ACC WHERE U.USER_ID = ACC.USER_ID AND U.RESOURCE_ID = asg_base.get_resource_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, U.RESOURCE_ID
, U.USER_ID
, U.USER_NAME
, U.CLIENT_NUMBER
, U.ENABLED
, U.LANGUAGE
, U.ORG_ID
, U.LAST_SYNCH_MODE
, U.LAST_SYNCH_DATE_START
, U.LAST_SYNCH_DATE_END
, U.ONAIR_FLAG
, U.COOKIE
, U.LAST_WIRELESS_CONTACT_DATE
, U.NEW_DATA_FLAG
, U.NEW_DATA_DATE
, U.CREATION_DATE
, U.CREATED_BY
, U.LAST_UPDATE_DATE
, U.LAST_UPDATED_BY
, U.SECURITY_GROUP_ID
FROM ASG_USER U
, JTM_ASG_USER_ACC ACC
WHERE U.USER_ID = ACC.USER_ID
AND U.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID