VIEW: APPS.AMS_ORG_INTERACTIONS_V

Source

View Text - Preformatted

SELECT jiiv.INTERACTION_ID ,hca.CUST_ACCOUNT_ID ,jiiv.CREATION_DATE ,jiiv.CREATED_BY ,jiiv.LAST_UPDATE_DATE ,jiiv.LAST_UPDATED_BY ,jiiv.LAST_UPDATE_LOGIN ,jiiv.PARTY_ID , hp.PARTY_NAME , hca.ACCOUNT_NUMBER ,jiiv.RESOURCE_ID ,jiiv.HANDLER_ID ,jiiv.START_DATE_TIME ,jiiv.END_DATE_TIME ,jiiv.DURATION ,jiiv.OUTCOME_ID ,jiiv.RESULT_ID ,jiiv.REASON_ID ,jiiv.FOLLOW_UP_ACTION ,jiiv.INTER_INTERACTION_DURATION ,jiiv.INTERACTION_INTERS_ID ,jiiv.METHOD_CODE ,jiiv.NON_PRODUCTIVE_TIME_AMOUNT ,jiiv.OBJECT_ID ,jiiv.OBJECT_TYPE ,jiiv.OBJECT_VERSION_NUMBER ,jiiv.PREVIEW_TIME_AMOUNT ,jiiv.PRODUCTIVE_TIME_AMOUNT ,jiiv.REFERENCE_FORM ,jiiv.SCRIPT_ID ,jiiv.SOURCE_CODE ,jiiv.SOURCE_CODE_ID ,jiiv.WRAP_UP_TIME_AMOUNT ,jiiv.ATTRIBUTE_CATEGORY ,jiiv.ATTRIBUTE1 ,jiiv.ATTRIBUTE2 ,jiiv.ATTRIBUTE3 ,jiiv.ATTRIBUTE4 ,jiiv.ATTRIBUTE5 ,jiiv.ATTRIBUTE6 ,jiiv.ATTRIBUTE7 ,jiiv.ATTRIBUTE8 ,jiiv.ATTRIBUTE9 ,jiiv.ATTRIBUTE10 ,jiiv.ATTRIBUTE11 ,jiiv.ATTRIBUTE12 ,jiiv.ATTRIBUTE13 ,jiiv.ATTRIBUTE14 ,jiiv.ATTRIBUTE15 ,jiiv.created_by CREATED_BY_NAME ,jiiv.last_update_login LAST_UPDATE_LOGIN_NAME ,jiiv.last_updated_by LAST_UPDATED_BY_NAME FROM JTF_IH_INTERACTIONS jiiv, HZ_PARTIES hp, JTF_IH_ACTIVITIES jia, HZ_CUST_ACCOUNTS hca WHERE jiiv.interaction_id = jia.interaction_id AND jiiv.party_id = hp.party_id AND jia.cust_account_id = hca.cust_account_id(+) AND hp.STATUS = 'A' AND hp.PARTY_TYPE = 'ORGANIZATION'

View Text - HTML Formatted

SELECT JIIV.INTERACTION_ID
, HCA.CUST_ACCOUNT_ID
, JIIV.CREATION_DATE
, JIIV.CREATED_BY
, JIIV.LAST_UPDATE_DATE
, JIIV.LAST_UPDATED_BY
, JIIV.LAST_UPDATE_LOGIN
, JIIV.PARTY_ID
, HP.PARTY_NAME
, HCA.ACCOUNT_NUMBER
, JIIV.RESOURCE_ID
, JIIV.HANDLER_ID
, JIIV.START_DATE_TIME
, JIIV.END_DATE_TIME
, JIIV.DURATION
, JIIV.OUTCOME_ID
, JIIV.RESULT_ID
, JIIV.REASON_ID
, JIIV.FOLLOW_UP_ACTION
, JIIV.INTER_INTERACTION_DURATION
, JIIV.INTERACTION_INTERS_ID
, JIIV.METHOD_CODE
, JIIV.NON_PRODUCTIVE_TIME_AMOUNT
, JIIV.OBJECT_ID
, JIIV.OBJECT_TYPE
, JIIV.OBJECT_VERSION_NUMBER
, JIIV.PREVIEW_TIME_AMOUNT
, JIIV.PRODUCTIVE_TIME_AMOUNT
, JIIV.REFERENCE_FORM
, JIIV.SCRIPT_ID
, JIIV.SOURCE_CODE
, JIIV.SOURCE_CODE_ID
, JIIV.WRAP_UP_TIME_AMOUNT
, JIIV.ATTRIBUTE_CATEGORY
, JIIV.ATTRIBUTE1
, JIIV.ATTRIBUTE2
, JIIV.ATTRIBUTE3
, JIIV.ATTRIBUTE4
, JIIV.ATTRIBUTE5
, JIIV.ATTRIBUTE6
, JIIV.ATTRIBUTE7
, JIIV.ATTRIBUTE8
, JIIV.ATTRIBUTE9
, JIIV.ATTRIBUTE10
, JIIV.ATTRIBUTE11
, JIIV.ATTRIBUTE12
, JIIV.ATTRIBUTE13
, JIIV.ATTRIBUTE14
, JIIV.ATTRIBUTE15
, JIIV.CREATED_BY CREATED_BY_NAME
, JIIV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, JIIV.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM JTF_IH_INTERACTIONS JIIV
, HZ_PARTIES HP
, JTF_IH_ACTIVITIES JIA
, HZ_CUST_ACCOUNTS HCA
WHERE JIIV.INTERACTION_ID = JIA.INTERACTION_ID
AND JIIV.PARTY_ID = HP.PARTY_ID
AND JIA.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID(+)
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'ORGANIZATION'