Results for “function_description”

1 result




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGSFV_AD_ADM_APPL_TYP view is a self-service reporting object within the Oracle E-Business Suite Student System (IGS) product family. It is owned by the APPS schema and is defined with the WITH READ ONLY clause, meaning it is intended exclusively for query and reporting purposes. The view exposes admission application type definitions together with their associated general ledger accounting flexfield references and descriptive attributes.

Its role within EBS is to provide a single denormalized source of admission application type configuration data, resolving foreign keys into human-readable descriptions. This makes it suitable for both end-user reporting tools (such as Oracle BI Publisher, Discoverer, or custom OAF pages) and integration extracts that need to present application type configuration without joining the base tables individually. The view is registered in ETRM with a status of VALID.

Underlying Base Objects

The view is defined over four documented base objects:

Notably, the metadata documents no referenced base objects separately from those visible in the view text; the joins above are the authoritative relationships. Because the GL joins are outer joins (note the (+) operators), records with null or invalid account CCIDs still appear, with null concatenated segments.

Key Columns

Common Use Cases and Queries

A frequent requirement is to retrieve the revenue and cash account concatenated strings for a given application type — a task that the user search term gl_code_combinations_kfv reflects directly, since this view embeds two references to that key flexfield view.

SELECT admission_application_type,
       application_type_desc,
       gl_revenue_account_name,
       gl_cash_account_name,
       application_fee_amount
FROM   apps.igsfv_ad_adm_appl_typ
WHERE  admission_category = 'UNDERGRAD';

Reporting scenarios include validating that every active application type has a valid revenue and cash account configured (identifying rows where the concatenated name is null), and building configuration extracts for review by the finance and admissions teams. Because the object is read-only, it can be safely queried in custom concurrent programs, BI Publisher data templates, and OAF view objects without risk of DML.