View: BIC_INTERACTIONS_DETAIL_V

View Text

SELECT I.INTERACTION_ID
, A.ACTIVITY_ID
, I.START_DATE_TIME
, I.START_DATE_TIME INTERACTION_DATE
, I.PARTY_ID
, A.DOC_SOURCE_OBJECT_NAME DOC_ID
, M.MEDIA_ITEM_TYPE MEDIA
, A.CUST_ACCOUNT_ID
, A.CUST_ORG_ID
, SUBSTR(O.SHORT_DESCRIPTION
, 1
, 20) OUTCOME
, SUBSTR(R.SHORT_DESCRIPTION
, 1
, 20) REASON
, SUBSTR(S.SHORT_DESCRIPTION
, 1
, 20) RESULT
, EMP.FULL_NAME EMPNAME
, EMP.WORK_TELEPHONE EMPPHONE
FROM JTF_IH_ACTIVITIES A
, JTF_IH_INTERACTIONS I
, BIC_PARTIES_V P
, JTF_RS_RESOURCE_EXTNS RSC
, PER_PEOPLE_F EMP
, JTF_IH_MEDIA_ITEMS M
, JTF_IH_OUTCOMES_TL O
, JTF_IH_REASONS_TL R
, JTF_IH_RESULTS_TL S
WHERE I.INTERACTION_ID = A.INTERACTION_ID(+)
AND RSC.CATEGORY = 'EMPLOYEE'
AND RSC.SOURCE_ID = EMP.PERSON_ID
AND I.START_DATE_TIME BETWEEN EMP.EFFECTIVE_START_DATE
AND EMP.EFFECTIVE_END_DATE
AND A.CUST_ACCOUNT_ID = P.CUST_ACCOUNT_ID (+)
AND I.RESOURCE_ID = RSC.RESOURCE_ID(+)
AND A.MEDIA_ID=M.MEDIA_ID(+)
AND I.OUTCOME_ID=O.OUTCOME_ID(+)
AND I.RESULT_ID=S.RESULT_ID(+)
AND I.REASON_ID=R.REASON_ID(+) WITH READ ONLY

Columns