Search Results correspondence_ind




Overview
Explore in AI Chat

Overview

IGS_GR_VENUE_ADDR is a reporting and integration view within the Oracle E-Business Suite Student System (product family IGS). Its purpose is to present venue address information in a denormalized, business-friendly form. In the 12.1.1 and 12.2.2 releases, IGS objects belong to the legacy Student System module, which Oracle has designated as obsolete. The view therefore survives primarily for backward compatibility with custom reports, extracts, and interfaces that were built against the original IGS data model rather than being actively maintained as part of current functionality.

The view exposes mailing-style address attributes for a venue, including a set of free-form address lines, city, state, province, county, country, postal code, and an address type/use code. Because the underlying address structures are shared with the common HZ (Trading Community) location tables, the view also surfaces standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE). This makes it suitable for audit-oriented extracts as well as simple address listings.

Underlying Base Objects

The ETRM metadata does not document a formal list of referenced base objects, and the object is recorded as "Not implemented in this database" for the reference environment. The view text, however, defines the join logic. Four base objects are referenced:

  • HZ_LOCATIONS (alias HL) — the standard Trading Community location table holding ADDRESS1 through ADDRESS4, city, state, province, county, country, postal code, and delivery point.
  • IGS_AD_LOCVENUE_ADDR (alias LA) — the IGS venue address link table, providing the link to the location, the venue code, and identifying-address flags.
  • IGS_PE_HZ_LOCATIONS (alias IHL) — the IGS extension to HZ locations, carrying contact person, verification date, and additional detail attributes.
  • IGS_PE_LOCVENUE_USE (alias PLU) — the venue use table supplying the address type/site use code. It is outer-joined through LOC_VENUE_ADDR_ID.

The joins relate all records on LOCATION_ID and restrict to SOURCE_TYPE = 'V' (venue). The outer join to IGS_PE_LOCVENUE_USE means a venue address row can exist even where no use record is defined.

Key Columns

Common Use Cases and Queries

Typical uses include producing venue address lists for registration, scheduling, and event correspondence reporting, and feeding address data into external mail or mapping systems. A simple listing:

SELECT venue_cd, addr_type, addr_line_1, addr_line_2, city, state, postal_code
FROM   igs_gr_venue_addr
WHERE  start_dt <= SYSDATE
AND    (end_dt IS NULL OR end_dt >= SYSDATE);

Filtering on the searched column:

SELECT venue_cd, addr_line_1, addr_line_2, city
FROM   igs_gr_venue_addr
WHERE  UPPER(addr_line_1) LIKE UPPER('%&keyword%');

Because the module is obsolete, users should verify view existence before relying on it and consider replacement with standard HZ location queries in current implementations.