Product: | BIC - Customer Intelligence (obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT P.CUSTOMER_NAME
, P.ACCOUNT_NUMBER
, A.INTERACTION_ID
, A.START_DATE_TIME
, A.OUTCOME_ID
, A.REASON_ID
, A.RESULT_ID
, I.RESOURCE_ID
, A.DOC_SOURCE_OBJECT_NAME
, A.CUST_ACCOUNT_ID
, A.CUST_ORG_ID
, O.SHORT_DESCRIPTION OUTCOME
, R.SHORT_DESCRIPTION REASON
, S.SHORT_DESCRIPTION RESULT
, E.RESOURCE_NAME
, E.PHONE
FROM JTF_IH_INTERACTIONS I
, JTF_IH_ACTIVITIES A
, BIC_PARTIES_V P
, JTF_IH_OUTCOMES_TL O
, JTF_IH_REASONS_TL R
, JTF_IH_RESULTS_TL S
, JTF_RS_RESOURCE_DTLS_VL E
WHERE A.CUST_ACCOUNT_ID = P.CUST_ACCOUNT_ID
AND A.INTERACTION_ID(+) = I.INTERACTION_ID
AND I.OUTCOME_ID = O.OUTCOME_ID(+)
AND I.REASON_ID = R.REASON_ID(+)
AND I.RESULT_ID = S.RESULT_ID(+)
AND I.RESOURCE_ID = E.RESOURCE_ID WITH READ ONLY