Product: | AMS - Marketing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AMS_PERSON_INTERACT_ACT_V |
SELECT JIAV.ACTIVITY_ID
, JIAV.INTERACTION_ID
, JIAV.CREATION_DATE
, JIAV.CREATED_BY
, JIAV.LAST_UPDATE_DATE
, JIAV.LAST_UPDATED_BY
, JIAV.LAST_UPDATE_LOGIN
, HP.PARTY_ID
, HP.PARTY_NAME
, JIIV.RESOURCE_ID
, JIAV.MEDIA_ID
, JIIV.HANDLER_ID
, JIAV.START_DATE_TIME
, JIAV.END_DATE_TIME
, JIAV.TASK_ID
, JIAV.DOC_ID
, JIAV.DOC_REF
, JIAV.DOC_SOURCE_OBJECT_NAME
, JIAV.DURATION
, JIAV.DESCRIPTION
, JIAV.ROLE
, JIAV.OUTCOME_ID
, JIAV.RESULT_ID
, JIAV.REASON_ID
, JIAV.ACTION_ITEM_ID
, JIAV.ACTION_ID
, JIAV.OBJECT_ID
, JIAV.OBJECT_TYPE
, JIAV.SOURCE_CODE
, JIAV.SOURCE_CODE_ID
, JIAV.INTERACTION_ACTION_TYPE
, JIAV.OBJECT_VERSION_NUMBER
, JIAV.CUST_ACCOUNT_ID
, HCA.ACCOUNT_NUMBER
, JIAV.CREATED_BY CREATED_BY_NAME
, JIAV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, JIAV.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM JTF_IH_ACTIVITIES JIAV
, HZ_PARTIES HP
, JTF_IH_INTERACTIONS JIIV
, HZ_CUST_ACCOUNTS HCA
WHERE JIAV.INTERACTION_ID = JIIV.INTERACTION_ID
AND JIIV.PARTY_ID = HP.PARTY_ID
AND JIAV.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID(+)
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'