eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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