eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGS_AD_PS_APLINSTUNT_APLUNIT_V

Object Details

Object Name:	IGS_AD_PS_APLINSTUNT_APLUNIT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AD_PS_APLINSTUNT_APLUNIT_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
ROW_ID	ROWID	(10)
PERSON_ID	NUMBER	(15)	Yes	This field describes the ID of the person that the admission application is for.
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	This field uniquely identifies an admission application for a person.
NOMINATED_COURSE_CD	VARCHAR2	(6)	Yes	This field describes the course code of the course offering instance that the person is applying for admission to.
ACAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	This field describes the unique identifier of an admission course application instance. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
UNIT_CD	VARCHAR2	(10)	Yes	This field describes the unit code of the unit offering pattern that the person is applying for admission to.
UV_VERSION_NUMBER	NUMBER	(3)	Yes	This field describes the unit version number of the unit offering pattern that the person is applying for admission to.
UV_TITLE	VARCHAR2	(90)	Yes	The title of the unit.
UV_UNIT_STATUS	VARCHAR2	(10)	Yes	The institution-defined status of a unit which maps to a system unit status. A unit is established with a system equivalent status of PLANNED. For students to be enrolled in the unit it must have a system equivalent status of ACTIVE. When the unit is no longer to be offered it is given a system equivalent status of INACTIVE. INACTIVE units may be archived.
CAL_TYPE	VARCHAR2	(10)		This field describes the teaching calendar type of the unit offering pattern that the person is applying for admission to.
CI_SEQUENCE_NUMBER	NUMBER	(6)		This field describes the teaching calendar sequence number of the unit offering pattern that the person is applying for admission to.
TEACH_ALTERNATE_CODE	VARCHAR2	(10)		This field describes the alternate code for a teaching calendar.
LOCATION_CD	VARCHAR2	(10)		This field describes the location code of the course admission application.
UNIT_CLASS	VARCHAR2	(10)		This field describes the unit class of the unit within the admission course application instance. Only one of unit class or unit mode may be nominated.
UNIT_MODE	VARCHAR2	(10)		This field describes the unit mode of the unit within the admission course application instance. Only one of unit class or unit mode may be nominated
ASS_TRACKING_ID	NUMBER	(9)		This field describes the tracking ID of an application that has been forwarded for assessment.
ADM_UNIT_OUTCOME_STATUS	VARCHAR2	(10)	Yes	This field describes the outcome status of the admission course application instance unit.
RULE_WAIVED_DT	DATE			This field describes the date on which a failed rule applying to the offered unit was waived.
RULE_WAIVED_PERSON_ID	NUMBER	(15)		This field describes the person who waived the unit rule applicable to the offered unit.
SUP_UNIT_CD	VARCHAR2	(10)		This field describes the superior unit code of the unit version being offered.
SUP_UV_VERSION_NUMBER	NUMBER	(3)		This field describes the superior unit version number of the unit version being offered.
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)
ADM_PS_APPL_INST_UNIT_ID	NUMBER		Yes	The value of this column will uniquely identify the record

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      ACAI_SEQUENCE_NUMBER
,      UNIT_CD
,      UV_VERSION_NUMBER
,      UV_TITLE
,      UV_UNIT_STATUS
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      TEACH_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_MODE
,      ASS_TRACKING_ID
,      ADM_UNIT_OUTCOME_STATUS
,      RULE_WAIVED_DT
,      RULE_WAIVED_PERSON_ID
,      SUP_UNIT_CD
,      SUP_UV_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ADM_PS_APPL_INST_UNIT_ID
FROM APPS.IGS_AD_PS_APLINSTUNT_APLUNIT_V;

Dependencies

[top of page]

APPS.IGS_AD_PS_APLINSTUNT_APLUNIT_V references the following:

APPS: IGS_AD_PS_APLINSTUNT; IGS_CA_INST; IGS_PS_UNIT_VER

APPS.IGS_AD_PS_APLINSTUNT_APLUNIT_V is referenced by following:

APPS: IGS_AD_GEN_010 - show dependent code