VIEW: APPS.JTF_IH_INTERACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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