Search Results standard_industry_class




Overview
Explore in AI Chat

Overview

APPS.FII_AR_SIC_CODE_BASE_V is a reporting and integration view in the Oracle E-Business Suite Receivables (FII/AR) product family. It presents a consolidated, de-duplicated list of Standard Industrial Classification (SIC) codes drawn from multiple transactional and master-data sources across the EBS data model. Because SIC codes are captured in more than one place — customer parties, customer site uses, and suppliers — this view exists to provide a single, unified reference set of the distinct SIC codes actually in use in the instance.

The view is commonly consumed by Oracle Business Intelligence, Discoverer worksheets, custom concurrent programs, and third-party data-integration routines that need to enumerate valid SIC codes without querying each base table separately. The presence of the LAST_UPDATE_DATE column makes the view particularly useful for incremental extraction and change-detection patterns, since it exposes the most recent modification timestamp associated with each distinct SIC code across all contributing sources.

Underlying Base Objects

The view is defined as a three-branch UNION ALL over the following EBS base tables:

  • HZ_PARTIES — the Trading Community Architecture (TCA) master table holding party records, including customers, prospects, and organizations. Its SIC_CODE column supplies SIC codes recorded at the party level.
  • HZ_CUST_SITE_USES_ALL — the TCA table describing the uses to which a customer site is put. Its SIC_CODE column supplies SIC codes captured at the site-use level.
  • PO_VENDORS — the Purchasing supplier master table. Its STANDARD_INDUSTRY_CLASS column is aliased to SIC_CODE, supplying supplier-side industry classifications.

Each branch filters out NULL SIC codes, applies DISTINCT grouping, and returns the MAX(LAST_UPDATE_DATE) for each code. The three result sets are combined with UNION ALL, so a SIC code appearing in more than one source is returned as separate rows rather than merged. No base objects are separately documented in the ETRM metadata beyond those visible in the view text.

Key Columns

  • SIC_CODE — the distinct Standard Industrial Classification code. Sourced directly from HZ_PARTIES.SIC_CODE, HZ_CUST_SITE_USES_ALL.SIC_CODE, and PO_VENDORS.STANDARD_INDUSTRY_CLASS respectively. NULL values are excluded in every branch.
  • LAST_UPDATE_DATE — the most recent update timestamp for that SIC code within a given source table. Because the aggregation is performed per branch, the returned date reflects the latest change to any row carrying that code in that specific table, not a cross-table maximum.

Common Use Cases and Queries

Typical scenarios include populating SIC code pick lists or validation sets, auditing which industry classifications are in active use, and driving incremental data extracts keyed on the LAST_UPDATE_DATE column. The following query returns all distinct SIC codes with their most recent update timestamp:

  • SELECT sic_code, last_update_date FROM apps.fii_ar_sic_code_base_v ORDER BY sic_code;
  • SELECT sic_code, MAX(last_update_date) FROM apps.fii_ar_sic_code_base_v GROUP BY sic_code; — consolidates the duplicate rows produced by UNION ALL into one row per code.
  • SELECT * FROM apps.fii_ar_sic_code_base_v WHERE last_update_date >= SYSDATE - 30; — supports incremental change detection.

Because the view performs DISTINCT and aggregation across three large tables, it is not intended for high-frequency transactional access; it is best used in batch reporting, extracts, and reference-data synchronisation routines where a point-in-time snapshot of active SIC codes is required.