[Home] [Help]
View: AS_SCRIPT_ANSWERS_ACTS_EXIST_V
Product: | AS - Sales Foundation |
Description: | Script answers view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PDA.SCRIPT_PRE_DEF_ANSWER_ID
, PDA.LABEL
, PDA.ANSWER
, PDA.SCRIPT_ID
, Q.QUESTION_SEQ
, SUBSTR(Q.TEXT
, 1
, 240)
FROM AS_SCRIPT_PRE_DEFINED_ANSWERS PDA
, AS_SCRIPT_QUESTIONS Q
WHERE PDA.QUESTION_ID = Q.SCRIPT_QUESTION_ID
AND EXISTS (SELECT AA.PRE_DEF_ANSWER_ID
FROM AS_SCRIPT_ANSWER_ACTIONS AA
WHERE AA.PRE_DEF_ANSWER_ID = PDA.SCRIPT_PRE_DEF_ANSWER_ID)
Columns
Name |
PRE_DEF_ANSWER_ID |
ANSWER_LABEL |
ANSWER |
SCRIPT_ID |
QUESTION_SEQ |
QUESTION_TEXT |