VIEW: APPS.IES_SVY_SUMMARY_STATS_V

Source

View Text - Preformatted

SELECT SSS.SURVEY_ID SURVEY_ID, SSS.SURVEY_CYCLE_ID SURVEY_CYCLE_ID, SSS.SURVEY_DEPLOYMENT_ID SURVEY_DEPLOYMENT_ID, SSS.SURVEY_NAME SURVEY_NAME, SSS.SURVEY_CYCLE_NAME SURVEY_CYCLE_NAME, sss.SURVEY_DEPLOYMENT_NAME SURVEY_DEPLOYMENT_NAME, sss.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, sss.DEPLOYMENT_STATUS DEPLOYMENT_STATUS, SSS.SURVEY_STATUS SURVEY_STATUS, SSS.TOTAL_ABANDONED TOTAL_ABANDONED, SSS.TOTAL_ABORTED TOTAL_ABORTED, SSS.DEPLOY_DATE DEPLOY_DATE, SSS.RESPONSE_END_DATE RESPONSE_END_DATE, SSS.MEDIA_TYPE_CODE MEDIA_TYPE_CODE, SSS.LIST_HEADER_ID LIST_HEADER_ID, SSS.LIST_NAME LIST_NAME, SSS.TOTAL_NO_SENT TOTAL_NO_SENT, SSS.TOTAL_NO_ERRORS TOTAL_NO_ERRORS, SSS.TOTAL_NO_RESPONSES_RECD TOTAL_NO_RESPONSES_RECD, SSS.REFRESH_DATE REFRESH_DATE, SSS.F_DELETEDFLAG F_DELETEDFLAG FROM IES_SVY_SUMMARY_STATS SSS

View Text - HTML Formatted

SELECT SSS.SURVEY_ID SURVEY_ID
, SSS.SURVEY_CYCLE_ID SURVEY_CYCLE_ID
, SSS.SURVEY_DEPLOYMENT_ID SURVEY_DEPLOYMENT_ID
, SSS.SURVEY_NAME SURVEY_NAME
, SSS.SURVEY_CYCLE_NAME SURVEY_CYCLE_NAME
, SSS.SURVEY_DEPLOYMENT_NAME SURVEY_DEPLOYMENT_NAME
, SSS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SSS.DEPLOYMENT_STATUS DEPLOYMENT_STATUS
, SSS.SURVEY_STATUS SURVEY_STATUS
, SSS.TOTAL_ABANDONED TOTAL_ABANDONED
, SSS.TOTAL_ABORTED TOTAL_ABORTED
, SSS.DEPLOY_DATE DEPLOY_DATE
, SSS.RESPONSE_END_DATE RESPONSE_END_DATE
, SSS.MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, SSS.LIST_HEADER_ID LIST_HEADER_ID
, SSS.LIST_NAME LIST_NAME
, SSS.TOTAL_NO_SENT TOTAL_NO_SENT
, SSS.TOTAL_NO_ERRORS TOTAL_NO_ERRORS
, SSS.TOTAL_NO_RESPONSES_RECD TOTAL_NO_RESPONSES_RECD
, SSS.REFRESH_DATE REFRESH_DATE
, SSS.F_DELETEDFLAG F_DELETEDFLAG
FROM IES_SVY_SUMMARY_STATS SSS