Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_ACTIVITIES_V |
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
, 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
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(+)