VIEW: APPS.AMS_DS_INTERACTIONS_V

Source

View Text - Preformatted

SELECT act.ACTION_ITEM_ID, act.ACTION_ID, act.active, act.start_date_time, act.end_date_time, act.doc_id, act.doc_ref, act.outcome_id, act.media_id, act.activity_id, act.interaction_id, act.result_id, act.reason_id, act.SOURCE_CODE, act.SOURCE_CODE_ID, act.cust_account_id, act.OBJECT_ID, hz.party_name, int.resource_id, int.handler_id, int.party_id, out.outcome_code, rsl.result_code, rea.reason_code, actn.ACTION, aci.ACTION_ITEM, aci.ACTION_ITEM || actn.ACTION ACTIVITY, act.script_trans_id, out.short_description outcome_description, rsl.short_description result_description, rea.short_description reason_description, jmi.media_item_type, jmi.direction, act.AVT_SCRIPT_ID, int.creation_date ,rsl.POSITIVE_RESPONSE_FLAG FROM jtf_ih_activities act, jtf_ih_interactions int, hz_parties hz, jtf_ih_outcomes_tl out, jtf_ih_results_vl rsl, jtf_ih_reasons_tl rea, jtf_ih_action_items_tl aci, jtf_ih_actions_tl actn, jtf_ih_media_items jmi WHERE act.interaction_id = int.interaction_id AND int.party_id = hz.party_id AND act.outcome_id = out.outcome_id(+) AND out.language(+) = userenv('LANG') AND act.result_id = rsl.result_id(+) AND act.reason_id = rea.reason_id(+) AND rea.language(+) = userenv('LANG') AND act.action_item_id = aci.action_item_id(+) AND aci.language(+) = userenv('LANG') AND act.action_id = actn.action_id(+) AND actn.language(+) = userenv('LANG') AND act.media_id = jmi.media_id(+)

View Text - HTML Formatted

SELECT ACT.ACTION_ITEM_ID
, ACT.ACTION_ID
, ACT.ACTIVE
, ACT.START_DATE_TIME
, ACT.END_DATE_TIME
, ACT.DOC_ID
, ACT.DOC_REF
, ACT.OUTCOME_ID
, ACT.MEDIA_ID
, ACT.ACTIVITY_ID
, ACT.INTERACTION_ID
, ACT.RESULT_ID
, ACT.REASON_ID
, ACT.SOURCE_CODE
, ACT.SOURCE_CODE_ID
, ACT.CUST_ACCOUNT_ID
, ACT.OBJECT_ID
, HZ.PARTY_NAME
, INT.RESOURCE_ID
, INT.HANDLER_ID
, INT.PARTY_ID
, OUT.OUTCOME_CODE
, RSL.RESULT_CODE
, REA.REASON_CODE
, ACTN.ACTION
, ACI.ACTION_ITEM
, ACI.ACTION_ITEM || ACTN.ACTION ACTIVITY
, ACT.SCRIPT_TRANS_ID
, OUT.SHORT_DESCRIPTION OUTCOME_DESCRIPTION
, RSL.SHORT_DESCRIPTION RESULT_DESCRIPTION
, REA.SHORT_DESCRIPTION REASON_DESCRIPTION
, JMI.MEDIA_ITEM_TYPE
, JMI.DIRECTION
, ACT.AVT_SCRIPT_ID
, INT.CREATION_DATE
, RSL.POSITIVE_RESPONSE_FLAG
FROM JTF_IH_ACTIVITIES ACT
, JTF_IH_INTERACTIONS INT
, HZ_PARTIES HZ
, JTF_IH_OUTCOMES_TL OUT
, JTF_IH_RESULTS_VL RSL
, JTF_IH_REASONS_TL REA
, JTF_IH_ACTION_ITEMS_TL ACI
, JTF_IH_ACTIONS_TL ACTN
, JTF_IH_MEDIA_ITEMS JMI
WHERE ACT.INTERACTION_ID = INT.INTERACTION_ID
AND INT.PARTY_ID = HZ.PARTY_ID
AND ACT.OUTCOME_ID = OUT.OUTCOME_ID(+)
AND OUT.LANGUAGE(+) = USERENV('LANG')
AND ACT.RESULT_ID = RSL.RESULT_ID(+)
AND ACT.REASON_ID = REA.REASON_ID(+)
AND REA.LANGUAGE(+) = USERENV('LANG')
AND ACT.ACTION_ITEM_ID = ACI.ACTION_ITEM_ID(+)
AND ACI.LANGUAGE(+) = USERENV('LANG')
AND ACT.ACTION_ID = ACTN.ACTION_ID(+)
AND ACTN.LANGUAGE(+) = USERENV('LANG')
AND ACT.MEDIA_ID = JMI.MEDIA_ID(+)