View: AS_SCRIPT_ACT_ANS_DISTINCT_V

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