Search Results uv_version_number




Overview
Explore in AI Chat

Overview

The IGS_CO_OU_CO_REF view is a core data object within the Oracle E-Business Suite Student System (IGS) module for versions 12.1.1 and 12.2.2. It serves as a security-filtered presentation layer for all references linked to an outgoing correspondence item. The view's primary function is to join and present reference data while enforcing a Multi-Org Access Control (MOAC) security model. It achieves this by filtering the underlying base table, IGS_CO_OU_CO_REF_ALL, based on the ORG_ID context from the user's session, ensuring users only access data pertinent to their operating unit. This abstraction is critical for maintaining data integrity and security in a shared-instance EBS environment.

Key Information Stored

The view consolidates key identifiers that link an outgoing correspondence to various entities within the Student System. Essential columns include the core correspondence identifiers (PERSON_ID, CORRESPONDENCE_TYPE, REFERENCE_NUMBER, ISSUE_DT, SEQUENCE_NUMBER) and the specific academic entities being referenced. The CV_VERSION_NUMBER column, which was part of the user's search context, stores the version number of the referenced course (COURSE_CD). Similarly, UV_VERSION_NUMBER holds the version number for a referenced unit (UNIT_CD). Other significant columns are CAL_TYPE and CI_SEQUENCE_NUMBER for calendar references, S_OTHER_REFERENCE_TYPE and OTHER_REFERENCE for generic references, and ORG_ID for operating unit segregation. Standard EBS audit columns (CREATED_BY, CREATION_DATE, etc.) are also present.

Common Use Cases and Queries

This view is predominantly used for reporting and data extraction related to student communications. A common use case is generating a list of all outgoing correspondence items that reference a specific course version for audit or tracking purposes. For example, to find correspondence for a particular course and version, a query would filter on COURSE_CD and CV_VERSION_NUMBER. Another typical scenario involves joining this view to person or correspondence detail tables to create comprehensive communication histories. The view's built-in ORG_ID filter means reports automatically respect the user's operating unit context without requiring explicit WHERE clause conditions.

  • Sample Query Pattern: SELECT correspondence_type, reference_number, issue_dt FROM apps.igs_co_ou_co_ref WHERE course_cd = 'BSC001' AND cv_version_number = 2;
  • Reporting Use Case: Creating a report showing all correspondence sent to students enrolled in a specific unit version, joining on UNIT_CD and UV_VERSION_NUMBER.

Related Objects

The view is directly dependent on the IGS_CO_OU_CO_REF_ALL table, from which it selects all columns and applies the MOAC security filter. As a view that aggregates references, it is inherently related to the core tables for the entities it references. This includes student PERSON records, COURSE offerings (via COURSE_CD and CV_VERSION_NUMBER), and UNIT offerings (via UNIT_CD and UV_VERSION_NUMBER). It is also closely tied to the main outgoing correspondence entity, likely represented by a table such as IGS_CO_OU_CO_ALL, which would share the key columns PERSON_ID, CORRESPONDENCE_TYPE, REFERENCE_NUMBER, and ISSUE_DT. The view is designed to be queried by other Student System components and custom reports that need a secure, operating-unit-aware list of correspondence references.