Search Results source_promotion_code




Overview
Explore in AI Chat

Overview

The IGR_I_APPL_V view is a reporting and integration object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to present enquiry and application data that originates in Oracle Marketing (OMO) and to join that data to the Student System's own application records through the IGR_I_APPL_ALL junction table. In practical terms, the view provides a consolidated, enquiry-oriented projection of sales lead information enriched with student-system attributes such as academic calendar context, admission calendar context, entry levels, and educational goals. The view is marked VALID and is available in the EBS 12.1.1 and 12.2.2 releases.

The view is particularly relevant to reporting on prospect and enquiry pipelines, since it exposes both the OMO-generated lead identity and the IGS-specific classification data used by admissions and recruitment staff.

Underlying Base Objects

The ETRM documentation states that the view is based on the OMO public view AS_SALES_LEADS_V and the IGR_I_APPL_ALL junction table. The view text confirms this relationship through the alias EAP, which represents the enquiry/application junction data, and through references to AS_STATUSES_VL for status descriptions. Person-level attributes are projected through the alias PDV, providing party number, known-as name, preferred given name, first name, and last name. Additional decode and lookup logic resolves entry levels (IEL), educational goals, how-did-you-hear-of-us, and who-influenced-you references from the relevant IGS and OMO lookup structures. No additional referenced base objects are documented in the ETRM metadata, and the object is a read-only view rather than a table.

Key Columns

Notably, the metadata does not expose a column literally named source_promotion_code; source attribution in this view is represented through the how-know-us and who-influenced identifiers and their decoded names.

Common Use Cases and Queries

Typical uses include enquiry pipeline reporting, lead source analysis, and reconciliation between OMO sales leads and IGS applications.

  • Listing active enquiries with status and person details.
  • Aggregating enquiries by entry level, educational goal, or how-know-us source.
  • Joining the view to IGS application tables to confirm converted leads.

A representative query:

SELECT PERSON_NUMBER,
       ENQUIRY_APPL_NUMBER,
       MEANING,
       INQ_ENTRY_LEVEL,
       EDU_GOAL_NAME,
       HOW_KNOWUS_NAME,
       ENQUIRY_DT
FROM   APPS.IGR_I_APPL_V
WHERE  ENQUIRY_STATUS IS NOT NULL
ORDER  BY ENQUIRY_DT DESC;

Because the view is a reporting projection, queries should be designed for read-only extraction and should avoid reliance on the temporary column positions shown in the view text.