DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_PS_UNIT_OFR_OPT_INQ_V

Object Details
Object Name: IGS_PS_UNIT_OFR_OPT_INQ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PS_UNIT_OFR_OPT_INQ_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIT_CD VARCHAR2 (10) Yes The unit offering unit code for which the class list is required.
VERSION_NUMBER NUMBER (3) Yes The version number of the unit being offered. Students are normally enrolled in the current version of a unit. Prior versions of the unit are end-dated. This is an optional field. Leaving the value null returns all students in the class.
CAL_TYPE VARCHAR2 (10) Yes The calendar type in which the unit is offered. Examples include SEM-1 (semester 1 teaching period), TRI-2 (trimester 2 teaching period) and SUM (summer teaching period). Units can only be offered in instances of calendar types that are categorised as TEACHING calendars.
CI_SEQUENCE_NUMBER NUMBER (6) Yes The unique identifier for the calendar instance.
ACAD_ALTERNATE_CODE VARCHAR2 (10)
The short reference code for the academic period associated with the unit offering for the class list. Eg. '1998', '1999'
TEACH_ALTERNATE_CODE VARCHAR2 (10)
The short reference code for the unit offering teaching period for the class list. Eg '1', '2', 'S' . This is a mandatory field in the class list inquiry.
LOCATION_CD VARCHAR2 (10) Yes The code identifying the location of the unit offering for which the class list is to be retrieved. This is an optional field. Leaving the value null returns all students in the unit irrespective of their location. Entering a value restricts the set of students to those enrolled at the nominated location.
UNIT_CLASS VARCHAR2 (10) Yes The code identifying the class of the unit offering for which the class list is to be retrieved. This is an optional field. Leaving the value null returns all students in the unit irrespective of their class. Entering a value restricts the set of students to those enrolled in the nominated class.
UNIT_MODE CHAR (0)
The code identifying the mode of the unit offering for which the class list is to be retrieved. This is an optional field. Leaving the value null returns all students in the unit irrespective of their location. Entering a value restricts the set of students to those enrolled in the nominated mode.
INCLUDE_DISCONT_IND CHAR (0)
An indicator which specifies whether or not students who discontinued their enrolment in the unit offering are to be displayed in the mark/grade entry form. Setting the indicator (ticked) causes discontinued student unit attempts to be displayed in the form.
SORT_BY CHAR (0)
The class list student sort order. The available sort options are Surname and Person ID.
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ACAD_ALTERNATE_CODE
,      TEACH_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_MODE
,      INCLUDE_DISCONT_IND
,      SORT_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_UNIT_OFR_OPT_INQ_V;

Dependencies

[top of page]

APPS.IGS_PS_UNIT_OFR_OPT_INQ_V references the following:

SchemaAPPS
PL/SQL PackageIGS_CA_GEN_001 - show dependent code
PL/SQL PackageIGS_EN_GEN_014 - show dependent code
ViewIGS_PS_UNIT_OFR_OPT

APPS.IGS_PS_UNIT_OFR_OPT_INQ_V is not referenced by any database object