[Home] [Help]
View: AS_SCRIPT_ACT_ANS_DISTINCT_V
Product: | AS - Sales Foundation |
Description: | Distinct actual answers view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT AA.SCRIPT_ID
, PROM.CODE
, PROM.NAME
, PROM.SCRIPT_TYPE
, ASLKP.MEANING
, INT.TODO_ID
, INT.CREATION_DATE
, INT.ASSIGN_TO_PERSON_ID
, PER.FIRST_NAME
, PER.LAST_NAME
, AA.CUSTOMER_ID
, AA.ADDRESS_ID
, AA.CONTACT_ID
FROM AS_SCRIPT_ACTUAL_ANSWERS AA
, AS_LOOKUPS ASLKP
, AS_PROMOTIONS PROM
, AS_TODO_LISTS INT
, PER_ALL_PEOPLE_F PER
WHERE AA.SCRIPT_ID = PROM.PROMOTION_ID
AND AA.INTERACTION_ID = INT.TODO_ID
AND INT.ASSIGN_TO_PERSON_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PROM.SCRIPT_TYPE = ASLKP.LOOKUP_CODE
AND ASLKP.LOOKUP_TYPE = 'SCRIPT_TYPE'
Columns
Name |
SCRIPT_ID |
SCRIPT_CODE |
SCRIPT_NAME |
SCRIPT_TYPE_CODE |
SCRIPT_TYPE |
INTERACTION_ID |
INTERACTION_DATE |
PERSON_ID |
PERSON_FIRST_NAME |
PERSON_LAST_NAME |
CUSTOMER_ID |
ADDRESS_ID |
CONTACT_ID |