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_EN_STDNT_PS_INTM_V

Object Details

Object Name:	IGS_EN_STDNT_PS_INTM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_STDNT_PS_INTM_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	Person ID
COURSE_CD	VARCHAR2	(6)	Yes	Course Code.
INTERMISSION_TYPE	VARCHAR2	(25)		Type of Intermission
DESCRIPTION	VARCHAR2	(90)		Description of Intermission Type
APPROVED	VARCHAR2	(1)	Yes	Whether approved or not
INSTITUTION_CD	VARCHAR2	(90)		Institution Code
INSTITUTION_NAME	VARCHAR2	(360)		Institution Name
MAX_CREDIT_PTS	NUMBER	(15)		Maximum Credit Points accepted for Advanced Standing.
MAX_TERMS	NUMBER	(15)		Maximum Terms accepted for Advanced Standing.
ANTICIPATED_CREDIT_POINTS	NUMBER	(15)		Credit points anticipated to be completed by the student at the other institution
APPROVER_ID	NUMBER	(15)		Who Approved this type of Intermission.
APPROVER_NUMBER	VARCHAR2	(30)		Approver Number
APPROVER_NAME	VARCHAR2	(360)		Approver Name
START_DT	DATE		Yes	Start Date of the Student Program Intermission
LOGICAL_DELETE_DATE	DATE		Yes	Date on which the Intermission is logically deleted
END_DT	DATE		Yes	End Date of the Student Program Intermission
VOLUNTARY_IND	VARCHAR2	(1)	Yes	Voluntary Indicator
COMMENTS	VARCHAR2	(2000)		Comments about the Student Program Intermission
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard Descriptive Flex field Column.
ATTRIBUTE1	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE2	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE3	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE4	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE5	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE6	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE7	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE8	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE9	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE10	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE11	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE12	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE13	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE14	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE15	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE16	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE17	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE18	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE19	VARCHAR2	(150)		Standard Descriptive Flex field Column.
ATTRIBUTE20	VARCHAR2	(150)		Standard Descriptive Flex field Column.
COND_RETURN_FLAG	VARCHAR2	(1)	Yes	Conditional Return Indicator

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      COURSE_CD
,      INTERMISSION_TYPE
,      DESCRIPTION
,      APPROVED
,      INSTITUTION_CD
,      INSTITUTION_NAME
,      MAX_CREDIT_PTS
,      MAX_TERMS
,      ANTICIPATED_CREDIT_POINTS
,      APPROVER_ID
,      APPROVER_NUMBER
,      APPROVER_NAME
,      START_DT
,      LOGICAL_DELETE_DATE
,      END_DT
,      VOLUNTARY_IND
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      COND_RETURN_FLAG
FROM APPS.IGS_EN_STDNT_PS_INTM_V;

Dependencies

[top of page]

APPS.IGS_EN_STDNT_PS_INTM_V references the following:

APPS: HZ_PARTIES; IGS_EN_INTM_TYPES; IGS_EN_STDNT_PS_INTM; IGS_OR_INST_EXEMPT_V

APPS.IGS_EN_STDNT_PS_INTM_V is not referenced by any database object