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_UNITHST_V

Object Details

Object Name:	IGS_AD_PS_APLINSTUNT_UNITHST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AD_PS_APLINSTUNT_UNITHST_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	Comments
PERSON_ID	NUMBER	(15)	This field describes the ID of the person that the admission application is for.
ADMISSION_APPL_NUMBER	NUMBER	(2)	This field uniquely identifies an admission application for a person.
NOMINATED_COURSE_CD	VARCHAR2	(6)	This field describes the course code of the course offering instance that the person is applying for admission to.
ACAI_SEQUENCE_NUMBER	NUMBER	(6)	This field describes the unique identifier of an admission course application. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
UNIT_CD	VARCHAR2	(10)	This field describes the unit code of the unit offering pattern that the person is applying for admission to.
HIST_START_DT	DATE		The effective start date/time of the history record.
HIST_END_DT	DATE		The effective end date/time of the history record.
HIST_WHO	NUMBER	(15)	The Oracle username of the person who created the history record.
UV_VERSION_NUMBER	NUMBER		This field describes the unit version number of the unit offering pattern that the person is applying for admission to.
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		This field describes the teaching calendar sequence number of the unit offering pattern that the person is applying for admission to.
LOCATION_CD	VARCHAR2	(10)	This field describes the location code of the unit within the admission course application instance.
UNIT_CLASS	VARCHAR2	(10)	This field describes the unit class of the unit within the admission course application instance.
UNIT_MODE	VARCHAR2	(10)	This field describes the attendance mode of the admission course application instance unit.
ADM_UNIT_OUTCOME_STATUS	VARCHAR2	(10)	This field describes the outcome status of the admission course application instance unit.
ASS_TRACKING_ID	NUMBER		This field describes the tracking ID of an application that has been forwarded for assessment.
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		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		This field describes the superior unit version number of the unit version being offered.
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
ADM_PS_APPL_INST_UNIT_ID	NUMBER		The value of this column will uniquely identify the transaction record

Query Text

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


SELECT PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      ACAI_SEQUENCE_NUMBER
,      UNIT_CD
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      UV_VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_MODE
,      ADM_UNIT_OUTCOME_STATUS
,      ASS_TRACKING_ID
,      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_UNITHST_V;

Dependencies

[top of page]

APPS.IGS_AD_PS_APLINSTUNT_UNITHST_V references the following:

APPS: IGS_AD_PS_APINTUNTHS; IGS_AD_PS_APLINSTUNT; IGS_AU_GEN_001 - show dependent code; IGS_GE_DATE - show dependent code

APPS.IGS_AD_PS_APLINSTUNT_UNITHST_V is not referenced by any database object