Results for “note_context_type_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_IH_NOTES_VL is a read-only view in the APPS schema of Oracle E-Business Suite, belonging to the JTF – CRM Foundation product. Its documented purpose is to allow users and applications to view JTF Notes attached to Interactions. In functional terms, it answers a common CRM question: for a given interaction record, what free-text notes are associated with it, and under which note context type was each note captured.

The object is classified as a VIEW and holds a VALID status in the ETRM repository, indicating it is a supported, queryable object rather than a base table that applications write to directly. Because its name carries the _VL suffix, it follows the standard EBS convention for a "view language" object: a view that exposes translatable, language-sensitive content. In this case the surfaced content is the note text itself, drawn from JTF_NOTES_VL.

Its role in reporting and integration is primarily as a denormalized access point. Rather than requiring report authors or interface developers to join interaction, note context, and note detail tables manually, JTF_IH_NOTES_VL consolidates the relationship in a single definition, scoped specifically to the 'JTF_INTERACTION' note context type. This makes it convenient for CRM reporting on interaction notes and for lightweight integration extracts.

Underlying Base Objects

The documented view text defines JTF_IH_NOTES_VL over three objects:

• JTF_NOTE_CONTEXTS (referenced as a SYNONYM) — provides the linkage between a note and the entity it is attached to, via NOTE_CONTEXT_TYPE and NOTE_CONTEXT_TYPE_ID.
• JTF_IH_INTERACTIONS (referenced as a SYNONYM) — supplies the INTERACTION_ID that the note context resolves to for interactions.
• JTF_NOTES_VL (a VIEW) — supplies the actual note text through the NOTES column.

The join logic is explicit: the view filters JTF_NOTE_CONTEXTS to rows where NOTE_CONTEXT_TYPE equals 'JTF_INTERACTION'; matches NOTE_CONTEXT_TYPE_ID to JTF_IH_INTERACTIONS.INTERACTION_ID; and matches JTF_NOTE_ID to JTF_NOTES_VL.JTF_NOTE_ID. Additional documented base objects, including the packages JTF_NOTES_PKG, JTF_COMMON_PVT, and FND_GLOBAL, are associated with this object family and are typically involved in note creation, security, and localization handling rather than in the view definition itself.

Key Columns

• NOTES — the note text associated with the interaction, sourced from JTF_NOTES_VL.
• NOTE_CONTEXT_TYPE_ID — the identifier of the entity to which the note context applies; for this view it equates to the interaction identifier.
• INTERACTION_ID — the identifier of the interaction in JTF_IH_INTERACTIONS, used to join back to interaction header data.

Common Use Cases and Queries

Typical uses include interaction note reporting, CRM analytics, and data extracts. A simple listing of notes for a specific interaction:

• SELECT interaction_id, notes FROM jtf_ih_notes_vl WHERE interaction_id = :p_interaction_id;

Joining to interaction headers for richer reporting:

• SELECT i.interaction_id, n.notes FROM jtf_ih_interactions i, jtf_ih_notes_vl n WHERE i.interaction_id = n.interaction_id;