View: ASG_USER_VERSIONS

Product:	ASG - CRM Gateway for Mobile Devices
Description:
Implementation/DBA Data:	APPS.ASG_USER_VERSIONS

View Text

SELECT D.DEVICE_USER_ID
, D.CLIENT_NAME
, D.MOBILE_APPLICATION_ID
, D.USER_ID
, D.RESOURCE_ID
, S.SERVER_ID
, S.SNAP_DATABASE
, P.RELEASE_VERSION
, P.COMPATIBLE_VERSION
FROM ASG_DEVICE_USERS D
, ASG_SYNCH_SERVER S
, ASG_SERVER_PUBS P
, ASG_APPLICATIONS_B A
, ASG_PUBLICATIONS PUB
WHERE D.SERVER_ID = S.SERVER_ID
AND D.MOBILE_APPLICATION_ID = A.MOBILE_APPLICATION_ID
AND P.SERVER_ID = D.SERVER_ID
AND A.APPLICATION_CODE = PUB.NAME
AND P.PUBLICATION_ID = PUB.PUBLICATION_ID

Columns