Product: | AS - Sales Foundation |
---|---|
Description: | Script actual answers view |
Implementation/DBA Data: | Not implemented in this database |
SELECT AA.ROWID
, AA.SCRIPT_ACTUAL_ANSWER_ID
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATED_BY
, AA.CREATION_DATE
, AA.CREATED_BY
, AA.LAST_UPDATE_LOGIN
, AA.SCRIPT_ID
, AA.INTERACTION_ID
, AA.CUSTOMER_ID
, AA.ADDRESS_ID
, AA.CONTACT_ID
, AA.EVENT_OFFERING_ID
, AA.PRE_DEF_ANSWER_ID
, PDA.ENABLED_FLAG
, PDA.QUESTION_SEQ
, PDA.LABEL
, PDA.ANSWER
, AA.QUESTION_ID
, AA.COMMENTS
, AA.STATUS_CODE
, ASLKP.MEANING
, AA.ATTRIBUTE_CATEGORY
, AA.ATTRIBUTE1
, AA.ATTRIBUTE2
, AA.ATTRIBUTE3
, AA.ATTRIBUTE4
, AA.ATTRIBUTE5
, AA.ATTRIBUTE6
, AA.ATTRIBUTE7
, AA.ATTRIBUTE8
, AA.ATTRIBUTE9
, AA.ATTRIBUTE10
, AA.ATTRIBUTE11
, AA.ATTRIBUTE12
, AA.ATTRIBUTE13
, AA.ATTRIBUTE14
, AA.ATTRIBUTE15
FROM AS_LOOKUPS ASLKP
, AS_SCRIPT_ACTUAL_ANSWERS AA
, AS_SCRIPT_PRE_DEFINED_ANSWERS PDA
WHERE PDA.SCRIPT_PRE_DEF_ANSWER_ID = AA.PRE_DEF_ANSWER_ID
AND AA.STATUS_CODE = ASLKP.LOOKUP_CODE(+)
AND ASLKP.LOOKUP_TYPE(+)= 'PROCESSING_STATUS'