Search Results org_unit_wlst_id




Overview
Explore in AI Chat

Overview

The IGS_EN_OR_UNIT_WLST_PRI_V view is a read-only database object owned by the APPS schema within the Oracle E-Business Suite (IGS – Student System product family). It exposes the priority rules applied to organizational unit wait lists, capturing the ordered criteria used when the system allots a unit to students who have been waitlisted. The view combines transactional wait-list priority rows with their corresponding lookup display meanings, so consumers receive both the stored priority value and its human-readable description in a single rowset.

This object is marked VALID in the ETRM (E-Business Suite Technical Reference Manual) and is available in both 12.1.1 and 12.2.2 releases. Because it is a view rather than a base table, it carries no independent storage and is intended for querying and reporting, not for direct DML. It is typically referenced by wait-list allotment logic and by reporting layers that need to present priority sequencing without joining to the lookup framework separately.

Underlying Base Objects

The view is defined over two sources according to the documented view text:

  • IGS_EN_ORUN_WLST_PRI (alias UWP) – the base table holding the persisted priority records for organizational unit wait lists. All key surrogate identifiers, priority ordering, and audit columns originate here.
  • IGS_LOOKUPS_VIEW (alias LV) – a lookup view supplying the display meaning for the priority value.

The join predicate restricts the lookup view to LV.LOOKUP_TYPE = 'UNIT_WAITLIST' and matches LV.LOOKUP_CODE = UWP.PRIORITY_VALUE. This means the view returns only rows whose priority value has a corresponding active lookup code of type UNIT_WAITLIST. No other base objects are documented in the ETRM metadata.

Key Columns

  • ROW_ID – the base table ROWID, useful for identifying the physical row.
  • ORG_UNIT_WLST_PRI_ID – primary surrogate key of the priority record.
  • ORG_UNIT_WLST_ID – foreign key to the parent organizational unit wait-list record; this is the column most commonly searched using the term org_unit_wlst_id, and it links a priority rule back to its owning wait list.
  • PRIORITY_NUMBER – numeric sequence indicating the order in which the priority is evaluated.
  • PRIORITY_VALUE – the coded value compared against the UNIT_WAITLIST lookup.
  • DSP_PRIORITY_MEANING – the lookup meaning, i.e. the display-friendly description of the priority.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard EBS audit columns reflecting who created and last modified the record and when.

Common Use Cases and Queries

The view is used to drive wait-list allotment sequencing and to surface priority configurations in reporting and integration layers. A typical retrieval filters by the parent wait list and orders by priority number:

SELECT org_unit_wlst_id, priority_number, priority_value, dsp_priority_meaning
FROM apps.igs_en_or_unit_wlst_pri_v
WHERE org_unit_wlst_id = :p_wlst_id
ORDER BY priority_number;

Analysts also use it to list all configured priority values for a set of wait lists, or to audit creations and updates within a date range by querying the audit columns. Because it resolves the lookup meaning inline, it is convenient for concurrent programs, BI Publisher data templates, and OAF/ADF-based inquiry pages that must display priority values in business language rather than as raw codes.