Product: | CSC - Customer Care |
---|---|
Description: | View of JTF_IH_INTERACTIONS . This view is used to get Inteaction details for a party. |
Implementation/DBA Data: | APPS.CSC_INTERACTIONS_V |
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.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
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')