SELECT P.CUSTOMER_NAME , P.ACCOUNT_NUMBER , I.INTERACTION_ID , I.START_DATE_TIME , I.PARTY_ID , I.OUTCOME_ID , I.REASON_ID , I.RESULT_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 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 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(+) WITH READ ONLY
[Home] [Help]