Search Results enquiry_duns




Overview
Explore in AI Chat

Overview

APPS.JTF_HZ_ORGANIZATION_PROFILES_V is a reporting and integration view in Oracle E-Business Suite that exposes organization-level profile data maintained by the Trading Community Architecture (TCA) and Customer Relationship Management (CRM) modules. The view presents one row per organization profile record, keyed by the surrogate ORGANIZATION_PROFILE_ID and linked to the underlying party through PARTY_ID. Its principal business role is to consolidate firmographic, credit, classification, and diversity attributes of an organization into a single queryable structure. The view spans the classic descriptive flexfield columns (ATTRIBUTE1 through ATTRIBUTE20 and the global attribute series), credit and risk scoring fields, small-business and diversity indicators, and organizational identifiers such as DUNS_NUMBER and ENQUIRY_DUNS. Because it is an APPS-owned object, it is typically consumed by reports, concurrent programs, and outbound integrations that must read organization profile facts without navigating the full TCA data model.

Underlying Base Objects

The documented referenced base object is HZ_ORGANIZATION_PROFILES, implemented in the APPS schema as a synonym. The view is a thin projection over that table: it selects the table's ROWID along with the profile's business columns, and does not introduce joins, aggregations, or filters. Consequently, row cardinality, uniqueness, and column-level meaning are governed entirely by HZ_ORGANIZATION_PROFILES. Standard audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — are carried through, as are warehouse-related fields such as WH_UPDATE_DATE and the concurrent program identifiers REQUEST_ID, PROGRAM_APPLICATION_ID, and PROGRAM_ID. The view exposes no additional derivations, so any business rule layered on these columns must be applied by the consumer.

Key Columns

Common Use Cases and Queries

Typical scenarios include supplier and customer due-diligence reports, diversity spend analysis, credit exposure dashboards, and data-quality audits of D-U-N-S assignments. The following query retrieves profile and enquiry D-U-N-S details for organizations that carry an enquiry identifier:

SELECT organization_profile_id,
       party_id,
       organization_name,
       duns_number,
       enquiry_duns,
       credit_score,
       small_bus_ind
  FROM apps.jtf_hz_organization_profiles_v
 WHERE enquiry_duns IS NOT NULL
 ORDER BY organization_name;

A second common pattern identifies organizations with active debarment or exclusion flags for compliance screening:

SELECT organization_name, duns_number, debarment_ind,
       debarments_count, gsa_indicator_flag
  FROM apps.jtf_hz_organization_profiles_v
 WHERE debarment_ind = 'Y'
    OR gsa_indicator_flag = 'Y';

Because the view performs no filtering, consumers should apply their own predicates on ENQUIRY_DUNS, status indicators, and flexfield attributes, and should join to HZ_PARTIES when additional party-level context is required.