Product: | AMS - Marketing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AMS_DS_INTERACTIONS_V |
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(+)