[Home] [Help]
View: AS_SCRIPT_PRE_DEF_ANS_ACTIVE_V
Product: | AS - Sales Foundation |
Description: | Active predefined answers view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PDA.SCRIPT_PRE_DEF_ANSWER_ID
, PDA.QUESTION_ID
, PDA.QUESTION_SEQ
, PDA.LABEL
, PDA.ANSWER
, PDA.SCRIPT_ID
, PDA.NEXT_QUESTION_SEQ
FROM AS_SCRIPT_PRE_DEFINED_ANSWERS PDA
, AS_SCRIPT_QUESTIONS QUES
WHERE QUES.ENABLED_FLAG = 'Y'
AND QUES.SCRIPT_QUESTION_ID = PDA.QUESTION_ID
AND PDA.ENABLED_FLAG = 'Y'
Columns
Name |
SCRIPT_PRE_DEF_ANSWER_ID |
QUESTION_ID |
QUESTION_SEQ |
LABEL |
ANSWER |
SCRIPT_ID |
NEXT_QUESTION_SEQ |