VIEW: APPS.CS_SR_ACTIVITIES_V

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, int.party_id, act.activity_id, act.interaction_id, hz.party_name, act.media_id, media.direction, media.media_item_type, media.direction || media.media_item_type mediadirtype, media.media_data, 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, 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.ACTION_ITEM_ID, aci.ACTION_ITEM, aci.short_description action_item_desc, act.ACTION_ID, actn.ACTION, actn.short_description action_desc, aci.ACTION_ITEM || actn.ACTION ACTITM, act.OBJECT_ID, act.OBJECT_TYPE, act.SOURCE_CODE, act.SOURCE_CODE_ID, act.INTERACTION_ACTION_TYPE, act.object_version_number, act.cust_account_id, hzca.account_number, obj.object_function, obj.object_parameters, media.address 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_tasks_b tsk, hz_cust_accounts hzca, jtf_objects_b obj WHERE act.interaction_id = int.interaction_id AND int.party_id = hz.party_id AND act.cust_account_id = hzca.cust_account_id(+) 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.task_id = tsk.task_id(+) AND act.doc_ref = 'SR' AND obj.object_code ='SR'

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
, INT.PARTY_ID
, ACT.ACTIVITY_ID
, ACT.INTERACTION_ID
, HZ.PARTY_NAME
, ACT.MEDIA_ID
, MEDIA.DIRECTION
, MEDIA.MEDIA_ITEM_TYPE
, MEDIA.DIRECTION || MEDIA.MEDIA_ITEM_TYPE MEDIADIRTYPE
, MEDIA.MEDIA_DATA
, 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
, 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.ACTION_ITEM_ID
, ACI.ACTION_ITEM
, ACI.SHORT_DESCRIPTION ACTION_ITEM_DESC
, ACT.ACTION_ID
, ACTN.ACTION
, ACTN.SHORT_DESCRIPTION ACTION_DESC
, ACI.ACTION_ITEM || ACTN.ACTION ACTITM
, ACT.OBJECT_ID
, ACT.OBJECT_TYPE
, ACT.SOURCE_CODE
, ACT.SOURCE_CODE_ID
, ACT.INTERACTION_ACTION_TYPE
, ACT.OBJECT_VERSION_NUMBER
, ACT.CUST_ACCOUNT_ID
, HZCA.ACCOUNT_NUMBER
, OBJ.OBJECT_FUNCTION
, OBJ.OBJECT_PARAMETERS
, MEDIA.ADDRESS
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_TASKS_B TSK
, HZ_CUST_ACCOUNTS HZCA
, JTF_OBJECTS_B OBJ
WHERE ACT.INTERACTION_ID = INT.INTERACTION_ID
AND INT.PARTY_ID = HZ.PARTY_ID
AND ACT.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID(+)
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.TASK_ID = TSK.TASK_ID(+)
AND ACT.DOC_REF = 'SR'
AND OBJ.OBJECT_CODE ='SR'