FND Design Data [Home] [Help]

View: IES_SVY_DEPLYMENTS_V

Product: IES - Scripting
Description:
Implementation/DBA Data: ViewAPPS.IES_SVY_DEPLYMENTS_V
View Text

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

Columns

Name
SURVEY_DEPLOYMENT_ID
DEPLOYMENT_NAME
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SURVEY_CYCLE_ID
MEDIA_TYPE_CODE
DEPLOY_DATE
RESPONSE_END_DATE
DEPLOYMENT_STATUS_CODE
IS_EMPLOYEE_LIST
LIST_HEADER_ID
TEMPLATE_ID
REMINDER_TEMPLATE_ID
MAX_RESPONSES_PER_PERSON
MIN_RESPONSES_FOR_CLOSE
EMAIL_SUBJECT_HEADING
CONCURRENT_REQ_ID
FULFILLMENT_REQ_ID
ORG_ID
F_DELETEDFLAG
SECURITY_GROUP_ID