Results for “output_type”

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

Overview

The view APPS.JTF_FM_FAX_JTF_FM_GROUPS_V is a dictionary-defined database object within the Oracle E-Business Suite release 12.1.1 and 12.2.2 environments. It belongs to the JTF — CRM Foundation product family, which supplies the shared telephony, resource, and messaging infrastructure used across CRM modules such as TeleSales, TeleService, and Interaction Center. The view presents a projection over the entity that associates fax output records with the dispatcher and group configuration used by the Fax Manager components of CRM Foundation. Its status is VALID in the APPS schema.

Because it exposes the DISPATCHER_ID column directly, the view is frequently located by administrators and developers who are tracing how a fax dispatch request is tied to a particular dispatcher process and server. The view does not introduce additional joins or transformations; it is a simplifying access path onto the underlying group table. This makes it suitable for lightweight reporting, diagnostic queries, and integration extracts where the caller requires only the base group, server, and dispatcher identifiers along with standard audit columns.

Underlying Base Objects

Per the documented metadata, the view is defined strictly over a single reference:

• JTF_FM_FAX_JTF_FM_GROUPS, exposed within the APPS schema as a SYNONYM.

The SELECT list in the view text draws all columns directly from this source object without filtering predicates or aggregation. Consequently, the view inherits the row cardinality and concurrency behavior of JTF_FM_FAX_JTF_FM_GROUPS. The JTF_FM_FAX_ prefix indicates a Fax Manager table within CRM Foundation, while the _JTF_FM_GROUPS suffix identifies the group-level configuration records. In EBS 12.1.1 and 12.2.2, the runtime synonym resolves to the APPS-owned object, so the view may be queried by any user granted access to the APPS synonym layer without needing to qualify the base table name directly.

Key Columns

• OUTPUT_ID — Identifier for the output record associated with the fax group.
• OUTPUT_TYPE — Classifies the type of the output entry.
• DISPATCHER_ID — Identifier of the dispatcher process assigned to the output; this is the column most commonly searched when tracing fax dispatch ownership.
• SERVER_ID — Identifies the server on which the dispatcher operates.
• GROUP_ID — Identifier of the fax group to which the record belongs.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the row, and from which login session.
• F_DELETEDFLAG — Soft-delete indicator; rows flagged as deleted remain physically present.
• OBJECT_VERSION_NUMBER — Optimistic locking token used by the OA Framework and forms to detect concurrent updates.

Common Use Cases and Queries

The view supports operational and diagnostic reporting on fax dispatch configuration. A typical lookup resolves which server and group are tied to a given dispatcher:

SELECT output_id, output_type, dispatcher_id, server_id, group_id
FROM apps.jtf_fm_fax_jtf_fm_groups_v
WHERE dispatcher_id = :p_dispatcher_id;

A secondary scenario lists active (non-deleted) group records for auditing:

SELECT group_id, server_id, dispatcher_id, last_update_date, last_updated_by
FROM apps.jtf_fm_fax_jtf_fm_groups_v
WHERE f_deletedflag = 'N'
ORDER BY group_id;

Because the view contains no joins, it is safe for high-volume extracts and can be combined with other CRM Foundation tables on GROUP_ID or SERVER_ID when reconciling fax dispatch activity. Always apply the F_DELETEDFLAG predicate in reports to exclude logically removed configuration rows.