Product: | JTF - CRM Foundation |
---|---|
Description: | Used for generating reports for records in table JTF_IH_ACTIVITIES. |
Implementation/DBA Data: | APPS.JTF_IH_ACTIVITIES_V |
SELECT ACT.ROWID ROW_ID
, ACT.DOC_SOURCE_OBJECT_NAME
, ACT.ACTIVITY_ID
, ACT.OBJECT_VERSION_NUMBER
, ACT.CREATION_DATE
, ACT.CREATED_BY
, ACT.LAST_UPDATED_BY
, ACT.LAST_UPDATE_DATE
, ACT.LAST_UPDATE_LOGIN
, ACT.CUST_ACCOUNT_ID
, ACT.CUST_ORG_ID
, ACT.INTERACTION_ID
, ACT.ACTION_ITEM_ID
, ITM.ACTION_ITEM
, ACT.OBJECT_ID
, ACT.OBJECT_TYPE
, ACT.SOURCE_CODE_ID
, ACT.SOURCE_CODE
, ACT.DOC_ID
, ACT.DOC_REF
, ACT.RESULT_ID
, ACT.REASON_ID
, ACT.MEDIA_ID
, ACT.OUTCOME_ID
, ACT.TASK_ID
, ACT.ACTION_ID
, ACT.DURATION
, ACT.DESCRIPTION
, ACT.END_DATE_TIME
, ACT.ROLE
, ACT.START_DATE_TIME
, ACT.INTERACTION_ACTION_TYPE
, ACT.ACTIVE
, ACT.SCRIPT_TRANS_ID
FROM JTF_IH_ACTIVITIES ACT
, JTF_IH_ACTION_ITEMS_TL ITM
WHERE ACT.ACTION_ITEM_ID = ITM.ACTION_ITEM_ID
AND ITM.LANGUAGE = USERENV('LANG')