VIEW: APPS.IES_SVY_DEPLYMENTS_V

Source

View Text - Preformatted

SELECT SDA.SURVEY_DEPLOYMENT_ID SURVEY_DEPLOYMENT_ID, SDA.DEPLOYMENT_NAME DEPLOYMENT_NAME, SDA.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SDA.CREATED_BY CREATED_BY, SDA.CREATION_DATE CREATION_DATE, SDA.LAST_UPDATED_BY LAST_UPDATED_BY, SDA.LAST_UPDATE_DATE LAST_UPDATE_DATE, SDA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SDA.SURVEY_CYCLE_ID SURVEY_CYCLE_ID, SDA.DSCRIPT_ID DSCRIPT_ID, SDA.MEDIA_TYPE_CODE MEDIA_TYPE_CODE, SDA.DEPLOY_DATE DEPLOY_DATE, SDA.RESPONSE_END_DATE RESPONSE_END_DATE, SDA.DEPLOYMENT_STATUS_CODE DEPLOYMENT_STATUS_CODE, SDA.IS_EMPLOYEE_LIST IS_EMPLOYEE_LIST, SDA.LIST_HEADER_ID LIST_HEADER_ID, SDA.TEMPLATE_ID TEMPLATE_ID, SDA.REMINDER_TEMPLATE_ID REMINDER_TEMPLATE_ID, SDA.MAX_RESPONSES_PER_PERSON MAX_RESPONSES_PER_PERSON, SDA.MIN_RESPONSES_FOR_CLOSE MIN_RESPONSES_FOR_CLOSE, SDA.EMAIL_SUBJECT_HEADING EMAIL_SUBJECT_HEADING, SDA.CONCURRENT_REQ_ID CONCURRENT_REQ_ID, SDA.FULFILLMENT_REQ_ID FULFILLMENT_REQ_ID, SDA.ORG_ID ORG_ID, SDA.F_DELETEDFLAG F_DELETEDFLAG, SDA.DEPLOYMENT_TYPE_CODE DEPLOYMENT_TYPE_CODE FROM IES_SVY_DEPLYMENTS_ALL SDA

View Text - HTML Formatted

SELECT SDA.SURVEY_DEPLOYMENT_ID SURVEY_DEPLOYMENT_ID
, SDA.DEPLOYMENT_NAME DEPLOYMENT_NAME
, SDA.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SDA.CREATED_BY CREATED_BY
, SDA.CREATION_DATE CREATION_DATE
, SDA.LAST_UPDATED_BY LAST_UPDATED_BY
, SDA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SDA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SDA.SURVEY_CYCLE_ID SURVEY_CYCLE_ID
, SDA.DSCRIPT_ID DSCRIPT_ID
, SDA.MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, SDA.DEPLOY_DATE DEPLOY_DATE
, SDA.RESPONSE_END_DATE RESPONSE_END_DATE
, SDA.DEPLOYMENT_STATUS_CODE DEPLOYMENT_STATUS_CODE
, SDA.IS_EMPLOYEE_LIST IS_EMPLOYEE_LIST
, SDA.LIST_HEADER_ID LIST_HEADER_ID
, SDA.TEMPLATE_ID TEMPLATE_ID
, SDA.REMINDER_TEMPLATE_ID REMINDER_TEMPLATE_ID
, SDA.MAX_RESPONSES_PER_PERSON MAX_RESPONSES_PER_PERSON
, SDA.MIN_RESPONSES_FOR_CLOSE MIN_RESPONSES_FOR_CLOSE
, SDA.EMAIL_SUBJECT_HEADING EMAIL_SUBJECT_HEADING
, SDA.CONCURRENT_REQ_ID CONCURRENT_REQ_ID
, SDA.FULFILLMENT_REQ_ID FULFILLMENT_REQ_ID
, SDA.ORG_ID ORG_ID
, SDA.F_DELETEDFLAG F_DELETEDFLAG
, SDA.DEPLOYMENT_TYPE_CODE DEPLOYMENT_TYPE_CODE
FROM IES_SVY_DEPLYMENTS_ALL SDA