Search Results jtf_qual_type_usgs




Overview
Explore in AI Chat

Overview

The JTF_QUAL_TYPE_USGS view is a reporting and integration object within the JTF - CRM Foundation product of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It is owned by the APPS schema and carries a VALID status in the ETRM repository. According to the documented metadata, the view is described as being "Same as JTF_QUAL_TYPE_USGS_ALL table," indicating that it is a thin, Org-filtered projection of the underlying multi-organization table rather than a view that performs aggregation, joins, or data transformation.

The naming convention follows the standard Oracle EBS pattern in which an _ALL suffixed table stores data across all operating units (ORG_ID), while the unsuffixed view exposes only the rows relevant to the current session's Org context. This design allows CRM Foundation functionality — specifically the assignment and tracking of qualification usage types — to be consumed by forms, concurrent programs, and reports under the Operating Unit (MOAC) security model without exposing cross-Org data inadvertently.

Underlying Base Objects

The documented base object referenced by this view is the table JTF_QUAL_TYPE_USGS_ALL, accessed through a synonym. The view definition is a straightforward SELECT against that table:

Because it is defined only over JTF_QUAL_TYPE_USGS_ALL, the view inherits all columns, data types, and constraints from that table. It does not join to any lookup, qualification type, or source reference table at the database level. Any enrichment of the persisted values — for example, resolving QUAL_TYPE_ID to a human-readable qualification name or translating SOURCE_ID into a source system description — must be performed through joins in the consuming query or application layer.

Key Columns

The view exposes the following columns, each mapped directly from the base table:

  • QUAL_TYPE_USG_ID — Primary identifier for a qualification type usage record.
  • LAST_UPDATE_DATE — Timestamp of the most recent modification to the row.
  • LAST_UPDATED_BY — User ID of the person or process that last updated the row.
  • CREATION_DATE — Timestamp when the record was originally inserted.
  • CREATED_BY — User ID that created the record.
  • LAST_UPDATE_LOGIN — Login ID associated with the most recent update, used for audit purposes.
  • QUAL_TYPE_ID — Foreign key to the qualification type definition, establishing which qualification a given usage belongs to.
  • SOURCE_ID — Identifier of the originating source (such as a program or subsystem) that produced the usage record.
  • PACKAGE_NAME — Name of the PL/SQL package or executable associated with the qualification usage, typically the routine that processed or evaluated the qualification.
  • PACKAGE_SPOOL_FILENAME — Filename of the spool or output file generated when the qualification package was executed.
  • ORG_ID — Operating Unit identifier that governs Multi-Org access to the row.

Common Use Cases and Queries

Because the view mirrors the _ALL table, typical usages involve auditing and diagnosing qualification processing — for example, determining which packages have been run against a qualification type, or locating spool files produced during qualification evaluation. A rudimentary query follows:

  • SELECT qual_type_usg_id, qual_type_id, package_name, package_spool_filename, last_update_date FROM jtf_qual_type_usgs WHERE org_id = :org_id ORDER BY last_update_date DESC;
  • SELECT qtu.qual_type_usg_id, qtu.package_name, qtu.package_spool_filename FROM jtf_qual_type_usgs qtu WHERE qtu.qual_type_id = :qual_type_id;

When reporting across all operating units, developers may query the base table JTF_QUAL_TYPE_USGS_ALL directly, or rely on MOAC initialization to filter the view appropriately. Because the view contains no joins, performance is largely dependent on indexing of the underlying table on ORG_ID, QUAL_TYPE_ID, and the primary key QUAL_TYPE_USG_ID.