VIEW: APPS.AMS_PERSON_INTERACT_ACT_V

Source

View Text - Preformatted

SELECT jiav.ACTIVITY_ID ,jiav.INTERACTION_ID ,jiav.CREATION_DATE ,jiav.CREATED_BY ,jiav.LAST_UPDATE_DATE ,jiav.LAST_UPDATED_BY ,jiav.LAST_UPDATE_LOGIN ,hp.PARTY_ID ,hp.PARTY_NAME ,jiiv.RESOURCE_ID ,jiav.MEDIA_ID ,jiiv.HANDLER_ID ,jiav.START_DATE_TIME ,jiav.END_DATE_TIME ,jiav.TASK_ID ,jiav.DOC_ID ,jiav.DOC_REF ,jiav.DOC_SOURCE_OBJECT_NAME ,jiav.DURATION ,jiav.DESCRIPTION ,jiav.ROLE ,jiav.OUTCOME_ID ,jiav.RESULT_ID ,jiav.REASON_ID ,jiav.ACTION_ITEM_ID ,jiav.ACTION_ID ,jiav.OBJECT_ID ,jiav.OBJECT_TYPE ,jiav.SOURCE_CODE ,jiav.SOURCE_CODE_ID ,jiav.INTERACTION_ACTION_TYPE ,jiav.OBJECT_VERSION_NUMBER ,jiav.CUST_ACCOUNT_ID ,hca.ACCOUNT_NUMBER ,jiav.created_by CREATED_BY_NAME ,jiav.last_update_login LAST_UPDATE_LOGIN_NAME ,jiav.last_updated_by LAST_UPDATED_BY_NAME FROM JTF_IH_ACTIVITIES jiav, HZ_PARTIES hp, JTF_IH_INTERACTIONS jiiv, HZ_CUST_ACCOUNTS hca WHERE jiav.interaction_id = jiiv.interaction_id AND jiiv.party_id = hp.party_id AND jiav.cust_account_id = hca.cust_account_id(+) AND hp.STATUS = 'A' AND hp.PARTY_TYPE = 'PERSON'

View Text - HTML Formatted

SELECT JIAV.ACTIVITY_ID
, JIAV.INTERACTION_ID
, JIAV.CREATION_DATE
, JIAV.CREATED_BY
, JIAV.LAST_UPDATE_DATE
, JIAV.LAST_UPDATED_BY
, JIAV.LAST_UPDATE_LOGIN
, HP.PARTY_ID
, HP.PARTY_NAME
, JIIV.RESOURCE_ID
, JIAV.MEDIA_ID
, JIIV.HANDLER_ID
, JIAV.START_DATE_TIME
, JIAV.END_DATE_TIME
, JIAV.TASK_ID
, JIAV.DOC_ID
, JIAV.DOC_REF
, JIAV.DOC_SOURCE_OBJECT_NAME
, JIAV.DURATION
, JIAV.DESCRIPTION
, JIAV.ROLE
, JIAV.OUTCOME_ID
, JIAV.RESULT_ID
, JIAV.REASON_ID
, JIAV.ACTION_ITEM_ID
, JIAV.ACTION_ID
, JIAV.OBJECT_ID
, JIAV.OBJECT_TYPE
, JIAV.SOURCE_CODE
, JIAV.SOURCE_CODE_ID
, JIAV.INTERACTION_ACTION_TYPE
, JIAV.OBJECT_VERSION_NUMBER
, JIAV.CUST_ACCOUNT_ID
, HCA.ACCOUNT_NUMBER
, JIAV.CREATED_BY CREATED_BY_NAME
, JIAV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, JIAV.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM JTF_IH_ACTIVITIES JIAV
, HZ_PARTIES HP
, JTF_IH_INTERACTIONS JIIV
, HZ_CUST_ACCOUNTS HCA
WHERE JIAV.INTERACTION_ID = JIIV.INTERACTION_ID
AND JIIV.PARTY_ID = HP.PARTY_ID
AND JIAV.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID(+)
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'