VIEW: APPS.CSM_AUTO_SYNC_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, ASYNC.ID, ASYNC.FLAG, ASYNC.AUTO_SYNC_NUM, ASYNC.DOWNLOAD_ONLY, ASYNC.CREATION_DATE, ASYNC.CREATED_BY, ASYNC.LAST_UPDATE_DATE, ASYNC.LAST_UPDATED_BY FROM CSM_AUTO_SYNC ASYNC, CSM_AUTO_SYNC_ACC ACC WHERE ASYNC.ID=ACC.ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ASYNC.ID
, ASYNC.FLAG
, ASYNC.AUTO_SYNC_NUM
, ASYNC.DOWNLOAD_ONLY
, ASYNC.CREATION_DATE
, ASYNC.CREATED_BY
, ASYNC.LAST_UPDATE_DATE
, ASYNC.LAST_UPDATED_BY
FROM CSM_AUTO_SYNC ASYNC
, CSM_AUTO_SYNC_ACC ACC
WHERE ASYNC.ID=ACC.ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID