Product: | IES - Scripting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IES_SVY_DEPLYMENTS_V |
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.MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, SDA.DEPLOY_DATE DEPLOY_DATE
, SDA.RESPONSE_END_DATE RESPONSE_END_DATE
, SDA.DEPLOYMENT_STATUS_CODE DEPLOYEMNT_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.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM IES_SVY_DEPLYMENTS_ALL SDA