View: JTF_IH_WRAPUP_REASONS_VL

Product:	JTF - CRM Foundation
Description:	View used to drive Reason LOVs presented in Interaction Wrap-up UIs
Implementation/DBA Data:	APPS.JTF_IH_WRAPUP_REASONS_VL

View Text

SELECT WRP.ROWID
, WRP.WRAP_ID
, WRP.OBJECT_VERSION_NUMBER
, WRP.CREATED_BY
, WRP.CREATION_DATE
, WRP.LAST_UPDATED_BY
, WRP.LAST_UPDATE_DATE
, WRP.LAST_UPDATE_LOGIN
, REAB.REASON_REQUIRED
, WRP.OUTCOME_ID
, WRP.RESULT_ID
, WRP.REASON_ID
, WRP.ACTION_ACTIVITY_ID
, WRP.OBJECT_ID
, WRP.OBJECT_TYPE
, WRP.SOURCE_CODE_ID
, WRP.SOURCE_CODE
, WRP.SECURITY_GROUP_ID
, WRP.START_DATE
, WRP.END_DATE
, REAB.GENERATE_PUBLIC_CALLBACK
, REATL.SHORT_DESCRIPTION
, REAB.GENERATE_PRIVATE_CALLBACK
, REAB.VERSATILITY_CODE
, REAB.ACTIVE
, WRP.WRAP_UP_LEVEL
FROM JTF_IH_WRAP_UPS WRP
, JTF_IH_REASONS_B REAB
, JTF_IH_REASONS_TL REATL
WHERE WRP.REASON_ID = REAB.REASON_ID
AND WRP.REASON_ID = REATL.REASON_ID
AND REATL.LANGUAGE = USERENV('LANG')

Columns