VIEW: APPS.ASG_USER_VERSIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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