eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JTF_IH_ACTIVITIES_VL3

Source

View Text - Preformatted


SELECT act.rowid row_id, act.CREATION_DATE, act.CREATED_BY, act.LAST_UPDATE_DATE, act.LAST_UPDATED_BY, act.LAST_UPDATE_LOGIN, act.ATTRIBUTE_CATEGORY, act.ATTRIBUTE1, act.ATTRIBUTE2, act.ATTRIBUTE3, act.ATTRIBUTE4, act.ATTRIBUTE5, act.ATTRIBUTE6, act.ATTRIBUTE7, act.ATTRIBUTE8, act.ATTRIBUTE9, act.ATTRIBUTE10, act.ATTRIBUTE11, act.ATTRIBUTE12, act.ATTRIBUTE13, act.ATTRIBUTE14, act.ATTRIBUTE15, act.active, act.start_date_time, act.end_date_time, act.task_id, act.doc_id, act.doc_ref, act.doc_source_object_name, act.duration, act.description, act.role, act.outcome_id, act.media_id, act.activity_id, act.interaction_id, act.result_id, act.reason_id, act.ACTION_ITEM_ID, act.ACTION_ID, act.OBJECT_TYPE, act.SOURCE_CODE, act.SOURCE_CODE_ID, act.INTERACTION_ACTION_TYPE, act.object_version_number, act.cust_account_id, act.OBJECT_ID, hz.party_name, int.resource_id, int.handler_id, int.party_id, rsc.resource_name, media.direction, media.media_data, media.media_item_ref, media.media_item_type, media.direction || media.media_item_type mediadirtype, media.source_item_id media_source_item_id, app.application_short_name, out.outcome_code, out.short_description out_desc, rsl.result_code, rsl.short_description rsl_desc, rea.reason_code, rea.short_description rea_desc, actn.ACTION, aci.ACTION_ITEM, aci.ACTION_ITEM || actn.ACTION ACTITM, hzca.account_number, obj.object_function, obj.object_parameters, act.script_trans_id, app.APPLICATION_NAME, out.short_description, rsl.short_description, rea.short_description, aci.short_description, actn.short_description, ACT.BULK_WRITER_CODE, ACT.BULK_BATCH_TYPE, ACT.BULK_BATCH_ID, ACT.BULK_INTERACTION_ID, int.CONTACT_PARTY_ID, int.CONTACT_REL_PARTY_ID, int.PRIMARY_PARTY_ID, DECODE(NVL(int.PRIMARY_PARTY_ID,''),'','',(select Party_Name from hz_Parties where Party_id=int.PRIMARY_PARTY_ID)) AS CUSTOMER_NAME, DECODE(NVL(int.CONTACT_PARTY_ID,''),'','',(select Party_Name from hz_Parties where Party_id=int.CONTACT_PARTY_ID)) AS CONTACT_NAME, obj.launch_method, fndlu.meaning, fndmi.description MEDIA_ITEM_DESC FROM jtf_ih_activities act, jtf_ih_interactions int, hz_parties hz, jtf_ih_media_items media, fnd_application_vl app, 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_tasks_b tsk, jtf_rs_resource_extns_vl rsc, hz_cust_accounts hzca, jtf_objects_b obj, hz_parties hz2, fnd_lookup_values fndlu , fnd_lookup_values fndmi 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 act.media_id = media.media_id(+) AND int.handler_id = app.application_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.task_id = tsk.task_id(+) AND act.doc_ref = obj.object_code(+) AND int.contact_party_id = hz2.party_id(+) AND int.primary_party_id = hz2.party_id(+) AND fndlu.lookup_type(+) = 'JTF_IH_MEDIA_DIRECTION' AND fndlu.language(+) = userenv('LANG') AND fndlu.lookup_code(+) = media.direction AND fndmi.lookup_type(+) = 'JTF_IH_ALL_MEDIA_TYPES' AND fndmi.language(+) = userenv('LANG') AND fndmi.lookup_code(+) = media.media_item_type

View Text - HTML Formatted

SELECT ACT.ROWID ROW_ID
, ACT.CREATION_DATE
, ACT.CREATED_BY
, ACT.LAST_UPDATE_DATE
, ACT.LAST_UPDATED_BY
, ACT.LAST_UPDATE_LOGIN
, ACT.ATTRIBUTE_CATEGORY
, ACT.ATTRIBUTE1
, ACT.ATTRIBUTE2
, ACT.ATTRIBUTE3
, ACT.ATTRIBUTE4
, ACT.ATTRIBUTE5
, ACT.ATTRIBUTE6
, ACT.ATTRIBUTE7
, ACT.ATTRIBUTE8
, ACT.ATTRIBUTE9
, ACT.ATTRIBUTE10
, ACT.ATTRIBUTE11
, ACT.ATTRIBUTE12
, ACT.ATTRIBUTE13
, ACT.ATTRIBUTE14
, ACT.ATTRIBUTE15
, ACT.ACTIVE
, ACT.START_DATE_TIME
, ACT.END_DATE_TIME
, ACT.TASK_ID
, ACT.DOC_ID
, ACT.DOC_REF
, ACT.DOC_SOURCE_OBJECT_NAME
, ACT.DURATION
, ACT.DESCRIPTION
, ACT.ROLE
, ACT.OUTCOME_ID
, ACT.MEDIA_ID
, ACT.ACTIVITY_ID
, ACT.INTERACTION_ID
, ACT.RESULT_ID
, ACT.REASON_ID
, ACT.ACTION_ITEM_ID
, ACT.ACTION_ID
, ACT.OBJECT_TYPE
, ACT.SOURCE_CODE
, ACT.SOURCE_CODE_ID
, ACT.INTERACTION_ACTION_TYPE
, ACT.OBJECT_VERSION_NUMBER
, ACT.CUST_ACCOUNT_ID
, ACT.OBJECT_ID
, HZ.PARTY_NAME
, INT.RESOURCE_ID
, INT.HANDLER_ID
, INT.PARTY_ID
, RSC.RESOURCE_NAME
, MEDIA.DIRECTION
, MEDIA.MEDIA_DATA
, MEDIA.MEDIA_ITEM_REF
, MEDIA.MEDIA_ITEM_TYPE
, MEDIA.DIRECTION || MEDIA.MEDIA_ITEM_TYPE MEDIADIRTYPE
, MEDIA.SOURCE_ITEM_ID MEDIA_SOURCE_ITEM_ID
, APP.APPLICATION_SHORT_NAME
, OUT.OUTCOME_CODE
, OUT.SHORT_DESCRIPTION OUT_DESC
, RSL.RESULT_CODE
, RSL.SHORT_DESCRIPTION RSL_DESC
, REA.REASON_CODE
, REA.SHORT_DESCRIPTION REA_DESC
, ACTN.ACTION
, ACI.ACTION_ITEM
, ACI.ACTION_ITEM || ACTN.ACTION ACTITM
, HZCA.ACCOUNT_NUMBER
, OBJ.OBJECT_FUNCTION
, OBJ.OBJECT_PARAMETERS
, ACT.SCRIPT_TRANS_ID
, APP.APPLICATION_NAME
, OUT.SHORT_DESCRIPTION
, RSL.SHORT_DESCRIPTION
, REA.SHORT_DESCRIPTION
, ACI.SHORT_DESCRIPTION
, ACTN.SHORT_DESCRIPTION
, ACT.BULK_WRITER_CODE
, ACT.BULK_BATCH_TYPE
, ACT.BULK_BATCH_ID
, ACT.BULK_INTERACTION_ID
, INT.CONTACT_PARTY_ID
, INT.CONTACT_REL_PARTY_ID
, INT.PRIMARY_PARTY_ID
, DECODE(NVL(INT.PRIMARY_PARTY_ID
, '')
, ''
, ''
, (SELECT PARTY_NAME
FROM HZ_PARTIES
WHERE PARTY_ID=INT.PRIMARY_PARTY_ID)) AS CUSTOMER_NAME
, DECODE(NVL(INT.CONTACT_PARTY_ID
, '')
, ''
, ''
, (SELECT PARTY_NAME
FROM HZ_PARTIES
WHERE PARTY_ID=INT.CONTACT_PARTY_ID)) AS CONTACT_NAME
, OBJ.LAUNCH_METHOD
, FNDLU.MEANING
, FNDMI.DESCRIPTION MEDIA_ITEM_DESC
FROM JTF_IH_ACTIVITIES ACT
, JTF_IH_INTERACTIONS INT
, HZ_PARTIES HZ
, JTF_IH_MEDIA_ITEMS MEDIA
, FND_APPLICATION_VL APP
, 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_TASKS_B TSK
, JTF_RS_RESOURCE_EXTNS_VL RSC
, HZ_CUST_ACCOUNTS HZCA
, JTF_OBJECTS_B OBJ
, HZ_PARTIES HZ2
, FND_LOOKUP_VALUES FNDLU
, FND_LOOKUP_VALUES FNDMI
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 ACT.MEDIA_ID = MEDIA.MEDIA_ID(+)
AND INT.HANDLER_ID = APP.APPLICATION_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.TASK_ID = TSK.TASK_ID(+)
AND ACT.DOC_REF = OBJ.OBJECT_CODE(+)
AND INT.CONTACT_PARTY_ID = HZ2.PARTY_ID(+)
AND INT.PRIMARY_PARTY_ID = HZ2.PARTY_ID(+)
AND FNDLU.LOOKUP_TYPE(+) = 'JTF_IH_MEDIA_DIRECTION'
AND FNDLU.LANGUAGE(+) = USERENV('LANG')
AND FNDLU.LOOKUP_CODE(+) = MEDIA.DIRECTION
AND FNDMI.LOOKUP_TYPE(+) = 'JTF_IH_ALL_MEDIA_TYPES'
AND FNDMI.LANGUAGE(+) = USERENV('LANG')
AND FNDMI.LOOKUP_CODE(+) = MEDIA.MEDIA_ITEM_TYPE