DBA Data[Home] [Help]

VIEW: APPS.CSM_AUTO_SYNC_LOG_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, ASLOG.ID, ASLOG.NOTIFICATION_ID, ASLOG.AS_TYPE, ASLOG.AS_START_DATE, ASLOG.AS_FINISH_DATE, ASLOG.AS_RESULT, ASLOG.EMAIL_SENT, ASLOG.CREATION_DATE, ASLOG.CREATED_BY, ASLOG.LAST_UPDATE_DATE, ASLOG.LAST_UPDATED_BY FROM CSM_AUTO_SYNC_LOG ASLOG, CSM_AUTO_SYNC_LOG_ACC ACC WHERE ASLOG.ID=ACC.ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ASLOG.ID
, ASLOG.NOTIFICATION_ID
, ASLOG.AS_TYPE
, ASLOG.AS_START_DATE
, ASLOG.AS_FINISH_DATE
, ASLOG.AS_RESULT
, ASLOG.EMAIL_SENT
, ASLOG.CREATION_DATE
, ASLOG.CREATED_BY
, ASLOG.LAST_UPDATE_DATE
, ASLOG.LAST_UPDATED_BY
FROM CSM_AUTO_SYNC_LOG ASLOG
, CSM_AUTO_SYNC_LOG_ACC ACC
WHERE ASLOG.ID=ACC.ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID