VIEW: APPS.CSC_INTERACTIONS_V

Source

View Text - Preformatted

SELECT int.interaction_id, int.rowid row_id, int.CREATION_DATE, int.CREATED_BY, int.LAST_UPDATE_DATE, int.LAST_UPDATED_BY, int.LAST_UPDATE_LOGIN, int.party_id, hz.party_name, int.resource_id, rsc.resource_name, int.primary_party_id, int.contact_party_id, int.contact_rel_party_id, DECODE(NVL(int.contact_party_id,''),'','', (SELECT party_name FROM hz_parties WHERE party_id = int.contact_party_id)) AS CONTACT_NAME, int.start_date_time, int.end_date_time, int. duration, int.outcome_id, out.outcome_code, out.short_description out_desc, int.result_id, rsl.result_code, rsl.short_description rsl_desc, int.reason_id, rea.reason_code, rea.short_description rea_desc, int.FOLLOW_UP_ACTION, int.INTER_INTERACTION_DURATION, int.INTERACTION_INTERS_ID, int.METHOD_CODE, int.NON_PRODUCTIVE_TIME_AMOUNT, int.OBJECT_ID, int.OBJECT_TYPE, int.OBJECT_VERSION_NUMBER, int.PREVIEW_TIME_AMOUNT, int.PRODUCTIVE_TIME_AMOUNT, int.REFERENCE_FORM, int.SCRIPT_ID, int.SOURCE_CODE, int.SOURCE_CODE_ID, int.WRAP_UP_TIME_AMOUNT, int.ATTRIBUTE_CATEGORY, int.ATTRIBUTE1, int.ATTRIBUTE2, int.ATTRIBUTE3, int.ATTRIBUTE4, int.ATTRIBUTE5, int.ATTRIBUTE6, int.ATTRIBUTE7, int.ATTRIBUTE8, int.ATTRIBUTE9, int.ATTRIBUTE10, int.ATTRIBUTE11, int.ATTRIBUTE12, int.ATTRIBUTE13, int.ATTRIBUTE14, int.ATTRIBUTE15 from jtf_ih_interactions int, hz_parties hz, jtf_ih_outcomes_tl out, jtf_ih_results_tl rsl, jtf_ih_reasons_tl rea, hz_parties hz1, jtf_rs_resource_extns_vl rsc WHERE int.party_id = hz.party_id AND int.outcome_id = out.outcome_id(+) AND out.language(+) = userenv('LANG') AND int.result_id = rsl.result_id(+) AND rsl.language(+) = userenv('LANG') AND int.reason_id = rea.reason_id(+) AND rea.language(+) = userenv('LANG') AND int.resource_id = rsc.resource_id AND int.primary_party_id = hz1.party_id(+) AND int.contact_party_id = hz1.party_id(+)

View Text - HTML Formatted

SELECT INT.INTERACTION_ID
, INT.ROWID ROW_ID
, INT.CREATION_DATE
, INT.CREATED_BY
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATED_BY
, INT.LAST_UPDATE_LOGIN
, INT.PARTY_ID
, HZ.PARTY_NAME
, INT.RESOURCE_ID
, RSC.RESOURCE_NAME
, INT.PRIMARY_PARTY_ID
, INT.CONTACT_PARTY_ID
, INT.CONTACT_REL_PARTY_ID
, DECODE(NVL(INT.CONTACT_PARTY_ID
, '')
, ''
, ''
, (SELECT PARTY_NAME
FROM HZ_PARTIES
WHERE PARTY_ID = INT.CONTACT_PARTY_ID)) AS CONTACT_NAME
, INT.START_DATE_TIME
, INT.END_DATE_TIME
, INT. DURATION
, INT.OUTCOME_ID
, OUT.OUTCOME_CODE
, OUT.SHORT_DESCRIPTION OUT_DESC
, INT.RESULT_ID
, RSL.RESULT_CODE
, RSL.SHORT_DESCRIPTION RSL_DESC
, INT.REASON_ID
, REA.REASON_CODE
, REA.SHORT_DESCRIPTION REA_DESC
, INT.FOLLOW_UP_ACTION
, INT.INTER_INTERACTION_DURATION
, INT.INTERACTION_INTERS_ID
, INT.METHOD_CODE
, INT.NON_PRODUCTIVE_TIME_AMOUNT
, INT.OBJECT_ID
, INT.OBJECT_TYPE
, INT.OBJECT_VERSION_NUMBER
, INT.PREVIEW_TIME_AMOUNT
, INT.PRODUCTIVE_TIME_AMOUNT
, INT.REFERENCE_FORM
, INT.SCRIPT_ID
, INT.SOURCE_CODE
, INT.SOURCE_CODE_ID
, INT.WRAP_UP_TIME_AMOUNT
, INT.ATTRIBUTE_CATEGORY
, INT.ATTRIBUTE1
, INT.ATTRIBUTE2
, INT.ATTRIBUTE3
, INT.ATTRIBUTE4
, INT.ATTRIBUTE5
, INT.ATTRIBUTE6
, INT.ATTRIBUTE7
, INT.ATTRIBUTE8
, INT.ATTRIBUTE9
, INT.ATTRIBUTE10
, INT.ATTRIBUTE11
, INT.ATTRIBUTE12
, INT.ATTRIBUTE13
, INT.ATTRIBUTE14
, INT.ATTRIBUTE15
FROM JTF_IH_INTERACTIONS INT
, HZ_PARTIES HZ
, JTF_IH_OUTCOMES_TL OUT
, JTF_IH_RESULTS_TL RSL
, JTF_IH_REASONS_TL REA
, HZ_PARTIES HZ1
, JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE INT.PARTY_ID = HZ.PARTY_ID
AND INT.OUTCOME_ID = OUT.OUTCOME_ID(+)
AND OUT.LANGUAGE(+) = USERENV('LANG')
AND INT.RESULT_ID = RSL.RESULT_ID(+)
AND RSL.LANGUAGE(+) = USERENV('LANG')
AND INT.REASON_ID = REA.REASON_ID(+)
AND REA.LANGUAGE(+) = USERENV('LANG')
AND INT.RESOURCE_ID = RSC.RESOURCE_ID
AND INT.PRIMARY_PARTY_ID = HZ1.PARTY_ID(+)
AND INT.CONTACT_PARTY_ID = HZ1.PARTY_ID(+)