View: JTF_IH_ACTIVITIES_VL2

Product:	JTF - CRM Foundation
Description:	Interaction History Activities View
Implementation/DBA Data:	APPS.JTF_IH_ACTIVITIES_VL2

View Text

SELECT ACT.ROWID ROW_ID
, ACT.ACTIVITY_ID
, ACT.INTERACTION_ID
, INT.PARTY_ID
, HZ.PARTY_NAME
, ACT.CUST_ACCOUNT_ID
, HZCA.ACCOUNT_NUMBER
, INT.RESOURCE_ID
, RSC.RESOURCE_NAME
, ACT.ACTION_ITEM_ID
, ACI.ACTION_ITEM
, ACI.SHORT_DESCRIPTION ACI_DESC
, ACT.ACTION_ID
, ACTN.ACTION
, ACTN.SHORT_DESCRIPTION ACTN_DESC
, ACT.DOC_ID
, ACT.DOC_REF
, OBJTL.NAME BUSINESS_OBJECT
, ACT.MEDIA_ID
, MEDIA.DIRECTION
, MEDIA.MEDIA_DATA
, MEDIA.MEDIA_ITEM_REF
, MEDIA.MEDIA_ITEM_TYPE
, MEDIA.SOURCE_ITEM_ID MEDIA_SOURCE_ITEM_ID
, FNDLKUP.DESCRIPTION INTERACTION_TYPE
, DECODE(MEDIA.DIRECTION || '_' || MEDIA.MEDIA_ITEM_TYPE
, '_'
, 'ACTIVITY'
, MEDIA.DIRECTION || '_' || MEDIA.MEDIA_ITEM_TYPE) INTERACTION_TYPE_CODE
, ACT.ACTIVE
, ACT.START_DATE_TIME
, ACT.END_DATE_TIME
, ACT.DURATION
, ACT.OUTCOME_ID
, OUT.OUTCOME_CODE
, OUT.SHORT_DESCRIPTION OUT_DESC
, ACT.RESULT_ID
, RSL.RESULT_CODE
, RSL.SHORT_DESCRIPTION RSL_DESC
, ACT.REASON_ID
, REA.REASON_CODE
, REA.SHORT_DESCRIPTION REA_DESC
, ACT.SOURCE_CODE
, ACT.SOURCE_CODE_ID
, ACT.OBJECT_TYPE
, ACT.OBJECT_ID
, ACT.CREATION_DATE
, ACT.CREATED_BY
, ACT.LAST_UPDATE_DATE
, ACT.LAST_UPDATED_BY
, ACT.LAST_UPDATE_LOGIN
, ACT.OBJECT_VERSION_NUMBER
, FNDAPP.APPLICATION_NAME
, ACT.BULK_WRITER_CODE
, ACT.BULK_BATCH_TYPE
, ACT.BULK_BATCH_ID
, ACT.BULK_INTERACTION_ID
FROM JTF_IH_ACTIVITIES ACT
, JTF_IH_INTERACTIONS INT
, HZ_PARTIES HZ
, JTF_IH_MEDIA_ITEMS MEDIA
, JTF_IH_OUTCOMES_TL OUT
, JTF_IH_RESULTS_TL RSL
, JTF_IH_REASONS_TL REA
, JTF_IH_ACTION_ITEMS_TL ACI
, JTF_IH_ACTIONS_TL ACTN
, JTF_RS_RESOURCE_EXTNS_TL RSC
, HZ_CUST_ACCOUNTS HZCA
, JTF_OBJECTS_TL OBJTL
, FND_LOOKUPS FNDLKUP
, FND_APPLICATION_TL FNDAPP
WHERE ACT.INTERACTION_ID = INT.INTERACTION_ID
AND INT.PARTY_ID = HZ.PARTY_ID
AND ACT.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID(+)
AND INT.RESOURCE_ID = RSC.RESOURCE_ID
AND INT.HANDLER_ID = FNDAPP.APPLICATION_ID
AND FNDAPP.LANGUAGE(+) = USERENV('LANG')
AND ACT.MEDIA_ID = MEDIA.MEDIA_ID(+)
AND ACT.OUTCOME_ID = OUT.OUTCOME_ID(+)
AND OUT.LANGUAGE(+) = USERENV('LANG')
AND ACT.RESULT_ID = RSL.RESULT_ID(+)
AND RSL.LANGUAGE(+) = USERENV('LANG')
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.DOC_REF = OBJTL.OBJECT_CODE(+)
AND OBJTL.LANGUAGE(+) = USERENV('LANG')
AND (FNDLKUP.LOOKUP_TYPE(+) = 'JTF_IH_OBJECT_TYPE'
AND DECODE(MEDIA.DIRECTION || '_' || MEDIA.MEDIA_ITEM_TYPE
, '_'
, 'ACTIVITY'
, MEDIA.DIRECTION || '_' || MEDIA.MEDIA_ITEM_TYPE) = FNDLKUP.LOOKUP_CODE(+))

Columns