[Home] [Help]
View: AS_SCRIPT_ACT_ANS_DISTINCT_Q_V
Product: | AS - Sales Foundation |
Description: | Distinct questions from answers view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT AA.SCRIPT_ID
, AA.INTERACTION_ID
, AA.CUSTOMER_ID
, AA.ADDRESS_ID
, AA.CONTACT_ID
, AA.QUESTION_ID
, QU.TEXT
FROM AS_SCRIPT_ACTUAL_ANSWERS AA
, AS_SCRIPT_QUESTIONS QU
WHERE QU.SCRIPT_QUESTION_ID(+) = AA.QUESTION_ID
Columns
Name |
SCRIPT_ID |
INTERACTION_ID |
CUSTOMER_ID |
ADDRESS_ID |
CONTACT_ID |
QUESTION_ID |
QUESTION_TEXT |