Results for “igs_ps_ver”

50+ results




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

Overview

IGS_PS_VER is an Oracle E-Business Suite view owned by the APPS schema and registered as VALID in the IGS (Student System) product. As documented in the ETRM metadata, the view is defined with the descriptive purpose "This view would be used in form," indicating that it was constructed primarily to support the Oracle Forms-based user interface of the Student System rather than to serve as a standalone reporting entity. In Oracle EBS 12.1.1 and 12.2.2, such views typically wrap an underlying "_ALL" table and apply Multi-Org security filtering, exposing a subset of columns in the exact shape required by a particular form block.

The view presents version-level course (program/unit version) information from the Student System, including course identity, effective dates, status, and a large set of descriptive and administrative attributes. Because it applies an ORG_ID filter through the CLIENT_INFO session context, it behaves as an organization-restricted view: callers only see rows belonging to the operating unit context established for their session.

Underlying Base Objects

The documented base object for this view is IGS_PS_VER_ALL. The view text selects from this table using the alias TAB, projecting a defined column list and appending a WHERE clause that restricts rows by organization:

WHERE NVL(TAB.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

This is the standard Oracle EBS Multi-Org secured view pattern. When CLIENT_INFO is unset, the DECODE returns NULL, the fallback value becomes -99, and rows with a null ORG_ID (shared/global records) qualify. When an operating unit is set, only rows matching that ORG_ID are returned. The "_ALL" suffix on the base table confirms the underlying storage is not itself org-secured, and the view supplies the security layer.

Key Columns

IGS_PS_VER exposes a wide column list. Notable columns include:

Common Use Cases and Queries

Because the view is Multi-Org secured, queries should be run in a session (or responsibility) with the desired operating unit context set; otherwise only global (ORG_ID null/-99) rows are visible. Typical uses include:

  • Retrieving a course version for a given code and version number.
  • Listing all currently active versions for a course.
  • Reading flexfield attributes for downstream reporting.

Example queries:

SELECT course_cd, version_number, title, course_status, start_dt, end_dt FROM apps.igs_ps_ver WHERE course_cd = :course_cd AND version_number = :version_number;

SELECT course_cd, version_number, title FROM apps.igs_ps_ver WHERE course_status = 'ACTIVE' AND SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE) ORDER BY course_cd, version_number;

SELECT course_cd, version_number, attribute_category, attribute1, attribute2 FROM apps.igs_ps_ver WHERE org_id = :org_id;