View: BIC_INTERACTIONS_SUMMARY_V

View Text

SELECT H.ACCOUNT_NUMBER
, I.INTERACTION_ID
, I.HANDLER_ID APPLICATION
, I.ACTIVE STATUS
, I.START_DATE_TIME START_DATE
, I.END_DATE_TIME END_DATE
, I.PARTY_ID
, H.CUST_ACCOUNT_ID
, SUBSTR(O.SHORT_DESCRIPTION
, 1
, 20) OUTCOME
, SUBSTR(R.SHORT_DESCRIPTION
, 1
, 20) REASON
, SUBSTR(S.SHORT_DESCRIPTION
, 1
, 20) RESULT
, A.ACTIVITY_ID
FROM JTF_IH_INTERACTIONS I
, JTF_IH_ACTIVITIES A
, HZ_CUST_ACCOUNTS H
, JTF_IH_OUTCOMES_TL O
, JTF_IH_REASONS_TL R
, JTF_IH_RESULTS_TL S
WHERE I.INTERACTION_ID = A.INTERACTION_ID(+)
AND A.CUST_ACCOUNT_ID = H.CUST_ACCOUNT_ID(+)
AND I.OUTCOME_ID = O.OUTCOME_ID(+)
AND I.REASON_ID = R.REASON_ID(+)
AND I.RESULT_ID = S.RESULT_ID(+) WITH READ ONLY

Columns