View: AMS_ORG_INTERACTIONS_V

Product:	AMS - Marketing
Description:	A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked.
Implementation/DBA Data:	APPS.AMS_ORG_INTERACTIONS_V

View Text

SELECT JIIV.INTERACTION_ID
, HCA.CUST_ACCOUNT_ID
, JIIV.CREATION_DATE
, JIIV.CREATED_BY
, JIIV.LAST_UPDATE_DATE
, JIIV.LAST_UPDATED_BY
, JIIV.LAST_UPDATE_LOGIN
, JIIV.PARTY_ID
, HP.PARTY_NAME
, HCA.ACCOUNT_NUMBER
, JIIV.RESOURCE_ID
, JIIV.HANDLER_ID
, JIIV.START_DATE_TIME
, JIIV.END_DATE_TIME
, JIIV.DURATION
, JIIV.OUTCOME_ID
, JIIV.RESULT_ID
, JIIV.REASON_ID
, JIIV.FOLLOW_UP_ACTION
, JIIV.INTER_INTERACTION_DURATION
, JIIV.INTERACTION_INTERS_ID
, JIIV.METHOD_CODE
, JIIV.NON_PRODUCTIVE_TIME_AMOUNT
, JIIV.OBJECT_ID
, JIIV.OBJECT_TYPE
, JIIV.OBJECT_VERSION_NUMBER
, JIIV.PREVIEW_TIME_AMOUNT
, JIIV.PRODUCTIVE_TIME_AMOUNT
, JIIV.REFERENCE_FORM
, JIIV.SCRIPT_ID
, JIIV.SOURCE_CODE
, JIIV.SOURCE_CODE_ID
, JIIV.WRAP_UP_TIME_AMOUNT
, JIIV.ATTRIBUTE_CATEGORY
, JIIV.ATTRIBUTE1
, JIIV.ATTRIBUTE2
, JIIV.ATTRIBUTE3
, JIIV.ATTRIBUTE4
, JIIV.ATTRIBUTE5
, JIIV.ATTRIBUTE6
, JIIV.ATTRIBUTE7
, JIIV.ATTRIBUTE8
, JIIV.ATTRIBUTE9
, JIIV.ATTRIBUTE10
, JIIV.ATTRIBUTE11
, JIIV.ATTRIBUTE12
, JIIV.ATTRIBUTE13
, JIIV.ATTRIBUTE14
, JIIV.ATTRIBUTE15
, JIIV.CREATED_BY CREATED_BY_NAME
, JIIV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, JIIV.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM JTF_IH_INTERACTIONS JIIV
, HZ_PARTIES HP
, JTF_IH_ACTIVITIES JIA
, HZ_CUST_ACCOUNTS HCA
WHERE JIIV.INTERACTION_ID = JIA.INTERACTION_ID
AND JIIV.PARTY_ID = HP.PARTY_ID
AND JIA.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID(+)
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'ORGANIZATION'

Columns