VIEW: APPS.IEX_INT_ACTIVITY_HISTORY_V

Source

View Text - Preformatted

SELECT JIA.interaction_id, JIA.cust_account_id, JIA.activity_id, JIA.action_id, (select short_description from jtf_ih_actions_vl where action_id = jia.action_id) action_desc, JIA.outcome_id, (select short_description from jtf_ih_outcomes_vl where outcome_id = jia.outcome_id) outcome_desc, JIA.reason_id, (select short_description from jtf_ih_reasons_vl where reason_id = jia.reason_id) reason_desc, JIA.result_id, (select short_description from jtf_ih_results_vl where result_id = jia.result_id) result_desc, JIA.duration, JIA.doc_id, JIA.doc_ref, JIA.object_id, JIA.object_type, JIA.source_code_id, JIA.source_code, (Select Name from JTF_Objects_vl where object_code = JIA.doc_ref) object_name, JIA.doc_source_object_name, HZCA.Account_Number FROM JTF_IH_ACTIVITIES JIA, HZ_CUST_ACCOUNTS HZCA WHERE hzca.cust_account_id (+) = jia.cust_account_id

View Text - HTML Formatted

SELECT JIA.INTERACTION_ID
, JIA.CUST_ACCOUNT_ID
, JIA.ACTIVITY_ID
, JIA.ACTION_ID
, (SELECT SHORT_DESCRIPTION
FROM JTF_IH_ACTIONS_VL
WHERE ACTION_ID = JIA.ACTION_ID) ACTION_DESC
, JIA.OUTCOME_ID
, (SELECT SHORT_DESCRIPTION
FROM JTF_IH_OUTCOMES_VL
WHERE OUTCOME_ID = JIA.OUTCOME_ID) OUTCOME_DESC
, JIA.REASON_ID
, (SELECT SHORT_DESCRIPTION
FROM JTF_IH_REASONS_VL
WHERE REASON_ID = JIA.REASON_ID) REASON_DESC
, JIA.RESULT_ID
, (SELECT SHORT_DESCRIPTION
FROM JTF_IH_RESULTS_VL
WHERE RESULT_ID = JIA.RESULT_ID) RESULT_DESC
, JIA.DURATION
, JIA.DOC_ID
, JIA.DOC_REF
, JIA.OBJECT_ID
, JIA.OBJECT_TYPE
, JIA.SOURCE_CODE_ID
, JIA.SOURCE_CODE
, (SELECT NAME
FROM JTF_OBJECTS_VL
WHERE OBJECT_CODE = JIA.DOC_REF) OBJECT_NAME
, JIA.DOC_SOURCE_OBJECT_NAME
, HZCA.ACCOUNT_NUMBER
FROM JTF_IH_ACTIVITIES JIA
, HZ_CUST_ACCOUNTS HZCA
WHERE HZCA.CUST_ACCOUNT_ID (+) = JIA.CUST_ACCOUNT_ID