VIEW: APPS.OKL_CS_ACTIVITIES_UV

Source

View Text - Preformatted

SELECT act.rowid row_id, act.CREATION_DATE CREATION_DATE, act.CREATED_BY CREATED_BY, act.LAST_UPDATE_DATE LAST_UPDATE_DATE, act.LAST_UPDATED_BY LAST_UPDATED_BY, act.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, int.party_id party_id, act.activity_id activity_id, act.interaction_id interaction_id, hz.party_name party_name, act.media_id media_id, media.direction direction, media.media_item_type media_item_type, media.direction || media.media_item_type mediadirtype, act.start_date_time start_date_time, act.end_date_time end_date_time, act.task_id task_id, act.doc_id doc_id, act.doc_ref doc_ref, act.doc_source_object_name doc_source_object_name, act.duration duration, act.description description, act.role role, act.outcome_id outcome_id, out.outcome_code outcome_code, out.short_description out_desc, act.result_id result_id, rsl.result_code result_code, rsl.short_description rsl_desc, act.reason_id reason_id, rea.reason_code reason_code, rea.short_description rea_desc, act.ACTION_ITEM_ID ACTION_ITEM_ID, aci.ACTION_ITEM ACTION_ITEM, aci.short_description action_item_desc, act.ACTION_ID ACTION_ID, actn.ACTION ACTION, actn.short_description action_desc, aci.ACTION_ITEM || actn.ACTION ACTITM, act.OBJECT_ID OBJECT_ID, act.OBJECT_TYPE OBJECT_TYPE, act.SOURCE_CODE SOURCE_CODE, act.SOURCE_CODE_ID SOURCE_CODE_ID, act.INTERACTION_ACTION_TYPE INTERACTION_ACTION_TYPE, act.object_version_number object_version_number, act.cust_account_id cust_account_id, hzca.account_number account_number, obj.object_function object_function, obj.object_parameters object_parameters 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 = obj.object_code(+)

View Text - HTML Formatted

SELECT ACT.ROWID ROW_ID
, ACT.CREATION_DATE CREATION_DATE
, ACT.CREATED_BY CREATED_BY
, ACT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACT.LAST_UPDATED_BY LAST_UPDATED_BY
, ACT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INT.PARTY_ID PARTY_ID
, ACT.ACTIVITY_ID ACTIVITY_ID
, ACT.INTERACTION_ID INTERACTION_ID
, HZ.PARTY_NAME PARTY_NAME
, ACT.MEDIA_ID MEDIA_ID
, MEDIA.DIRECTION DIRECTION
, MEDIA.MEDIA_ITEM_TYPE MEDIA_ITEM_TYPE
, MEDIA.DIRECTION || MEDIA.MEDIA_ITEM_TYPE MEDIADIRTYPE
, ACT.START_DATE_TIME START_DATE_TIME
, ACT.END_DATE_TIME END_DATE_TIME
, ACT.TASK_ID TASK_ID
, ACT.DOC_ID DOC_ID
, ACT.DOC_REF DOC_REF
, ACT.DOC_SOURCE_OBJECT_NAME DOC_SOURCE_OBJECT_NAME
, ACT.DURATION DURATION
, ACT.DESCRIPTION DESCRIPTION
, ACT.ROLE ROLE
, ACT.OUTCOME_ID OUTCOME_ID
, OUT.OUTCOME_CODE OUTCOME_CODE
, OUT.SHORT_DESCRIPTION OUT_DESC
, ACT.RESULT_ID RESULT_ID
, RSL.RESULT_CODE RESULT_CODE
, RSL.SHORT_DESCRIPTION RSL_DESC
, ACT.REASON_ID REASON_ID
, REA.REASON_CODE REASON_CODE
, REA.SHORT_DESCRIPTION REA_DESC
, ACT.ACTION_ITEM_ID ACTION_ITEM_ID
, ACI.ACTION_ITEM ACTION_ITEM
, ACI.SHORT_DESCRIPTION ACTION_ITEM_DESC
, ACT.ACTION_ID ACTION_ID
, ACTN.ACTION ACTION
, ACTN.SHORT_DESCRIPTION ACTION_DESC
, ACI.ACTION_ITEM || ACTN.ACTION ACTITM
, ACT.OBJECT_ID OBJECT_ID
, ACT.OBJECT_TYPE OBJECT_TYPE
, ACT.SOURCE_CODE SOURCE_CODE
, ACT.SOURCE_CODE_ID SOURCE_CODE_ID
, ACT.INTERACTION_ACTION_TYPE INTERACTION_ACTION_TYPE
, ACT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACT.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HZCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, OBJ.OBJECT_FUNCTION OBJECT_FUNCTION
, OBJ.OBJECT_PARAMETERS OBJECT_PARAMETERS
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 = OBJ.OBJECT_CODE(+)