Search Results squal_char11




Overview
Explore in AI Chat

Overview

APPS.AS_TAP_OPPORTUNITIES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes opportunity and lead data drawn from the TeleSales and Territory Assignment (TAE) functional area, presenting a denormalized projection of lead records and their associated transaction-detail attributes. The view carries an Oracle Internal Use Only designation, meaning Oracle Corporation does not support direct customer access to its data except through standard Oracle Applications programs. Its FND Design Data identifier is AS.AS_TAP_OPPORTUNITIES_V, and its status is VALID.

The view is principally consumed by sales, marketing, and channel-reporting layers that need a consolidated picture of leads, their qualification attributes, and their status within the opportunity lifecycle. Because it flattens transaction detail columns into individually named SQUAL columns, it is well suited to ad-hoc reporting, BI Publisher extracts, and downstream integration loads that cannot easily navigate the underlying TAE flex structures.

Underlying Base Objects

The documented referenced base objects for this view are:

  • AS_LEADS_ALL (SYNONYM) — the master lead/opportunity table, supplying lead identity, channel, status, amount, and currency context.
  • AS_STATUSES_B (SYNONYM) — the base status definitions used to resolve lead status values.
  • JTF_TAE_1001_ACCOUNT_TRANS (SYNONYM) — the TAE transaction table for the 1001 account object, which materializes user-defined transaction detail attributes (the SQUAL_CHAR, SQUAL_NUM, SQUAL_CURC, and SQUAL_FC columns).

Several columns carry comments referencing JTF_TAE_1001_ACCOUNT, which is the account object counterpart of the transaction table; the view joins lead records to their TAE transaction detail so that qualification attributes stored in the flex columns are visible alongside native lead fields.

Key Columns

  • TRANS_OBJECT_ID (NUMBER) — lead identifier; the primary correlation key back to the lead record.
  • SQUAL_CHAR01 … SQUAL_CHAR11 (VARCHAR2, 360) — user-defined character attributes from JTF_TAE_1001_ACCOUNT. SQUAL_CHAR11 is the column most frequently requested in reporting contexts; it holds the eleventh flex character attribute and is commonly repurposed for custom qualification fields.
  • SQUAL_NUM01 … SQUAL_NUM06 (NUMBER) — numeric qualification attributes, including SQUAL_NUM02 (transaction detail object id) and SQUAL_NUM04 (transaction object id), both foreign keys to JTF_TAE_1001_ACCOUNT.
  • SQUAL_CURC01 (VARCHAR2, 30) and SQUAL_CURC07 (VARCHAR2, 15) — currency attributes; SQUAL_CURC07 carries the lead currency code.
  • SQUAL_FC01 (VARCHAR2) — flex field character attribute.
  • SQUAL_CHAR40 (VARCHAR2, 30) — lead channel code.
  • SQUAL_NUM40 (NUMBER) — lead promotion identifier.
  • SQUAL_CHAR41 (VARCHAR2, 30) — lead status.
  • SQUAL_NUM41 (NUMBER) — total lead amount.

Common Use Cases and Queries

Typical uses include lead qualification reporting, channel and promotion analysis, and extraction feeds that require flex attributes such as SQUAL_CHAR11. A representative query for the searched column is:

SELECT trans_object_id, squal_char11, squal_char41, squal_num41, squal_curc07 FROM apps.as_tap_opportunities_v WHERE squal_char41 = 'OPEN';

To profile the distribution of the requested attribute:

SELECT squal_char11, COUNT(*) FROM apps.as_tap_opportunities_v GROUP BY squal_char11 ORDER BY 2 DESC;

Because access is unsupported outside standard Oracle programs, implementations should treat the view as read-only reference data and confirm column semantics against the configured TAE flex mapping before relying on any SQUAL column in production reporting.