Product: | JTF - CRM Foundation |
---|---|
Description: | Translated view of the related Action (JTF_IH_ACTIONS_VL) and Action Item (JTF_IH_ACTION_ITEMS_VL) pairs. Used to default Interaction Activity wrap-up values. |
Implementation/DBA Data: | APPS.JTF_IH_ACTION_ACTION_ITEMS_VL |
SELECT AAI.ACTION_ITEM_ID
, AAI.ACTION_ID
, AW.OUTCOME_ID
, AW.RESULT_ID
, AW.REASON_ID
, AAI.DEFAULT_WRAP_ID
, AI.SHORT_DESCRIPTION
, A.SHORT_DESCRIPTION
, AW.OUTCOME_SHORT_DESC
, AW.RESULT_SHORT_DESC
, AW.REASON_SHORT_DESC
, A.ACTIVE
, AI.ACTIVE
, AAI.OBJECT_VERSION_NUMBER
, AAI.CREATED_BY
, AAI.CREATION_DATE
, AAI.LAST_UPDATED_BY
, AAI.LAST_UPDATE_DATE
, AAI.LAST_UPDATE_LOGIN
, AW.START_DATE
, AW.END_DATE
FROM JTF_IH_ACTION_ACTION_ITEMS AAI
, JTF_IH_ACTION_ITEMS_VL AI
, JTF_IH_ACTIONS_VL A
, JTF_IH_WRAP_UPS_VL AW
WHERE AAI.ACTION_ID=A.ACTION_ID
AND AAI.ACTION_ITEM_ID=AI.ACTION_ITEM_ID
AND AAI.DEFAULT_WRAP_ID=AW.WRAP_ID(+)