View: JTF_IH_INTERACTIONS_V

Product:	JTF - CRM Foundation
Description:	Used for generating reports for records in table JTF_IH_INTERACTIONS.
Implementation/DBA Data:	APPS.JTF_IH_INTERACTIONS_V

View Text

SELECT INT.ROWID ROW_ID
, INTERACTION_ID
, OBJECT_VERSION_NUMBER
, INT.CREATION_DATE
, INT.CREATED_BY
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATE_LOGIN
, INT.LAST_UPDATED_BY
, INT.INTERACTION_INTERS_ID
, INT.OBJECT_ID
, INT.OBJECT_TYPE
, INT.SOURCE_CODE
, INT.SOURCE_CODE_ID
, INT.REFERENCE_FORM
, INT.DURATION
, INT.END_DATE_TIME
, INT.FOLLOW_UP_ACTION
, INT.NON_PRODUCTIVE_TIME_AMOUNT
, INT.RESULT_ID
, INT.REASON_ID
, INT.START_DATE_TIME
, INT.OUTCOME_ID
, INT.PREVIEW_TIME_AMOUNT
, INT.PRODUCTIVE_TIME_AMOUNT
, INT.HANDLER_ID
, INT.INTER_INTERACTION_DURATION
, INT.WRAP_UP_TIME_AMOUNT
, INT.SCRIPT_ID
, INT.PARTY_ID
, INT.RESOURCE_ID
, INT.METHOD_CODE
, INT.ACTIVE
, INT.CONTACT_PARTY_ID
, INT.CONTACT_REL_PARTY_ID
, INT.PRIMARY_PARTY_ID
FROM JTF_IH_INTERACTIONS INT

Columns